Check out our Black Friday Sale – new deals added (and removed) daily!

  Please register (it's free!) or login to view the remaining preview.
If you are logged in, your referral link [?] is automatically included below.
EMBED CODE (Copy and Paste)


BENEFITS OF DOCUMENT

  1. Enables users to calculate DCF and perform Business Valuation and Sensitivity Analysis
  2. Customizable for any type of business/industry

DOCUMENT DESCRIPTION

User friendly template providing valuation tools for any type of business/industry.

Template includes 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. They are used to populate the sensitivity tables in a different worksheet, so please do not edit
-In the "Sensitivity" tab, you may change the blue colored percentage(%), to see how a change in the output impacts the share price

Got a question about the product? Email us at [email protected] or ask the author directly by using the form to the right. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: DCF & Sensitivity - Business Valuation Model Excel document

 

DCF & Sensitivity - Business Valuation Model

Sold by GL Consulting (this author has 63 documents)

$69.00

ALL FEES INCLUDED
Add to Cart
  

This business document is categorized under the function(s):

It applies to All Industries

File Type: Excel (xlsx)

File Size: 119.2 KB

Related Topic(s): Valuation Model Example

Purchase includes lifetime product updates. After your purchase, you will receive an email to download this document.

Initial upload date (first version): May 2, 2021
Most recent version published: Aug 13, 2021

Ask the Author a Question

Must be logged in Click here to log in



This document is available as part of the following discounted bundle(s):


All-in-One General Financial Models

$350.00

This bundle contains 8 additional documents.

View Full Details

Excel workbook
$69.00
Author:
Excel workbook
$59.00
Author:
Excel workbook
$49.00
Author:
Excel workbook
$49.00
Author:
Excel workbook
$59.00
Author:
Excel workbook
$69.00
Author:
Excel workbook
$49.00
Author:
Excel workbook
$39.00
Author:

Investment Models

$290.00

This bundle contains 4 additional documents.

View Full Details

Excel workbook
$76.00
Author:
Excel workbook
$109.00
Author:
Excel workbook
$69.00
Author:
Excel workbook
$69.00
Author:




CUSTOMER TESTIMONIALS




SELECT CUSTOMERS

Since 2012, we have provided best practices to over 5,000 businesses and organizations of all sizes across the world—in over 130 countries. Below is just a very small sample of our customer base.



Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.



CUSTOMERS ALSO BOUGHT THESE DOCUMENTS

Excel workbook
$25.00
Excel workbook
$30.00
Excel workbook
$20.00
Excel workbook and supporting Excel workbook
$30.00
Excel workbook
$99.00
Excel workbook
$35.00
Author: pdA63Utu
Excel workbook
$69.00

 
RELATED TOPICS

TOP 10 TOPICS

Become your organization's resident expert on...

Digital Transformation
 
Strategy Development
 
Organizational Design (OD)
 
Post-merger Integration (PMI)
 
Performance Management
 
Business Transformation
 
Organizational Culture (OC)
 
Customer-centric Design (CCD)
Interested in something else? Browse our 350+ Business Toolkits of best practices, each focused on a specific management topic.