Question: From the discounted cash flow analysis, using a WACC 16.8 % as the discount rate. Find the implied equity value on January 1, 2021? Can

From the discounted cash flow analysis, using a WACC 16.8 % as the discount rate. Find the implied equity value on January 1, 2021? Can some one explain and help.

1) $79,946

2) $77,210

3) $73,712

4) $79,229

From the discounted cash flow analysis, using a WACC 16.8 % as

DCF Analysis 01.01.2021 31.12.2021 31.12.2021 Time Periods Date Date for NPV (Annual Cash Flows) Year Fraction Time period EBITDA Terminal Value 0,5 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 1,0 1,0 1.0 1,0 1,0 1,0 0 1 2 3 4 5 6 $18 092 $17219 $16 292 $15 308 $14264 $13 159 $11 989 $10 753 $107 527 $19 680 $18 911 Unlevered Free Cash Flow EBITDA Depreciation EBIT Unlevered Taxes Depreciation Capital Expenditures Change in Non-Cash Working Capital Unlevered Free Cash Flow $19 680 $4 182 $23 862 ($4 262) $4 182 $12 240 $368 $36 390 $18 911 $4287 $23 198 ($4022) $4 287 $12546 $385 $36 395 $18 092 $4 394 $22 486 ($3767) $4 394 $12 860 $403 $36 376 $17 219 $4504 $21723 ($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) $4 732 $13 848 $461 $36 172 $14 264 $4850 $19 114 ($2 589) $4 850 $14 195 $482 $36 052 $13 159 $4 971 $18 130 ($2 252) $4971 $14550 $504 $35 903 $11 989 $5095 $17084 ($1 896) $5 095 $14913 $526 $35 723 $10753 $5 223 $15 975 ($1 521) $5 223 $15 286 $549 $35 513 $36 390 $36 395 $36 376 $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 $35 513 $107 527 $143 040 $0) $36 390 $36 395 $36 376 $36 333 $36 266 $36 172 $36 052 $35 903 $35 723 $293 939 16,80 % 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 $0 $0 $293 939 DCF Analysis 01.01.2021 31.12.2021 31.12.2021 Time Periods Date Date for NPV (Annual Cash Flows) Year Fraction Time period EBITDA Terminal Value 0,5 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 1,0 1,0 1.0 1,0 1,0 1,0 0 1 2 3 4 5 6 $18 092 $17219 $16 292 $15 308 $14264 $13 159 $11 989 $10 753 $107 527 $19 680 $18 911 Unlevered Free Cash Flow EBITDA Depreciation EBIT Unlevered Taxes Depreciation Capital Expenditures Change in Non-Cash Working Capital Unlevered Free Cash Flow $19 680 $4 182 $23 862 ($4 262) $4 182 $12 240 $368 $36 390 $18 911 $4287 $23 198 ($4022) $4 287 $12546 $385 $36 395 $18 092 $4 394 $22 486 ($3767) $4 394 $12 860 $403 $36 376 $17 219 $4504 $21723 ($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) $4 732 $13 848 $461 $36 172 $14 264 $4850 $19 114 ($2 589) $4 850 $14 195 $482 $36 052 $13 159 $4 971 $18 130 ($2 252) $4971 $14550 $504 $35 903 $11 989 $5095 $17084 ($1 896) $5 095 $14913 $526 $35 723 $10753 $5 223 $15 975 ($1 521) $5 223 $15 286 $549 $35 513 $36 390 $36 395 $36 376 $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 $35 513 $107 527 $143 040 $0) $36 390 $36 395 $36 376 $36 333 $36 266 $36 172 $36 052 $35 903 $35 723 $293 939 16,80 % 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 $0 $0 $293 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!