Can someone help me figure out what to put in the boxes?

B C D E F G H . 1 5. The firm is planning to shift its servers to Amazon Web Services (AWS). AWS reserved instances have several payment options; the management has decided to either go with a No Upfront (monthly payment option) or an All upfront payment options. Firm would like to reserve some servers for 1 year term and some servers for 3-year term. (a) The Image P2.1 has the pricing structure for the Ohio datacenter for Linux "a1.4xlarge" server for Standard 1-Year Term. Assume that the monthly payments are done at the end of the month. Compute the monthly payments' present value and suggest whether the firm should opt for No Upfront or All upfront payment option. Hint: If the monthly payment's present value is more than the upfront payment, you should prefer the upfront payment option. 2 Correct Answer Firm's annualised required rate of return is 10% pa. (i) Write a formula in cell C6 to compute the monthly required rate of return. (ii) Enter the values of number of periods, Monthly payments and Type in cells C7, C8 and C10 respectively. (iii) Write a formula in cell C12 to compute the present value of the monthly paments. 3 (iv) In cell C13, select your recommended payment option from the dropdown. 4 5 Annual Required Rate 10.000% Image P2.1 6 Monthly Required Rate STANDARD 1-YEAR TERM 7 Number of periods (Nper) 8 Monthly Payments (PMT) Payment Option Upfront Monthly* 9 Future Value (FV) 0 No Upfront $0 $187.61 10 | 11 Partial Upfront $1,072 $89.35 12 Present Value (PV) All Upfront $2,102 $0.00 13 Your recommendation Select from the list 14 Present Value (PV) ($2,133.97) OR Present Value (PV) $2,133.97