1. Calculate the loan payment for each loan in the portfolio
Please Include excel function used
PM Excel Test Search She Ruta. A ss. Home Insert Draw Page Layout Formulas J E -0- PetTable Runnended Table Plures Shapes kons Data Review View 0-9. 30 SmartArt Soreenshot Der Add-ins D ?. . F E A 4-1 - My Add-ins - Bing People Remended Mops PestChart Sparkes Soar Timeline Link New Tee Header & Wardent Object Equation Symbol M6 x fc 1. Crust the the man went for each an in the portinin Lou Loun Numbe Seller Name La Amentar 1140117 Shanna'sinan Headquarters 2 4120954 Shanna's Innenduarters 370.000 3 25055BGO Shanna's Loan Headquarters 210.000 4 61173047 Shanna's Inn Headsuarters 120.000 51398733 Shanna's Loan Headavarters 350.000 6 76906141 Shanna's Loan Headquarters 220.000 7 49304139 Shanna's Loan Headquarters 330.000 7.99% 9 53651842 Shanna's Loan Headquarters 370,000 3165573753 Shant's Loan Headquarters 240,000 4.02% 13 95991315 Shann's Loan Headquarters 150,000 15 R80RTAS Shanna's nan Hadsuits 210,000 17 71157613 Shanna'sinin I lenduartres 18 41 8020 Shanna'sinin Henduartres 1977337579 Shanna's Con Headquarters 66901329 Shanna's Logn Heidauarters 2114201516 Shanna's Loan Headquarters 22 33480177 Shanna's Loan Headquarters 740,oon 200.000 310.000 300.000 200.000 340.000 4.06 25 50237533 Shanna's Loan Headquarters 320,000 52337527 Shara's Loan Handeur TS350.000 Loan Huadever LS 170,000 slaan Huadeurlar 380,000 67342178 Shann's Loan Headquarters 350,000 3.56% BBBBBBBERS 28 5.49% 10 51105403 Shanna's Loan Headsuarters 210,000 S1C64197 Shanna'sinan lead unters 100,00 12 91120062 Shanna's Inanlandsuarters 250,00 1121929 mesin Instruction 1 2 Q3 Smart destination and press ENTER or choo Pasta 06 Bone Master Data + PM Excel Test Search She Ruta. A ss. Home Insert Draw Page Layout Formulas J E -0- PetTable Runnended Table Plures Shapes kons Data Review View 0-9. 30 SmartArt Soreenshot Der Add-ins D ?. . F E A 4-1 - My Add-ins - Bing People Remended Mops PestChart Sparkes Soar Timeline Link New Tee Header & Wardent Object Equation Symbol M6 x fc 1. Crust the the man went for each an in the portinin Lou Loun Numbe Seller Name La Amentar 1140117 Shanna'sinan Headquarters 2 4120954 Shanna's Innenduarters 370.000 3 25055BGO Shanna's Loan Headquarters 210.000 4 61173047 Shanna's Inn Headsuarters 120.000 51398733 Shanna's Loan Headavarters 350.000 6 76906141 Shanna's Loan Headquarters 220.000 7 49304139 Shanna's Loan Headquarters 330.000 7.99% 9 53651842 Shanna's Loan Headquarters 370,000 3165573753 Shant's Loan Headquarters 240,000 4.02% 13 95991315 Shann's Loan Headquarters 150,000 15 R80RTAS Shanna's nan Hadsuits 210,000 17 71157613 Shanna'sinin I lenduartres 18 41 8020 Shanna'sinin Henduartres 1977337579 Shanna's Con Headquarters 66901329 Shanna's Logn Heidauarters 2114201516 Shanna's Loan Headquarters 22 33480177 Shanna's Loan Headquarters 740,oon 200.000 310.000 300.000 200.000 340.000 4.06 25 50237533 Shanna's Loan Headquarters 320,000 52337527 Shara's Loan Handeur TS350.000 Loan Huadever LS 170,000 slaan Huadeurlar 380,000 67342178 Shann's Loan Headquarters 350,000 3.56% BBBBBBBERS 28 5.49% 10 51105403 Shanna's Loan Headsuarters 210,000 S1C64197 Shanna'sinan lead unters 100,00 12 91120062 Shanna's Inanlandsuarters 250,00 1121929 mesin Instruction 1 2 Q3 Smart destination and press ENTER or choo Pasta 06 Bone Master Data +
