Please provide keystrokes from excel!

98 6. Calculate the present value of the following different investments. 100 Populate the Input Data table to the right for Question 6, using a nominal rate of 7% a. Annual INPUT DATA b. Annual INPUT DATA C. d. Annual Annual INPUT DATA INPUT DATA 101 Excel function name nominal PV 102 Present Value 103 a. You are to receive $4,000,000 in 25 years. What is it worth today? 104 105 nper npery PMT FV Effect Type b. You are to receive $20,000 at the end of every year for 25 years. Present Value 107 of the first payment starts in 1 year, what is this investment If , 108 worth today? 109 110c. You are to receive $70,000 a year, forever, Present Value 111 If the first payment starts in 1 year, what is this investment 112 worth today? 113 114 d. You are to receive $70,000 a year, forever. Present Value 115 If the first payment starts today, what is this investment 116 worth today? 117 118 7. You take out a loan today and will make equal annual payments for the next 3 years, starting in 1 year. 119 Amount borrowed 120 Time periods 121 a. Compute your annual payment on this loan: Nominal interest rate Payment 123 INPUT DATA $ 300,000.00 3 5.00% 1 1 122 1 124 1 125 Beg. Balance Payment Interest Principal Ending Balance 126 b. Amortization this loan in the table set up below: 127 Year 128 1 129 2 130 3 131 TOTAL 132 133