Overview

Excel Financial Model & Valuation.

This is a generic financial model that allows the user to forecast the Company's profit and loss account, balance sheet, cash flow statement, and it also estimates the value of your company/Investment using the DCF method.

The tabs provided can be split into two main categories:

1. Input tabs:

A) General inputs - in this tab you will enter general information about currency, valuation date, forecast years;

B) Income Statement- in this tab the user can enter the Income Statement items (including interim accounts);

C) Balance Sheet - in this tab one can enter the historical balance sheet items(including interim accounts);

D) Cash Flow- in this tab you can enter the historical Cash Flow Statement items(including interim accounts);

E) Forecast Input:
 In this tab the user can enter up to 26 Drivers for the different forecast outputs.
 The automatic scenario is evaluated through the historical data.
 Some drivers are the same for the different scenarios, excepting for the Absolute scenario Case, where the user must input the values accordingly;
 For some drivers it's only possible the absolute numbers approach, so in those cases the absolute numbers are the same for all scenarios;
 For the main drivers (i.e. Revenues, OpexCapex) the Growth % for the Base, Conservative and Stress Scenarios;
e) DCF Valuation

2. Output tabs:

A) Forecast Fin. Statement (Including Balance Sheet, Cash Flow Statement and Income Statement);

B) Forecast Fin. Highlights (containing the major financial ratios, covering Balance Structure, Debt Equity, Liquidity, Working capitaletc)

C) Cases Overviewallowing the comparison of the different scenarios (including the comparison between the Net Income, EBITDA, Free Cash Flow, Balance structure, Earnings per Share P/E, Share priceetc)

This is a powerful tool that will allow the user to create accurate forecasts, whit multiple scenarios, for a Company (or Investment).

Reviews Add a review
No reviews yet

More From Jair

Browse our top rated business templates. See All
Convenience Store Gas Station Financial Plan
515
0
This Financial Plan Model is a perfect tool for a financial feasibility study on launching a Convenience Store Gas Station. The model can be used to create 5 years’ projections.   The model…
Bakery Financial Plan
548
1
This financial model can be utilized to evaluate a bakery business feasibility. This template is detailed, robust and very user-friendly.…
Mobile App Business Case Financial Model
559
0
The mobile app financial model provides a comprehensive financial plan template for a mobile app business such as a startup…
Real Estate Condo Development Model - With Pre-sold units
521
0
This is a fully functional, institutional quality and dynamic real estate Development Financial Model, which will allow the user to…
Real Estate - Land Development Model
560
1
This financial model can be used to evaluate a real estate investment opportunities such as a land development project. It’s…
Hotel Valuation - Real Estate Development Model
590
0
This template is a very detailed financial model that takes into account the specifics of the real-estate niche that is…
See All