i used the what if table with using reference to d3. i am not sure if this if correct

3. (12 points) Create a one-input data table as follows to determine how variable interest rates in the range A12:A23 will affect the total cost of the new inn: a. In cell B11, insert a formula that references cell D5 (the quarterly payments). b. In cell C11, insert a formula that references cell D6 (the total interest paid on the loan). c. In cell D11, insert a formula that references cell D7 (the total cost of the mortgage). d. Based on the range A11:023, create a one-input data table using an absolute reference to cell D3 (the mortgage interest rate) as the input cell. File Home Insert Draw Page Layout Formulas Data Review View Help Search A E % Conditional Formatting Format as Table Alignment Number Cells Editing Ideas Cell Styles Paste Font Clipboard Styles Ideas B12 {=TABLE(D3) F $ D (4,601,616.37) (2,128,116.37) $ A B 6 Down-Payment $ 473,500.00 Total Interest 7 Amount Borrowed $2,000,000.00 Total Cost 8 9 Varying Interest Rate Schedule 10 Rate Quarterly Payment Total Interest 11 $ (43,360.27) $ (4,601,616.37) $ 12 3.000% $ (41,516.71) $ (4,491,002.63) $ 13 3.125% $ (41,881.65) $ (4,512,899.28) $ 14 3.250% $ (42,248.49) $ (4,534,909.24) $ 15 3.375% $ (42,617.20) $ (4,557,032.25) $ 16 3.500% $ (42,987.80) $ (4,579,268.05) $ 17 3.625% $ (43,360.27) $ (4,601,616.37) $ 18 3.750% $ (43,734.62) $ (4,624,076.94) $ 19 3.875% $ (44,110.82) $ (4,646,649.49) $ 20 4.000% $ (44,488.90) $ (4,669,333.72) $ 21 4.125% $ (44,868.82) $ (4,692,129.34) $ 22 4.250% $ (45,250.60) $ (4,715,036.06) $ 23 4.375% $ (45,634.23) $ (4,738,053.55) $ 24 25 26 Total Cost (2,128,116.37) (2,017,502.63) (2,039,399.28) (2,061,409.24) (2,083,532.25) (2,105,768.05) (2,128,116.37) (2,150,576.94) (2,173,149.49) (2,195,833.72) (2,218,629.34) (2,241,536.06) (2,264,553.55) 1 Inn Mortgage Spruce Hotel Adela Condos Pinehi ... Ready @ 1:25 PM 7/14/2020 3. (12 points) Create a one-input data table as follows to determine how variable interest rates in the range A12:A23 will affect the total cost of the new inn: a. In cell B11, insert a formula that references cell D5 (the quarterly payments). b. In cell C11, insert a formula that references cell D6 (the total interest paid on the loan). c. In cell D11, insert a formula that references cell D7 (the total cost of the mortgage). d. Based on the range A11:023, create a one-input data table using an absolute reference to cell D3 (the mortgage interest rate) as the input cell. File Home Insert Draw Page Layout Formulas Data Review View Help Search A E % Conditional Formatting Format as Table Alignment Number Cells Editing Ideas Cell Styles Paste Font Clipboard Styles Ideas B12 {=TABLE(D3) F $ D (4,601,616.37) (2,128,116.37) $ A B 6 Down-Payment $ 473,500.00 Total Interest 7 Amount Borrowed $2,000,000.00 Total Cost 8 9 Varying Interest Rate Schedule 10 Rate Quarterly Payment Total Interest 11 $ (43,360.27) $ (4,601,616.37) $ 12 3.000% $ (41,516.71) $ (4,491,002.63) $ 13 3.125% $ (41,881.65) $ (4,512,899.28) $ 14 3.250% $ (42,248.49) $ (4,534,909.24) $ 15 3.375% $ (42,617.20) $ (4,557,032.25) $ 16 3.500% $ (42,987.80) $ (4,579,268.05) $ 17 3.625% $ (43,360.27) $ (4,601,616.37) $ 18 3.750% $ (43,734.62) $ (4,624,076.94) $ 19 3.875% $ (44,110.82) $ (4,646,649.49) $ 20 4.000% $ (44,488.90) $ (4,669,333.72) $ 21 4.125% $ (44,868.82) $ (4,692,129.34) $ 22 4.250% $ (45,250.60) $ (4,715,036.06) $ 23 4.375% $ (45,634.23) $ (4,738,053.55) $ 24 25 26 Total Cost (2,128,116.37) (2,017,502.63) (2,039,399.28) (2,061,409.24) (2,083,532.25) (2,105,768.05) (2,128,116.37) (2,150,576.94) (2,173,149.49) (2,195,833.72) (2,218,629.34) (2,241,536.06) (2,264,553.55) 1 Inn Mortgage Spruce Hotel Adela Condos Pinehi ... Ready @ 1:25 PM 7/14/2020