Excel Spreadsheets : five year balance sheets, profit & loss schedules

Excel Spreadsheets : FastPlan PRO Financial Forecasting Excel workbook

Planning Excel Templates

Excel Templates for accounting

FastPlan 9.0 is the latest version ( 2006) of our popular financial forecasting Excel workbook.

With FastPlan 9.0 you can achieve the following:

1. With a few simple entries into the monthly unit sales, pricing, cost of sales and expense items template (100 rows of expenses), FastPlan generates monthly five year balance sheets, profit & loss schedules and cash flow tables.

2. The balance sheets always balance! (By cross linking with the source and application of funds spreadsheets, the closing cash balance balances always balance the balance sheets! A which is precisely how real business finances operate).

3. Vary any unit volume forecast, price and cost of sales and FastPlam instantly recalculates monthly and profit & loss forecasts, balance sheets, month end closing cash balances.

4. Instantly calculate all the key operating ratios.

5. Instantly calculate times covered quick working capital and inventory levels above or below credit facility covenants or agreed credit limits.

6. You can review the five year plan in one easy report that contains the income forecast, balance sheets and cash flows (source and application of finances).

No accounting knowledge is required.

Sensitivity and Flexibility

The spreadsheets within FastPlan are connected using Excels 3-D links. You can change any input variable and recalculate the summary forecasts, balance sheets and monthly cash balance calculations.

Frequently asked questions about a financial plan answered by FastPlan PRO ; Equity Returns & Ratios:

Is the plan achievable?		Check the forecast data with FastPlan PRO Returns & Ratios. With quick inputs of sales and expenses plus starting data you can see whether results, returns and operating ratios work out to be realistic values. All commonly applied financial ratios calculated and compared plan- to-plan.
How can I reach my goals?		Create a plan and fine tune income, margins and expenses and find exactly how to reach your short and long term financial goals.

How can I value my shares?		Enter quick forecast projections. FastPlan PRO discounts future after tax forecast earnings to give present value per share. You select the discounting rate.

How can I value cash flows?		FastPlan PRO provides rate of return (IRR) of pre and after tax operating cash flows over the lifetime of the plan.

What is the return on equity?		FastPlan PRO calculates the average Return on Equity over the full lifetime of any financial plan.

FastPlan PRO Equity Returns & Ratios provides easy to use spreadsheets Assumptions Plan A forecast Plan B forecast (based on adjusted Plan A), Returns & Ratios and depreciation & loans tables. With simple input of revenue and expense forecasts FastPlan PRO gives you instant pre-tax cash flow forecasts, depreciation charges, loan charges, income taxes, discounted cash flows, pre- and after tax IRR. Select from straight line, MACRS or DDB depreciation options. Add any mix of equity and loan financing terms for new capital purchases, forecast operating cash flows, equity pay back, discounted cash flows, after tax IRR, and operating cash flows IRR, net present values, interest coverage ratios, earnings per share, share value and the average return on equity.

We have received several requests lately from customers who want to purchase 10 year financial business plan templates for Excel.

So we have added as FREE GIVEAWAY to our FastPlan financial business plan templates new ten year financial spreadsheets for Excel. This provides a quick way for users to develop 10 years financial forecasts for inclusion in their business plans.

Fastplan Excel Spreadsheets

System Requirements

Web data requires Excel 2000 or above and MS Windows XP/2000/2003 or later.

Order

Please note that Our Main Financial Excel Templates contain this product.

30 day money back guarantee!