Can someone please help me out with what I need to put into the excel squares to get the right result? I Cant seem to figure it out.

A B D E F G H I 1 2 3 1. The management team has decided to permanently implement remote working for all technical staff and sell a part of its office to a coworking outfit for $500,000. The firm will invest the entire proceeds to earn 5% per year. Given these data, compute how much the firm can expect to withdraw at the end of 5 years. (i) Enter values of required rate, number of periods and PV in cells C4, C5 and C7 respectively. (ii) Write formula in cell F5 to compute the Future Value. Correct Answer Table P1.1 Future Value (FV) ($638,140.78) Required Rate Number of Periods (Nper) Future Value (FV) OR Periodic Payment (PMT) 0 Future Value (FV) $638,140.78 Present Value (PV) 4 5 000 2. The firm is facing a lot of downtime issues with the current cloud computing provider. The firm has won a lawsuit against the cloud computing provider for not meeting the uptime Service Level Agreement (SLA). The firm is expecting a payment of $100,000 to be paid two years from now. The required rate of return (or discount) rate for the firm is 10%. (i) Enter values of required rate (or discount Rate), number of periods and FV in cells C12, C13 and C15 respectively. (ii) Write formula in cell F13 to compute the present value of the payment. 9 Correct Answer Present Value (PV) ($82,644.63) 10 11 12 13 14 15 16 Table P1.2 Required rate (or discount Rate) Number of Periods (Nper) Periodic Payment (PMT) Future Value (FV) Present Value (PV) OR 0 Present Value (PV) $82,644.63