ASAP! DO NOT SEND ME CODES, I DONT GET THAT AND IF YOU DO IMMA THUMBS DOWN. anyways, I need help on what to click and insert on excel. Please show what I need to click on excel. Need help with the formulas too please such as PMT. Please no codes either. Here are the steps and data. Thank you.

Part 1 - Loan Worksheet - Calculate Payment 5. Output ara-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 in the total of all payments Total Interest which is the difference between the Loan Amount and Total cost of Loan 0 Loan Amount Monthly Payment Total Interest Total cost of Loan 7. Create Range Nome for the Workbook using the monthly payment amount with the name toan Payment 6. Format the worksheet to make it look business live and professional Self check. Change the Loan Term to 15 years. You should see the Monthly Payment. Total interest and Total cost of Loary 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 Sales 319.03 64191.00 Total formula Expenses Mortgage Payroll Tax Insurance Phone Internet Utilities Advertising Total Add 3D reference to Loan Payment 3D reference to Payroll Total (from Lab 2) formula 1622.50 187.22 221.86 418.24 1218.37 formula Net Income formula 1. Add a 3D cell reference to the Loan_Payment range in the Mortgage cell B D E 1 Loan Calculation 722,100 32,300.00 3.125% 30 2 3 Store Cost - 2201 Cuyamaca St. 4 Down Payment 5 Annual Percentage Rate 6 Loan Term - Years 7 8 Loan Amount 9 Monthly Payment 10 Total Interest 11 Total Cost of Loan 12 13 14 15 16 17 18 19 20 21 B C D E F G G 1 Southwest Mini-Market #213 2 3 Income 4 Interest $ 5 Sales $ 6 Total $ 319 64,191 64,510 7 8 Expenses 9 Mortage $ 10 Payroll $ 11 Tax $ 12 Insurancs 13 Phone $ 14 Internet $ 15 Utilities $ 16 Advertiss 17 Total s 18 19 Net Incor $ 20 21 2,500 3,210 5,710 1,623 187 122 418 1,218 3,568 60,942 NN