Question

In: Finance

Please Calculate the WACC, the discounted payback period, and the net present value for the following...

Please Calculate the WACC, the discounted payback period, and the net present value for the following scenario. Show all work and clearly show how you came to your answers.

A municipal stadium owned by a city stadium authority is thinking about updating it's grass field to turf. New turf will cost $750,000. A local company has offered to give you $100,000 to put their logo on the turf, which you will happily take if you decide to go forward with the project.

In order to raise the remaining funds for the project, the stadium authority would issue $450,000 worth of bonds that pay 6% interest. They would borrow the remaining funds at a rate of 12.5%.

Your current leases on the field bring in $750,000 per year, but with the turf and the ability to host more events on the field, you project lease earnings of $975,000 per year. Assume the turf has a useful life of 6 years.

Solutions

Expert Solution

Solution:

a)Calculation of WACC

Remaining Fund Requirement=$750,000-$100,000

=$650,000

Fund raised through Bond=$450,000

Fund raised through loan=$650,000-$450,000=$200,000

WACC=Cost of bond*Bond Value/Total fund raised+Cost of loan*Loan value/Total fund raised

=6%*450,000/650,000+12.50%*200,000/650,000

=8%

b)Calculation of discounted pay back period

Initial Cash outlay=$750,000-$100,000=$650,000

Annual incremental cash inflows=$975,000-$750,000

=$225,000

Statement showing present value and cummulative present value of cash flows

Year Cash flows Present value factor @8% Present value Cummulative Cash flows
0 -$650,000 1 -$650,000 -$650,000
1 $225,000 0.925926 $208,333.35 -$441,666.65
2 $225,000 0.857339 192,901.28 -$248,765.37
3 $225,000 0.793832 $178,612.20 -$70153.17
4 $225,000 0.735030 $165,381.75 $95228.58
5 $225,000 0.680583 $153,131.18
6 $225,000 0.630170 $141,788.25

Discounted pay back period=A+B/C

A=Last year with negative cummulative cash flows

B=Absolute cash flows in year A

C=Discounted cash inflows in Year following year A

Payback period=3+($70153.17/165,381.75)

=3+0.42=3.42 Years

c)Calculation of Net Present value

NPV=Present value of cash inflows-Initial cash outflows

=$225000*Present value annuity factor @8% for 6 year-$650,000

=$225000*4.62288-$650000

=$1040148-$650,000

=$390,148


Related Solutions

Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following after-tax cash flow projections. Also tell me whether the IRR is greater or less then the RRR. A. Year ATCF 0 $(60,000) 1 21,000 2 27,000 3 24,000 4 16,000 Assume a 16% required rate of return
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following...
Determine the Payback Period, the Discounted Payback Period, and the Net Present Value for the following after-tax cash flow projections. Also tell me whether the IRR is greater or less then the RRR B. Year ATCF 0 (100,000) 1 (320,000) 2 130,000 3 185,000 4 200,000 5 195,000 6 150,000 Assume a 20% required rate of return
Calculate? (a) net present? value, (b) payback? period, (c) discounted payback? period, and? (d) internal rate...
Calculate? (a) net present? value, (b) payback? period, (c) discounted payback? period, and? (d) internal rate of return. Cost of the equipment $166,000 Reduced labor costs $45,000 Estimated life of the equipment 10 years Terminal disposal value ?$0 ?After-tax cost of capital 12 ?% Tax rate 20 ?% Assume depreciation is calculated on a? straight-line basis for tax purposes. Assume all cash flows occur at? year-end except for initial investment amounts. Calculate? (a) net present? value, (b) payback? period, (c)...
For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index...
For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index (Benefit-Cost Ratio) Internal Rate of Return Modified Internal Rate of Return             Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital ko is 15% and the risk free...
Calculate the discounted payback, net present value, and internal rate of return for the following cash...
Calculate the discounted payback, net present value, and internal rate of return for the following cash flows. -60, -50, 6, 45, 60, 70, 60, 45, 20. Discount rate at 7%. Please show work for the internal rate of return calculation.
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present...
Capital Budgeting Assignment For the following two projects, determine the Payback Period Discounted Payback Net Present Value Profitability Index (Benefit-Cost Ratio) Internal Rate of Return Modified Internal Rate of Return             Project A Project B Year Net Income Cash Flow Net Income Cash Flow 0 (15,000) (19,000) 1 5,000 6,000 3,000 4,000 2 5,000 6,000 5,000 6,000 3 5000 6,000 7,000 8,000 4 5,000 6,000 11,000 12,000 Risk Index 1.80 .60 The firm’s cost of capital ko is 15% and...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment of $20,000 with expected after-tax operating cash flows of $125,000 per year for each of the next 3 years. However, in preparation for its termination at the end of year 3, an additional investment of $350,000 must be made at the end of Year 2. Please show all work in excel.
Calculate the net present value, internal rate or return and payback period for an investment project...
Calculate the net present value, internal rate or return and payback period for an investment project with the following cash flows using a 5 percent cost of capital:                 Year                       0                              1                              2                              3                 Net Cash Flow   -$150,000             $62,000 $62,000 $62,000 Do you recommend the investment?                
Calculate the discounted payback period for the following cash flows. Investment = $300,000 Salvage Value =...
Calculate the discounted payback period for the following cash flows. Investment = $300,000 Salvage Value = 0 Service Life = 4 Years MARR = 5% n Cash Flow Cost of Capital Balance 0 -300,000 1 100,000 2 150,000 3 125,000 4 100,000
Calculate the payback period, net present value, profitability index, and internal rate of return for Project...
Calculate the payback period, net present value, profitability index, and internal rate of return for Project A. Assume a discount rate of 20%. Should the firm accept or reject Project A? Explain. If the firm must choose between Project A and Project B, which is the better choice? Explain. Under what circumstances should the modified internal rate of return be used instead of the standard internal rate of return? Project A Project B Year Cash Flow Year Cash Flow 0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT