Question

In: Accounting

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…)

Case Two (22 pts)

Given the following information for Bajor Co.:

Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time-to-maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100).

Preferred stock: Bajor has not issued any preferred stocks.

Common stock (equity):

  • Bajor’s equity capital consists of common stocks with the most recent annual dividend of $0.92 per share, and a current stock price of $14 per share.  

  • According to online data sources, Bajor’s long-term dividend growth (for next 5-Year average, per annum) g = 4.5% per year.

  • The “risk-free” Treasury bill return is 3.8%; the market expected return for the stock market on average is 12.3%; and Bajor’s systematic risk (Beta) is 0.71.

Taxes: The applicable federal-plus-state corporate tax rate for Bajor is 25.7 percent.

Capital weight: Bajor’s “Market Cap” amounts to $18.23 billion, and “Total Debt” amounts to $14.44 billion. You can use such data to estimate the capital weights for equity and debt, respectively (We and Wd).

Time constraint: For any investment projects, Bajor are required by her investors to recover its initial cost within no more than 6 years.



Q1: What is Bajor’s pretax cost of debt Rd, cost of equity Re, and WACC, respectively? (Hint: For the best estimate of cost of equity Re, you must apply both CAPM and Dividend Growth Model and then average the two estimates.)


Q2: There are three investment projects available to Bajor:  

Project A costs $12 million to invest today, and then provides “cash inflow from assets” of $2.50 million per year for the next 7 years.

Project B costs $18 million to invest today, and then provides “cash inflow from assets” of $3.30 million per year for the next 8 years.

Project C costs $30 million to invest today, and then provides “cash inflow from assets” of $4.25 million per year for the next 10 years.

If Projects A, B & C are mutually exclusive, which project(s) should Bajor accept? (You must apply the three major investment evaluation rules NPV, IRR and Payback)


Q3: If Projects A, B & C are independent, which project(s) should Bajor accept? (You must apply the three major investment evaluation rules NPV, IRR and Payback)


Solutions

Expert Solution

1)
Cost of debt:
Face value 100
Coupon Rate (Semiannual) = 6.25%/2 3.13%
Coupon payment = PMT = 3.13% x 100 3.125
Current Price = PV 106.61
Period = 9 x 2 18
YTM = Rate (semiannual) 2.66%
Annual YTM = Pretax cost of Debt 5.32%
Cost of Equity
Cost of Equity ( Dividend Growth Model) = (D0 x ( 1 + g)/P0) + g
Cost of Equity = 0.92 x ( 1 + 4.5%)/$14 + 4.5% 11.37%
Cost of Equity (CAPM) = Rf + beta x (Rm-Rf)
Cost of Equity (CAPM) = 3.8% + 0.71 x (12.3% - 3.8%) 9.84%
Average Cost of Equity  (11.37% + 9.84%)/2 10.60%
WACC
Market cap $ billions) Weight
Equity 3.79 20.79%
Debt 14.44 79.21%
Total 18.23
WACC = We x Re + Wd x Rd x (1 - tax)
Wacc = 20.79% x 10.60% + 79.21% x 5.32% x (1-25.7%) 5.33%
2)
Q2: There are three investment projects available to Bajor:  
NPV (Amount in Milllion) IRR Payback period
Project A costs $12 million to invest today, and then provides “cash inflow from assets” of $2.50 million per year for the next 7 years. $                            2.29 10.43%                        4.80 Years
Project B costs $18 million to invest today, and then provides “cash inflow from assets” of $3.30 million per year for the next 8 years. $                            3.04 9.39% 5.45 Years
Project C costs $30 million to invest today, and then provides “cash inflow from assets” of $4.25 million per year for the next 10 years. $                            2.29 6.89% 7.06 Years
If Projects A, B & C are mutually exclusive, which project(s) should Bajor accept? (You must apply the three major investment evaluation rules NPV, IRR and Payback)
Project C would be rejected as it does not meet Time constraint of 6 years.
In case of mutually exclusive projects, the project with highest net present value or the highest IRR or the lowest payback period is preferred since Project A would be selected because its IRR is the highest and payback period is shortest but NPV is the lowest. Project B has the highest NPV but IRR is lesser than the Project A and payback period is more than project A.Both Project A and B could be consider.
3)
Independent is favorable if the net present value is positive and/or IRR is higher than the hurdle rate and/or the payback period is shorter than a specific reference period.Project A and B both are selected.


