Part 1 - Loan Worksheet - Calculate Payment To add the Mortgage expense for the store we need to calculate the mortgage payment on the Loan Worksheet and then add a reference to the payment amount on the Overview worksheet. This type of calculation was covered as a topic in Excel chapter 2. Since this worksheet will have an area for user input and also an area where the calculated results will be displayed you need to design the worksheet appropriately and may want to refer to the Worksheet Design page to view example layouts. Start by opening your Excel Lab 2 file and save it as Cierra.Woods_Excel_Lab3 In the Loan worksheet, enter the text Loan Calculation in cell A1 Merge and center the text in cell A1 across columns A to E Change cell A1 font size and background color to an appropriate combination for a title. Input area - Starting in cell A3 create the following. Use the following for your input area text and values. Store Cost - 2301 Cuyamaca St. 723,100.00 Down Payment 32,300.00 Annual Percentage Rate 3.125% Loan Term - Years 30 Output area - select an appropriate area to enter formulas to calculate the following for your output area values. Loan Amount is the difference between the cost of the store and the down payment. Monthly Payment - payments are at the end of the month and displayed as a positive value. Total Cost of Loan which is the total of all payments. Total Interest which is the difference between the Loan Amount and Total Cost of Loan Loan Amount Monthly Payment Total Interest Total Cost of Loan Create a Range Name for the Workbook using the monthly payment amount with the name Loan_Payment. Format the worksheet to make it look business like and professional. Self check. Change the Loan Term to 15 years. You should see the Monthly Payment, Total Interest and Total Cost of Loan change. If any of them stay the same, then you have a problem. When finished checking change the Loan Term back to 30 years. Part 2 - Update Overview Worksheet In the part of the assignment, you will add references to the Overview worksheet you already created in your workbook. Income Interest 319.03 Sales 64191.00 Total formula Expenses Mortgage Add 3D reference to Loan Payment Payroll 3D reference to Payroll Total (from Lab 2) Tax formula Insurance 1623.50 Phone 187.23 Internet 123.86 Utilities 418.24 Advertising 1218.37 Total formula Net Income formula Add a 3D cell reference to the Loan_Payment range in the Mortgage cell. Please do not answer in a code. I need to know what functions to create in excel to solve the problem.