I need help with solving these. If you can only help with one, thats fine, anything helps. Thank you! if possible please solve using formulas including: vlookup, hlookup, findifs, countifs, fv, abs, pmt, ipmt, ppmt, pv

B 1 Construct formulas in the open cells below to answer the questions. The work you do here will prepare you to complete the section on the right. As you work through these problems, pay attention to how you break down a large problem in smaller pieces, and how the small pieces interact to produce results. COMPLETE THE QUESTIONS BELOW FIRST... THEN WORK THROUGH THE LOAN PROCESSING WORKSHEET ON THE RIGHT Credit Score $ Down $12,600 800 690 Loan Annual Percentage Rate Lookup Table Credit Score 300 400 500 600 700 11.11 9.61% 8.11% 6.61N 5.11% 11.10 9.60% 8.10% 6.60 5.10% 11.09 9.595 8.09% 6.59% 5.09% 1.OON 3.61% 750 $11,800 2.50N 3.60% 300 $4,500 5.00N 3.59% 360 55,300 7.50N 11.07 9.57 8.07% 6.57% 10 5.07% 3.57% 820 $5,600 $1,300 2 4 10.00% 11.06 8.06 6.56% 11 3.56% 710 LOOKUP TABLES 9.56% 9.555 5.06% 5.05% ACCOUNT HOLDERS ID Name Address BL-1044 Bar, Benjamin E 971 South Main Boulevard FO-7198 Foster, MR 248 North Cedar Street GO 9359 Gonzales, Braiden M. 394 South Cedar St. OR 9208 Oro, Alex A 100 West Pine Street G-2453 Gle, Rudy 211 West Par Street / Apartment 10 MO 7497 Momson, Kay A 381 South Eighth Street / Apt 114 SH. 2158 Shepard, Isabel 235 South Eghth Street / Apartment 116 LE-7679 Lewis, Chalo M. 180 West Hill St. B0 333 Rose, kai 633 South Street / Apartment. A BR-3525 Browning. Danica 131 South fourth Blvd, GR-2481 y. Aniya 331 West Washington Street CA6950 Camell, Salvato 739 East Third St. / Apt. +20 PR-1920 549 South Fifth St./ Apt. - U-5136 Lindsay Lily H 227 North Eighth Street / Apartment 12 11.05% 12 8.05 6.55% 3.55 370 $10,100 15.00N 8.04 6.54% 5.04% 3.54% 580 13 $6,000 11.04% 11.02 17.50% 9.54% 9.52 9.51% 8.02% 5.02 14 3.52% 850 $6,000 6.52% 651 20.00% 11.01% 15 8.01% 5.01% 3.51% 850 $1,400 16 22.50% Z OO 11.00% 9.50% 8.00% 6.50% 3.50N 5.00% 430 $3,200 25.00% 10.99% 17 7.99% 6.49% 4.99% 3.49% 780 $12.900 10.97 9.47 7.97% 6.47% 18 4.97% 3.47% 660 27.50N 30.00% $9,200 $5,500 10.96 7.96 6.46% 19 4.96% 3.46% 640 20 21 11 22 if someone with a credit score of 600 is seeking a loan, and they are able to put down 11.25% of the purchase price, what interest rate should they 23 21 If someone with a credit score of 470 is seeking a loan, and they able to put down 22.50% of the purchase price, what interest rate should they 24 25 26 if someone with a credit score of 770 is seeking a loan, and they we able to put down 14.00% of the purchase price, what interest rate should theypt 1000 27 4 28 if someone with a credit score of 470 is seeking alon, and they are able to put down 26.50% of the purchase price what interest rate should they 29 30 51 If someone has a credit score of 400 and is able to put down 10.25% of the purchase price, what interest rate should they stil 31 32 33 if someone wants to buy something worth is able to put down and has a credit score of what interest rate should they? How much will they need to borrowi $10,651 $1,961 890 450 7) What are the credit scores of these customes FO-7198 How many customers in the list have credit GI-2453 scores of at least MO-7497 How many customers in the list have credit LE-7679 scores less than 35 510 36 37 2 ID 500 Credit Score 330 650 11 LOOKUP TABLES Loan Annual Percentage Rate Lookup Table Credit Score 300 400 600 700 800 1.00% 11.11% 9.61% 8.11% 6.61% 5.11% 3.61% 2.50% 11.10% 9.60% 8.10% 6.60% 5.10% 3.60% 5.00% 11.09% 9.59% 8.09% 6.59% 5,09% 3.59% 7.50% 11.07% 9.57% 8.07% 6.57% 5.07% 3.57% 10.00% 11.06% 9.56% 8.06% 6.56% 5.06% 3.56% 11.25% 11.05% 9.55% 8.05% 6.55% 5.05% 3.55% 15.00% 11.04% 9.54% 8.04% 6.54% 5,04% 3.54% 17.50% 11.02% 9.52% 8.02% 6.52% 5.02% D 20.00% 11.01% 9.51% 8.01% 6.51% 5.01% 3.51% 0 22.50% 11.00% 9.50% 8,00% 6.50% 5.00% 3.S0x w 25.00% 10.99% 9.49% 7.99% 6.49% 4.99% 3.49% N 27.5010.97% 9,47% 7.976.47% 4.97% 3.47% 30.00% 10.96% 9.46% 7.96% 6.46% 4.96% 3.46% ACCOUNT HOLDERS Name Address Blair, Benjamin 171 South Main Boulevard Foster, Marjorie R 248 North Cedar Street Gonzales, Braiden 394 South Cedar Ortiz, Alexia A 100 West Pine Street Gles, Rudy 211 West Park Street / Apartment Morrison, Katelyn 881 South Eighth Street /Apt. 124 Shepard, Isabel 888 South Eighth Street / Apartme Lewis, Charleigh M 180 West Hill St Rose, Kaik 633 South Oak Street / Apartment Browning, Danica 131 South Fourth Blvd. Gregory. Amiya K 331 West Washington Street Carroll, Salvatore 739 East Third St./Apt. 26 Frazier, Maylin 549 South Filth St./Apt. Lindsay, Riley H. 227 North Street/Apartmd BL-1014 FO-7198 GO-9359 OR-9208 GI-2453 MO-7497 SH-2158 LE-7679 | R3238 BR-3525 GR-2481 CA-6950 FR-3920 1-5136 12 13 14 15 16 840 780 350 710 420 610 600 550 810 530 640 740 $ Down $9.200 $7.900 $10,700 $10,100 $4.300 $1,200 $5,500 $12,000 $10,600 $3,400 58,800 $6,600 55,800 $9.000 3.52% IN 19 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 If someone with a credit score of Goo is seeking a loan, and they are able to put down 7.5OX If someone with a credit score of 470 is seeking a loan, and they are able to put down 1.00% If someone with a credit score of 770 is seeking a loan, and they are able to put down 4.00% If someone with a credit score of 470 is seeking a loan, and they are able to put down 9.00% If someone has a credit score of 380 and is able to put down 16.50% eone wants to buy something worth $10,788 7) What are the credit scores of these customers: is able to put down $299 GO-9359 and has a credit score of MO-7497 what interest rate should they get? LE-7679 How much will they need to borrow? GR-2481 of the purchase price, what Interest rate should they eet? of the purchase price, what interest rate should they get? of the purchase price, what interest rate should they get? of the purchase price, what interest rate should they get? of the purchase price, what interest rate should they get? 680 790 How many customers in the list have credit scores of at least How many customers in the list have credit scores less than 730 B 1 Construct formulas in the open cells below to answer the questions. The work you do here will prepare you to complete the section on the right. As you work through these problems, pay attention to how you break down a large problem in smaller pieces, and how the small pieces interact to produce results. COMPLETE THE QUESTIONS BELOW FIRST... THEN WORK THROUGH THE LOAN PROCESSING WORKSHEET ON THE RIGHT Credit Score $ Down $12,600 800 690 Loan Annual Percentage Rate Lookup Table Credit Score 300 400 500 600 700 11.11 9.61% 8.11% 6.61N 5.11% 11.10 9.60% 8.10% 6.60 5.10% 11.09 9.595 8.09% 6.59% 5.09% 1.OON 3.61% 750 $11,800 2.50N 3.60% 300 $4,500 5.00N 3.59% 360 55,300 7.50N 11.07 9.57 8.07% 6.57% 10 5.07% 3.57% 820 $5,600 $1,300 2 4 10.00% 11.06 8.06 6.56% 11 3.56% 710 LOOKUP TABLES 9.56% 9.555 5.06% 5.05% ACCOUNT HOLDERS ID Name Address BL-1044 Bar, Benjamin E 971 South Main Boulevard FO-7198 Foster, MR 248 North Cedar Street GO 9359 Gonzales, Braiden M. 394 South Cedar St. OR 9208 Oro, Alex A 100 West Pine Street G-2453 Gle, Rudy 211 West Par Street / Apartment 10 MO 7497 Momson, Kay A 381 South Eighth Street / Apt 114 SH. 2158 Shepard, Isabel 235 South Eghth Street / Apartment 116 LE-7679 Lewis, Chalo M. 180 West Hill St. B0 333 Rose, kai 633 South Street / Apartment. A BR-3525 Browning. Danica 131 South fourth Blvd, GR-2481 y. Aniya 331 West Washington Street CA6950 Camell, Salvato 739 East Third St. / Apt. +20 PR-1920 549 South Fifth St./ Apt. - U-5136 Lindsay Lily H 227 North Eighth Street / Apartment 12 11.05% 12 8.05 6.55% 3.55 370 $10,100 15.00N 8.04 6.54% 5.04% 3.54% 580 13 $6,000 11.04% 11.02 17.50% 9.54% 9.52 9.51% 8.02% 5.02 14 3.52% 850 $6,000 6.52% 651 20.00% 11.01% 15 8.01% 5.01% 3.51% 850 $1,400 16 22.50% Z OO 11.00% 9.50% 8.00% 6.50% 3.50N 5.00% 430 $3,200 25.00% 10.99% 17 7.99% 6.49% 4.99% 3.49% 780 $12.900 10.97 9.47 7.97% 6.47% 18 4.97% 3.47% 660 27.50N 30.00% $9,200 $5,500 10.96 7.96 6.46% 19 4.96% 3.46% 640 20 21 11 22 if someone with a credit score of 600 is seeking a loan, and they are able to put down 11.25% of the purchase price, what interest rate should they 23 21 If someone with a credit score of 470 is seeking a loan, and they able to put down 22.50% of the purchase price, what interest rate should they 24 25 26 if someone with a credit score of 770 is seeking a loan, and they we able to put down 14.00% of the purchase price, what interest rate should theypt 1000 27 4 28 if someone with a credit score of 470 is seeking alon, and they are able to put down 26.50% of the purchase price what interest rate should they 29 30 51 If someone has a credit score of 400 and is able to put down 10.25% of the purchase price, what interest rate should they stil 31 32 33 if someone wants to buy something worth is able to put down and has a credit score of what interest rate should they? How much will they need to borrowi $10,651 $1,961 890 450 7) What are the credit scores of these customes FO-7198 How many customers in the list have credit GI-2453 scores of at least MO-7497 How many customers in the list have credit LE-7679 scores less than 35 510 36 37 2 ID 500 Credit Score 330 650 11 LOOKUP TABLES Loan Annual Percentage Rate Lookup Table Credit Score 300 400 600 700 800 1.00% 11.11% 9.61% 8.11% 6.61% 5.11% 3.61% 2.50% 11.10% 9.60% 8.10% 6.60% 5.10% 3.60% 5.00% 11.09% 9.59% 8.09% 6.59% 5,09% 3.59% 7.50% 11.07% 9.57% 8.07% 6.57% 5.07% 3.57% 10.00% 11.06% 9.56% 8.06% 6.56% 5.06% 3.56% 11.25% 11.05% 9.55% 8.05% 6.55% 5.05% 3.55% 15.00% 11.04% 9.54% 8.04% 6.54% 5,04% 3.54% 17.50% 11.02% 9.52% 8.02% 6.52% 5.02% D 20.00% 11.01% 9.51% 8.01% 6.51% 5.01% 3.51% 0 22.50% 11.00% 9.50% 8,00% 6.50% 5.00% 3.S0x w 25.00% 10.99% 9.49% 7.99% 6.49% 4.99% 3.49% N 27.5010.97% 9,47% 7.976.47% 4.97% 3.47% 30.00% 10.96% 9.46% 7.96% 6.46% 4.96% 3.46% ACCOUNT HOLDERS Name Address Blair, Benjamin 171 South Main Boulevard Foster, Marjorie R 248 North Cedar Street Gonzales, Braiden 394 South Cedar Ortiz, Alexia A 100 West Pine Street Gles, Rudy 211 West Park Street / Apartment Morrison, Katelyn 881 South Eighth Street /Apt. 124 Shepard, Isabel 888 South Eighth Street / Apartme Lewis, Charleigh M 180 West Hill St Rose, Kaik 633 South Oak Street / Apartment Browning, Danica 131 South Fourth Blvd. Gregory. Amiya K 331 West Washington Street Carroll, Salvatore 739 East Third St./Apt. 26 Frazier, Maylin 549 South Filth St./Apt. Lindsay, Riley H. 227 North Street/Apartmd BL-1014 FO-7198 GO-9359 OR-9208 GI-2453 MO-7497 SH-2158 LE-7679 | R3238 BR-3525 GR-2481 CA-6950 FR-3920 1-5136 12 13 14 15 16 840 780 350 710 420 610 600 550 810 530 640 740 $ Down $9.200 $7.900 $10,700 $10,100 $4.300 $1,200 $5,500 $12,000 $10,600 $3,400 58,800 $6,600 55,800 $9.000 3.52% IN 19 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 If someone with a credit score of Goo is seeking a loan, and they are able to put down 7.5OX If someone with a credit score of 470 is seeking a loan, and they are able to put down 1.00% If someone with a credit score of 770 is seeking a loan, and they are able to put down 4.00% If someone with a credit score of 470 is seeking a loan, and they are able to put down 9.00% If someone has a credit score of 380 and is able to put down 16.50% eone wants to buy something worth $10,788 7) What are the credit scores of these customers: is able to put down $299 GO-9359 and has a credit score of MO-7497 what interest rate should they get? LE-7679 How much will they need to borrow? GR-2481 of the purchase price, what Interest rate should they eet? of the purchase price, what interest rate should they get? of the purchase price, what interest rate should they get? of the purchase price, what interest rate should they get? of the purchase price, what interest rate should they get? 680 790 How many customers in the list have credit scores of at least How many customers in the list have credit scores less than 730