Financial Projection Online Calculator

Last modified September 30th, 2019 by Michael Brown
Sorry, the online calculator is not suitable for mobile screens, please view on a larger screen or alternatively download our Financial Projections Template for use offline.

This 3 year financial projection calculator is a free online tool. The calculator produces income statements, balance sheets, and cash flow statements for the next 3 years, and provides a quick and easy way to test the outline feasibility of your business idea.

Simply enter the amounts in the highlighted input cells and hit the 'Calculate' button. All amounts entered will be rounded to the nearest integer.

The contents of this calculator will be lost if you reload the page or press the reset button.

3 Year Financial Projections

Income Statement

%Year 1Year 2Year 3
Revenue
Cost of sales180003375045000
Gross margin220004125055000
Operating expenses
Depreciation50001400011600
Operating income1000825018400
Finance costs60023291874
Income before tax400592116526
Income tax expense8011843305
Net income320473713221

Balance Sheet

DaysOpeningYear 1Year 2Year 3
Cash 13882759515841
Accounts Receivable4932924712329
Inventory4438832211096
Current Assets16000132522516439266
Long-term assets200005600046400
Total assets36000332528116485666
Accounts Payable295955487397
Other liabilities274237014961
Current Liabilities60005701924912358
Long-term debt122314685835030
Total liabilities21000179325610747388
Capital100001500015000
Retained earnings500053201005723278
Equity15000153202505738278
Total liabilities and equity36000332528116485666

Cash Flow Statement

Year 1Year 2Year 3
Net income320473713221
Add back depreciation50001400011600
Changes in working capital1331-4651-2747
Cash flow from operating activities66511408622074
Amount paid for long term assets 2
Cash flows from investing activities-5000-50000-2000
Proceeds from long-term debt
Proceeds from issue of new capital
Repayment of long-term debt-2769-11373-11828
Cash flows from financing activities-276939627-11828
Cash flow-111837138246
Beginning cash balance500038827595
Ending cash balance3882759515841
1 Cash in the Balance Sheet should always be positive
2 Amount paid for long term assets should be entered as a negative amount
Notes and major health warnings Users use this financial projection calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of an financial projection accounting format that you might use. It is purely illustrative. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the financial projection calculator, please let us know and we will try to fix it. The statements produced are for your own use to give a guide as to the feasibility of your business idea and are not suitable for submission to third parties.