I need an excel business plan template/workbook that provides the following facilities:-
It provides fully automated self calculating balance sheets, income and cash flow forecasts, eps data together with leading financial ratios built up from monthly sales and expenses forecasts, capital and investment budgets and working capital ratios.
Includes an additional starting balance sheet that defines the starting point for the five year plan (can be zero for a new venture).
Using ten quick and easy ready to use integrated financial worksheets with guide notes and demonstration data included (optional),
It’s to be used to build a five year sales, cost of sales and company expense forecasts, and create share issue plans and capital purchase budgets over a five year period. This is to be targeted for a specific industry, some sample data will be provided, but it needs to be easy to adjust for any other industry.
It needs to bring all the business plan data together in a simple one step seamless process to create five year balance sheets, profit & loss and cash flow forecasts. It should be able to calculate year end inventory levels, working capital, depreciation charges, tax calculations, financing charges on debt, short and long term loan payables at each year end and forecasts year end bank balances to provide a completely worked out and balanced 5 year business plan.
I also need it to calculate all major and significant financial ratios for the 5 year plan, including earnings/share, net assets/share, return on assets, return on shareholder equity, return on invested capital, current ratios, quick ratios, debt ratios and interest coverage.
Any further details required can be provided upon request.