Question

1 Approved Answer

Posted on Aug 03, 2024

You should include a qualitative analysis where you detail the reasons supporting your chosen super-normal growth rate. You should also justify your chosen time-horizon of

You should include a qualitative analysis where you detail the reasons supporting your chosen super-normal growth rate. You should also justify your chosen time-horizon of this supernormal growth stage of the business cycle of the firm (how long the firm will grow at this super normal rate before using the long term growth rate).

The qualitative analysis must be at least 2 pages (single-spaced and typed), you should comment on all of the parameters in the Excel sheet Assumptions.

Your valuation calculations should be also included after these 2-page qualitative analysis.

image text in transcribed

Free Cash Flows and Valuation Summary niu -I1EEI -- 11/144EM PP va "Lu Hi THEM PHI HIiun us DCF. Several of the parameters are assumed and/or fixed-through-time for simplicity will be filled automatically after you have input parameters in have chosen the relevant parameters as well. Fixed Assets (You will need this field to calculate depreciation expense) 4,000.00 4.200.00 4.410.00 4.630.50 4,862.03 Revenues - Cost of Goods Sold = Gross Margin - Depreciation & Amortization - All Other Expenses except Interest (for simplicity) - EBIT: Tares NOPAT + Depreciation & Amortization - Increases to Working Capital (you can assume 0 for this project) CAPEX Free Cash Flows Terminal Value Total TO (2017) 102,273,000,000.00 66,415,000,000.00 35,858,000,000.00 10,261,000,000.00 71.481,000,000.00 (45,884,000,000.00) 18.353.600.000.00 (27,530,400,000) 10,261,000,000 TI (2018) 112,500,300,000.00 56,250,150,000.00 56,250,150,000.00 210.00 22,500,060,000.00 33,750.089.790.00 (13,500,035,916.00) 20.250.053,874 210 T2 (2019) 13 (2020) 123,750,330,000.00 136,125,363,000.00 61,875,165,000.00 68,062,681,500.00 61,875,165,000.00 68,062,681,500.00 220.50 231.53 24,750,066,000.00 27,225,072,600.00 37,125,098.779.50 40,837,608,668.48 (14,850,039,511.80) (16,335,043,467.39) 22,275,059,268 24.502,565,201 221 232 T4 (2021) 149,737,899,300.00 74,868,949,650.00 74,868,949,650.00 243.10 29,947,579,860.00 44,921,369,546.90 (17,968,547,818.76) 26,952,821,728 243 S (100) (17.269,400.100) S (105) 20.250,053,979 S (110) 22.275,059,378 S (116) 24,502,565,317 S S 24,502,565,317 S (122) 26,952,821,850 (2.147,802,991,147.16) (2.120,850,169,297) S (17.269,400,100) S 20,250,053,979 S 22,275,059,378 S lear 0 4 Present Value of Free Cash Flows 1 20,105,295,848.89 S S 3 21,957,729,780.40 S 23,980,840,706.44 S (2.060,853,498,298.28) PV of FCFs and Terminal Value Add Back Initial Cash Firm's Value Subtract year 0 Debt Equity Value Number of Outstanding Shares Value per Share $ $ $ $ $ $ $ (1,994,809,631,962.55) 1,000.00 (1,994,809,630,962.55) (2.000.00) (1,994,809,632,962.55) 2,000.00 (997,404,816.48) Free Cash Flows and Valuation Summary niu -I1EEI -- 11/144EM PP va "Lu Hi THEM PHI HIiun us DCF. Several of the parameters are assumed and/or fixed-through-time for simplicity will be filled automatically after you have input parameters in have chosen the relevant parameters as well. Fixed Assets (You will need this field to calculate depreciation expense) 4,000.00 4.200.00 4.410.00 4.630.50 4,862.03 Revenues - Cost of Goods Sold = Gross Margin - Depreciation & Amortization - All Other Expenses except Interest (for simplicity) - EBIT: Tares NOPAT + Depreciation & Amortization - Increases to Working Capital (you can assume 0 for this project) CAPEX Free Cash Flows Terminal Value Total TO (2017) 102,273,000,000.00 66,415,000,000.00 35,858,000,000.00 10,261,000,000.00 71.481,000,000.00 (45,884,000,000.00) 18.353.600.000.00 (27,530,400,000) 10,261,000,000 TI (2018) 112,500,300,000.00 56,250,150,000.00 56,250,150,000.00 210.00 22,500,060,000.00 33,750.089.790.00 (13,500,035,916.00) 20.250.053,874 210 T2 (2019) 13 (2020) 123,750,330,000.00 136,125,363,000.00 61,875,165,000.00 68,062,681,500.00 61,875,165,000.00 68,062,681,500.00 220.50 231.53 24,750,066,000.00 27,225,072,600.00 37,125,098.779.50 40,837,608,668.48 (14,850,039,511.80) (16,335,043,467.39) 22,275,059,268 24.502,565,201 221 232 T4 (2021) 149,737,899,300.00 74,868,949,650.00 74,868,949,650.00 243.10 29,947,579,860.00 44,921,369,546.90 (17,968,547,818.76) 26,952,821,728 243 S (100) (17.269,400.100) S (105) 20.250,053,979 S (110) 22.275,059,378 S (116) 24,502,565,317 S S 24,502,565,317 S (122) 26,952,821,850 (2.147,802,991,147.16) (2.120,850,169,297) S (17.269,400,100) S 20,250,053,979 S 22,275,059,378 S lear 0 4 Present Value of Free Cash Flows 1 20,105,295,848.89 S S 3 21,957,729,780.40 S 23,980,840,706.44 S (2.060,853,498,298.28) PV of FCFs and Terminal Value Add Back Initial Cash Firm's Value Subtract year 0 Debt Equity Value Number of Outstanding Shares Value per Share $ $ $ $ $ $ $ (1,994,809,631,962.55) 1,000.00 (1,994,809,630,962.55) (2.000.00) (1,994,809,632,962.55) 2,000.00 (997,404,816.48)