How to Determine Other Liabilities Days Outstanding

For the purposes of the financial projection template other liabilities are defined as amounts owed by a business at the year end arising from operating expenses, finance costs, and income tax expenses. The year end value of other liabilities is calculated using the other liabilities days assumption.

How to Determine Other Liabilities Days Outstanding July 19th, 2017Team
Read more

Enter Other Liabilities Opening Balance

The opening day other liabilities balance forms part of the opening balance sheet of the business. For the purposes of the financial projections. other liabilities are amounts which are owed by the business in respect of operating expenses, finance costs and income tax expenses.

Enter Other Liabilities Opening Balance July 18th, 2017Team
Read more

Estimate New Capital

New equity capital is included in the cash flow statement of the projection as a positive figure as it represents cash flowing into the business from investors. For example, if in year two the plan inject new capital of 5,000 to finance the purchase of new machinery, the figure of 5,000 should be included in the cash flow statement on the proceeds from the issue of new share capital line.

Estimate New Capital October 5th, 2016Team
Read more

Operating Expense Formula

Customized operating expense formulas can be used in lines 7 to 9 of the Financial Projections Template to link operating expenses to another template cell value such as revenue, this allows amendments to be made to the estimated operating expenses for each of the five years without having to manually enter each amount.

Operating Expense Formula October 5th, 2016Team
Read more

Revenue Projection Formula

Customized revenue projection formulas can be used in line three of the Financial Projections Template to allow amendments to be made to the estimated revenue for each of the five years without having to manually enter each amount.

Revenue Projection Formula October 5th, 2016Team
Read more

Enter New Debt Payment Term

Debt finance is normally evidenced by a note or document which specifies the amount, interest rate, and date of repayment. The date of repayment will dictate the payment term for the debt, for example a debt might be payable in five years time.

In the previous step the new debt was entered, and in order to allow for this debt to be repaid, a new debt payment term needs to be entered.

Enter New Debt Payment Term October 5th, 2016Team
Read more

Estimate New Debt

For a business, debt can take many forms including loans, mortgages, borrowings, overdrafts, credit cards, and generally any form of finance on which interest is paid.

New debt is included in the cash flow statement of the projection as a positive figure as it represents cash flowing into the business from lenders. For example, if in year two the plan is to borrow 46,000 to finance the purchase of new equipment, the figure of 46,000 should be included in the cash flow statement on the new debt line.

Estimate New Debt October 5th, 2016Team
Read more

Estimate Capital Expenditure

Capital expenditure is amounts spent of long term assets during the accounting period.

Long term assets are assets which have a long life and are for use within the business and not held for resale, they include for example land, buildings, equipment, and plant and machinery, needed to get the new business up and running, ready to start producing and selling goods and services.

Capital expenditures are included in the financial projection as a negative amount in the cash flow statement, as money flows out of the business to pay for them.

Estimate Capital Expenditure October 5th, 2016Team
Read more

Enter Opening Debt Payment Term

Debt finance is normally evidenced by a note or document which specifies the amount, interest rate, and date of repayment. The date of repayment will dictate the payment term for the debt, for example a debt might be payable in five years time.

In the previous step the opening balance sheet debt was entered, and in order to allow for this debt to be repaid, an opening debt payment term needs to be entered.

Enter Opening Debt Payment Term October 5th, 2016Team
Read more

How to Determine Inventory Days

Inventory or stock as it is sometimes referred to, is the total of raw materials, work in process, and finished goods that a business holds for the purpose of resale.

If the value of the inventory is divided by the value of the average daily cost of sales, then the resulting figure is the average number of days sales which the business is holding. This number is referred to as inventory days, days inventory outstanding, inventory turnover days, or stock days.

How to Determine Inventory Days October 5th, 2016Team
Read more

How to Determine Days Payable Outstanding

A business which purchases on account from its suppliers will at any point in time have amounts outstanding to them for unpaid invoices. The amount outstanding is referred to as accounts payable or sometimes as trade creditors.

If the value of the accounts payable is divided by the value of the average daily cost of sales, then the resulting figure is the number of days of payable which are outstanding. This number is sometimes referred to as days payables outstanding, accounts payable days or trade creditor days.

How to Determine Days Payable Outstanding July 19th, 2017Team
Read more

How to Determine Days Sales Outstanding

A business which sells on account to its customers will at any point in time have amounts outstanding from them for unpaid invoices. The amount outstanding is referred to as accounts receivable or sometimes as trade debtors.

If the value of the accounts receivable is divided by the value of the average daily sale, then the resulting figure is the number of days of sales which are outstanding. This number is sometimes referred to as day sales outstanding, accounts receivable days or trade debtor days.

How to Determine Days Sales Outstanding October 5th, 2016Team
Read more

You May Also Like