ideas to numbers .. simple financial projections
In the financial projections template other liabilities represents amounts owed in respect of operating expenses, finance costs and income tax expenses. This free Excel financial calculator calculates the other liabilities days outstanding by entering details of the expenses, number of days in the accounting period, and the other liabilities balance.
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.
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.
A business needs to finance its working capital requirements using a combination of short term and long term funding sources. Permanent working capital is best financed with long term funding such a equity or long term loans, whereas temporary seasonal working capital is best funded by short term loans or overdraft facilities.
The fundamentals of a businesses trading activity are that it buys from a supplier, holds inventory, and sells to the customer. The amount of finance a business needs to carry out this day to day trading activity is known as the working capital requirement, and varies from industry to industry depending on the amount of time the business takes to pay suppliers, the amount of inventory held, and the time it takes to collect cash from customers.
Accounts payable represent amounts owed by a business for goods purchased on account from its suppliers.
Days payable outstanding is calculated using the days payable outstanding formula and shows the average number of days the business is taking to pays its suppliers for purchases on account.
The Excel days payable outstanding calculator, available for download below, calculates the days payable outstanding by entering details of cost of sales, number of days in the accounting period, and the accounts payable balance.
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.
The opening day accounts payable balance forms part of the opening balance sheet of the business. Accounts payable are amounts which are owed by the business to its suppliers, they are sometimes referred to as trade creditors.
If a supplier allows a business credit and invoices it for a product or service and payment is made at a later date 30 days 60 days etc, then while the business owes the supplier the money it are classified as an accounts payable in the accounts of the business.