sales forecasting
prediiting future sales volume/revenue based on past sales data and market research
how does sales forcasting help the finance function
helps to produce cash flow forecasts to help identify if more finance is needed
how does sales forcasting help the marketing function
marketing department knows periods that sales are predicted low, socan plan on how to increase
how does sales forcasting help the operations function
know amont of people needed to produce stock
how does sales forcasting help the HR function
understand that high volume may cause stress and absenteeism
Time series data
Sales figures that have been collected at consistent time intervals and presented in time order.
Advantages of scatter graphs to find correlations
Disadvanteges of scatter graphs to find correlations
Extrapolation
Using trends in past sales data to forecast future sales
Advanatages of extrapolation
Useful in stable environments where the size of the market or number of competitors are unlikely to change
Disadvantages of extrapolation
Past performance does not gurantee sales performance will continue in the future
how to calculate payback
Calculate annual net cash flow of project (inflows - outflows)
Calculate the cumulative net cash flow
(net cash flow of previous year + net cash flow of year)
Identify the year pay back was achieved
(cumulative cash flow of last negative year / net cash flow of positive year after that x 12)
advantages of pay back
Disadvantages of Payback
What is Payback
The length of time it takes to pay back the initial cost of an investment
Average Rate of return
How much of the investment cost is returned as annual profit
How to calculate ARR
Advantages of ARR
Disadvantages of ARR
Net present value
How much the profit is worth in the future years
How to calculate net present value
(Net cash flow year 1 x discount factor) + (Net cash flow year 2 x discount factor)….. Minus Initial cost
Advantages of NPV
Disadvantages of NPV
Decision Trees
Mathematical models representing the likely outcomes for a business of a number of courses of action, showing the financial consequences of each