General and Administrative Cost Model

General & administrative costs are a necessary part of operating a business. Expenses associated with general and administration such customer acquisition costs and the costs to service customers throughout the customer life-cycle, need to be included in the income statement of the financial projections template, and this model allows those cost to be estimated in detail and summarized.

General and Administrative Cost Model October 5th, 2016Team
Read more

Sales and Marketing Cost Model

Sales & marketing costs are a necessary part of operating a business. Expenses associated with sales and marketing such customer acquisition costs and the costs to service customers throughout the customer life-cycle, need to be included in the income statement of the financial projections template, and this model allows those cost to be estimated in detail and summarized.

Sales and Marketing Cost Model October 5th, 2016Team
Read more

Research and Development Cost Model

R&D costs are a necessary part of developing new products for a business. Expenses associated with R&D such as staff costs, need to be included in the income statement of the financial projections template, and this model allows those cost to be estimated in detail and summarized.

Research and Development Cost Model December 12th, 2016Team
Read more

Profit Improvement Calculator

The profit improvement calculator shows the impact on net income of making percentage adjustments to the product selling price, unit cost, unit sales volume and operating expenses. Minor adjustments to each of these four key areas can have a significant impact on the net income of the business.

Profit Improvement Calculator October 5th, 2016Team
Read more

Gross and Net Profit Margin

The gross profit and net profit margins are used as measures of profitability. The gross margin indicates whether the products produced and sold by the business are profitable, whereas the net margin indicates the profitability of the entire business taking into account all expenses.

Gross and Net Profit Margin 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

16 Things To Know About Creating Financial Projections

Financial projections are made up from three financial statements, the balance sheet, the income statement, and the cash flow statement. Here are sixteen things to know about creating financial projections which should give you a better understanding of what’s included in the three financial statements, and how they relate to each other.

16 Things To Know About Creating Financial Projections October 5th, 2016Team
Read more

Cash vs Accrual Accounting in Financial Projections

It is important to consider both the cash basis and accrual basis of accounting when preparing financial projections.

Cash basis accounting records revenue and expenses when cash enters and leaves the business, and the accrual basis of accounting records revenue when earned and expenses when the benefit of them is received.

Cash vs Accrual Accounting in Financial Projections October 5th, 2016Team
Read more

Pro Forma Financial Statements

The terms pro forma financial statements, financial projections, financial forecasts, and financial budgets are often used interchangeably, but they are not the same thing.

Pro forma financials simply refers to a set of financial statements in the usual format (balance sheet, income statement, and cash flow statement), which have been prepared in order to show the effects of a transaction on the historical financial statements prior to the transaction actually taking place.

Pro Forma Financial Statements October 5th, 2016Team
Read more

Startup Financial Projections Checklist

The financial projections checklist can be used at any stage, but is particularly useful for startup businesses preparing financial projections for first time. The checklist provides a listing of some of the most common items to check for when reviewing financial projections.

Startup Financial Projections Checklist October 5th, 2016Team
Read more