Search the site...

Finance Web Apps
  • Home
  • Web Apps
    • Investment Appraisal
    • Projections
    • Cash Flow Forecast
    • Sensitivity Analysis
    • Profit Simulation >
      • Profit Simulation Normal Distribution
    • Loan Calculators >
      • Loan Prepayment Calculator
      • Interest Rate Sensitivity
    • Sales Forecasting
    • Pension Calculator
    • Real Option Calculator
    • Depreciation Calculator
    • Company Valuation
    • WACC Calculator
    • Optimal Capital Structure
    • Loan Fair Value
    • Bond Yield & Duration
    • Bond Exp Return
    • Beta Calculator
    • VAR Calulcator
    • Options Payoff Graph
  • About Us
  • Useful Links
  • Contact us
  • Home
  • Web Apps
    • Investment Appraisal
    • Projections
    • Cash Flow Forecast
    • Sensitivity Analysis
    • Profit Simulation >
      • Profit Simulation Normal Distribution
    • Loan Calculators >
      • Loan Prepayment Calculator
      • Interest Rate Sensitivity
    • Sales Forecasting
    • Pension Calculator
    • Real Option Calculator
    • Depreciation Calculator
    • Company Valuation
    • WACC Calculator
    • Optimal Capital Structure
    • Loan Fair Value
    • Bond Yield & Duration
    • Bond Exp Return
    • Beta Calculator
    • VAR Calulcator
    • Options Payoff Graph
  • About Us
  • Useful Links
  • Contact us

Financial Statement Projections 

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:

  1. The tax charge for a particular forecast year is assumed to be paid in the following forecast year.
  2. 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.
  3. The forecast current assets are calculated by applying the actual current assets over revenue ratio to the forecast revenues.
  4. The forecast current liabilities are calculated by applying the actual current liabilities over expenses ratio to the forecast expenses.
  5. The forecast interest expense for a particular year is calculated on the average of the opening and closing borrowings balance for that year.​​
  6. To delete an amount in a cell type '0'.
  7. The net cash flow outputs could be used as inputs in our valuation tool to calculate the estimate fair value of the company 
  8. 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

home

Useful Links

About

Terms & conditions

Privacy Policy

Contact

www.financewebapps.com Copyright © 2019