Cost Forecast Using Excel Regression Analysis

Financial projections require cost forecasts to be made based on key cost drivers. Most costs are mixed in that they contain both a variable and a fixed cost component. Excel linear regression analysis can be used to identify both of these components based on past data to enable a cost forecast equation to be developed.

Last modified October 17th, 2018 by Michael Brown
Read more

Limiting Factor Analysis

Limiting factor analysis is a technique used by a business to identify which of its products should be manufactured in order to maximize profits when there are scare resources. It can be used as part of a financial projection in order to ensure that unit sales forecasts do not exceed available production capacity.

Last modified November 21st, 2018 by Michael Brown
Read more

Expense Forecasting

To simplify the process of expense forecasting there are various techniques which can be employed to link each type of expense to other variables (cost drivers), such as revenue or headcount, which have already been forecast in the financial projections. Of course there will always be expenses which are fixed in nature, which cannot be linked to other variables and need to be estimated in absolute monetary terms.

Last modified October 5th, 2016 by Michael Brown
Read more

Cost Structure in a Business Plan

Cost structure is an important factor to consider when producing financial projections. A high fixed cost structure will result in the need for higher levels of sales in order for the business to break even.

Last modified November 9th, 2018 by Michael Brown
Read more

You May Also Like