Please use Excel financial functions or algebraic time value of money equations to answer these questions in the spreadsheet. Give a screenshot of what you did in the excel and give the function.

Prof. Business has a self-managed retirement plan through her University and would like to retire in 10 years and wonders if her current and future planned savings will provide adequate future retirementincome. Here's her information and goals. >Prof. Business wants a 20-year retirement annuity that begins 10 years from todaywith an equal annual payment equal to $100,000 today inflated at 2% annually over 10 years. Her first retirement annuity payment would occur 10 years from today. She realizes her purchasing power will decrease over time during retirement. >Prof. Business currently has $560,000 in her University retirementaccount. she expects these savings and anyfuture deposits into her University and anyother retirement account will earn 7% compounded annually. Also, she expects to earn this same 7% annual return after she retires., Answer the followingquestionsto help Prof. Business finalize her retirement planning. 1. What is Prof. Business' desired annual retirement income? 2.How much will Prof. Business need 10 years from todayto fund her desired retirement annuity? 3. In addition to the $560,000 balance today, Prof. Business will fund her future retirement goal from question 2 by making 10 annual equal deposits at 7% compounded annually into her retirement accounts starting a year from today (the last deposit will be made