Question

In: Finance

ThefollowingforecastsforGassonTronicsweretakenfromanalyst’sreportsinthefourth quarterof2018 ($ millions). IncomeStatement: 2019 2020 2021 2022 2023 Revenues 1900 2075 2311 2598 2919...

ThefollowingforecastsforGassonTronicsweretakenfromanalyst’sreportsinthefourth quarterof2018 ($ millions).

IncomeStatement:

2019

2020

2021

2022

2023

Revenues

1900

2075

2311

2598

2919

OperatingExpenses(bef int. &dep.)

1371

1546

1747

1975

2240

Depreciation

100

107

111

114

107

BalanceSheet:

Change inNet WorkingCapital

81

91

103

116

129

Additions toGross FixedAssets (CAPEX)

174

190

205

220

225

OtherInformation

Expectedeffective taxrate

30%

Debt / Total Capital

40%

Marginal Debt Rate

   4%

Beta

0.70

Risk FreeRate

2.75%

ExpectedMarket Return

  9.75%

Cash & Non-Operating Assets (mil)

      150

Outstandingshares (mil)

             70

Usetheaboveinformationtoanswerthefollowingquestions:

A. UsingtheCapitalAssetPricingModel,estimatethecostofequity.

                    

B. Estimatetheweightedaveragecostofcapitalassumingthecompanymaintainsitscurrent capitalstructure.

C. Estimate the share price using Free Cash Flows toall providersofc apita land assuming the company’s cash flows continue to grow a t3% after the forecas tperiod.

Solutions

Expert Solution

a). Cost of equity ke = risk-free rate + beta*market risk premium = 2.75% + 0.70*(9.75%-2.75%) = 7.65%

b). Cost of debt = 4%

After-tax cost of debt kd = 4%*(1-tax rate) = 4%*(1-30%) = 2.80%

Debt/Total Capital (D/TC) = 40%

Therefore, Equity/Total Capital (E/TC) = 60%

WACC = ke*(E/TC) + kd*(D/TC) = (7.65%*0.6) + (2.80%*0.4) = 5.71%

c).

