Assumptions

This sheet contains the input values used to automate certain cash flow projection calculations. The reporting periods included in the income statement, cash flow statement, and balance sheet are determined by the start date specified at the top of the sheet. Additional assumptions include annual turnover growth, annual expense inflation, inventory levels, trade receivables, trade payables, payroll accruals, sales tax, income tax, loan terms, opening balance sheet balances, and dividends.

IncomeStatement

This sheet presents a monthly income statement covering 12 monthly periods and 5 annual periods. All rows highlighted in yellow in column A require user input in the monthly columns. Only the gross profit percentage rows require user input in the annual columns. All other rows are calculated automatically. Additional turnover and expense rows may be added if required, and the template is suitable for both service-based and trade-based businesses. The codes in column A are used for automated balance sheet calculations relating to sales tax, trade receivables, and trade payables. Monthly reporting periods are determined by the start date specified at the top of the Assumptions sheet.

CashFlow

This sheet includes a cash flow statement for 12 monthly periods and 5 annual periods. All rows highlighted in yellow in column A require user input in the monthly columns. Inputs for years 2 to 5 should be entered on the Assumptions sheet. All rows without yellow highlighting in column A are calculated automatically.

BalanceSheet

This sheet contains a balance sheet for 12 monthly periods and 5 annual periods. All calculations are fully automated, and no user input is required. The balance sheet is calculated using data from the monthly income statement and cash flow statement. Opening balances at the start of the cash flow projection period can be entered on the Assumptions sheet.

Loans1

This sheet contains the first of four loan amortization tables, calculated using the opening balance sheet values and loan terms specified in the template assumptions. Additional loan amounts may be entered in column C. Interest charges and principal repayment amounts from each amortization table are automatically reflected in the income statement and cash flow statement. The template therefore supports automated loan calculations across four separate sets of loan repayment terms.

You must log in to submit a review.