overview
Generate up to 8 years of financial statement projections using our below free and simple to use projection web application. Simply add your forecast assumptions and latest actuals into the yellow cells. The web app will use these inputs to generate up to 8 years of forecast income statements, balance sheets and cash flow statements. Please note the following general points and assumption methodologies:
A similar downloadable version of the tool can be obtained here.
- The tax charge for a particular forecast year is assumed to be paid in the following forecast year.
- The Fixed Asset opening balance is assumed to have a remaining useful life equal to the the number of year included in the input section.
- The forecast current assets are calculated by applying the actual current assets over revenue ratio to the forecast revenues.
- The forecast current liabilities are calculated by applying the actual current liabilities over expenses ratio to the forecast expenses.
- The forecast interest expense for a particular year is calculated on the average of the opening and closing borrowings balance for that year.
- To delete an amount in a cell type '0'.
- The net cash flow outputs could be used as inputs in our valuation tool to calculate the estimate fair value of the company
- None of the inputs and outputs will be saved once the webpage is closed, this data also cannot be retrieved. If you would like to save a copy of the output please print or take a screen shot of the webpage before closing.
A similar downloadable version of the tool can be obtained here.
DISCLAIMER:
Whilst every effort has been made to ensure the accuracy of the information and tools contained in all our web pages, we do not accept any liability for any direct, indirect, incidental or consequential losses of any kind arising out of or in connection with the use of the tools and information derived from this website. The tools and information in all our web pages are only meant as a guide, please use at your own risk and always seek professional advice before making any decisions. For full terms and conditions please click here
SIMILAR TOOLS AVAILABLE FOR DOWNLOAD
check out our other fINANCE WEB APPS
- Investment Appraisal Tool
- Loan Fair Value Calculator
- Cash Flow Forecast
- Sensitivity Analysis
- Monte Carlo Simulation
- Optimal Capital Structure
- Loan Calculators
- Pension Calculator
- Sales Forecasting
- WACC Calculator
- Company Valuation Calculator
- Depreciation Calculator
- Real Option Calculator
- Bond Yield and Duration Calculator
- Bond Expected Return Calculator
- Value At Risk (VAR) Calculator
- Beta Calculator
- Option Payoff Graph
Share this Web Page