(n) 1 2 3 4 5 5
Formula Year (t) 2019 2020 2021 2022 2023 Perpetuity
Growth rate 3%
Revenues ('R)      1,900.00      2,075.00      2,311.00      2,598.00      2,919.00                   -  
Op. expenses (O) 1371 1546 1747 1975 2240
Dep. (D) 100 107 111 114 107
(R-O-D) EBIT          429.00          422.00          453.00          509.00          572.00                   -  
30%*EBIT Tax @30%          128.70          126.60          135.90          152.70          171.60                   -  
(EBIT-Tax) Net income (NI)          557.70          548.60          588.90          661.70          743.60                   -  
Add: dep. 100 107 111 114 107
(NI + D) Op.Cash Flow (OCF)          657.70          655.60          699.90          775.70          850.60                   -  
Less: Change in NWC 81 91 103 116 129
Less: Capex 174 190 205 220 225
(OCF-nwc-capex) FCFF          912.70          936.60      1,007.90      1,111.70      1,204.60      1,240.74
(1st perpetuity cash flow/(k-g) Terminal CF 45783.69
Total CF          912.70          936.60      1,007.90      1,111.70      1,204.60    45,783.69
1/(1+WACC)^n Discount factor          0.9460          0.8949          0.8465          0.8008          0.7576          0.7576
(Total CF*discount factor) PV of CFs          863.40          838.15          853.24          890.27          912.56    34,684.10
Sum of all PVs EV    39,041.72

Note: Gross debt is not given so equity value cannot be calculated. I have left it with the Enterprise Value calculation.

You can calculate total equity value by EV - gross debt + cash and other non-operating assets.


Related Solutions

Arndt, Inc. reported the following for 2021 and 2022 ($ in millions): 2021 2022 Revenues $...
Arndt, Inc. reported the following for 2021 and 2022 ($ in millions): 2021 2022 Revenues $ 944 $ 1,036 Expenses 800 856 Pretax accounting income (income statement) $ 144 $ 180 Taxable income (tax return) $ 100 $ 214 Tax rate: 25% Expenses each year include $62 million from a two-year casualty insurance policy purchased in 2021 for $124 million. The cost is tax deductible in 2021. Expenses include $2 million insurance premiums each year for life insurance on key...
rndt, Inc. reported the following for 2021 and 2022 ($ in millions): 2021 2022 Revenues $...
rndt, Inc. reported the following for 2021 and 2022 ($ in millions): 2021 2022 Revenues $ 944 $ 1,036 Expenses 800 856 Pretax accounting income (income statement) $ 144 $ 180 Taxable income (tax return) $ 100 $ 214 Tax rate: 25% Expenses each year include $62 million from a two-year casualty insurance policy purchased in 2021 for $124 million. The cost is tax deductible in 2021. Expenses include $2 million insurance premiums each year for life insurance on key...
Arndt, Inc. reported the following for 2021 and 2022 ($ in millions): 2021 2022 Revenues $...
Arndt, Inc. reported the following for 2021 and 2022 ($ in millions): 2021 2022 Revenues $ 954 $ 1,046 Expenses 810 866 Pretax accounting income (income statement) $ 144 $ 180 Taxable income (tax return) $ 90 $ 214 Tax rate: 25% Expenses each year include $72 million from a two-year casualty insurance policy purchased in 2021 for $144 million. The cost is tax deductible in 2021. Expenses include $2 million insurance premiums each year for life insurance on key...
It is January 1, 2020. Free cash flow for 2020, 2021, 2022, and 2023 are expected...
It is January 1, 2020. Free cash flow for 2020, 2021, 2022, and 2023 are expected to be -$5,000; -$1,000; $5,000; and $15,000. Cash flow growth beyond 2023 is expected to stabilize at 10% for 2 years, beyond which point free cash flows are expected to grow at 4% in perpetuity. If the discount rate is 20%, what should be the value of the firm today if there is $1,000 excess cash? What should the enterprise value be (assuming the...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026...
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 BVPS, start of year 7 7.61 8.51 9.51 10.73 11.77 13.17 14.4 15.91 17.58 19.43 21.47 23.72 25.38 27.16 29.06 EPS 0.81 1.1 1.3 1.52 1.64 2 2.03 2.16 2.39 2.64 2.91 3.22 2.37 2.54 2.72 2.91 ROE 0.116 0.145 0.153 0.16 0.153 0.17 0.154 0.15 0.15 0.15 0.15 0.15 0.1 0.1 0.1 0.1 Payout Ratio 0.247 0.182 0.231 0.197 0.366 0.3 0.394 0.3...
LG Following is the seven-year forecast for LG: (all amounts in $000) 2020 2021 2022 2023...
LG Following is the seven-year forecast for LG: (all amounts in $000) 2020 2021 2022 2023 2024 2025 2026 EBIT $(1000) $(900) $200 $1,200 $2,500 $3000 $3,050 Capital Expenditures $550 $350 $200 $175 $175 $160 $150 Changes in Working Capital $400 $300 $200 $100 $100 ($100) ($100) Depreciation $40 $80 $125 $150 $150 $150 $150 Beginning after year 2026 the annual growth in EBIT is expected to be 1.5%, a rate that is projected to be constant over LG remaining...
In 2023, the Berryhill Company discovers a self-correcting error made in 2021, affecting 2021 and 2022...
In 2023, the Berryhill Company discovers a self-correcting error made in 2021, affecting 2021 and 2022 Net Incomes. The 2022 books are closed. Accounting for the error correction will include: Select one: a. An adjustment to Retained Earnings, but not a Restatement of prior-year presented financial statements b. A Restatement of prior-year presented financial statements, but not an adjustment to Retained Earnings c. Both an adjustment to Retained Earnings and a Restatement of prior-year presented financial statements d. Neither an...
Prepare the projected profit & Loss statement for the year 2021, 2022, and 2023. Please calculate...
Prepare the projected profit & Loss statement for the year 2021, 2022, and 2023. Please calculate the payback period for the frim. Our AAA sightseeing tour plan will start with total capital of 90,000 USD on 2021 January. Projected Costs are as follows Vehicle costs  34000 USD Software & Apps cost 4000 USD Location Rental for 250 USD per month for 3 years contract after first-year rental cost, it will increase 5% for the next coming 2 years. Vehicle Maintenance fees...
Small Tractor Inc. reported pretax accounting income in 2021, 2022, and 2023 of $10 million, $14...
Small Tractor Inc. reported pretax accounting income in 2021, 2022, and 2023 of $10 million, $14 million, and $16 million, respectively, which includes 2021 income of $4 million from installment sales of property. However, the installment sales are reported on the tax return when collected, in 2022 ($2 million) and 2023 ($2 million). The enacted tax rate is 25% for each year. Required: 1) Prepare a compound journal entry to record the income tax expense for the year 2021. 2)...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $...
Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $ 913 $ 988 Expenses 770 810 Pretax accounting income (income statement) $ 143 $ 178 Taxable income (tax return) $ 135 $ 200 Tax rate: 40% Expenses each year include $30 million from a two-year casualty insurance policy purchased in 2018 for $60 million. The cost is tax deductible in 2018. Expenses include $2 million insurance premiums each year for life insurance on key...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT