Please show excel calculations

Formulas you may use: FV=PV*(1+IY'N, Profit=TR-TC-TR-(TVC+FC+OH) Answer the following compounding/discounting questions assuming year-end cash flows. The Chicago Ho Hospital purchased a MRI machine for 12 million dollars, using a 6-year loan at 8% interest. a) What will be the annual payment for the machine? PVIS 12,000,000 Solve for Payment: N $2,595,784.63 I 0.08 FV 0 Manual Payment 4.622879663961 $ 2,595,784.63 b. The price of the MRI machine (12 million) is rising at a fixed rate of 2% each year. How much would it cost to replace the MRI machine 6 years from now? 12,000,000 PV $ N I PMT Solve for Future Value: $13,513,949.03 FV = PV (1+1)^N $ 13,513,949.03 0.02 0