Excel Competency Class

Rmaher
ExcelCaseStudy.xlsx
Home>Business & Finance homework help>Accounting homework help>Excel Competency Class

Product and Store Information

Z Ltd- Product and Store Information
Product Information Store Information
Product ID Product Name Product Cost Store ID City
1 Sofa 1500 101 New York City
2 Bed 1000 102 Philadelphia
3 Study Table 150 103 Boston
4 Recliner 450 104 Chicago
5 Chair 50 105 Los Angeles
6 Dining set 950 106 San Fransisco
7 TV Stand 200 107 Dallas
8 Dresser 250 108 Seattle
9 Book Case 80 109 Miami
10 Storage Cabinet 275 110 Salt Lake City

Perform a V-look up to get the City and Product Cost values. Calculate the Sales Amount(Product Cost * Quantity) Use the Month Function to get the month number The company offers a discount to all purchases made during the months of January and December(see cells A2:B4 in "Sales" worksheet) After populating the month number in column" I", use an If function to calculate the discount based on the purchase month(All purchases except the ones made in January and December have a 0% discount) Calculate the Sales Amount after discount(Sales Amount-Discount) Create a Pivot Table in a new worksheet to show the Sales Amount before and after discount by City and Product ID.

This worksheet provides product and store information for different home furniture pieces. This sheet contains two tables. The first table, Product Information, takes a look at each products ID, respective name, and cost. The second table, Store Information, looks at the stores ID and the city it's located in. Below, see instructions that you will need to complete for the following sheets.

Sales

