Question

In: Finance

You need to estimate the value of Laputa Aviation. You have the following forecasts (in millions...

You need to estimate the value of Laputa Aviation. You have the following forecasts (in millions of dollars) of its profits and of its future investments in new plant and working capital:

Year
1 2 3 4
Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 74 $ 94 $ 109 $ 114
Depreciation 24 34 39 44
Pretax profit 50 60 70 70
Tax at 40% 20 24 28 28
Investment 18 21 24 26

From year 5 onward, EBITDA, depreciation, and investment are expected to remain unchanged at year-4 levels. Laputa is financed 50% by equity and 50% by debt. Its cost of equity is 17%, its debt yields 8%, and it pays corporate tax at 40%.

a. Estimate the company’s total value. (Do not round intermediate calculations. Enter your answer in millions rounded to the nearest whole amount.)

b. What is the value of Laputa’s equity? (Do not round intermediate calculations. Enter your answer in millions rounded to 2 decimal places.)

Solutions

Expert Solution

Answer :- (a)

Calculation of free cash flow :-

1 2 3 4
EBITDA 74 94 109 114
less :- Depreciation 24 34 39 44
Pretax Profit 50 60 70 70
Tax @ 40 % on pre tax profit 20 24 28 28
Profit after tax 30 36 42 42
Operating Cash flow ( Depreciation + Profit after tax) 54 70 81 86
less : Investment 18 21 24 26
Free Cash Flow 36 49 57 60

Now we will calculate WACC :-

WACC = ( Weight of debt * Cost of debt after tax ) + (weight of equity * Cost of equity)

= { 0.50 * [ 8 * ( 1- 0.40 ) ] } + { 0.50 * 17 }

= { 0.50 * 4.8 } + { 0.50 * 17 }

= 2.4 + 8.50

= 10.90%

Now we will calculate Horizon Value at Year 4 :-

= FCF ( year 4 ) / WACC

= 60 / 0.1090

= 550.46

Company's Value = FCF1 / 1.109 + FCF2 / 1.1092 + FCF3 / 1.1093 + FCF4 / 1.1094​​​​​​​ + Horizon Value4 / 1.1094

= (36 / 1.109) + (49 / 1.22988) + (57 / 1.363938) + (60 / 1.51261) + (550.46 / 1.51261)

= 32.46 + 39.84 + 41.79 + 39.67 + 363.91

= 517.67

(b) Value of Laputa’s equity :-

As equity weight is 0.50 , so

Value of equity = Total Value of firm * weight of equity

= 517.67 * 0.50

= 258.835


Related Solutions

You need to estimate the value of Laputa Aviation. You have the following forecasts (in millions...
You need to estimate the value of Laputa Aviation. You have the following forecasts (in millions of dollars) of its profits and of its future investments in new plant and working capital: Year 1 2 3 4 Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 75 $ 95 $ 110 $ 115 Depreciation 15 25 30 35 Pretax profit 60 70 80 80 Tax at 40% 24 28 32 32 Investment 17 20 23 25 From year 5 onward,...
Skeets Mfg Inc forecasts the following financial information for the next 3 years (in millions):                           &
Skeets Mfg Inc forecasts the following financial information for the next 3 years (in millions):                                        Year 1                 Year 2                 Year 3 Revenues                       $25,200              $27,540              $32,300 Operating Expenses      $13,650              $13,848              $14,200 Depreciation                  $6,573                $5,580                $6,750 EBIT                                $4,977                $8,112                $11,350 Interest Expenses          $1,170                $1,572                $1,325 Taxes                              $1,332                $2,289                $3,509 Net Income                    $2,475                $4,251                $6,516 Increase in NWC            $165                   $420                   $735 The firm estimates capital expenditures of $1,200 million in year1, $750 million in year 2 and $1,550 million in year 3....
you are evaluating a new project and need an estimate for your project's beta. You have...
you are evaluating a new project and need an estimate for your project's beta. You have identified the following information about three firms with comparable projects. Firm Name Equity Beta Debt Beta Debt to equity ratio Lincoln 1.25 0 0.25 Blinkin 1.6 0.2 1 Nod 2.3 0.3 1.5 The unlevered beta for Nod is closest to : A.1.00 B.0.90 C.0.95 D.1.10
You have collected the following data on the returns of George Aviation (GA) and Aw Under...
You have collected the following data on the returns of George Aviation (GA) and Aw Under Bins Suction (AUB) over the last 10 years: Year GA AUB 1 19% 3% 2 14% 7% 3 18% -2% 4 13% 5% 5 12% 8% 6 17% 2% 7 16% -3% 8 10% 4% 9 11% 1% 10 20% 0% Given this information, find the optimal weights of a portfolio that consists of these two securities assuming a minimum acceptable return of 2%....
You need to estimate the Weighted Average Cost of Capital (WACC) for your company. You have...
You need to estimate the Weighted Average Cost of Capital (WACC) for your company. You have the following balance sheet data as well as the information provided below Assets Current Assets                                                                                                $38,000,000 Net Plant, Property, and Equipment                                                               101,000,000 Total Assets                                                                                                   $139,000,000 Liabilities and Equity                       Accounts Payable                                                                                           $10,000,000 Accruals                                                                                                          9,000,000 Current Liabilities                                                                                          $19,000,000                Long-term Debt (40,000 bonds, $1,000 face value)                                      $40,000,000 Total Liabilities                                                                                              $59,000,000 Common Stock (10,000,000 shares)                                                              $30,000,000 Retained Earnings                  ...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions)...
The following data show the annual revenue ($ millions) and the estimated team value ($ millions) for the 30 Major League Baseball teams (Forbes website, January 16, 2014). Team Revenue ($ millions) Value ($ millions) Arizona Diamondbacks 195 584 Atlanta Braves 225 629 Baltimore Orioles 206 618 Boston Red Sox 336 1312 Chicago Cubs 274 1000 Chicago White Sox 216 692 Cincinnati Reds 202 546 Cleveland Indians 186 559 Colorado Rockies 199 537 Detroit Tigers 238 643 Houston Astros 196...
You have been asked to estimate the value of a home for sale. The subject property...
You have been asked to estimate the value of a home for sale. The subject property has three bedrooms, one bathroom, and is in good condition. A highly comparable property just sold near the subject recently. You will use this recent sale as the comp to estimate value of of the subject property. The comp sold for $134,000. It has three bedrooms, two bathrooms, and is in good condition. Assume bedrooms are worth $5,000 and bathrooms are worth $3,000. What...
You have been asked to estimate the value of a home for sale. The subject property...
You have been asked to estimate the value of a home for sale. The subject property has three bedrooms, two bathrooms, and is in good condition. A highly comparable property just sold near the subject recently. The comp sold for $127,900. It has three bedrooms, one bathroom, and is in good condition. Assume bedrooms are worth $4,500 and bathrooms are worth $2,700. What is the indicated value of the subject based on the comparable sale? (please show all work below...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT