Question

In: Accounting

a) A company expects a series of 24 monthly receipts of $3,600 each. The first payment...

a) A company expects a series of 24 monthly receipts of $3,600 each. The first payment will be received 1 month from today. Determine the present value of this series assuming an interest rate of 12% per year compounded semiannually.

b)ANB ltd has common equity of $35.5mn and $31.9mn of long-term debt and $10.3mn of preferred equity on its books. Required return on these funds are 12%, 8%, and 10%, respectively. Market values of the common equity and long-term debt are $46.6mn and $35mn, respectively. Market value of preferred equity is the same as its book value. Estimate WACC for the company given that its effective tax rate is 30%.

Solutions

Expert Solution

a) Number of payments to be received = 24 months
Monthly Receipts = $ 3600 each
Interest rate = 12% per year compounded semiannually
We need 12% per year compounded per year
Therefore, the effective annual rate would be
Semi Annual Rate = 12/2 = 6%
(1.06)^2 - 1 12.36%
Monthly Interest Rate = 12.36%/12 1.03%
We need to calculate present value of $ 3600 received for 24 months as today by discounting the receipts
Months Cash inflow Discount Factor @ 12.36%(1/(1.1236^n) Present Value
1 $3,600 0.9898 1/(1.0103^1) $3,563.30
2 $3,600 0.9797 1/(1.0103^2) $3,526.97
3 $3,600 0.9697 1/(1.0103^3) $3,491.01
4 $3,600 0.9598 1/(1.0103^4) $3,455.42
5 $3,600 0.9501 1/(1.0103^5) $3,420.19
6 $3,600 0.9404 1/(1.0103^6) $3,385.33
7 $3,600 0.9308 1/(1.0103^7) $3,350.81
8 $3,600 0.9213 1/(1.0103^8) $3,316.65
9 $3,600 0.9119 1/(1.0103^9) $3,282.84
10 $3,600 0.9026 1/(1.0103^10) $3,249.37
11 $3,600 0.8934 1/(1.0103^11) $3,216.24
12 $3,600 0.8843 1/(1.0103^12) $3,183.45
13 $3,600 0.8753 1/(1.0103^13) $3,151.00
14 $3,600 0.8664 1/(1.0103^14) $3,118.87
15 $3,600 0.8575 1/(1.0103^15) $3,087.08
16 $3,600 0.8488 1/(1.0103^16) $3,055.60
17 $3,600 0.8401 1/(1.0103^17) $3,024.45
18 $3,600 0.8316 1/(1.0103^18) $2,993.62
19 $3,600 0.8231 1/(1.0103^19) $2,963.10
20 $3,600 0.8147 1/(1.0103^20) $2,932.89
21 $3,600 0.8064 1/(1.0103^21) $2,902.99
22 $3,600 0.7982 1/(1.0103^22) $2,873.39
23 $3,600 0.7900 1/(1.0103^23) $2,844.10
24 $3,600 0.7820 1/(1.0103^24) $2,815.10
Present Value of series $76,203.76
Present Value of monthly Payment is $ 76203.76
Alternatively can be calculated using the PV function
$76,203.76 PV(1.03%,24,-3600)
b) The WACC of the firm can be calculated either based on the book value weights of capital or market value weights of capital, since nothing is mentioned we would estimate WACC by using both the methods
Cost of Equity = 12%
After Tax cost of debt = 8%*(1-0.30) 5.60%
Cost of Preferred stock = 10%
Weights based on Book Value
Book Value (In mn) Weights
Common Equity $35.50 0.4569 35.50/77.70
Long Term Debt $31.90 0.4106 31.90/77.70
Preferred Equity $10.30 0.1326 10.30/77.70
$77.70
WACC = 0.12*0.4569 + 0.056*0.4106 + 0.10*0.1326
9.11%
Weights based on Market Value
Book Value (In mn) Weights
Common Equity $46.60 0.5071 46.60/91.90
Long Term Debt $35.00 0.3808 35/91.90
Preferred Equity $10.30 0.1121 10.30/91.90
$91.90
WACC = 0.12*0.5071 + 0.056*0.3808 + 0.10*0.1121
9.34%

