Free Business Financial Forecast Template in Excel to Download
Date posted: 5 December 2015 | Posted in: Free Business Tools Downloads
Free 2 year financial projection template in Excel
There are lots of times when businesses want to make financial forecasts for the future but it can be a bit ‘finger in the air’ sometimes!
Here’s a useful method of doing it in Excel using the TREND function.
You enter your sales & costs per quarter for the past 2 years and this sheet will calculate sales, costs & profit for the next 2 years, by quarter, based on the historical trend – (only enter data in the red areas of the sheet). It will also produce a snazzy graph.
It may not be perfect (as lots of things can change in business) but at least it’s based on some reality.
Click the icon to download.