This spreadsheet provides a complete three (or five) year company financial plan. It assumes no prior accounting knowledge and guides you through the steps in forecasting sales, calculating expenses, borrowing funds and purchase of fixed assets. With the inputs, the spreadsheet automatically generates a complete three (or five) year financial plan and forecasts including monthly and yearly Income Statements, Balance Sheets and Cash Flow Statements. A Common Size Financial Statement, a Financial Ratio Analysis worksheet and a Valuation report are also generated automatically for further analysis of the company.
Bonus
Financial Planning and Forecasting using historical Financial Statements spreadsheet