Please try to solve this via excel if possible with each excel function used listed if needed. thank you.

A B D E F Add/Sub Interest Balance John is opening an account today with $36,000 and will earn 5.50% for the next ten years. Date Feb 6, 2021 Feb 6, 2022 Feb 6, 2023 Feb 6, 2024 Feb 6, 2025 Feb 6, 2026 Feb 6, 2027 Feb 6, 2028 Feb 6, 2029 Feb 6, 2030 Feb 6, 2031 John will add $5,500 to the account on Feb 6, 2023 and will pull out $20,000 from the account on Feb 6, 2027. Fill in the interest earned each year, the amount added to (subtracted from) the account each year, and the balance at the end of the year. What is the NPV of the investment Jane is considering? Jane is considering investing $215,000 today for an uncertain set of future cash flows. She discounts her expected cash flows at 6.10% What is the IRR of the investment Jane is considering? Jane expects to receive $90,500 on Feb 6, 2022, $34,000 on Feb 6, 2023, $33,000 on Feb 6, 2025, and $132,500 on Feb 6, 2026. Pay close attention to the dates of the cash flows. Grade