Open the Investments worksheet. In cell B$5,$ enter a function that will calculate the present value of an investment using the data in the range B$2$:B$4.$ Assume this investment will be made at the beginning of the first year.

Consider the present value calculation in cell B$5.$ Assume that there is only $$275,000$ that can be invested today, but you still need to achieve a future value of $$1,550,000.$ Use Goal Seek to set the present value calculation to $$275,000$ by changing the Annual Rate of Return.

In cell B$11,$ enter a function that will calculate the present value of an investment that will provide funding for the cost in cell B$10.$ Use the data in the range B$8$:B$10$ to set up the function. Assume that payments are made at the beginning of each year.

Enter a function in cell B$17$ that will calculate the future value of a one$-$time investment. Use the data in the range B$14$:B$16$ to create the function. Assume the investment is made at the beginning of the first year.

Enter a function in cell B$24$ that will calculate the future value of a recurring investment. Use the date in the range B$20$:B$23$ to create the function. Assume that investments are made at the end of each month.

Open the Loan worksheet. Use the necessary data in the range B$2$:B$5$ to create a formula in cell B$6$ that calculates the Loan Principal.

Enter the date $11/09/2020$ into cell B$7.$

Enter a formula into cell B$8$ that displays a date $60$ days from the date entered into cell B$7.$

Enter a function into cell B$9$ that shows the date that occurs on the last day of the month, one month after the date in cell B$8.$

Enter a function into cell B$10$ that shows just the year of the date that is in cell B$9.$

Enter a function into cell B$11$ that calculates the monthly payments for the loan. Use the data in the range B$2$:B$6$ to create the function. Assume that payments are made at the end of each month.

Open the Lease worksheet. Enter a formula into cell B$6$ that calculates the monthly lease payments. Use the data in the range B$2$:B$5$ to create the function. Assume that payments are made at the end of each month.

Apply protection to the Lease worksheet such that users can edit the range B$2$:B$5.$ Name this range Lease Data.

Open the Summary worksheet. Use a cell reference in cell B$2$ to display the value in cell B$4$ on the Lease worksheet.

Use a cell reference in cell B$3$ to display the value in cell B$6$ on the Loan worksheet.

Enter a formula in cell B$4$ that adds the values in cells B$5$ and B$11$ on the Investments worksheet.

Enter a formula in cell B$5$ that adds the values in cells B$17$ and B$24$ on the Investments worksheet.

Save and close your workbook.