From the blog

News, articles and advice for all things related to business and marketing.

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.

 

excel_icon

Tags: | | | |