This is a very detailed and user-friend financial model with the three financial statements i.e. Income Statement, Balance Sheet, and Cash Flow Statement, and detailed calculation around DCF based valuation and financial analysis.
The model captures 3 years of Historical + 5 Years of the forecast period. Valuation is based on the 5-year forecast using Discounted Cash Flow methodology.
The assumptions tab allows for the input of a large amount of financial data for your business.
These inputs cover a wide range of financial data:
1. Revenue Assumption (Order Intake, Order Conversion, and Backlog)
2. Costs Assumptions (Raw Material, Subcontracting Cost & More)
3. Income tax
4. Working Capital Assumptions (Receivables, Payable, Inventory)
5. Capital Expenditure and Depreciation/Amortization (Tangle and In Tangible Assets)
6. Long Term and Short Term Debt
7. Share Capital (Issue of New shares, Reserve Accounts)
8. Dividend Calculation (Interim and Final Dividend along with Tax impact)
9. Interest Income and Expense calculations
The model runs comprehensive calculations based on the inputs provided by the user and generates very accurate outputs which include:
1. Income Statement: Includes Historical and forecast Profit and Loss statement
2. Balance Sheet: Includes Historical and forecast Balance sheet
3. Cash Flow Statement: Includes Historical and forecast cash flows
4. Valuation: DCF based valuation based on the forecast cash flows and discount rate assumptions
5. Valuation Ratio: A very detailed financial analysis covering:
– Price and EV based valuation ratios
– Per Share Data like EPS, DPS, FCFF per share & more
– Margin ratios
– Return ratios
– Dupont Analysis
– Gearing Ratios
– Liquidity ratios
– Coverage Ratios
– Activity Ratios
– Investment rations
– Enterprise value
Functional areas where this model can be used:
1. Investment Banking (Buy-Side and Sell-Side)
2. Equity Research Firms
3. Financial Analysis and Valuations
4. Financial Modeling with Best Practices
5. Business Planning for E&C companies
Similar Products
Other customers were also interested in...
Crane Truck Rental Company Financial Model
Step into the world of crane rental business success with our Crane Truck Rental Company Financial M... Read more
Construction/Engineering Project Business Financia...
3 statement 5 year rolling financial projection Excel model for a startup /existing business engaged... Read more
Public-Private Partnership (PPP) Financial Model
Financial Model presenting development and operating scenarios of various projects under a Public-Pr... Read more
Toll Road Financial Model (Development, Operation ...
Financial Model providing forecast and profitability analysis for a development and operating scenar... Read more
Oil and Gas Project Finance Model
Oil and Gas Project Finance Modeling Template. This is a project finance model for an oil and gas up... Read more
Tool Hire Company Finance Model
A very comprehensive editable Excel spreadsheet for tracking your tool hire financials throughout th... Read more
Plant Hire Business Financial Model
A comprehensive editable MS Excel spreadsheet for tracking your plant hire financials throughout the... Read more
Electrical Contractor Financial Model Excel Templa...
Electrical Contractor Financial Model Enhance your pitches and impress potential investors with the ... Read more
Startup Business Plan – Project Road Contrac...
In summary, the model easy to use, you need to update the “Front page” sheet and fill the green ... Read more
Biomass to Hydrogen Gas PPP Project Model Template
Biomass to Hydrogen Gas PPP Project Model with 3 Statements, Cash Waterfall & NPV – IRR Analys... Read more
You must log in to submit a review.