Place the corresponding loan payments in the March Inventory worksheet. (Hint: Please use LOOKUP function or IF function.

Please find this formula for me. It will placed in cell J11.

Spring Garden Customer Loans Divisions Loan Periods (years) Interest Rates Copier Printer A2 an Amounts $3,000.00 $2,000.00 $1,200.00 5.0% 6.0% 7.0% Monthly Loan Payments (56.61) (60.84) (53.73) Fax # of Printers in Inventory at a cost of Less than $1,000? Total Inventory Value: 575,361.69 Cost Monthly Loan Payments 10 Amt 11 12 13 14 15 16 8 Division 1 Copier 3 Copier 5 Copier 10 Fax 5 Fax 5 Printer 3 Printer 8 Printer 1 Fax 2 Copier 3 Copier 4 Copier 25 Fax 10 Copier 15 Copier 12 Copier 100 Fax 5 Fax 5 Printer 5 Printer 10 Printer 10 Printer 10 n . Model # C320 GLS C310 GLS C300 GLS F350 G F300 G P500 S P500 L P500 G F600 G C120 GLS C110 GLS C100 GLS F100 G C220 GLS C210 GLS C200 GLS F250 G F200 G P310 S P310 L P310 G P100 S nin March Inventory Product Name Business Copier Business Copier Business Copier Business Fax Business Fax Business Printer - Laser Business Printer - Laser Business Printer - Laser Compact Professional Plus Fax Personal Copier Personal Copier Personal Copier Personal Fax Personal Plus Copier Personal Plus Copier Personal Plus Copier Personal Plus Fax Personal Plus Fax Personal Plus Printer - Bubble Jet Personal Plus Printer - Bubble Jet Personal Plus Printer - Bubble Jet Personal Printer - Dot Matrix 3,558.02 2,965.02 2,470.85 1,260.66 1,050.55 1,952.28 1,859.32 1,770.78 3,136.94 1,191.58 992.98 827.48 607.96 2,059.03 1,715.86 1,429.89 875.66 729.55 780.91 743.73 708.32 339.52 Value of Inventory Sales Prices 3,558.02 4,803.32 8,895.05 4,002.77 12,354.23 3,335.64 12,606.60 1,701.89 5,252.75 1,418.24 9,761.40 2,635.58 5,577.96 2,510.08 14,166.24 2,390.55 3,136.94 4,234.87 2,383.15 1,608.63 2,978.93 1,340.52 3,309.92 1,117.10 15,199.00 820.75 20,590.34 2,779.70 25,737.90 2,316.41 17,158.68 1,930.35 87,566.00 1,182.14 3,647.75 984.89 3,904.55 1,054.23 3,718.65 1,004.04 7,083.20 956.23 3,395.20 458.35 Bonus 720.50 600.42 500.35 170.19 141.82 395.34 376.51 358.58 635.23 160.86 134.05 111.71 41.04 416.95 347.46 193.04 118.21 49.24 105.42 100.40 47.81 9.17 % of Inventory 0.62 1.55 2.15 2.19 0.91 1.70 0.97 2.46 0.55 0.41 0.52 0.58 2.64 3.58 4.47 2.98 15.22 0.63 0.68 0.65 1.23 0.59 26 27 28 29 30 31 32 Loans