there were some part of this assignment i got wrong. i know i need to put the words into the formula in the specified cell but it comes up with error throughout the answers. im not sure why im doing wrong in order for the equations to work. the last picture shows the cell is named but it doesnt recognize it in the equation

AutoSave om HC. SC_EX19_4a_Nicole Hemperly_2 - Excel A Nicole Klotkowski NK File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments X Trebuchet MS 11 - AA == ab Wrap Text Currency - IX TH W 48 2 Paste LG A- BIU- E Merge & Center Insert Delete Format Ideas $ -% -2 Conditional Format as Cell Formatting - Table - Styles Styles Sort & Find & Filter - Select - Editing Clipboard Font Alignment Number Cells Ideas Monthly_... fi --PMT(D4/12,D5,88) E F G H J K A B D 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator 4 Date 9/15/2021 Rate 4.45% 5 Property Charles Street Term in Months 180 6 Price $ 1,150,000 Monthly Payment $7,014.45 7 Down Payment $ 230,000 Total Interest $ 342,601.29 8 Loan Amount $ 920.000 Total Cost $ 1,492,601.29 9 10 Varying Interest Rates and Terms 11 Rate Number of Months 4 12 $ 7,014 120 180 240 13 13 3.95% $ 9,292.71 $ 6,782.10 $ 5,550.81 14 14 4.05% $ 9,336.43 $ 6,828.20 $ 5,599.29 15 4.15% $ 9,380.28 $ 6,874.49 $ 5,648.00 16 4.25% $ 9,424.25 $ 6,920.96 $ 5,696.96 17 4.35% $ 9,468.35 $ 6,967.62 $ 5,746.15 18 4.45% $ 9,512.58 $ 7,014.45 $ 5,795.57 19 4.55% $ 9,556.92 $ 7,061.47 $ 5,845.23 20 4.65% $ 9,601.40 $ 7,108.67 $ 5,895.13 7 LELDE E 0.15 Loan Calculator Equipment Loan + Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value Renovation 20 Years 8 Years $ 1,020,000 $ 968,938 $ 920,000 4.45% 4.25% 4.45% 0.37% 0.35% 0.37% 15 20 8 180 240 96 1/3/2022 1/3/2022 1/3/2022 $ (7,777) $ (6,000) $ (8,000) n/a n/a ($392,082.42) TEN E + 10095 I Type here to search O W x 7:41 PM 7/5/2020 AutoSave On AC SC_EX19_4a_Nicole Hemperly_2 - Excel A Nicole Klotkowski NK File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments X Trebuchet MS 11 - AA == ab Wrap Text Custom TH IX W 48 2 Paste LG BIU- A- Insert Delete Format Ideas Merge & Center - $ . % 33 Conditional Format as Cell Formatting - Table - Styles Styles Sort & Find & Filter - Select - Editing Clipboard Font Alignment Number Cells Ideas Loan_Am ** =Price-Down_Payment E F G H J K A B C D 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator 4 Date 9/15/2021 Rate 4.45% 5 Property Charles Street Term in Months 180 6 Price 1,150,000 Monthly Payment $7,014.45 7 Down Payment $ 230,000 Total Interest $ 342,601.29 8 Loan Amount $ 920,000 Total Cost $ 1,492,601.29 9 10 Varying Interest Rates and Terms 11 Rate Number of Months 12 $ 7,014 120 180 240 13 13 3.95% $ 9,292.71 $ 6,782.10 $ 5,550.81 14 14 4.05% $ 9,336.43 $ 6,828.20 $ 5,599.29 15 4.15% $ 9,380.28 $ 6,874.49 $ 5,648.00 16 4.25% $ 9,424.25 $ 6,920.96 $ 5,696.96 17 4.35% $ 9,468.35 $ 6,967.62 $ 5,746.15 18 4.45% $ 9,512.58 $ 7,014.45 $ 5,795.57 19 4.55% $ 9,556.92 $ 7,061.47 $ 5,845.23 20 4.65% $ 9,601.40 $ 7,108.67 $ 5,895.13 7 LELDE E 0.15 Loan Calculator Equipment Loan + Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value Renovation 20 Years 8 Years $ 1,020,000 $ 968,938 $ 920,000 4.45% 4.25% 4.45% 0.37% 0.35% 0.37% 15 20 8 180 240 96 1/3/2022 1/3/2022 1/3/2022 $ (7,777) $ (6,000) $ (8,000) n/a n/a ($392,082.42) TEN E + 10095 I Type here to search O W x 7:41 PM 7/5/2020 AutoSave On AC SC_EX19_4a_NicoleHemperly_2 - Excel A Nicole Klotkowski NK File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments X Trebuchet MS 11 - == ab Wrap Text Accounting - TH IX W 48 2 Paste LG A- BIU- E Merge & Center Insert Delete Format Ideas $ - %329 Conditional Format as Cell Formatting - Table - Styles Styles Sort & Find & Filter - Select - Editing Number Cells Ideas E F G H J K Clipboard Font Alignment Total_Inte... fi =(D6*D5)-B8 A B C D 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator 4 Date 9/15/2021 Rate 4.45% 5 Property Charles Street Term in Months 180 6 Price $ 1,150,000 Monthly Payment $7,014.45 7 Down Payment $ 230,000 Total Interest $ 342,601.29 8 Loan Amount $ 920.000 Total Cost $ 1,492,601.29 9 10 Varying Interest Rates and Terms 11 Rate Number of Months 4 12 $ 7,014 120 180 240 13 13 3.95% $ 9,292.71 $ 6,782.10 $ 5,550.81 14 14 4.05% $ 9,336.43 $ 6,828.20 $ 5,599.29 15 4.15% $ 9,380.28 $ 6,874.49 $ 5,648.00 16 4.25% $ 9,424.25 $ 6,920.96 $ 5,696.96 17 4.35% $ 9,468.35 $ 6,967.62 $ 5,746.15 18 4.45% $ 9,512.58 $ 7,014.45 $ 5,795.57 19 4.55% $ 9,556.92 $ 7,061.47 $ 5,845.23 20 4.65% $ 9,601.40 $ 7,108.67 $ 5,895.13 7 LELDE E 0.15 Loan Calculator Equipment Loan + Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value Renovation 20 Years 8 Years $ 1,020,000 $ 968,938 $ 920,000 4.45% 4.25% 4.45% 0.37% 0.35% 0.37% 15 20 8 180 240 96 1/3/2022 1/3/2022 1/3/2022 $ (7,777) $ (6,000) $ (8,000) n/a n/a ($392,082.42) TEN E + 10095 I Type here to search O W x 7:41 PM 7/5/2020 AutoSave On AC SC_EX19_4a_NicoleHemperly_2 - Excel A Nicole Klotkowski NK File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Comments X Trebuchet MS 11 - AA == ab Wrap Text Accounting - TH IX W 48 2 Paste LG BIU A Ideas Merge & Center - Insert Delete Format $ - %329 Conditional Format as Cell Formatting - Table - Styles Styles Sort & Find & Filter - Select - Editing Clipboard Font Alignment Number Cells Ideas Total_Cost ** fi =B6+D7 E F G H J K B C D 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator 4 Date 9/15/2021 Rate 4.45% 5 Property Charles Street Term in Months 180 6 Price $ 1,150,000 Monthly Payment $7,014.45 7 Down Payment $ 230,000 Total Interest $ 342,601.29 8 Loan Amount $ 920.000 Total Cost $ 1,492,601.29 9 10 Varying Interest Rates and Terms 11 Rate Number of Months 12 $ 7,014 120 180 240 13 13 3.95% $ 9,292.71 $ 6,782.10 $ 5,550.81 14 14 4.05% $ 9,336.43 $ 6,828.20 $ 5,599.29 15 4.15% $ 9,380.28 $ 6,874.49 $ 5,648.00 16 4.25% $ 9,424.25 $ 6,920.96 $ 5,696.96 17 4.35% $ 9,468.35 $ 6,967.62 $ 5,746.15 18 4.45% $ 9,512.58 $ 7,014.45 $ 5,795.57 19 4.55% $ 9,556.92 $ 7,061.47 $ 5,845.23 20 4.65% $ 9,601.40 $ 7,108.67 $ 5,895.13 7 LELDE E 0.15 Loan Calculator Equipment Loan + Scenarios Loan Amount Annual Interest Rate Monthly Interest Rate Loan Period in Years Loan Period in Months Start Date Monthly Payment Future Value Renovation 20 Years 8 Years $ 1,020,000 $ 968,938 $ 920,000 4.45% 4.25% 4.45% 0.37% 0.35% 0.37% 15 20 8 180 240 96 1/3/2022 1/3/2022 1/3/2022 $ (7,777) $ (6,000) $ (8,000) n/a n/a ($392,082.42) TEN E + 10095 I Type here to search O W x 7:41 PM 7/5/2020 A Nicole Klotkowski NK AutoSave On 2 SC_EX19_4a_NicoleHemperly_Report_1 (2) - Protected View - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful-filles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Share Comments X A1 fix D E F G 0/6 B 4. Liam needs to calculate the monthly payment for a loan to purchase the Charles Street property. Calculate the payment as follows: a. In cell D6, start to enter a formula using the PMT function. b. For the rate argument, divide the Rate (cell D4) by 12 to use the monthly interest rate. c. For the nper argument, use the Term_in_Months (cell D5) to specify the number of periods. d. For the pv argument, use the Loan Amount (cell B8) to include the present value. e. Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount. 20 21 22 X Create a formula using a function. In the Loan Calculator worksheet, the formula in cell D6 should contain the PMT function. 5. In cell D7, enter a formula without using a function that multiples the Monthly Payment (cell D6) by the Term in Months (cell D5) and then subtracts the Loan Amount (cell B8) from the result to determine the total interest. 0/6 23 24 X Create a formula. In the Loan Calculator worksheet, the formula in cell D7 should calculate the total interest of the loan. 25 0/6 26 27 6. In cell D8, enler a formula wilhoul using a lunclion lhal adds the Price (cell B6) lo lhe Total_Interest (cell D7) lo determine the total cost. X Create a formula. In the Loan Calculator worksheet, the formula in cell D8 should calculate the total cost of the loan. 28 3/6 7. Liam wants to compare monthly payments for interest rates that vary from 3.95% to 5.15% and for terms of 120, 180, and 240 months. He has already set in the structure for a datatable in the range A12:25 Documentation Loan Calculator Equipment Loan Ready E + 10096 HE Type here to search o W x 7:43 PM 7/5/2020