Funding Plan PRO for Excel forecasts monthly financials over 10 years starting from any month or year. It covers common share issuance, financing, loan note amortization, fixed asset expenditure, and depreciation.
To start, this program comes with a sequence of financial plan templates. The input templates provide monthly forecasts for any ten-year period, starting from any month or year. You can choose from monthly equity plans, loan note amortization schedules, monthly fixed asset expenditures, and depreciation schedules. There are five depreciation classes, covering any useful life periods from zero upwards. You can also create a sales plan that incorporates unit volume projections, unit price, and cost of sales. You can vary volumes and prices by any percentage value control to produce best-case, expected-case, and worst-case projections.
Company expenses are covered by straightforward monthly expense templates. Expenses are divided into six categories (personnel, G&A, marketing...), and category expenses are summarized in the P/L schedules. Working capital variables include days sales outstanding, days inventories outstanding, and percentage payable to sales. Again, you can change any assumptions to produce best, expected, and worst-case scenarios.
Your monthly forecasts are then converted into 10-year profit/loss forecasts, complete balance sheets, cash flows (source and application of monthly funds), and a management summary. Loan interest charges and reducing balances are incorporated into the profit/loss and balance sheets. The management summary includes a company valuation based on your selected EBITDA multiple.
Finally, you can easily print or present your spreadsheets in a presentable way. The download zip file contains a Dollar version, a Euro version, and a Tutorial version for your convenience. Overall, Funding Plan PRO is a comprehensive solution for anyone who needs to create accurate financial models for any 10-year projection. It's easy to use and provides a complete overview of your company's financial health.
Version 3.3: added support of 10 years funding plan