Your company is considering purchasing a new building as part of an expansion plan. The building cost is $1.5 million. Instead of paying cash for the building out of the business, you plan to borrow $500,000 from your bank via a commercial loan, at a rate of 4.5%. The balance of the building cost will be pulled from your personal investment account, which has averaged only a 1% return the past eight years. The company will pay your personal loan back at a 3% interest rate. The cash flows from the building acquisition are expected to be steady over the next 10 years at $225,000 per year. Answer the following questions. Excel Format
A) What is the weighted average cost of capital (WACC) for the investment?
B) What is the present value of the cash flows?
C) What is the Net Present Value (NPV) of the investment?
D) What is the Internal Rate of Return (IRR) of the investment?
E) What is the payback period?
1. WACC = Weight of Debt * After Tax Cost of Debt + Weight of equity * Cost of Equity
WACC = 500000/1500000 * 4.50% + 1000000/1500000 * 3%
WACC = 3.50%
Please upvote if satisfied
Get Answers For Free
Most questions answered within 1 hours.