The Financial Projections model provides an in-depth analysis of the current year’s operations as well as a 4-year projection. Included in the template you will find:
• The Income Statement, Balance Sheet and Cash Flow Statement for the current year and 4-year forecast
• Detailed sections for Payroll, Sales and Operating Expenses for the current year and 4-year forecast
• Section containing Financial Analysis Ratios to dive deeper into the efficiencies of the business
All tabs are linked individually so information must be entered into each tab separately. Sections highlighted in light grey are used to input information that will flow to the top of the worksheet. This provides a Year-to-Date figure for the monthly information entered in the highlighted sections. Operating Expenses can be edited according to the specific expenses of the business. Formulas have been provided for each ratio in the Financial Analysis Ratio worksheet.
All cells in black font are input cells where custom information can be entered. All cells in blue font are formulas set to streamline the model. Sections are grouped to condense the model to view sections individually.