Related Solutions

A. In a series of semi-annual payments of P14465 each, the first payment is due at...
A. In a series of semi-annual payments of P14465 each, the first payment is due at the beginning of 5 years and the last at the end of 12 years and 6 months. If money is worth 11% compounded semi-annually, find the present value of the deferred annuity. B. The cost of equipment is P582277 and the cost of installation is P27253, if the salvage value is 10% of the cost of the equipment at the end of 8 years...
A gradient payment series is received monthly for 20 years and deposited into an account. The...
A gradient payment series is received monthly for 20 years and deposited into an account. The first payment is $2,000 and the gradient factor is $100 per month. What is the balance in the account after the initial 20 years? AFTER the first 20 years, the gradient factor is then doubled for an additional 10 years. At an interest rate of 6% compounded monthly (throughout the 30 years). What is the balance in the account after the last payment is...
Robert expects to make 24 monthly deposits of $330 into an investment account that earns 9.9%...
Robert expects to make 24 monthly deposits of $330 into an investment account that earns 9.9% compounded quarterly. After a one year investment pause, he intends to take out 30 equal monthly amounts from his investment account, the first withdrawal being exactly one year from the date of his last deposit. What is the dollar amount of each withdrawal assuming after the last one he has drained his investment account to zero. Assume the account earns the same rate of...
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is...
What is the monthly payment for a $800,000 mortgage for the first 119 payments that is due in 10 years, has a 25 year amortization, at 5% interest? What is the amount of the 120th payment? Please use Excel and explain. Make sure that formulas are set to show in excel sheet.
Claude is buying a house. He expects his budget to allow a monthly payment of $1250...
Claude is buying a house. He expects his budget to allow a monthly payment of $1250 on a 25-year mortgage with an interest rate of (6.8%,2). If Claude makes a 10 percent down payment, determine the most he can pay for the house.
A fifteen-year annuity-immediate has monthly payments. The first payment is $300 and the monthly increase is...
A fifteen-year annuity-immediate has monthly payments. The first payment is $300 and the monthly increase is $50. Calculate the accumulated value of the annuity if the annual effective interest rate is 4%. pls show work and formula, thanks!
What is the present worth of a geometrically increasing series with a first year payment of...
What is the present worth of a geometrically increasing series with a first year payment of $11,000 increasing at 6% per year for 25 years if the interest rate is 6% compounded annually?
A company expects to make a payment of €1,000,000 to their vendor in Germany in six...
A company expects to make a payment of €1,000,000 to their vendor in Germany in six months. The following information is available: Spot rate today = $1.1800 $/€ Six-month Forward Rate = $1.22 $/€ Six-month Call Option premium, E=$1.18 $0.04 Six month Put option premium, E=$1.18 $0.03 Six-month Interest rate in U.S. 4% per annum Amount € 1,000,000.00 a) Should the company be worried about the dollar depreciation or appreciating? b) How should the company hedge the payment using options?...
Facts and Assumptions: Lease Term in Months 24 Lease Down Payment $ 500.00 Monthly Lease Payments...
Facts and Assumptions: Lease Term in Months 24 Lease Down Payment $ 500.00 Monthly Lease Payments $ 300.00 Sales Tax Rate 8% Lease Buyout at End $ 15,000.00 Title Fee $ 25.00 Car Loan Market Rate 7% Outright Purchase Price Before Tax and Title $ 19,500.00 What is the NPV of the lease? What would it cost you to buy the car today if you were paying cash? Round you answer to the nearest whole number. Do not use $,...
Consider an annuity-due with 24 annual payments. The first payment is 800 at time 0 and...
Consider an annuity-due with 24 annual payments. The first payment is 800 at time 0 and each subsequent payment increases by 7%. Find the PV of this annuity at an annual effective rate of interest i=5%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT