Assumptions

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

Income Statement

This sheet contains an annual income statement for 5 annual periods. All the rows with yellow highlighting in column A require user input in column C. Only the gross profit % rows require user input in all the annual columns. The values in all other rows are calculated automatically. Additional turnover & expense rows can be added if required and the template is suitable for both service & trade based businesses. The codes in column A apply to automated balance sheet calculations for sales tax, trade receivables

and trade payables.

CashFlow

This sheet includes a cash flow statement for 5 annual periods. No user input is required on this sheet. All the cash flow statement calculations are automated and based on the user input on the “Assumptions” sheet and the calculations on the balance sheet.

BalanceSheet

This sheet contains a balance sheet for 5 annual periods. All the calculations on this sheet are automated and no user input is required. The entire balance sheet is calculated based on the values on the annual income statement and cash flow statement. Opening balances at the start of the cash flow projection period can be included on the “Assumptions” sheet.

Loans

This is the first of four amortization tables calculated based on the balance sheet opening balances and loan terms specified in the template assumptions. No user input is required on these sheets and additional loan amounts can be added on the “Assumptions” sheet. The interest charges and capital repaymen amounts of each amortization table are automatically included on the income statement and cash flow statement. The template therefore accommodates automated loan calculations based on four different sets of loan repayment terms.

You must log in to submit a review.