You have the opportunity to buy a business for $39,000. The business is a portable car washing business. It comes with a truck and trailer that has everything needed to wash cars anywhere. The owner hired students to wash the cars. The business owner is graduating from college and wants to sell. The business has paid the owners tuition, books, fees, and rent for the last three years. The net income was $13,000 per year. You have the $39,000 in your college fund. You are planning on going for a PhD and believe you can graduate in 8 years. You are conservative and estimate the business will generate following net income for the next eight years

Year	Income
1	$11,000
2	$11,000
3	$12,000
4	$13,000
5	$13,000
6	$13,500
7	$14,000
8	$14,500

What return would you have to get on the $39,000 to equal the income from buying the business? (Hint: use the IRR function.) Internal rate of return (IRR) is the interest rate at which the net present value of all the cash flows (both positive and negative) from a project or investment equal zero. Internal rate of return is used to evaluate the attractiveness of a project or investment. Double-check this by finding the NPV of the cash flows using the interest rate calculated by the IRR.

Your income estimate may be high. If you only get 75% of the projected income, what is the IRR for the investment? Should you buy the business at 75% income?

Please show formulas on excel