please help me with numb 2,3

insert page Layout Fornulas bata Rever View ACROBAT me what you-ant te do defined names Rate Loan Amount as the nper, and pv argur t a negative sign uei Son & Find & Formal une PME function to make the formula return a positive value 5,75% In the function, Rate should be divided by 12 to calculate the monthly interest rate, and Term Years should be multiplied by 12 to calculate the total number of monthly payments. b. Camp Millo vski Cage loan payment the mortgage interest rate she expects to qualify for. She now wants to determine how different interest rates could impact the total cost of the campground. 15-Aug 18 Rate Balance Ending Balance Paid on Principal Interest Paid Campground Term (Years) 1 388,80000371, 973.53 486,000.00 Monthly Payment(3,228.63) S (969,954.20) 3 $ 354,153.63 335,281.65 4 335,281.65 315,25.47 S 315,295.47 $294,123.30 b s 94,129.30 271,713.49 7$ 271,713.49 $ 247,974.26 B$247.94.26 222,333.46 9 222,833.46 196,208.36 190,208.36 $ 168,011.31 11 $ 16801131 138,149.52 12 $ 138,149.52 106,524.09 524.69 3,032.73 14 S 73,032 7a 5 37,563.42 97,200.00 Total interest 388,800,00 Total Cost Select the range A12:A26 and fill it with a percent series based on the values in range A12:A13. These values are the interest rates that Kaleen will analyze in the Varying Interest Rate Schedule. Payment Create a single variable data table to determine the impact that the variable interest rates (in the range A12:A22) will have on the total cost of the campground 3. 3. In cell B11, create a formula without using a function that references cell D5 (the monthly payments). a. In cell C11, create a formula without using a function that references cell D6 (the total interest paid on the loan). b. 7,563 42 In cell D11, create a formula without using a function that references cell D7 (the total cost of the mortgage). c. d. Select the range A11:D26 and create a single-variable data le, using an absolute reference to cell D3 (the mortgage interest rate) as the Column input cell 4. To help Kaleen identify how each rate in her Variable Interest Rate Schedule compares to the interest rate she anticipates on her mortgage, she decides to highlight the matching Interest rate in the schedule with a conditional formatting rule. Apply a Highlight Cells conditional formatting rule to the range A12:A26 that formats any cell In the range that is equal to the value insert page Layout Fornulas bata Rever View ACROBAT me what you-ant te do defined names Rate Loan Amount as the nper, and pv argur t a negative sign uei Son & Find & Formal une PME function to make the formula return a positive value 5,75% In the function, Rate should be divided by 12 to calculate the monthly interest rate, and Term Years should be multiplied by 12 to calculate the total number of monthly payments. b. Camp Millo vski Cage loan payment the mortgage interest rate she expects to qualify for. She now wants to determine how different interest rates could impact the total cost of the campground. 15-Aug 18 Rate Balance Ending Balance Paid on Principal Interest Paid Campground Term (Years) 1 388,80000371, 973.53 486,000.00 Monthly Payment(3,228.63) S (969,954.20) 3 $ 354,153.63 335,281.65 4 335,281.65 315,25.47 S 315,295.47 $294,123.30 b s 94,129.30 271,713.49 7$ 271,713.49 $ 247,974.26 B$247.94.26 222,333.46 9 222,833.46 196,208.36 190,208.36 $ 168,011.31 11 $ 16801131 138,149.52 12 $ 138,149.52 106,524.09 524.69 3,032.73 14 S 73,032 7a 5 37,563.42 97,200.00 Total interest 388,800,00 Total Cost Select the range A12:A26 and fill it with a percent series based on the values in range A12:A13. These values are the interest rates that Kaleen will analyze in the Varying Interest Rate Schedule. Payment Create a single variable data table to determine the impact that the variable interest rates (in the range A12:A22) will have on the total cost of the campground 3. 3. In cell B11, create a formula without using a function that references cell D5 (the monthly payments). a. In cell C11, create a formula without using a function that references cell D6 (the total interest paid on the loan). b. 7,563 42 In cell D11, create a formula without using a function that references cell D7 (the total cost of the mortgage). c. d. Select the range A11:D26 and create a single-variable data le, using an absolute reference to cell D3 (the mortgage interest rate) as the Column input cell 4. To help Kaleen identify how each rate in her Variable Interest Rate Schedule compares to the interest rate she anticipates on her mortgage, she decides to highlight the matching Interest rate in the schedule with a conditional formatting rule. Apply a Highlight Cells conditional formatting rule to the range A12:A26 that formats any cell In the range that is equal to the value