Question: I need help and explaining to how, and with which formulas to use to find this: Based on the DCF analysis and using WACC as

I need help and explaining to how, and with which formulas to use to find this:

"Based on the DCF analysis and using WACC as the discount rate, what is the implied equity value of Company XYZ on January 1, 2021?"

A) 79,946

B) 77,210

C) 73,712

D) 79,292

WACC = 16.8 %

I need help and explaining to how, and with which formulas to

B C D E F G 1 N H 2022E K 2025E L 2026E M 2027E o 2029E 2021E 2023E 2024E 2028E 2030E DCF Analysis Time Periods Date Date for NPV (Annual Cash Flows) Year Fraction Time period EBITDA Terminal Value 01.01.2021 31.12.2021 31.12.2021 31.12.2021 31.12.2021 31.12.2022 31.12.2023 31.12.2024 31.12.2025 31.12.2026 31.12.2027 15.06.2024 31.12.2024 31.12.2025 31.12.2026 31.12.2027 31.12.2028 31.12.2029 31.12.2030 0,5 1,0 1,0 1,0 1,0 1,0 1,0 0 1 2 3 4 5 6 $17 219 $16 292 $15 308 $14 264 $13 159 $11989 $10 753 $107 527 Unlevered Free Cash Flow EBITDA Depreciation EBIT Unlevered Taxes Depreciation Capital Expenditures Change in Non-Cash Working Capital Unlevered Free Cash Flow $17219 $4504 $21 723 ($3 497) $4504 $13 181 $422 $36 333 $16 292 $4616 $20 908 ($3 211) $4616 $13511 $441 $36 266 $15 308 $4732 $20 040 ($2 909) $4732 $13 848 $461 $36 172 $14 264 $4 850 $19 114 ($2 589) $4 850 $14 195 $482 $36 052 $13 159 $4971 $18 130 ($2 252) $4971 $14550 $504 $35 903 $11 989 $5 095 $17 084 ($1 896) $5 095 $14913 $526 $35 723 $10 753 $5223 $15 975 ($1 521) $5 223 $15 286 $549 $35 513 $36 333 $36 266 $36 172 $36 052 $35 903 $35 723 Adjusted Unlevered Free Cash Flow Terminal Value Total Adjusted Unlevered Free Cash Flow $35513 $107 527 $143 040 $0 $0 $0 $0 $36 333 $36 266 $36 172 $36 052 $35 903 $35 723 $293 939 Net Present Value (NPV) Present Value of Free Cash Flows Present Value of Terminal Value Total Net Present Value (NPV) Add: Cash Less: Debt Equity Value $293 939 $50 000 $0 $343 939 B C D E F G 1 N H 2022E K 2025E L 2026E M 2027E o 2029E 2021E 2023E 2024E 2028E 2030E DCF Analysis Time Periods Date Date for NPV (Annual Cash Flows) Year Fraction Time period EBITDA Terminal Value 01.01.2021 31.12.2021 31.12.2021 31.12.2021 31.12.2021 31.12.2022 31.12.2023 31.12.2024 31.12.2025 31.12.2026 31.12.2027 15.06.2024 31.12.2024 31.12.2025 31.12.2026 31.12.2027 31.12.2028 31.12.2029 31.12.2030 0,5 1,0 1,0 1,0 1,0 1,0 1,0 0 1 2 3 4 5 6 $17 219 $16 292 $15 308 $14 264 $13 159 $11989 $10 753 $107 527 Unlevered Free Cash Flow EBITDA Depreciation EBIT Unlevered Taxes Depreciation Capital Expenditures Change in Non-Cash Working Capital Unlevered Free Cash Flow $17219 $4504 $21 723 ($3 497) $4504 $13 181 $422 $36 333 $16 292 $4616 $20 908 ($3 211) $4616 $13511 $441 $36 266 $15 308 $4732 $20 040 ($2 909) $4732 $13 848 $461 $36 172 $14 264 $4 850 $19 114 ($2 589) $4 850 $14 195 $482 $36 052 $13 159 $4971 $18 130 ($2 252) $4971 $14550 $504 $35 903 $11 989 $5 095 $17 084 ($1 896) $5 095 $14913 $526 $35 723 $10 753 $5223 $15 975 ($1 521) $5 223 $15 286 $549 $35 513 $36 333 $36 266 $36 172 $36 052 $35 903 $35 723 Adjusted Unlevered Free Cash Flow Terminal Value Total Adjusted Unlevered Free Cash Flow $35513 $107 527 $143 040 $0 $0 $0 $0 $36 333 $36 266 $36 172 $36 052 $35 903 $35 723 $293 939 Net Present Value (NPV) Present Value of Free Cash Flows Present Value of Terminal Value Total Net Present Value (NPV) Add: Cash Less: Debt Equity Value $293 939 $50 000 $0 $343 939

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Cash flow helps to overlook the company for the progress, ability to meet the creditors and debtors, growth, actual cash position as it is the basis of financial operations and also help to internal...

Pls find the attached financial documents. Excel has to be filled out UV5144 Rev. Sept. 1, 2011 CARDED GRAPHICS, LLC: SHEETER REPLACEMENT DECISION I don't play to lose. Murry Pitts, Carded Graphics...

The Company that has been chosen is Tesla. Maximum pages is 16 PERFORMANCE ANALYSIS : Give short company profile. Construct a table and summarize your companys performance data for 5 years. Use only...

BACKGROUND The Big Consumer Product Company acquires 100% of Green Grass Diapers for $ 540000 on 12/31/x0. Green Diapers company is diaper manufacturer that specializes in the manufacture of organic...

PLEASE HELP, would love the steps and process it took to complete this, but answers work as well. Project 1: A bicycle manufacturer has an opportunity to begin making a new higher-end model which has...

302 Prime Page Data Pret 2 The same equipment manufacturer has another opportunity presented to and the current actory to increase production and may be able to reach new market with tranded...

DCF Analysis - Apply the appropriate discount rate for each scenario ( worst case, base case, best case ) to calculate the present value of the FCFs over the * NEXT * 5 years. - Determine the...

2. How many aircraft does Airbus need to sells per year in order to make a profil brithe nvestment is this number greater or less than your estimate of total demand for very large aircraft (VLA) over...

Company is TESLA PERFORMANCE ANALYSIS : Give short company profile. Construct a table and summarize your companys performance data for 5 years. Use only key items such as Revenue, COGS, GP, Operating...

Murry Pitts was passionate about his business. He firmly believed that to survive and thrive in the folding carton industry, Carded Graphics needed to be the leanest, most agile, and most efficient...

Groupthink is a serious problem because it can influence people to make bad decisions. First, what is the psychological attribute of groups that is most heavily involved in groupthink? Provide a...

Identify the following expressions as true or false. If true, prove the result; if false, give a counterexample. (a) (b) (c) (a; + 1) = a,

You sell two December futures contracts when the futures price is $ 1 , 0 1 0 per unit. Each contract is on 1 0 0 units and the initial margin per contract that you provide is $ 2 , 0 0 0 . The...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

In Tableau, the benchmark colors show below 60 percent as red, below 80 percent as yellow, and below 100 percent as green. Why might a manager consider 80100 percent of the previous years results...

How many stores exceeded the KPI target in 2015?

If management is interested in lowperforming stores, where would they locate the cluster on this graph?