Sales Data
Month Discount%
1 5%
12 10%
Date Customer Name Product ID Product Cost Store ID City Quantity Sales Amount Month Discount Sales Amount after discount
9/26/20 Clayton Friatt 9 110 3
7/28/20 Winny Pilpovic 3 109 1
5/16/20 Durante Belchambers 9 109 1
6/14/20 Constantin Raybould 3 109 1
7/13/20 Hedvige Godbert 10 104 1
10/13/20 Jackquelin Udy 6 104 1
2/8/20 Ric Steinor 3 109 1
2/11/20 Benedikt Kitlee 7 107 3
11/20/20 Anestassia Baudain 9 109 3
11/13/20 Elyn Standon 10 104 2
9/14/20 Amara Fulbrook 9 106 3
9/2/20 Rees Haddington 8 109 3
2/27/20 Travus Huntar 1 105 3
1/29/20 Chicky Cromack 8 104 3
1/17/20 Lisetta Bruhnicke 6 103 1
2/11/20 Andee Bennington 1 108 1
2/17/20 Mead Aspin 1 103 2
10/8/20 Glendon Danet 3 103 2
2/24/20 Artair Novotna 6 103 3
8/25/20 Horatia Butler 1 105 3
3/2/20 Brigg Ifill 1 110 2
10/27/20 Oliy Blackhurst 7 101 3
7/9/20 Victoria Dudden 8 109 1
12/15/20 Roxine Leither 2 104 3
1/18/20 Joaquin Gillatt 10 104 2
9/19/20 Alec Lillicrop 2 104 3
11/12/20 Glennis Padden 9 101 1
12/24/20 Olvan Janssen 5 105 1
12/17/20 Abagael Dymick 4 104 1
12/7/20 Malchy Winckworth 4 109 1
4/9/20 Berke Deehan 6 102 1
10/28/20 Kingsley Ower 5 110 2
4/2/20 Frayda Manchett 1 101 1
11/19/20 Madalyn Glaysher 1 104 2
8/12/20 Retha Jimmes 7 101 2
1/24/20 Petr Creaney 4 104 1
6/21/20 Esta Hyland 10 102 1
6/1/20 Wilbur Demkowicz 8 105 1
5/10/20 Tucker Gotts 4 103 2
4/1/20 Mildred Arnaldo 8 110 1
1/18/20 Leicester Jacobovitz 1 109 3
2/15/20 Bruis Fobidge 4 106 1
3/14/20 Salim Baumaier 7 106 3
2/26/20 Niall Trevear 9 104 1
6/24/20 Jephthah Brugmann 5 102 2
6/17/20 Toni Campany 10 110 1
7/5/20 Gram Pallister 9 106 2
4/18/20 Clare Brockman 3 102 3
5/13/20 Kissie Hardes 2 108 2
8/21/20 Yehudit Saing 3 107 1
1/12/20 Beatriz Melior 4 107 3
8/2/20 Rosie Litchfield 6 101 2
7/20/20 Annamaria MacElroy 6 109 1
5/27/20 Genevra Bruneau 2 110 3
7/21/20 Faina Warrell 3 106 1
6/13/20 Mathew Caudelier 8 102 2
10/19/20 Arlina Harle 2 110 1
3/13/20 Casi Velasquez 2 110 3
7/3/20 Quentin Batcheldor 2 105 2
11/21/20 Thoma Ison 2 106 2
8/25/20 Helga Cawcutt 7 110 2
7/24/20 Abdel Hause 1 110 3
1/31/20 Dennis Lovatt 8 104 2
12/13/20 Elysia Ladlow 10 107 2
5/13/20 Consuela Mattocks 10 102 1
5/12/20 Shelby Avon 10 102 2
5/13/20 Isa Thirst 9 104 3
12/22/20 Anatole Roscamps 5 101 2
7/8/20 Ernie Cud 4 110 2
4/25/20 Salli MacCallum 7 110 1
6/29/20 Richy Valentine 1 101 2
8/22/20 Dale Domleo 2 105 3
6/17/20 Franky Beaver 2 106 3
10/15/20 Missie Pach 2 109 3
10/19/20 Frank Shortt 1 106 2
8/5/20 Waring Hentzer 2 105 1
9/28/20 Annecorinne Vannikov 1 110 2
5/20/20 Linell Ginglell 2 108 3
11/5/20 Whittaker Pyner 4 101 3
7/4/20 Emera Kempstone 2 102 3
5/11/20 Joycelin Proske 4 106 1
10/20/20 Harmonie Akenhead 6 102 1
11/17/20 Doria Giffaut 2 109 1
1/27/20 Oberon McCallum 4 106 3
8/16/20 Channa McCullagh 5 105 2
9/2/20 Wendie Taillant 8 110 2
5/22/20 Pattie Redfern 1 106 3
8/6/20 Dorice Spaughton 2 110 3
1/8/20 Neron Raye 7 104 3
11/28/20 Kennith Hellikes 5 103 2
11/30/20 Wald Impleton 7 101 1
7/19/20 Robenia Tull 4 109 1
3/25/20 Karleen Battyll 10 105 3
2/25/20 Kristy Kale 2 110 2
3/13/20 Helsa Curcher 5 103 2
12/7/20 Maurice Alexsandrev 1 101 2
4/14/20 Sherman Heinish 4 105 3
5/18/20 Melvin Edsall 2 102 1
9/4/20 Sherwynd Paskerful 6 102 2
7/6/20 Diannne Keyser 3 106 1
2/13/20 Amalita Avrahamov 3 105 1
11/9/20 Humphrey Lerigo 5 103 2
5/23/20 Guglielma Caulier 10 101 1
6/13/20 Dorine Pitrollo 6 104 1
6/23/20 Umeko Ilyushkin 4 108 3
11/24/20 Marena Duthie 1 106 2
6/10/20 Connor Heninghem 8 107 2
7/11/20 Reuben Guislin 2 104 2
7/24/20 Kaitlynn MacConneely 4 107 3
7/7/20 Jojo Lawry 6 102 1
5/17/20 Silva Zottoli 10 107 2
9/30/20 Cathe Kilgallen 8 107 2
1/17/20 Forest Pidler 8 103 2
8/19/20 Jennifer LaBastida 8 101 1
8/8/20 Nicolais Geeraert 4 102 2
6/11/20 Jack Kneebone 1 107 2
11/7/20 Elmore Leteurtre 3 105 3
2/29/20 Frederik Sangwin 4 108 2
7/31/20 Arlen Cleaton 6 105 3
9/29/20 Kitti McCarrison 6 104 1
7/18/20 Gwynne Dytham 5 106 2
1/1/20 Hildegaard Burden 6 103 1
10/29/20 Nobie Tighe 3 110 1
12/3/20 Jojo Freschini 6 108 3
1/31/20 Adda Chown 8 107 3
4/11/20 Paulina Playfoot 6 110 1
11/23/20 Morganica Cuncliffe 7 108 1
6/20/20 Cozmo Ashby 9 102 2
9/17/20 Elianore Statton 8 109 3
8/3/20 Fritz Medlen 2 104 1
2/22/20 Aldridge Parks 5 105 2
12/5/20 Pyotr McKague 7 104 3
5/26/20 Hilary Penticoot 1 104 2
3/4/20 Wolfgang Markson 8 102 3
8/9/20 Ewart Yann 1 101 1
4/15/20 Lorena Antognozzii 3 103 1
4/16/20 Lou Loweth 5 102 1
4/15/20 Corry Broxap 5 108 2
6/5/20 Hadleigh Harlowe 1 107 1
10/31/20 Rona Castagneto 9 102 1
7/11/20 Lurlene Averies 1 105 1
4/9/20 Emili Hingeley 1 101 3
7/21/20 Harriett Gerckens 7 106 3
2/6/20 Che Alexis 7 106 3
5/6/20 Gilli Sambell 3 102 1
11/9/20 Elden Cohane 10 101 3
6/5/20 Onofredo Tennick 9 105 1
12/28/20 Hortense Mulchrone 2 101 1
3/13/20 Ag Antowski 3 107 3
1/9/20 Lilas Tiernan 8 104 3
9/28/20 Neville Chater 5 107 1
12/3/20 Ashlan Grundell 2 103 2
7/26/20 Garrick MacLleese 3 107 1
1/14/20 Elyn Senussi 2 104 1
7/6/20 Renato Vitall 5 104 3
10/15/20 Joyce Mathely 10 101 2
4/25/20 Adrienne Allchorne 10 106 3
8/14/20 Ellissa Morstatt 5 102 3
4/26/20 Ashely Pedrollo 6 109 1
10/23/20 Pyotr Catling 3 102 2
3/5/20 Noreen Dibble 1 104 2
4/11/20 Rosabel Lunbech 3 108 3
5/13/20 Alejoa Gatcliff 10 101 1
1/2/20 Trueman Davoren 4 105 2
8/5/20 Tabor Livsey 6 101 2
11/6/20 Angelia Linggood 3 108 3
2/4/20 Palm Bilby 5 110 2
9/3/20 Isidro Hamflett 9 106 1
5/2/20 Hurlee Formby 2 110 2
8/18/20 Meaghan Rymour 7 107 2
9/16/20 Tessy Hawtin 7 109 2
4/6/20 Ken Woffenden 5 107 2
3/11/20 Rayner Betz 2 107 2
1/13/20 Kari Turfs 5 109 2
9/11/20 Walton Asplin 3 102 2
6/3/20 Abigael Franzini 7 102 3
2/12/20 Elsworth Noseworthy 7 103 3
3/10/20 Leoline Keers 1 106 1
2/21/20 Dayna Trytsman 9 101 1
12/18/20 Nicky Tipperton 1 104 2
6/19/20 Trix Piddocke 10 107 2
11/10/20 Culley Hugo 2 106 1
6/21/20 Nicolle Cocher 1 105 1
3/7/20 Ricca Kentish 5 103 1
1/9/20 Maxie Baumaier 8 107 2
5/8/20 Nikolia Wheowall 5 102 3
7/27/20 Sapphira Truin 6 106 3
9/16/20 Philippine Robertot 2 105 2
11/6/20 Kathi Menault 7 107 2
6/28/20 Gilberte Asquez 6 101 3
6/5/20 Lib Rawcliff 4 107 2
11/23/20 Bendick Guiot 10 103 2
6/28/20 Mariya Gladtbach 3 109 2
11/11/20 Elvin Bartrap 1 106 1
10/14/20 Brew Mordue 7 110 1
2/27/20 Brinna Polhill 8 108 2
11/15/20 Roarke Trudgeon 1 104 3
1/11/20 Bertram Gorgl 9 108 1
2/4/20 Montague Geelan 5 105 3
12/10/20 Panchito Scyone 9 110 1
11/2/20 Stepha Parkhouse 3 109 3
6/2/20 Julie Bustard 4 105 2
6/6/20 Delores Foulcher 4 103 1
4/28/20 Hasheem Raithbie 6 102 3
9/26/20 Josefina Hellin 9 107 3
3/22/20 Mei Porritt 1 107 1
12/4/20 Rory Arnhold 4 103 3
8/20/20 Merrile Beldham 9 107 2
1/18/20 Christos Morden 3 102 3
7/17/20 Libbi Tinniswood 8 105 1
1/4/20 Carolee Thieme 8 108 1
8/20/20 Filberte Warner 1 103 2
6/9/20 Jeramie Thams 3 108 3
10/7/20 Collete Barukh 6 108 2
10/8/20 Gabriele Povele 2 104 3
3/29/20 Katharine Toope 5 104 3
3/6/20 Chalmers Harefoot 7 107 2
11/21/20 Kingsley Scullion 8 104 2
5/24/20 Barbaraanne Kirkness 1 104 2
1/15/20 Vere Buie 5 102 3
11/6/20 Sandro O'Keevan 1 101 3
12/1/20 Kelsey O'Clery 10 101 2
8/14/20 Toby Roark 2 103 1
7/13/20 Davin Greguol 3 106 1
10/24/20 Chicky Dome 7 102 2
2/7/20 Guy Pomery 9 108 1
9/24/20 Grove Hantusch 3 106 2
8/8/20 Devland Juarez 8 108 1
12/2/20 Junina Lunn 4 107 2
2/26/20 Astra Lorentzen 4 102 2
10/16/20 Bill Bellwood 1 108 2
8/26/20 Jase Suttill 4 109 2
4/19/20 Harmonie Allday 8 109 2
3/9/20 Giff Frisdick 10 109 1
4/19/20 Alfy Weerdenburg 8 109 1
4/24/20 Darius Challicombe 7 105 1
3/1/20 Powell Layton 1 108 1
1/25/20 Rudolph Zarfati 7 106 2
8/17/20 Gerda Gristock 8 108 3
6/8/20 Adham Oke 4 107 3
12/12/20 Kettie Abrams 10 102 2
1/5/20 Son Lord 3 107 3
1/27/20 Charin Davenall 1 104 3
3/7/20 Ardelis Bossom 10 104 3
11/22/20 Evvie Dumingo 2 107 2
7/14/20 Holden Busk 5 106 2
10/14/20 Maurene Dixcey 3 103 1
10/5/20 Shae Defew 7 107 3
8/28/20 Hermann Corbridge 10 104 2
3/17/20 Dorothee Dumpleton 4 102 2
8/19/20 Florian Bricham 10 105 3
6/25/20 Lynea Stoodley 4 108 1
5/12/20 Tanya Le Noury 4 101 1
5/8/20 Trude Bessey 4 101 3
12/5/20 Sonnie Henkens 5 107 3
10/3/20 Fredrick Hargie 7 108 1
10/26/20 Quincy Wickerson 1 103 3
12/12/20 Meade Buttwell 1 108 1
6/19/20 Lynne Findlow 10 104 1
3/24/20 Inglebert Videan 6 103 1
7/17/20 Alleyn Caile 7 101 1
8/21/20 Arel Greenslade 5 107 1
7/11/20 Jenine Aspinwall 8 101 2
2/4/20 Belvia Lightollers 2 104 2
2/25/20 Sutherland Finn 10 105 3
10/5/20 Candie Wyldish 7 108 2
7/1/20 Conrade Pourvoieur 10 106 3
7/4/20 Mordecai Klus 2 107 2
12/28/20 Gerome Vasyutkin 3 108 2
2/6/20 Minnaminnie Kimmings 1 101 3
3/13/20 Kakalina Grisenthwaite 1 105 2
4/28/20 Deidre Innot 9 108 3
6/1/20 Caryn Dumbellow 9 107 2
2/10/20 Riane Groven 6 110 3
3/13/20 Bessy Gyford 9 105 3
2/27/20 Nelson Batrip 5 108 1
2/13/20 Mireielle Ounsworth 7 104 2
10/31/20 Pepe Lusher 4 108 2
7/9/20 Buiron Abrahami 2 104 1
3/1/20 Hatti Izkovitz 6 109 3
12/30/20 Farrand Iacavone 4 108 2
6/16/20 Jolene Beaten 8 110 2
2/13/20 Allie Calltone 6 103 3
3/18/20 Byrom Andryszczak 5 108 2
5/13/20 Lindsy Gittus 3 108 3
6/23/20 Hattie Elwood 6 109 1
12/21/20 Chiquia Birtwhistle 2 103 1
4/19/20 Grant Colquitt 8 102 3
2/1/20 Maximo Tippetts 8 103 1
3/1/20 James Ashburner 10 104 3
2/18/20 Morey Fellgett 5 107 3
7/3/20 Kelsey De Domenico 9 102 1
9/21/20 Margery Robard 7 107 3
3/2/20 Leoline Airth 2 110 1
1/16/20 Fawnia Northcliffe 10 101 3
4/3/20 Beverly Blackborough 3 103 2
9/29/20 Karil Proschke 1 103 1
4/22/20 Barton Torel 2 101 2
3/19/20 Pauletta Book 5 109 3
7/29/20 Margaux Ainley 9 103 1
7/9/20 Perceval Bernini 9 102 1
12/23/20 Fitzgerald Veschambes 3 103 3
2/26/20 Herrick Shade 8 108 2
8/17/20 Byran Troctor 10 110 1
9/1/20 Oralee Byne 2 109 3
12/23/20 Kile MacDermott 4 104 3
9/2/20 Benoite Gilliatt 4 105 1
5/25/20 Page Teresia 9 104 3
11/25/20 Alwin Lytton 8 107 3
4/17/20 Vite Ksandra 4 104 2
5/10/20 Freddy Fadden 4 108 3
3/22/20 Markus McMychem 8 105 3
3/15/20 Baxter MacEnelly 2 110 2
9/23/20 Brook Ridings 6 101 2
4/9/20 Tybalt McMoyer 7 103 3
6/8/20 Ado Twoohy 10 103 3
9/1/20 Delmore McGee 5 105 2
10/8/20 Marilee Bolt 2 108 3
6/28/20 Yoko Conechie 7 106 3
3/15/20 Vivie Cannavan 6 101 3
2/1/20 Hasty Egginson 7 103 3
11/5/20 Bunnie Patient 7 108 2
7/14/20 Hersch Oliveras 1 108 3
11/13/20 Gisele Darrigrand 2 109 1
9/25/20 Mordecai Meddick 3 104 1
7/26/20 Gigi Tomasini 5 107 3
3/22/20 Kinnie Yallowley 4 106 1
3/28/20 Brendis Alans 8 110 1
8/12/20 Em Beevis 3 110 2
1/24/20 Borg Tincey 7 110 2
12/29/20 Prisca Mynard 1 108 1
1/7/20 Andeee Athey 5 108 2
3/15/20 Read Beartup 8 105 3
8/23/20 Kayne Guyan 3 103 2
9/23/20 Derry Yeeles 5 106 3
2/23/20 Thurstan Daice 9 102 1
6/5/20 Clementina Peeke 2 110 3
4/25/20 Erminie Gatling 1 104 2
1/6/20 Cos Joe 5 101 1
8/6/20 Aurilia Bedow 6 104 2
5/8/20 Domenic Buntain 5 101 1
4/28/20 Marley Portwain 10 103 2
1/4/20 Panchito Fiddiman 2 109 2
8/21/20 Dalila Oxbrough 9 109 1
4/23/20 Kettie De la Perrelle 10 107 2
11/30/20 Godfry Whylie 3 106 3
9/9/20 Robin Feldklein 3 110 1
10/27/20 Lee Margaritelli 6 110 1
2/16/20 Camala Dallicoat 10 101 1
4/28/20 Dolly Hayller 7 106 1
8/4/20 Adelaide Bullan 1 106 3
5/8/20 Consuelo Burnsall 10 106 1
6/4/20 Muhammad Simmonds 4 109 2
8/2/20 Sarena Lewcock 10 104 2
7/6/20 Edgar Rove 4 101 3
6/24/20 Elvyn McCaughey 2 109 2
4/30/20 Marlo Bye 7 103 1
12/12/20 Rory Ong 2 107 2
2/19/20 Miquela Carwithim 6 105 1
2/25/20 Kelci Scintsbury 8 104 3
5/15/20 Estele Burchill 5 105 2
6/15/20 Esta Charpin 10 102 3
4/14/20 Corrine Baccup 6 102 2
5/21/20 Rowney McEntee 9 105 3
3/3/20 Halsy Jirek 7 109 3
12/18/20 Griffin Dymond 4 109 3
6/29/20 Merv Tomblett 10 108 1
2/11/20 Dieter Rothwell 1 105 3
10/16/20 Christiano Soper 7 104 1
10/15/20 Reilly Priestland 9 108 3
5/22/20 Catlee Currell 8 110 2
8/14/20 Mirabel Yarrington 2 106 2
9/12/20 Donovan Hek 2 101 3
7/12/20 Adi Maiklem 2 106 2
5/1/20 Karlens Sattin 2 104 2
4/29/20 Deirdre McKomb 1 108 2
7/9/20 Paulo Hartford 5 105 2
4/12/20 Guy Lytlle 4 108 1
6/16/20 Ellene Sebrook 10 108 1
5/2/20 Orv Wixey 2 109 2
2/25/20 Tierney Cramp 3 105 2
12/11/20 Lettie Paulich 3 108 3
9/3/20 Tabbie Rendle 6 101 1
12/16/20 Sharyl Herculson 9 104 3
5/18/20 Nanny Ronchka 8 104 3
7/3/20 Bill Barrows 1 102 3
12/13/20 Aimee Fillis 8 108 2
7/28/20 Travis Adaway 1 110 1
4/2/20 Gale Walden 2 102 1
3/5/20 Nada Cardiff 2 106 3
12/2/20 Sasha Peegrem 9 107 2
1/5/20 Rouvin Gilpillan 7 103 2
1/6/20 Willie Stoodley 2 106 2
10/4/20 Tamqrah Cluelow 3 103 1
10/11/20 Kelila Maccrea 2 103 2
5/31/20 Shep Dorie 9 103 2
9/21/20 Auberon Fussey 3 106 3
6/30/20 Stephen Liddicoat 8 101 2
8/14/20 Gianni Caherny 3 103 1
1/14/20 Coraline Steckings 10 108 3
10/21/20 Keeley McKevitt 8 102 3
8/10/20 Marcello Kohnen 5 109 1
6/2/20 Gabie Scott 9 104 3
12/29/20 Kassie Skaif 10 107 1
7/1/20 Inessa Kalewe 3 106 1
9/8/20 Crichton Tuhy 9 109 3
3/31/20 Jillana Gosdin 10 108 3
7/16/20 Orella Munks 2 103 1
12/18/20 Dorelia Pevie 7 105 3
10/19/20 Hamel Bettenay 7 104 3
12/21/20 Aline Ciobotaro 1 104 3
11/29/20 Laird Lidgate 4 108 3
7/24/20 Keen Espino 6 101 3
4/20/20 Dru Roseveare 2 105 3
7/15/20 Torr Whitwam 6 107 2
3/22/20 Duke Dimitru 8 107 2
10/17/20 Prisca Moyes 4 102 1
11/25/20 Rollin Vearncombe 6 107 1
6/5/20 Malina Almond 10 109 2
5/13/20 Zachary Garrard 9 102 2
8/16/20 Dorena Beaby 4 110 3
8/21/20 Minetta McGettigan 1 102 3
4/8/20 Cornall McGilroy 2 107 1
5/29/20 Lindy De Vaar 7 102 3
9/27/20 Dionisio Bouttell 4 106 2
5/20/20 Gifford Bordman 6 106 3
5/29/20 Sella Gudge 3 104 2
10/20/20 Rene Gourlie 6 107 1
5/10/20 Kimmie Pescud 7 110 3
10/27/20 Humberto Stappard 3 108 2
11/28/20 Wylie Legonidec 5 101 2
2/12/20 Sherie Smalecombe 2 106 2
2/11/20 Antoinette Sagerson 5 109 2
7/28/20 Susy Exelby 10 104 2
11/23/20 Hill Ramsay 4 104 3
9/28/20 Cleo Braunroth 10 107 2
7/25/20 Jdavie Horrigan 6 108 1
2/7/20 Neale Beckles 7 105 2
4/7/20 Oralee Lyon 10 101 1
3/17/20 Xerxes Yuill 7 106 2
6/19/20 Rudiger Yeend 8 107 1
1/14/20 Yolanthe Aldus 9 107 3
9/17/20 Ginelle Saur 2 108 1
11/29/20 Alys Benoist 1 109 1
10/22/20 Baxy Orriss 1 101 3
5/17/20 Louise Tippett 2 108 1
7/13/20 Janie Bakey 9 104 2
6/26/20 Keene Luton 3 107 1
12/24/20 Quintus Knobell 2 102 1
9/23/20 Patrick Lande 7 103 2
11/15/20 Josiah Crankshaw 5 107 2
7/31/20 Morissa McConnell 9 103 1
7/26/20 Ardra Gately 3 105 2
1/16/20 Karia Godden 8 109 2
1/26/20 Carlota Kinny 3 103 2
1/2/20 Harriett Garrity 8 106 3
10/12/20 Eric Ricoald 4 101 1
2/29/20 Barbra Ricciardo 4 110 2
7/23/20 Anstice Kiledal 2 107 2
10/4/20 Mag Ralls 9 102 1
2/19/20 Ashby Cowpland 4 104 3
10/27/20 Gwenette Perrone 3 102 3
1/23/20 Otis Soares 8 110 3
12/3/20 Sherlock Powys 8 101 1
12/18/20 Cheri Deeprose 5 101 1
3/31/20 Robinia Yeoman 8 107 3
4/5/20 Leena Torbett 10 110 2
7/26/20 Charlene Barff 7 103 3
9/3/20 Morgen Bouldon 5 110 2
10/6/20 Lacie Alsobrook 8 105 1
7/22/20 Candi Taillard 2 109 2
5/17/20 Ambur Stolze 5 104 3
9/9/20 Kiley Suthren 1 108 1
1/6/20 Pru Peebles 7 110 2
11/3/20 Kym Cantrill 6 108 2
12/13/20 Elena Land 8 109 1
2/15/20 Juline Philippson 5 103 1
11/28/20 Corly Danihelka 9 102 2
7/24/20 Ham Emeney 9 105 2
3/28/20 Madelin Stammler 2 106 3
4/9/20 Dania Arthars 6 103 3
10/7/20 Jamey Brindle 4 102 1
10/21/20 Jewell Schooling 4 103 3
8/15/20 Dayna Helliwell 1 103 3
2/11/20 Deloria Anthoney 1 102 3
6/6/20 Tremain Nassie 6 107 3
12/6/20 Adriane Barracks 6 108 2
9/24/20 Sherrie Jamot 1 102 3
11/24/20 Daren Paiton 7 107 2
12/1/20 Karole Arboin 8 107 2
6/16/20 Loutitia Dicte 10 109 2
1/20/20 Richardo Polly 6 107 3
10/6/20 Lillian Lurcock 4 107 2
3/29/20 Brynn Adame 9 105 2
3/14/20 Afton Boulsher 9 106 2
4/24/20 Bernie Seage 4 107 1
6/22/20 Berti Whorf 4 107 1
12/16/20 Rahal Angrock 4 108 1
8/31/20 Nolan McMinn 2 101 1
4/15/20 Waylen Lindenblatt 7 109 1
5/6/20 Fitzgerald Kondrat 1 102 2
7/13/20 Magdalen Kairns 10 103 2
8/22/20 Claresta Castelot 3 104 3
5/21/20 Lindie Horbath 9 106 3
5/3/20 Gaylene Yurkiewicz 4 102 1
4/29/20 Debbie Puddifer 4 101 2
2/3/20 Bank Farlamb 9 102 2
9/2/20 Roxane Cote 4 101 1
9/5/20 Marie Gagin 9 102 2
5/7/20 Nigel Erskine 5 104 2
7/22/20 Kamillah Macer 9 101 3
1/6/20 Delphinia Dawltrey 2 108 1
8/17/20 Merle Dimitrov 8 102 2
11/9/20 Sam Benson 2 105 2
10/15/20 Jeri Jachimak 2 107 1
6/4/20 Bethany Scobie 2 105 1
7/1/20 Talyah Leadbeatter 1 106 2
2/9/20 Redd Leather 5 104 2
11/11/20 Carlina Gummary 1 105 1
9/7/20 Jammal Brogioni 10 104 2
5/17/20 Emmeline Dawid 6 104 1
1/17/20 Nathan Yates 6 108 2
3/27/20 Lonni Stooke 3 107 2
2/18/20 Alphonso Meiningen 6 104 3
11/28/20 Audry Boddice 7 105 1
4/14/20 Ronny Grisard 3 101 1
6/8/20 Alvis Dickings 5 109 2
6/11/20 Phylys Crate 2 104 2
11/26/20 Hermia Byk 1 101 3
11/2/20 Dorree Brunt 10 104 2
8/1/20 Darell Duckering 1 103 2
11/15/20 Olia Habens 1 109 1
10/24/20 Lanny Burril 4 110 1
4/5/20 Jojo Vahl 9 110 3
8/6/20 Jeanie Tabard 5 106 2
11/19/20 Deny Faraday 2 103 3
2/27/20 Otha Feasley 5 110 1
10/10/20 Joli Blaske 6 103 2
2/1/20 Curtice Lewson 10 105 3
11/12/20 Temple Arkil 7 104 2
6/17/20 Obidiah Schurig 3 104 1
1/5/20 Ray Bloxsom 1 104 2
8/16/20 Olivero Vaissiere 8 104 2
9/8/20 Foster Tratton 7 103 2
1/19/20 Maximilien Thursby 8 107 2
6/21/20 Maximo Creech 5 108 2
12/27/20 Laraine Orman 9 103 3
8/30/20 Darin Florio 1 105 1
2/18/20 Bess Jahnel 10 110 3
4/4/20 Natalie Ferrelli 7 105 2
3/18/20 Eleanore Witz 5 102 3
12/16/20 Merna Loghan 9 104 1
5/12/20 Eba Pilmoor 2 109 2
8/18/20 Griffy Nolli 2 101 3
12/21/20 Marty Scartifield 7 107 2
9/3/20 Billie Krook 3 108 3
7/14/20 Eada Gatecliff 1 105 2
9/15/20 Devland Riquet 7 105 3
3/19/20 Tybie Ding 10 102 3
10/25/20 Persis Menichini 3 101 3
11/3/20 Clywd Tunny 8 108 3
10/15/20 Arne Yarnall 5 109 2
5/22/20 Romain Malling 1 105 1
4/3/20 Sarina Chaikovski 6 107 1
10/1/20 Gilberto Shadfourth 7 104 2
5/27/20 Johnathan Aspinal 10 108 3
12/15/20 Babb Stemp 1 105 2
10/2/20 Mord Lawford 8 102 3
6/2/20 Lela Newham 1 108 3
1/6/20 Drake Hue 7 103 2
9/26/20 Gabriella Thonger 7 108 3
8/29/20 Kerry Hince 2 108 1
12/3/20 Marven Pacquet 2 105 2
6/23/20 Brien Worgan 8 104 1
12/16/20 Arly Popple 5 108 1
10/23/20 Rosco Pietroni 10 101 3
10/1/20 Rod Garthshore 8 104 1
1/23/20 Frannie Advani 9 105 1
8/21/20 Giacinta Peatheyjohns 3 107 1
7/26/20 Alta MacGaughy 7 102 3
2/12/20 Wylie Whisson 10 101 1
8/8/20 Teodorico Extal 1 102 1
10/24/20 Konstanze Silverston 6 106 1
9/24/20 Trish Suett 3 101 3
11/15/20 Gwynne Comusso 10 104 3
5/21/20 Mirna Ruegg 9 104 1
3/2/20 Morse Tremeer 4 103 3
1/11/20 Dion McParland 7 109 3
2/9/20 Barrie Hewell 4 106 3
2/27/20 Jeanne Collen 4 109 1
10/1/20 Odille Marlon 3 103 3
4/5/20 Cecilius Tew 9 105 1
3/20/20 Jarrid Seid 10 101 2
8/4/20 Emera Fawkes 2 102 1
10/10/20 Brear Boodle 7 108 1
5/18/20 Murray Gater 2 105 1
11/19/20 Miguel Girod 2 107 1
5/3/20 Denver Crolly 7 102 1
6/17/20 Aleda Linning 9 108 1
3/4/20 Brennan Pagon 5 104 3
4/10/20 Korella Robinette 10 105 3
6/14/20 Elbertina Rosenbusch 10 106 2
4/4/20 Lorens Rignoldes 1 101 2
1/2/20 Pietra Gluyus 2 104 3
6/13/20 Dickie Hudd 3 102 3
5/24/20 Sheeree Bruyns 10 103 3
4/15/20 Pebrook Curtis 10 107 1
5/31/20 Shurwood Murton 10 104 2
12/3/20 Franklyn Ouchterlony 10 106 3
4/18/20 Rodolfo Fincher 7 104 2
10/22/20 Jim Necolds 8 105 3
7/17/20 Dulcinea Noblet 4 106 2
1/28/20 Winnie Benley 6 109 1
10/8/20 Guenevere Loalday 2 110 2
10/4/20 Christophe Howman 1 108 1
10/29/20 Adria Straine 3 109 1
6/19/20 Diego Drought 3 104 2
8/14/20 Mackenzie Egarr 5 101 2
11/20/20 Dennet Nulty 10 104 1
11/24/20 Lenee Mellon 7 102 2
10/24/20 Gabriell Bedrosian 4 106 2
8/26/20 Laurie Karby 1 105 1
10/2/20 Mildrid Pehrsson 4 104 2
8/25/20 Heidie Sabbin 4 101 3
8/21/20 Shandy Tobias 2 110 2
5/19/20 Lion Loynes 2 104 2
10/20/20 Caryl Winwood 2 104 3
12/28/20 Almeda Ellick 6 104 1
10/6/20 Marrissa MacNair 6 103 2
2/16/20 Carmita Fysh 2 102 3
3/20/20 Job Skeeles 4 106 1
2/9/20 Price Coldrick 8 102 2
8/12/20 Chicky Morton 6 101 2
6/26/20 Vin O'Fallon 10 107 1
11/24/20 Nehemiah Farrah 2 104 2
1/20/20 Suzanne Muglestone 4 108 3
2/8/20 Marleen Luckhurst 4 102 1
2/25/20 Ethelind Capstack 9 108 1
5/13/20 Jannelle Duell 7 105 2
6/10/20 Jessalyn Gladdis 10 102 3
9/10/20 Llewellyn Girkins 3 101 3
12/11/20 Madelina Gilligan 3 110 2
2/21/20 Loleta Linton 1 102 2
10/31/20 Minta Stavers 8 106 3
4/16/20 Gib Coley 8 107 3
7/15/20 Dulci Begbie 5 110 1
2/13/20 Shell Samsin 7 105 2
5/29/20 Evin Salzen 2 107 1
4/19/20 Farleigh Gregoretti 1 109 2
3/23/20 Delphine Bouchard 1 103 3
10/1/20 Anderea Nassi 2 109 2
12/20/20 Leia Catling 8 103 3
12/17/20 Jan Roles 1 104 1
10/19/20 Denney Bauman 1 109 2
8/10/20 Antonie Sherrocks 7 105 3
10/20/20 Domini Croizier 7 110 3
9/9/20 Kristyn Rosenstengel 8 110 1
1/22/20 Angelico Indgs 3 109 3
12/1/20 Sam Dumbarton 2 107 3
10/6/20 Kalinda Borthe 9 106 3
7/12/20 Kore Rumke 3 105 3
2/25/20 Gaelan Brane 1 108 2
5/22/20 Fredrika Twinbourne 8 102 2
10/11/20 Lorelle Cabrera 1 102 3
3/21/20 Gerik Palle 3 102 3
8/1/20 Alvan Oda 2 109 1
11/30/20 Anton Dewire 10 107 1
11/7/20 Gleda Pennicard 6 110 1
3/10/20 Rolf Pothecary 5 109 1
7/1/20 Rance Dawidowicz 9 105 2
7/24/20 Sheelah Frane 10 103 3
4/20/20 Richardo Postles 1 110 1
5/7/20 Abagail Curragh 4 105 2
12/12/20 Martin Guislin 2 104 1
3/18/20 Ryon Blagbrough 8 106 1
1/28/20 Clive Redmille 9 101 3
1/13/20 Bea Gerbi 4 106 2
11/1/20 Raff Sudron 10 101 2
2/11/20 Tobit Rowson 3 109 2
10/21/20 Johny Gifford 9 107 3
9/23/20 Annabell Southwood 8 108 3
6/12/20 Elisha Conechie 6 109 3
7/8/20 Joscelin Jelleman 1 104 3
3/19/20 Nelly Abdee 5 104 3
7/13/20 Theodosia Dow 8 110 2
12/7/20 Audra Grebner 6 106 1
11/16/20 Reynard Tym 8 102 3
11/14/20 Goldie Calendar 6 105 1
6/21/20 Bernard Pamphilon 2 108 1
1/1/20 Chandler Venart 4 110 1
6/3/20 Dale Arnaudon 3 104 2
6/11/20 Jeanne Piff 8 104 2
6/7/20 Timothee Schuck 1 106 2
8/29/20 Tierney Gouldthorp 6 108 2
9/21/20 Debee Davana 6 105 1
11/12/20 Jock O'Nowlan 7 102 1
4/3/20 Isiahi Jorry 5 101 3
8/16/20 Tammie Narraway 2 103 1
7/20/20 Celestina McDowell 6 103 3
12/15/20 Kate Juszczak 3 108 2
3/1/20 Osbert Bolduc 5 110 3
5/30/20 Terry Josephsen 2 108 1
5/18/20 Devy McCotter 4 107 3
12/9/20 Rasia Throughton 7 107 2
9/19/20 Myles Bonnette 3 103 1
5/21/20 Ninon Sandever 5 101 1
11/1/20 Juanita Cockin 5 107 1
1/31/20 Lexis Law 6 103 3
11/15/20 Salem Lamberto 2 105 2
11/7/20 Jay Baldry 7 107 2
10/7/20 Rita Rego 1 101 1
6/14/20 Goldie Wingrove 10 107 3
5/19/20 Darrell Di Bernardo 1 103 1
9/3/20 Avictor Mathey 6 107 2
2/14/20 Clarie Mordon 4 101 2
12/24/20 Ludovika Cockshott 2 106 3
8/17/20 Donielle Loffhead 7 108 2
9/3/20 Ondrea Poole 5 101 1
12/6/20 Billie Lawty 1 107 2
9/11/20 Noel Birchenough 4 105 2
8/16/20 Zebulen Dalgarnowch 4 106 2
8/24/20 Zebulen Hathorn 8 108 1
10/5/20 Dela Veltman 10 107 2
5/5/20 Eamon Trazzi 4 110 3
4/14/20 Jabez Merfin 3 108 2
5/28/20 Nollie Grayland 2 107 3
7/16/20 Gerek Simenet 9 107 1
5/21/20 Salim Slott 5 107 1
5/22/20 Ange Plume 1 102 1
1/14/20 Carmelina Grand 1 102 1
12/10/20 Brew Wyld 6 106 1
3/18/20 Arlette Danhel 8 106 2
3/14/20 Patsy Bocock 1 105 1
8/2/20 Eddie Hukins 5 109 3
10/11/20 Lay Wythe 3 104 2
7/31/20 Emile Kellegher 1 105 3
10/21/20 Waverley Metterick 5 109 1
1/6/20 Farrah Grinyov 1 101 2
7/3/20 Shaina Menendez 10 104 3
5/5/20 Charmain Wharton 10 106 2
4/8/20 Gareth Brotherhead 10 103 2
12/14/20 Clem Ghidotti 8 107 1
4/24/20 Lawry McAw 1 104 1
10/5/20 Bryan Matt 3 102 1
3/2/20 Margette McCrillis 6 110 2
10/7/20 Sybilla Mattussevich 4 110 3
5/27/20 Louella Crisall 6 105 2
2/21/20 Kamila Rapo 4 107 1
6/30/20 Jaquelyn Bamell 3 106 1
1/5/20 Lexi Jopp 10 109 2
6/27/20 Bernette Sprason 10 106 1
2/12/20 Janeta Ringe 7 106 2
1/6/20 Katie Bemrose 3 105 1
8/20/20 Hill Sandifer 6 105 1
6/4/20 Thacher March 9 103 1
12/18/20 Edythe Revening 10 108 2
12/17/20 Beauregard Blenkharn 4 103 3
8/19/20 Fina Larratt 2 101 3
3/13/20 Osborne Renol 2 106 1
5/22/20 Didi Gillice 7 104 3
10/4/20 Ingaborg Garrettson 2 107 1
6/18/20 Hali Polhill 1 103 1
5/13/20 Noell Knott 8 101 2
11/4/20 Kimmi Abela 2 105 3
10/27/20 Lacie McElhinney 10 108 3
9/8/20 Larine Schout 7 106 1
9/25/20 Sonni Sember 4 110 2
12/5/20 Doti Gainforth 5 102 3
7/28/20 Margaretha Tassel 10 107 2
11/30/20 Alvinia Bagnold 8 108 3
8/24/20 Pearl Bareford 5 104 1
4/16/20 Corly Kettridge 3 103 1
11/21/20 Ardis Boncore 2 107 1
1/21/20 Kenny Covelle 7 110 1
8/12/20 Rodge Heibel 3 103 3
11/20/20 Breanne Merrison 9 106 2
3/20/20 Chrisy Beckers 1 110 3
11/27/20 Samaria Burchall 1 107 2
1/3/20 Emmanuel Hendrichs 3 109 2
4/8/20 Torey Jory 1 107 1
8/29/20 Benny Meachan 2 102 3
5/21/20 Buck Lyven 3 110 1
11/3/20 Simonne Barnfather 2 109 1
2/18/20 Chrystal Marples 2 107 1
7/9/20 Katinka Danneil 7 108 3
2/23/20 Joellen Absolon 9 101 1
4/21/20 Lisetta Penton 6 109 1
9/14/20 Nicholle McIlwrick 10 105 1
6/22/20 Ronna Shinfield 7 104 2
8/20/20 Jillane Challenger 10 101 3
12/20/20 Denys Roocroft 1 103 3
4/11/20 Helga Cops 5 108 3
12/15/20 Ruben McKinnon 9 105 1
1/16/20 Stace Shanklin 1 102 1
9/6/20 Ferdinande Wasmer 10 110 3
5/12/20 Ellynn Hayers 2 110 1
1/30/20 Feodor Mothersole 1 109 1
7/29/20 Leif Marquess 9 105 3
10/23/20 Mariya Taill 1 101 3
7/13/20 Crissie Loverock 8 106 2
11/6/20 Jo ann McFall 8 104 2
1/4/20 Charmine O'Donovan 9 107 3
6/23/20 Edyth Riccetti 1 101 3
11/16/20 Pearce Navaro 5 103 2
1/16/20 Marlena Stabler 6 103 3
1/3/20 Emmanuel Hendrichs 3 106 1
6/5/20 Seline Deadman 7 106 2
12/25/20 Aeriell Corbin 7 110 1
6/26/20 Margie Bynert 8 106 3
4/27/20 Rebecca Pallatina 1 109 1
5/13/20 Waldo Skarr 9 102 3
5/17/20 Fionna Folkerts 7 102 3
12/25/20 Jori Weddup 3 104 2
11/25/20 Kyle Beeson 8 102 3
5/5/20 Borden Patterson 8 106 3
5/30/20 Mathe O'Howbane 5 106 1
9/22/20 Johnath Scrivin 1 110 1
1/15/20 Tisha Brolan 7 102 3
3/28/20 Bobette Gilpin 5 104 1
10/10/20 Andrew Ruberti 5 105 1
10/5/20 Bryn Mayward 5 104 1
5/2/20 Germain Gorwood 3 104 2
11/25/20 Adlai Beneyto 1 106 1
9/27/20 Florian Pegden 6 104 3
6/18/20 Saraann Neward 10 108 3
6/28/20 Solomon Janczak 3 105 1
4/6/20 Ardys Ondrousek 3 110 2
8/8/20 Zeke Fryer 1 109 1
12/9/20 Bettina Killwick 3 102 3
10/29/20 Emilie Vigus 6 104 3
6/21/20 Cherish Garvan 7 104 2
5/17/20 Rhetta Schwanden 4 110 3
8/3/20 Dexter Sager 5 106 3
9/9/20 Danny Versey 2 107 3
7/5/20 Lelah Attewill 2 109 3
11/8/20 Elfie Espinoy 4 105 2
5/28/20 Arnuad Sooper 7 106 1
11/27/20 Bren Caddell 9 101 2
7/21/20 Rosy Worsell 1 108 3
4/7/20 Sim Slayford 3 109 1
9/12/20 Huntington Bault 1 109 3
2/8/20 Flint Pykerman 4 103 2
4/14/20 Rustin Tunnadine 3 101 1
10/8/20 Rhoda Happel 4 107 2
2/11/20 Malcolm Reeson 3 106 1
7/25/20 Austin Glazer 1 110 1
9/14/20 Cal Franceschi 7 107 2
10/7/20 Tessa Hallawell 3 109 1
10/18/20 Florance Ackenson 3 103 3
11/8/20 Zena Jurkowski 5 107 3
1/8/20 Bridgette Carnalan 7 105 3
3/22/20 Bronny Cardenas 8 107 3
10/22/20 Hermione Gludor 9 108 2
5/28/20 Munmro Stellino 9 102 2
7/2/20 Horatio Normanville 8 105 1
5/16/20 Marven Piele 9 108 3
11/27/20 Thekla Libero 8 108 1
7/3/20 Kris Wallman 2 102 1
1/31/20 Jacki Dungey 1 109 3
10/20/20 Nickey Stoak 9 103 3
9/9/20 Bertie Facer 2 107 3
8/28/20 Babb Gierok 9 110 2
8/10/20 Catrina Duchesne 3 107 1
4/17/20 Pammy Hannen 2 102 1
10/28/20 Isabel Tyzack 4 101 3
12/17/20 Rita Thebeau 5 103 2
1/5/20 Gwendolyn Ninnotti 4 103 1
3/30/20 Ewan Samber 4 108 2
5/26/20 Fanya Chadbourne 9 102 1
6/5/20 Zarla Dizlie 4 108 3
7/19/20 Lynnelle Gellion 6 104 1
1/15/20 Britta Malzard 2 102 1
7/31/20 Lilly Claus 9 106 2
10/30/20 Ephraim Kahler 9 110 2
7/10/20 Rosabella Sukbhans 8 105 3
2/29/20 Guenevere Noen 2 102 3
7/5/20 Hermy Castree 9 107 3
2/28/20 Wolfie Mablestone 3 101 1
4/13/20 Jody Broadfoot 4 101 3
9/7/20 Aharon Oxborough 7 104 2
11/5/20 Gertrudis D'Alesio 8 110 3
5/5/20 Ramona Mac Geaney 8 110 3
2/2/20 Engelbert Gosden 7 109 2
5/26/20 Adela Banville 7 105 1
7/12/20 Nathanil Kemm 8 107 1
8/18/20 Dennis Blincowe 9 102 3
8/7/20 Gran Toope 8 102 2
4/6/20 Hamish De Biaggi 8 109 3
4/10/20 Tulley Astill 8 105 3
10/12/20 Pam Eddy 6 102 3
4/1/20 Lise Mc-Kerley 9 106 1
3/10/20 Gannie Knappen 1 102 2
3/23/20 Bernadine Hentze 7 101 2
7/28/20 Britteny Gercken 10 103 2
11/10/20 Karalee Joanaud 7 106 1
11/11/20 Melessa Vittet 1 106 3
6/4/20 Randy Bartelli 10 102 1
4/15/20 Yolanthe Bouldon 6 108 2
6/12/20 Nariko Joris 9 110 2
2/6/20 Tracie Paszek 3 110 1
1/11/20 Kalie Kenvin 7 108 1
6/24/20 Lissie Ledgard 4 108 2
3/6/20 Jamey Lau 4 110 3
9/30/20 Edlin Willows 10 101 1
3/27/20 Maud Bugbee 8 101 3
1/21/20 Sholom Roycroft 9 103 3
5/11/20 Elaina Mellodey 3 102 3
5/15/20 Deirdre Siberry 7 107 3
4/15/20 Carilyn Bearblock 10 104 3
3/17/20 Katee Shuter 1 108 3
8/7/20 Lucais Sarfat 7 101 1
9/12/20 Dav Thorpe 10 101 2
9/3/20 Keane Brinded 8 105 3
5/1/20 Rena Genese 3 103 1
12/17/20 Elie Harring 5 102 3
12/5/20 Pierette Melding 4 109 1
9/3/20 Reiko Petrello 8 105 1
7/28/20 Prue Thorsby 1 104 2
6/26/20 Haywood Geraudel 7 103 2
7/6/20 Chrysler Stoneham 1 105 2
8/20/20 Cory Komorowski 1 105 1
9/16/20 Ritchie Bosch 3 107 1
5/7/20 Eddie MacKenny 3 101 1
6/3/20 Grannie Tevelov 2 108 2
4/3/20 Annette Barniss 3 109 2
10/14/20 Cilka Sherrard 10 103 1
4/18/20 Francesco Cloonan 3 109 1
6/4/20 Laurel Downgate 6 108 2
8/7/20 Keary Jaffa 8 105 2
7/6/20 Olly Stairmond 4 102 3
12/20/20 Reuben Bamborough 8 106 3
8/22/20 Rosmunda Tille 4 102 2
7/27/20 Jennee Disbrey 2 102 1
2/10/20 Christophorus Yakubowicz 8 107 3
3/26/20 Angelica Fumagallo 1 102 1
2/3/20 Findlay Hatt 9 108 3
12/3/20 Walt Calender 4 105 1
11/14/20 Robinia Dodgshun 5 103 3
5/12/20 Lisabeth Filov 3 109 3
11/19/20 Lauree Coverlyn 3 103 2
9/11/20 Tanitansy Mandell 1 109 2
12/4/20 Marge Wildber 9 103 2
10/2/20 Isahella Towner 2 108 1
8/18/20 Adela Mabb 3 106 3
10/24/20 Konrad Kopta 1 102 3
4/14/20 Kessia Gonnelly 5 106 1
2/1/20 Shelden Kinsella 3 106 1
2/20/20 Case Hardbattle 1 105 1
12/21/20 Ase Righy 8 102 2
7/16/20 Pauli Murrells 10 102 2
6/12/20 Allister Thomton 3 104 2
10/24/20 Durward Risbrough 9 107 1
9/27/20 Rodge Sail 1 104 3
6/24/20 Claudianus Clint 6 101 1
6/17/20 Tiphani Dundredge 10 104 1
6/22/20 Kienan Shillaber 5 106 1
6/18/20 Errol Yerson 6 105 2
8/9/20 Eadith Izak 4 106 1
10/30/20 Lezlie Davidowsky 10 103 2
4/24/20 Heinrik Stammers 8 101 2
5/26/20 Lewes Alesio 1 101 2
2/2/20 Horton Glascott 2 107 1
2/6/20 Norene Sutheran 9 109 1
8/16/20 Neille Bernardet 2 106 2
2/14/20 Nerti Epple 3 107 2
4/1/20 Betsy Duggen 7 110 3
12/14/20 Nydia Birchwood 5 102 2
7/29/20 Lurline Bontein 10 101 3
4/30/20 Benedick Sindell 9 101 2
8/16/20 Sabra Keeting 5 101 2
1/6/20 Giacopo Dundendale 7 109 3
6/7/20 Timothee Schuck 1 110 1
3/18/20 Con Gadie 4 108 1
7/27/20 Jacinthe Bagnell 8 106 2
7/24/20 Katherina Yakuntsov 3 109 1
7/2/20 Danya Stuchbery 4 109 1
12/8/20 Armin Hemeret 5 103 1
4/24/20 Martynne Langston 9 110 3
9/25/20 Lonnie Canedo 2 109 2
10/28/20 Barnabe Schultze 4 102 2
6/9/20 Lia Cleaves 8 109 1
10/10/20 Shirlene Jacketts 4 105 1
3/4/20 Vinny Curgenven 3 105 1
9/8/20 Shanta Pervew 1 104 3
3/10/20 Louisa Bumby 5 105 1
5/28/20 Ariel Hazard 2 104 3
12/6/20 Jerrie Kettlestringe 9 104 2
6/24/20 Darcy Innes 2 109 2
6/7/20 Timothee Schuck 1 106 2
9/5/20 Joelynn Wyllt 8 109 1
3/5/20 Devina Timewell 2 109 3
7/15/20 Gayla Stoke 1 104 3
2/21/20 Bank Search 5 107 1
11/29/20 Bastien Androck 4 103 3
7/7/20 Benedetta Pursglove 9 105 2
10/27/20 Nadiya Stelle 8 103 2
10/13/20 Annadiane Housen 1 109 2
2/18/20 Lazare Escofier 1 110 1
10/23/20 Garrick Chorlton 3 107 1
1/5/20 Stella Sidney 6 104 3

Finance Functions

Option# Bank Name Number of Compounding Periods per Year Annual Interest Rate Loan Duration in Years Payment per Period Present Value Future Value Total Yearly Payments
1 Bank A 12 5 $ (1,564) $ 75,000 $ - 0
2 Bank B 4 6.75% $ (5,656) $ 70,000 $ - 0
3 Bank C 12 5.00% 4 $ (1,658.11) $ - 0
3 Bank D 2 3.80% 3 $ 65,000 $ - 0
Period Remaining Principal Interest Payment Principal Payment

Use the appropriate finance function to find missing information in the table below.

Choose a loan option that you think will be optimal for the business and create an amortization schedule for the same.