Please do 7A-2 and 7-49 Tables. Please do both questions and show all the formulas used. Thanks 7A-2 Find the rate of return for the following cash flow: Year 0 1 2 3 4 Cash Flow -$25,000 +$15,000 $4,000 +$8,000 +$15,000 5 77A-2 (page 279) Calculate NPV for various interest rates to document there is just one positive IRR 1 2 Time Cash Flow Int Rate NPV 3 0 -$25,000 -0.50 1 1 $15,000 -0.40 5 2 -$4,000 -0.30 5 3 $8,000 -0.20 7 4 $15,000 -0.10 3 0.00 0.10 0.20 1 0.30 2 0.40 3 0.50 0.60 5 0.70 7-49 An engineering student is deciding whether to buy multiple term length parking permits or an annual permit. The annual parking permit costs $250 due August 15th, and the semester permits are $160 due August 15th and January 15th. What is the rate of return for buying the annual permit? Should you purchase the annual permit if your MARR = 12%? 7-49 (Use XIRR; Dates formatted as dates) Pay by Pay by Semester A in Time Year CF Cash Flow Cash Flow 8/15/19 1/15/20 IRR of Annual Payment