I need at least a screenshot for the excel solution

Lisa's father is going to set up an account for her daughter's college education. Lisa's expenses during her undergraduate education are expected to be as follows. Assume that these expenses are due at the beginning of each year. Year Expense 1 $20,000 2 $30,000 3 $40,000 4 $45,000 Lisa considers two bond investment options at the beginning of her first year at college: Bond Par value Current price $1300 $1500 Annual rate of return (%) 20 25 Years to maturity 1 3 1 $1000 $1000 2 Funds not invested in bonds will be placed in savings with an annual interest rate of 2%. What is the minimum amount of money Lisa's father needs to put into her college account at the beginning of her first year so that Lisa can make all her expenses from that account during her four-years education? a) Define the variables. b) Write the mathematical formulation of the problem. c) Solve the problem in Excel and state the optimal solution here. Submit your Excel file in Canvas. Lisa's father is going to set up an account for her daughter's college education. Lisa's expenses during her undergraduate education are expected to be as follows. Assume that these expenses are due at the beginning of each year. Year Expense 1 $20,000 2 $30,000 3 $40,000 4 $45,000 Lisa considers two bond investment options at the beginning of her first year at college: Bond Par value Current price $1300 $1500 Annual rate of return (%) 20 25 Years to maturity 1 3 1 $1000 $1000 2 Funds not invested in bonds will be placed in savings with an annual interest rate of 2%. What is the minimum amount of money Lisa's father needs to put into her college account at the beginning of her first year so that Lisa can make all her expenses from that account during her four-years education? a) Define the variables. b) Write the mathematical formulation of the problem. c) Solve the problem in Excel and state the optimal solution here. Submit your Excel file in Canvas