Part 4: Based on the data presented in the Unit VII Spreadsheet Template in Excel (IRR tab), calculate the internal rate of return (IRR) for the new equipment purchase.

Complete your calculations by filling in the highlighted cells, and embed a copy of the completed spreadsheet into this report. Note: the PV Annuity table is provided for you. Discuss if you think the cookie business should accept or reject the purchase of the new equipment and why.

Additional information has come to your attention regarding the equipment purchase. One of the partner's brother owns the company that sells the equipment and insists the equipment is needed. Discuss any ethical concerns you see with this type of transaction.

This is a 5301- Managerial Applications of Accounting course.

Cookie Business
As the owner of the Cookie Business, you are considering the following investment:
Purchase of new equipment	$ 250,000.00
Expected annual increase in sales	$ 48,017.50
Time frame	7	years
Acceptable rate needed	9%
Calculate the Internal Rate of Return:
PV of annuity factor	5.2064
Internal rate of return	8%
Accept or reject	Reject