Question

MVP, Inc., has produced rodeo supplies for over 20 years. The company currently has a debt-equity ratio of 65 percent and the tax rate is 25 percent. The required return on the firm’s levered equity is 15 percent. The company is planning to expand its production capacity. The equipment to be purchased is expected to generate the following unlevered cash flows:

  

Year	Cash Flow
0	−$18,600,000
1	5,760,000
2	9,560,000
3	8,860,000

  

The company has arranged a debt issue of $9.48 million to partially finance the expansion. Under the loan, the company would pay interest of 8 percent at the end of each year on the outstanding balance at the beginning of the year. The company also would make year-end principal payments of $3,160,000 per year, completely retiring the issue by the end of the third year.

  

Calculate the APV of the project. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89)

I deleted the original and updated it, but I don't think anything is different.

Answer 1

SOLUTION:-

Year	Debt outstanding	Principal repayment	After tax interest payment	Total
0	$ 9,480,000
1	$ 6,320,000	$ 3,160,000	$ 568,800	$ 3,728,800
2	$ 3,160,000	$ 3,160,000	$ 379,200	$ 3,539,200
3	$	$ 3,160,000	$ 189,600	$ 3,349,600

Year	Cash flow	[email protected]%	Present value
0	$ (18,600,000)	1.000	$ (18,600,000.00)
1	$ 5,760,000	0.887	$ 5,110,647.18
2	$ 9,560,000	0.787	$ 7,526,008.87
3	$ 8,860,000	0.698	$ 6,188,622.21
NPV			$ 225,278.26
Unlevered cost of equity	12.71%
=(15%+8%*(1-25%)*0.65)/(1+0.65*(1-25%))
Year	Cash flow	PVIF@8%	Present value
0	$ 9,480,000	1.000	$ 9,480,000.00
1	$ (3,728,800)	0.926	$ (3,452,592.59)
2	$ (3,539,200)	0.857	$ (3,034,293.55)
3	$ (3,349,600)	0.794	$ (2,659,020.47)
NPV financing side affect	$ 334,093.38
Adjusted NPV (APV)	$ 559,371.64
			=225278.26+334093.38

THANK YOU, if any queries please leave your valuable comment on comment box......