General Overview
User-friendly template providing valuation tools for any type of business/industry.
The template includes a 3 Statement Financial Model for 5-Year Actual and 5-Year Forecast Scenario, Calculation of WACC, Discounted Cash Flow and Business Valuation, and highly-sophisticated Sensitivity Analysis.
The template is built using Financial Modeling Best Practices and is fully customizable.
Inputs:
• Contents: Update Company’s General Info and select currency from the drop-down list
• Financial Statements: Update Assumptions for Forecast Periods. Update Income Statement, Balance Sheet, Cash Flow, and Supporting Schedules Data for the Actual Periods
• WACC: Update Data for Comparable Companies and Calculation Assumptions.
• DCF & Valuation: Update Valuation Assumptions
Outputs:
• Financial Statements: 5-Year Forecast
• WACC: Calculation of Weighted Average Cost of Capital, which is used for Business Valuation
• DCF & Business Valuation: Discounted Cash Flow, Calculation of Enterprise Value, Equity Value, Targeted Share Price, IRR and Valuation Ratios
• Sensitivity Analysis: Presentation of various outputs and assumptions that affect Share Price
General Notes:
• Beta in WACC Tab is calculated based on Comparable Companies data. You can use sites as Yahoo Finance, Statistica, Capital IQ, etc. for reference
• Some cells in tabs “DCF & Valuation” & “Sensitivity Analysis” are locked (can be unlocked). They are used to populate the sensitivity tables in a different worksheet within the template, so please do not edit (unless you know how to update the formula and other dependents)
• In the “Sensitivity” tab, you may change the blue colored percentage(%), to see how a change in the output impacts the share price
For any inquiry/modification, please contact me via our support team: [email protected]
Similar Products
Other customers were also interested in...
Advanced Financial Model with DCF & Valuation
General Overview Advanced Financial Model suitable for any type of business/industry and fully cu... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
Mergers & Acquisitions (M&A) Financial M...
Advanced Financial Model presenting a potential Merger & Acquisition (M&A) transaction between t... Read more
Leveraged Buyout (LBO) Financial Model
Advanced Financial Model presenting a potential acquisition of a public or private company using a s... Read more
General Financial Models – All-in-One Bundle
A collection of templates suitable for various types of businesses/industries, covering major accoun... Read more
Investment Financial Models – All-in-One Bundle ...
A collection of templates suitable for investment decisions in various types of businesses/industrie... Read more
Cap Tables & Investor Returns Model
User-friendly Cap Table Model for a startup company or early-stage venture including multiple rounds... Read more
Budgeting & Forecasting Model Template
Budgeting & Forecasting Template suitable for either a Trade or Service company in any type of i... Read more
From Trial Balance to Business Valuation – M...
Management Accounts Template, providing full reporting cycle and mapping between accounting and fina... Read more
Three Statement Financial Model with Scenario Anal...
A 3 statement model linking the income statement, balance sheet, and cash flow statement into one dy... Read more
You must log in to submit a review.