You do not have to calculate numeric answers for any of these. Car Loan Furniture Rent-to-Own Month Payment 2 $24,000 Value of car at lease start $2,000 Value of Furniture Start $(2,000.00)2 $136 3 $142 4 $995 120 6 $123 7 $1118 $97 9 $105 10 129 11 130 12 $115 13 $140 14 120 15 $8916 $104 17 $116 18 125 19 100 20 108 21 $109 22 972:3 6% interest $120 Monthly Payment Jan Feb Mar Apr May Jun Jul 4 12 payments & periods per year 24 Total # Payments 5 year loan term a) Write the Excel formula to compute the monthly payment for the car loan. Monthly Payment Sep Oct Nov Dec Jan Feb Mar b) Write the Excel formula to determine the monthly interest rate you are being charged for the Furniture Rental Monthly Interest = c) Write the Excel formula to compute the Effective Annual Interest Rate for the Furniture Rental. If you need to refer to part b the result is in cell D8. May Jun Jul Effective Annual Interest d) Disregarding the $2000 Start value, write the Excel formula to determine Aug the present value of the 24 end of month cash flows shown in column F if the interest rate is 6% nominal compounded monthly. Oct Nov Dec 90 24 $109 25 112 26 Value of Cash Flows- e) Including the $2000 Start value, write the Excel formula to determine the Internal Rate of Return of the 24 end of month cash flows shown in column F. Internal Rate of Return- f) What is the period n of the IRR in question e) above