Related Solutions

(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable). Please show excel formulas. Given the following information for Bajor Co.: Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time to maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100). Preferred stock: Bajor has not...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable..) Ferengi, Inc. is subject to an applicable corporate tax rate of 21 percent, and the weighted average cost of capital (WACC) of 12.5 percent. There is no specific time constraint on investment project payback requirements. Q1: Ferengi is currently contemplating two capital investment plans. Plan A: the upgrade of an information system with an installed cost of $2,400,000. The...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…), =FV(…), =PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…) whenever applicable. Please show me the EXCEL functions that was used to help me better understand was equals what. Using Excel finance formulas You apply for a 20-year, fixed-rate (APR 6.48%) monthly-payment-required mortgage loan for a house selling for $150,000 today. Your bank requires 22% initial down payment of house value (to be paid in cash immediately),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =PV(…), =FV(…), =PMT(…), =NPER(…), =RATE(…), =PRICE(…) or =YIELD(…) whenever applicable. Please show me the EXCEL functions that was used to help me better understand was equals what. Using Excel finance formulas Case 3: We find the data for a municipal bond issued by the Illinois state government. The bond’s “last trade date” (i.e., settlement date) is June 05, 2019. The bond’s “maturity date” is March...
Please provide specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable. Given the following information for...
Please provide specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable. Given the following information for Bajor Co.: Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time-to-maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100). Preferred stock: Bajor has not issued any preferred stocks. Common stock (equity): Bajor’s equity capital consists of common stocks with the...
Please provide specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) etc...... Given the following information for Bajor...
Please provide specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) etc...... Given the following information for Bajor Co.: Debt: Bajor’s long-term debt capital consists of bonds with 6.250 percent coupon rate (semiannual coupon payments), 9 years time-to-maturity, and current price of 106.61 percent of its par value (i.e., price = 106.61 relative to full amount redemption par of 100). Preferred stock: Bajor has not issued any preferred stocks. Common stock (equity): Bajor’s equity capital consists of common stocks with the most...
use Excel Solver to answer the following question.You must provide sufficient evidence that you did the...
use Excel Solver to answer the following question.You must provide sufficient evidence that you did the work on your own. For example, what equations did you use in your model? How was the excel spread sheet laid out? A student at a local university has just completed a decision modeling course. On her assignments, she has earned a 86 on the mid-term, a 94 on the final, a 93 on problem sets, and 85 for participation. She has a unique...
In part 2 you will be creating multiple functions to calculate the present value. You may...
In part 2 you will be creating multiple functions to calculate the present value. You may be asking what a "present value" is. Suppose you want to deposit a certain amount of money into a savings account and then leave it alone to draw interest for some amount of time, say 12 years. At the end of the 12 years you want to have $15,000 in the account. The present value is the amount of money you would have to...
Create an Excel spreadsheet in which you use capital budgeting tools including net present value (NPV),...
Create an Excel spreadsheet in which you use capital budgeting tools including net present value (NPV), internal rate of return (IRR), payback period, and profitability index (PI) to determine the quality of 3 proposed investment projects, as well as an analysis of your computations and recommends the project that will bring the most value to the company. The analysis of the capital projects will need to be correctly computed and the resulting decisions rational. Scenario You work as a finance...
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash...
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year 1 2 3 4 5 6 Payment 195 220 270 320 350 470 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT