Homework 4

Travel Request Form Date Traveler Departure City ### Lumsky, Donal 1040 National San Francisco Chicago $899 ### Simpson, Jame 1034 National San Francisco Boston $1,225 4/7/2022 Hart, Agatha 1002 Local NY Seattle $957 ### Walton, Bryant 1029 National NY Chicago $699 5/1/2022 Gibson, Grace 1027 Local NY DC $300 ### Spencer, Alexa 1043 Local San Francisco NY $1,331 7/7/2022 Perez, Lonnie 1011 Local NY Boston $851 7/1/2022 Jefferson, Mic 1014 National NY Boston $389 5/6/2022 Coleman, Chri 1011 National NY Boston $799 ### Parks, Steve 1001 Local NY Seattle $957 3/6/2022 Alvarado, Stua 1042 National Chicago DC $399 ### Meyer, Valerie 1041 Local San Francisco LA $320 ### Schneider, Har 1011 Local NY Boston $851 ### Copeland, Virg 1023 Local NY LA $957 ### Kim, Noel 1014 National NY Boston $389 ### Franklin, Byro 1010 National NY Boston $450 ### Reese, Joyce 1037 Local San Francisco DC $1,197 ### Reynolds, Rob 1015 National NY DC $300 7/5/2022 Armstrong, Su 1025 National San Francisco Denver $495 ### Singleton, Oliv 1025 National San Francisco Denver $495 4/5/2022 Davis, Steven 1002 Local NY Seattle $957 ### Hill, Rudy 1041 National San Francisco LA $300 5/7/2022 Higgins, Terri 1015 Local NY DC $320 ### Welch, Cary 1025 National San Francisco Denver $495 ### Santiago, Jay 1041 National San Francisco LA $300 6/6/2022 Schultz, Alexa 1012 Local NY Boston $346 ### Montgomery, J 1011 National NY Boston $799 7/2/2022 Stevenson, De 1011 Local NY Boston $851 ### Alvarez, Velma 1011 National NY Boston $799 ### Ray, Desiree 1040 National San Francisco Chicago $899 ### Barton, Tracey 1006 National NY LA $762 ### Gibbs, Sheryl 1032 Local NY Chicago $851 ### Edwards, Moni 1041 National San Francisco LA $300 4/2/2022 Guzman, Bran 1028 National NY Chicago $799 Flight No. Account Type Arrival City Base Fare

m Weekday Category Sunday 3 Y $405 $75 $480 Thursday 3 X $735 $75 $810 Thursday 3 X $574 $55 $629 Wednesday 2 X $419 $40 $459 Sunday 1 Y $300 $15 $315 Friday 3 Y $1,331 $75 $1,406 Thursday 3 X $511 $55 $566 Friday 1 Y $389 $15 $404 Friday 2 Y $799 $40 $839 Thursday 3 X $574 $55 $629 Sunday 1 Y $399 $20 $419 Monday 1 X $192 $35 $227 Monday 3 X $511 $55 $566 Saturday 3 Z $335 $55 $390 Saturday 1 Z $136 $15 $151 Tuesday 2 X $270 $40 $310 Friday 3 Y $1,197 $75 $1,272 Sunday 1 Y $300 $15 $315 Tuesday 2 X $297 $60 $357 Friday 2 Y $495 $60 $555 Tuesday 3 X $574 $55 $629 Wednesday 1 X $180 $35 $215 Saturday 1 Z $112 $15 $127 Monday 2 X $297 $60 $357 Monday 1 X $180 $35 $215 Monday 1 X $208 $15 $223 Saturday 2 Z $280 $40 $320 Saturday 3 Z $298 $55 $353 Tuesday 2 X $479 $40 $519 Monday 3 X $539 $75 $614 Saturday 2 Z $267 $40 $307 Wednesday 3 X $511 $55 $566 Thursday 1 X $180 $35 $215 Saturday 2 Z $280 $40 $320 Discou nt Catego ry Discount ed Fare Airport Fee Total Ticket Price

Flight No. Departure City Arrival City 1000 NY Denver $ 635 1001 NY Seattle $ 899 1002 NY Seattle $ 899 1003 NY Atlanta $ 899 1004 NY Atlanta $ 899 1005 NY Atlanta $ 1,200 1006 NY LA $ 762 1007 NY Seattle $ 699 1008 NY DC $ 300 1009 San Francisco Seattle $ 325 1010 NY Boston $ 450 1011 NY Boston $ 799 1012 NY Boston $ 325 1013 NY Boston $ 389 1014 NY Boston $ 389 1015 NY DC $ 300 1016 NY Boston $ 389 1017 San Francisco Seattle $ 299 1018 San Francisco Atlanta $ 763 1019 NY Denver $ 699 1020 NY LA $ 1,250 1021 Chicago Seattle $ 670 1022 NY DC $ 452 1023 NY LA $ 899 1024 San Francisco Denver $ 384 1025 San Francisco Denver $ 495 1026 NY LA $ 599 1027 NY DC $ 282 1028 NY Chicago $ 799 1029 NY Chicago $ 699 1030 NY Chicago $ 699 1031 NY Chicago $ 459 1032 NY Chicago $ 799 1033 NY Chicago $ 702 1034 San Francisco Boston $ 1,225 1035 NY DC $ 300 1036 San Francisco DC $ 899 1037 San Francisco DC $ 1,124 1038 San Francisco NY $ 825 1039 San Francisco Chicago $ 875 1040 San Francisco Chicago $ 899 1041 San Francisco LA $ 300 National Account Fare

1042 Chicago DC $ 399 1043 San Francisco NY $ 1,250 1044 San Francisco NY $ 650 1045 San Francisco LA $ 300 1046 Chicago NY $ 459

$ 676 FARE CA $ 957 Ticket Price $ - $ 200.00 $ 300.00 $ 400.00 $ 957 Category 1 1 1 2 $ 957 $ 957 $ 1,278 $ 812 $ 744 $ 320 $ 346 $ 479 $ 851 $ 346 $ 414 $ 414 $ 320 $ 414 $ 318 $ 813 $ 744 $ 1,331 $ 714 $ 481 $ 957 $ 409 $ 527 $ 638 $ 300 $ 851 $ 744 $ 744 $ 489 $ 851 $ 748 $ 1,305 $ 320 $ 957 $ 1,197 $ 879 $ 932 $ 957 $ 320 Local Account Fare

ATEGORY $ 500.00 $ 600.00 $ 800.00 $ 1,000.00 2 2 3 3

Discount Rates Weekday Discount category X Y Z 1 Y % discount 40% 55% 65% 2 X 3 X 4 X 5 X 6 Y 7 Z Discount Category

Fees for Fare Category 1 Fees for Fare Category 2 Fees fo Departng From Departng From Departng From Atlanta $20 Atlanta $45 Boston $15 Boston $40 Chicago $20 Chicago $45 DC $15 DC $40 Denver $30 Denver $55 LA $35 LA $60 NY $15 NY $40 San Francisco $35 San Francisco $60 Seattle $35 Seattle $60 ``

or Fare Category 3 Atlanta $60 Boston $55 Chicago $60 DC $55 Denver $70 LA $75 NY $55 San Francisco $75 Seattle $75

Townsend Mortgage Company Loan # Sale Price % Financed 452786 $361,699 30.0% $ 108,510 $ 253,189 4.180% 0.348% 30 360 70% 453000 $235,199 20.0% $ 47,040 $ 188,159 4.270% 0.356% 30 360 80% 453025 $437,699 15.0% $ 65,655 $ 372,044 4.780% 0.398% 30 360 85% 452600 $549,999 20.0% $ 110,000 $ 439,999 4.310% 0.359% 30 360 80% 452638 $413,599 30.0% $ 124,080 $ 289,519 4.040% 0.337% 30 360 70% 446016 $369,099 20.0% $ 73,820 $ 295,279 4.520% 0.377% 30 360 80% 453161 $347,799 30.0% $ 104,340 $ 243,459 4.220% 0.352% 15 180 70% 447533 $263,400 20.0% $ 52,680 $ 210,720 4.290% 0.358% 30 360 80% 450495 $319,799 20.0% $ 63,960 $ 255,839 4.470% 0.373% 15 180 80% 446205 $324,300 10.0% $ 32,430 $ 291,870 5.540% 0.462% 40 480 90% 442719 $430,400 10.0% $ 43,040 $ 387,360 5.310% 0.443% 30 360 90% 455689 $445,400 20.0% $ 89,080 $ 356,320 4.660% 0.388% 30 360 80% 447218 $495,099 5.0% $ 24,755 $ 470,344 5.630% 0.469% 15 180 95% 443732 $365,400 20.0% $ 73,080 $ 292,320 4.400% 0.367% 40 480 80% 457552 $161,199 20.0% $ 32,240 $ 128,959 4.520% 0.377% 40 480 80% 457445 $301,400 20.0% $ 60,280 $ 241,120 4.290% 0.358% 30 360 80% 451624 $440,099 20.0% $ 88,020 $ 352,079 4.560% 0.380% 30 360 80% 457145 $196,799 30.0% $ 59,040 $ 137,759 4.180% 0.348% 30 360 70% 442400 $454,199 5.0% $ 22,710 $ 431,489 5.690% 0.474% 30 360 95% 441890 $426,999 20.0% $ 85,400 $ 341,599 4.480% 0.373% 30 360 80% 440038 $361,599 10.0% $ 36,160 $ 325,439 6.060% 0.505% 30 360 90% 441412 $272,400 10.0% $ 27,240 $ 245,160 5.790% 0.483% 30 360 90% 459478 $396,199 20.0% $ 79,240 $ 316,959 4.860% 0.405% 30 360 80% 446468 $377,999 30.0% $ 113,400 $ 264,599 4.030% 0.336% 30 360 70% Down Payment (%) Down Payment ($) Amount Financed Mortgage Rate (APR) Rate Per Period Loan Term No. Payment Periods

449642 $541,099 20.0% $ 108,220 $ 432,879 4.390% 0.366% 30 360 80% 456350 $539,699 20.0% $ 107,940 $ 431,759 4.810% 0.401% 30 360 80% 452707 $271,199 20.0% $ 54,240 $ 216,959 4.360% 0.363% 30 360 80% 445484 $409,099 20.0% $ 81,820 $ 327,279 4.510% 0.376% 30 360 80% 449613 $547,099 30.0% $ 164,130 $ 382,969 4.190% 0.349% 30 360 70% 441485 $481,400 20.0% $ 96,280 $ 385,120 4.380% 0.365% 40 480 80% 448578 $368,899 10.0% $ 36,890 $ 332,009 5.090% 0.424% 15 180 90% 459101 $341,599 20.0% $ 68,320 $ 273,279 4.620% 0.385% 30 360 80% 447049 $314,899 20.0% $ 62,980 $ 251,919 4.580% 0.382% 30 360 80% 453690 $308,699 20.0% $ 61,740 $ 246,959 4.390% 0.366% 30 360 80% 446621 $402,799 20.0% $ 80,560 $ 322,239 4.320% 0.360% 30 360 80% 441589 $495,300 20.0% $ 99,060 $ 396,240 4.520% 0.377% 30 360 80% 456153 $439,899 20.0% $ 87,980 $ 351,919 4.700% 0.392% 40 480 80% 445571 $493,200 20.0% $ 98,640 $ 394,560 4.560% 0.380% 30 360 80% 454059 $487,599 15.0% $ 73,140 $ 414,459 4.700% 0.392% 30 360 85% 451848 $577,200 10.0% $ 57,720 $ 519,480 5.210% 0.434% 30 360 90% 449279 $364,799 30.0% $ 109,440 $ 255,359 4.060% 0.338% 30 360 70% 440968 $445,599 20.0% $ 89,120 $ 356,479 4.280% 0.357% 30 360 80% 442229 $285,799 20.0% $ 57,160 $ 228,639 4.490% 0.374% 40 480 80% 441271 $223,200 20.0% $ 44,640 $ 178,560 4.560% 0.380% 30 360 80% 452511 $290,699 20.0% $ 58,140 $ 232,559 4.290% 0.358% 30 360 80% 450195 $459,599 5.0% $ 22,980 $ 436,619 5.730% 0.478% 30 360 95% 452941 $121,400 30.0% $ 36,420 $ 84,980 4.130% 0.344% 30 360 70% 443273 $434,200 20.0% $ 86,840 $ 347,360 4.470% 0.373% 30 360 80% 444891 $425,400 30.0% $ 127,620 $ 297,780 4.100% 0.342% 30 360 70% 446422 $399,999 20.0% $ 80,000 $ 319,999 4.610% 0.384% 30 360 80% 441845 $262,099 20.0% $ 52,420 $ 209,679 4.350% 0.363% 30 360 80% 443122 $282,199 20.0% $ 56,440 $ 225,759 4.520% 0.377% 30 360 80% 442225 $497,300 20.0% $ 99,460 $ 397,840 4.690% 0.391% 15 180 80% 442629 $329,899 20.0% $ 65,980 $ 263,919 4.500% 0.375% 30 360 80% 445370 $582,699 30.0% $ 174,810 $ 407,889 4.040% 0.337% 30 360 70% 443941 $211,200 10.0% $ 21,120 $ 190,080 5.620% 0.468% 15 180 90%

442676 $483,899 20.0% $ 96,780 $ 387,119 4.850% 0.404% 30 360 80% 457872 $344,199 20.0% $ 68,840 $ 275,359 4.660% 0.388% 30 360 80% 444504 $470,099 15.0% $ 70,515 $ 399,584 4.720% 0.393% 30 360 85% 455789 $268,799 30.0% $ 80,640 $ 188,159 4.110% 0.343% 30 360 70% 455984 $402,599 30.0% $ 120,780 $ 281,819 4.100% 0.342% 30 360 70% 455679 $401,200 20.0% $ 80,240 $ 320,960 4.570% 0.381% 30 360 80% 440073 $293,400 20.0% $ 58,680 $ 234,720 4.840% 0.403% 30 360 80% 455487 $522,599 20.0% $ 104,520 $ 418,079 4.860% 0.405% 15 180 80% 449929 $438,599 30.0% $ 131,580 $ 307,019 4.200% 0.350% 30 360 70% 449951 $438,199 20.0% $ 87,640 $ 350,559 4.780% 0.398% 30 360 80% 450648 $220,899 20.0% $ 44,180 $ 176,719 4.710% 0.393% 30 360 80% 440881 $504,899 30.0% $ 151,470 $ 353,429 4.100% 0.342% 30 360 70% 458534 $312,199 10.0% $ 31,220 $ 280,979 5.200% 0.433% 30 360 90% 444243 $288,199 20.0% $ 57,640 $ 230,559 4.540% 0.378% 30 360 80% 454569 $460,199 5.0% $ 23,010 $ 437,189 5.400% 0.450% 30 360 95% 458379 $215,099 20.0% $ 43,020 $ 172,079 4.800% 0.400% 30 360 80% 455423 $374,799 20.0% $ 74,960 $ 299,839 4.710% 0.393% 30 360 80% 457137 $415,200 20.0% $ 83,040 $ 332,160 4.550% 0.379% 30 360 80% 443787 $152,199 20.0% $ 30,440 $ 121,759 4.680% 0.390% 30 360 80% 446168 $371,300 20.0% $ 74,260 $ 297,040 4.610% 0.384% 30 360 80% 451538 $364,799 30.0% $ 109,440 $ 255,359 4.160% 0.347% 30 360 70% 450253 $445,799 20.0% $ 89,160 $ 356,639 4.560% 0.380% 30 360 80% 442045 $411,699 15.0% $ 61,755 $ 349,944 4.550% 0.379% 30 360 85% 455179 $413,300 15.0% $ 61,995 $ 351,305 4.970% 0.414% 30 360 85% 457364 $216,999 10.0% $ 21,700 $ 195,299 6.120% 0.510% 40 480 90% 454916 $306,099 20.0% $ 61,220 $ 244,879 4.690% 0.391% 30 360 80% 445072 $310,799 20.0% $ 62,160 $ 248,639 4.670% 0.389% 30 360 80% 445884 $314,200 20.0% $ 62,840 $ 251,360 4.590% 0.383% 40 480 80% 457123 $314,699 30.0% $ 94,410 $ 220,289 4.010% 0.334% 30 360 70% 447338 $390,400 10.0% $ 39,040 $ 351,360 4.890% 0.408% 30 360 90% 441634 $350,899 10.0% $ 35,090 $ 315,809 5.560% 0.463% 30 360 90% 453441 $311,799 20.0% $ 62,360 $ 249,439 4.760% 0.397% 15 180 80%

449276 $312,599 10.0% $ 31,260 $ 281,339 5.420% 0.452% 30 360 90% 448006 $566,999 20.0% $ 113,400 $ 453,599 4.690% 0.391% 30 360 80% 450642 $283,400 30.0% $ 85,020 $ 198,380 4.080% 0.340% 30 360 70% 459192 $357,999 20.0% $ 71,600 $ 286,399 4.290% 0.358% 30 360 80% 455010 $497,400 30.0% $ 149,220 $ 348,180 4.230% 0.353% 30 360 70% 442724 $330,599 15.0% $ 49,590 $ 281,009 4.840% 0.403% 30 360 85% 453608 $291,699 20.0% $ 58,340 $ 233,359 4.590% 0.383% 30 360 80% 449112 $424,899 20.0% $ 84,980 $ 339,919 4.310% 0.359% 30 360 80% 450700 $233,799 20.0% $ 46,760 $ 187,039 4.640% 0.387% 15 180 80% 453244 $320,200 20.0% $ 64,040 $ 256,160 4.270% 0.356% 15 180 80% 444610 $219,599 15.0% $ 32,940 $ 186,659 4.730% 0.394% 15 180 85% 448003 $319,199 20.0% $ 63,840 $ 255,359 4.360% 0.363% 30 360 80% 454957 $206,999 20.0% $ 41,400 $ 165,599 4.410% 0.368% 15 180 80% 456734 $310,300 20.0% $ 62,060 $ 248,240 4.400% 0.367% 30 360 80% 455907 $318,200 5.0% $ 15,910 $ 302,290 5.440% 0.453% 30 360 95% 444764 $527,199 15.0% $ 79,080 $ 448,119 4.780% 0.398% 30 360 85% 455857 $361,200 20.0% $ 72,240 $ 288,960 4.320% 0.360% 30 360 80% 457423 $302,099 20.0% $ 60,420 $ 241,679 4.460% 0.372% 30 360 80% 449128 $427,099 30.0% $ 128,130 $ 298,969 4.250% 0.354% 15 180 70% 442399 $465,400 20.0% $ 93,080 $ 372,320 4.700% 0.392% 30 360 80% 454409 $425,300 20.0% $ 85,060 $ 340,240 4.460% 0.372% 30 360 80% 444566 $501,699 20.0% $ 100,340 $ 401,359 4.370% 0.364% 30 360 80% 455509 $505,599 20.0% $ 101,120 $ 404,479 4.630% 0.386% 30 360 80% 451113 $326,400 20.0% $ 65,280 $ 261,120 4.420% 0.368% 15 180 80% 454014 $335,199 20.0% $ 67,040 $ 268,159 4.780% 0.398% 30 360 80% 457832 $333,400 20.0% $ 66,680 $ 266,720 4.860% 0.405% 30 360 80% 443600 $493,799 30.0% $ 148,140 $ 345,659 4.000% 0.333% 30 360 70% 451968 $469,400 20.0% $ 93,880 $ 375,520 4.340% 0.362% 30 360 80% 444859 $235,199 20.0% $ 47,040 $ 188,159 4.680% 0.390% 30 360 80% 450994 $436,999 20.0% $ 87,400 $ 349,599 4.280% 0.357% 30 360 80% 442872 $91,199 20.0% $ 18,240 $ 72,959 4.870% 0.406% 15 180 80% 455957 $403,599 20.0% $ 80,720 $ 322,879 4.700% 0.392% 30 360 80%

448703 $315,400 10.0% $ 31,540 $ 283,860 6.070% 0.506% 30 360 90% 451406 $306,400 20.0% $ 61,280 $ 245,120 4.490% 0.374% 30 360 80% 443631 $370,099 30.0% $ 111,030 $ 259,069 4.180% 0.348% 30 360 70% 444358 $506,699 20.0% $ 101,340 $ 405,359 4.260% 0.355% 30 360 80% 445205 $319,400 20.0% $ 63,880 $ 255,520 4.730% 0.394% 30 360 80% 441500 $370,200 20.0% $ 74,040 $ 296,160 4.850% 0.404% 30 360 80% 446061 $450,099 10.0% $ 45,010 $ 405,089 5.920% 0.493% 30 360 90% 441369 $437,200 20.0% $ 87,440 $ 349,760 4.670% 0.389% 30 360 80% 447374 $279,300 20.0% $ 55,860 $ 223,440 4.820% 0.402% 30 360 80% 450791 $303,200 20.0% $ 60,640 $ 242,560 4.690% 0.391% 30 360 80% 446274 $546,599 20.0% $ 109,320 $ 437,279 4.290% 0.358% 30 360 80% 457842 $474,599 20.0% $ 94,920 $ 379,679 4.320% 0.360% 30 360 80% 440695 $393,200 20.0% $ 78,640 $ 314,560 4.710% 0.393% 30 360 80% 456189 $366,199 20.0% $ 73,240 $ 292,959 4.770% 0.398% 30 360 80% 455332 $218,599 20.0% $ 43,720 $ 174,879 4.310% 0.359% 30 360 80% 451350 $401,699 20.0% $ 80,340 $ 321,359 4.270% 0.356% 30 360 80% 451912 $200,200 20.0% $ 40,040 $ 160,160 4.860% 0.405% 30 360 80% 441087 $368,799 20.0% $ 73,760 $ 295,039 4.380% 0.365% 30 360 80% 443071 $340,999 20.0% $ 68,200 $ 272,799 4.680% 0.390% 15 180 80% 452244 $351,199 20.0% $ 70,240 $ 280,959 4.300% 0.358% 30 360 80% 451916 $433,300 20.0% $ 86,660 $ 346,640 4.810% 0.401% 30 360 80% 448336 $420,400 20.0% $ 84,080 $ 336,320 4.750% 0.396% 40 480 80% 455741 $375,699 20.0% $ 75,140 $ 300,559 4.400% 0.367% 30 360 80% 444724 $199,599 20.0% $ 39,920 $ 159,679 4.840% 0.403% 30 360 80% 441671 $277,400 30.0% $ 83,220 $ 194,180 4.110% 0.343% 30 360 70% 452836 $549,300 15.0% $ 82,395 $ 466,905 4.670% 0.389% 30 360 85% 454093 $288,099 20.0% $ 57,620 $ 230,479 4.500% 0.375% 30 360 80% 442303 $330,999 20.0% $ 66,200 $ 264,799 4.410% 0.368% 30 360 80% 449429 $392,099 20.0% $ 78,420 $ 313,679 4.510% 0.376% 30 360 80% 446570 $399,699 20.0% $ 79,940 $ 319,759 4.630% 0.386% 30 360 80% 457066 $398,099 20.0% $ 79,620 $ 318,479 4.420% 0.368% 30 360 80% 452108 $409,199 20.0% $ 81,840 $ 327,359 4.800% 0.400% 30 360 80%

456493 $308,200 10.0% $ 30,820 $ 277,380 5.030% 0.419% 30 360 90% 441268 $242,899 20.0% $ 48,580 $ 194,319 4.770% 0.398% 15 180 80% 459959 $175,099 20.0% $ 35,020 $ 140,079 4.590% 0.383% 30 360 80% 444466 $480,599 10.0% $ 48,060 $ 432,539 5.760% 0.480% 15 180 90% 454830 $504,200 20.0% $ 100,840 $ 403,360 4.440% 0.370% 30 360 80% 459091 $527,300 20.0% $ 105,460 $ 421,840 4.840% 0.403% 30 360 80% 446693 $307,199 20.0% $ 61,440 $ 245,759 4.290% 0.358% 30 360 80% 440294 $347,799 20.0% $ 69,560 $ 278,239 4.820% 0.402% 30 360 80% 441185 $504,599 10.0% $ 50,460 $ 454,139 4.900% 0.408% 40 480 90% 450839 $642,999 20.0% $ 128,600 $ 514,399 4.610% 0.384% 30 360 80% 454594 $381,099 20.0% $ 76,220 $ 304,879 4.680% 0.390% 30 360 80% 454492 $375,899 15.0% $ 56,385 $ 319,514 4.980% 0.415% 30 360 85% 452087 $367,899 20.0% $ 73,580 $ 294,319 4.470% 0.373% 15 180 80% 445838 $440,300 20.0% $ 88,060 $ 352,240 4.260% 0.355% 30 360 80% 451334 $245,199 20.0% $ 49,040 $ 196,159 4.800% 0.400% 30 360 80% 459178 $363,199 20.0% $ 72,640 $ 290,559 4.610% 0.384% 40 480 80% 459332 $477,899 20.0% $ 95,580 $ 382,319 4.470% 0.373% 15 180 80% 441583 $424,199 10.0% $ 42,420 $ 381,779 5.580% 0.465% 30 360 90% 444141 $341,899 30.0% $ 102,570 $ 239,329 4.040% 0.337% 15 180 70% 449699 $420,599 20.0% $ 84,120 $ 336,479 4.300% 0.358% 30 360 80% 445993 $446,799 20.0% $ 89,360 $ 357,439 4.680% 0.390% 30 360 80% 457408 $321,099 20.0% $ 64,220 $ 256,879 4.310% 0.359% 30 360 80% 447968 $526,899 20.0% $ 105,380 $ 421,519 4.710% 0.393% 30 360 80% 443331 $544,999 20.0% $ 109,000 $ 435,999 4.570% 0.381% 30 360 80% 451450 $348,200 20.0% $ 69,640 $ 278,560 4.540% 0.378% 30 360 80% 447766 $330,799 15.0% $ 49,620 $ 281,179 4.790% 0.399% 15 180 85% 443681 $269,999 20.0% $ 54,000 $ 215,999 4.580% 0.382% 30 360 80% 443161 $232,300 20.0% $ 46,460 $ 185,840 4.720% 0.393% 30 360 80% 442206 $255,099 20.0% $ 51,020 $ 204,079 4.670% 0.389% 30 360 80% 445597 $178,699 10.0% $ 17,870 $ 160,829 6.120% 0.510% 30 360 90% 458856 $564,199 20.0% $ 112,840 $ 451,359 4.780% 0.398% 30 360 80% 459967 $410,999 20.0% $ 82,200 $ 328,799 4.330% 0.361% 30 360 80%

441351 $166,200 10.0% $ 16,620 $ 149,580 6.060% 0.505% 30 360 90% 453357 $537,899 20.0% $ 107,580 $ 430,319 4.760% 0.397% 30 360 80% 441557 $404,999 20.0% $ 81,000 $ 323,999 4.610% 0.384% 30 360 80% 441429 $243,599 20.0% $ 48,720 $ 194,879 4.700% 0.392% 15 180 80% 457153 $479,199 20.0% $ 95,840 $ 383,359 4.450% 0.371% 30 360 80% 448869 $385,999 20.0% $ 77,200 $ 308,799 4.420% 0.368% 30 360 80% 442924 $234,199 20.0% $ 46,840 $ 187,359 4.700% 0.392% 15 180 80% 457480 $270,099 20.0% $ 54,020 $ 216,079 4.470% 0.373% 30 360 80% 448739 $548,599 20.0% $ 109,720 $ 438,879 4.360% 0.363% 30 360 80% 457634 $440,300 30.0% $ 132,090 $ 308,210 4.150% 0.346% 30 360 70% 442849 $442,599 20.0% $ 88,520 $ 354,079 4.400% 0.367% 30 360 80% 454359 $280,699 15.0% $ 42,105 $ 238,594 4.800% 0.400% 15 180 85%

Summary Statstcs $1,235.19 Statstcs Sales Price Down Payment $927.83 Total $ 73,085,860 $ 14,268,152 $ 58,817,708 $ 319,075 $1,947.49 Average $ 372,887 $ 72,797 $ 300,090 $ 1,628 $2,180.01 Median $ 295,720 $ 71,920 $ 295,720 $ 1,588 $1,388.89 Lowest $ 91,199 $ 15,910 $ 72,959 $ 412 $1,499.65 Highest $ 642,999 $ 174,810 $ 519,480 $ 3,876 $1,827.80 # of Mortgag 196 $1,041.56 $1,953.23 $1,513.33 $2,153.43 Individual Loan Details $1,839.45 Period Perio $3,875.63 Amount Loan Mortgage Monthly Start End Interest $1,295.43 Loan # Financed Term Rate (APR) Payment Year Year Paid $581.41 453000 $188,159 30 4.27% $927.83 5 12 $54,092.09 $1,191.82 $1,796.51 $672.06 $2,501.63 $1,726.78 $1,963.74 $1,436.92 $1,674.49 $1,267.82 Monthly Payment Amount Financed Monthly Payment

$2,165.13 $2,267.90 $1,081.33 $1,660.22 $1,870.55 $1,701.76 $2,641.10 $1,404.22 $1,288.44 $1,235.22 $1,598.46 $2,012.40 $1,627.62 $2,013.27 $2,149.54 $2,855.73 $1,227.97 $1,759.93 $1,026.41 $911.11 $1,149.50 $2,542.45 $412.10 $1,753.84 $1,438.87 $1,642.37 $1,043.81 $1,146.57 $3,082.22 $1,337.24 $1,956.74 $1,565.24

$2,042.80 $1,421.50 $2,077.20 $910.27 $1,361.75 $1,639.63 $1,237.18 $3,275.73 $1,501.38 $1,835.03 $917.60 $1,707.76 $1,542.89 $1,173.70 $2,454.95 $902.84 $1,556.88 $1,692.89 $630.03 $1,524.53 $1,242.80 $1,819.78 $1,783.53 $1,879.45 $1,090.94 $1,268.56 $1,285.06 $1,144.60 $1,052.97 $1,862.63 $1,805.04 $1,941.51

$1,583.32 $2,349.81 $956.27 $1,415.63 $1,708.76 $1,481.16 $1,194.91 $1,684.16 $1,444.26 $1,929.63 $1,449.97 $1,272.71 $1,259.22 $1,243.09 $1,705.01 $2,345.71 $1,433.38 $1,218.82 $2,249.08 $1,930.99 $1,715.87 $2,002.74 $2,080.80 $1,986.89 $1,403.70 $1,409.08 $1,650.23 $1,867.17 $973.60 $1,725.96 $572.03 $1,674.57

$1,714.68 $1,240.53 $1,263.87 $1,996.50 $1,329.83 $1,562.81 $2,407.92 $1,807.69 $1,175.01 $1,256.55 $2,161.40 $1,883.39 $1,633.32 $1,531.75 $866.45 $1,584.66 $846.12 $1,473.96 $2,112.08 $1,390.39 $1,820.80 $1,566.44 $1,505.08 $841.65 $939.40 $2,413.13 $1,167.80 $1,327.58 $1,591.23 $1,644.97 $1,598.58 $1,717.54

$1,494.13 $1,513.48 $717.27 $3,594.16 $2,029.41 $2,223.46 $1,214.75 $1,463.19 $2,159.85 $2,640.11 $1,577.56 $1,711.32 $2,247.01 $1,734.87 $1,029.18 $1,326.86 $2,918.86 $2,186.90 $1,775.09 $1,665.14 $1,849.52 $1,272.73 $2,188.69 $2,227.32 $1,418.05 $2,192.91 $1,104.73 $966.07 $1,054.76 $976.69 $2,362.67 $1,632.93

$902.59 $2,247.34 $1,662.90 $1,510.81 $1,931.05 $1,550.00 $1,452.51 $1,090.99 $2,187.38 $1,498.22 $1,773.09 $1,862.02

od Principal Paid $34,980.03

Kaplan Design Services, Inc. Studio Expansion Loan Analysis Loan (PV) Loan Term $475,000 5.000% 5 $8,964 Amortzaton Schedule Year Month 1 1 $1,979 $6,985 $468,015.33 1 2 $1,950 $7,014 $461,001.56 1 3 $1,921 $7,043 $453,958.56 1 4 $1,891 $7,072 $446,886.22 1 5 $1,862 $7,102 $439,784.41 1 6 $1,832 $7,131 $432,653.01 1 7 $1,803 $7,161 $425,491.89 1 8 $1,773 $7,191 $418,300.94 1 9 $1,743 $7,221 $411,080.03 1 10 $1,713 $7,251 $403,829.02 1 11 $1,683 $7,281 $396,547.81 1 12 $1,652 $7,312 $389,236.25 2 13 $1,622 $7,342 $381,894.24 2 14 $1,591 $7,373 $374,521.63 2 15 $1,561 $7,403 $367,118.30 2 16 $1,530 $7,434 $359,684.12 2 17 $1,499 $7,465 $352,218.97 2 18 $1,468 $7,496 $344,722.71 2 19 $1,436 $7,527 $337,195.22 2 20 $1,405 $7,559 $329,636.36 2 21 $1,373 $7,590 $322,046.01 2 22 $1,342 $7,622 $314,424.04 2 23 $1,310 $7,654 $306,770.30 2 24 $1,278 $7,686 $299,084.67 3 25 $1,246 $7,718 $291,367.02 3 26 $1,214 $7,750 $283,617.22 3 27 $1,182 $7,782 $275,835.12 3 28 $1,149 $7,815 $268,020.60 3 29 $1,117 $7,847 $260,173.51 Annual Rate (Monthly Compounding) Monthly Payment (PMT) Interest Payment Principal Payment Remaining Principal

3 30 $1,084 $7,880 $252,293.73 3 31 $1,051 $7,913 $244,381.12 3 32 $1,018 $7,946 $236,435.54 3 33 $985 $7,979 $228,456.85 3 34 $952 $8,012 $220,444.92 3 35 $919 $8,045 $212,399.60 3 36 $885 $8,079 $204,320.77 4 37 $851 $8,112 $196,208.27 4 38 $818 $8,146 $188,061.97 4 39 $784 $8,180 $179,881.72 4 40 $750 $8,214 $171,667.39 4 41 $715 $8,249 $163,418.84 4 42 $681 $8,283 $155,135.91 4 43 $646 $8,317 $146,818.48 4 44 $612 $8,352 $138,466.38 4 45 $577 $8,387 $130,079.49 4 46 $542 $8,422 $121,657.65 4 47 $507 $8,457 $113,200.72 4 48 $472 $8,492 $104,708.56 5 49 $436 $8,528 $96,181.01 5 50 $401 $8,563 $87,617.93 5 51 $365 $8,599 $79,019.16 5 52 $329 $8,635 $70,384.58 5 53 $293 $8,671 $61,714.01 5 54 $257 $8,707 $53,007.31 5 55 $221 $8,743 $44,264.34 5 56 $184 $8,779 $35,484.94 5 57 $148 $8,816 $26,668.96 5 58 $111 $8,853 $17,816.24 5 59 $74 $8,890 $8,926.64 5 60 $37 $8,927 $0.00

Amounts Paid Yearly Year 1 2 3 Interest $21,802 $17,414 $12,802 Principal $85,764 $90,152 $94,764 Total $107,566 $107,566 $107,566

4 5 Total $7,954 $2,857 $62,830 $99,612 $104,709 $475,000 $107,566 $107,566 $537,830

Item ID Item Order Date Date Expected 1001 Bronzing gel 8/15/2022 8/29/2022 5 5 1002 Bronzing powder 8/15/2022 8/29/2022 20 20 1003 Bronzing blush 8/15/2022 8/29/2022 15 20 1004 Cuticle remover 8/15/2022 8/29/2022 20 20 1005 Cuticle conditioner 8/15/2022 8/29/2022 20 18 1006 Conditioning spray 9/9/2022 9/23/2022 20 20 1007 DermoMagic 8 oz 8/12/2022 9/2/2022 30 28 1008 DermoMagic 16 oz 8/12/2022 9/2/2022 15 15 1009 DermoMagic 24 oz 8/12/2022 9/2/2022 15 15 1010 DermoMagic samples 8/12/2022 9/2/2022 10 10 1011 Hair Tint -- color 01 8/27/2022 9/3/2022 25 25 1012 Hair Tint -- color 02 8/27/2022 9/3/2022 25 25 1013 Hair Tint -- color 03 8/27/2022 9/3/2022 25 25 1014 Hair Tint -- color 04 8/27/2022 9/3/2022 25 25 1015 Hair Tint -- color 05 8/27/2022 9/3/2022 25 20 1016 Hair Tint -- color 06 8/27/2022 9/3/2022 25 25 1017 Hair Tint -- color 07 8/27/2022 9/3/2022 25 25 1018 Hair Tint -- color 08 8/27/2022 9/3/2022 25 25 1019 Hair Tint -- color 09 8/27/2022 9/3/2022 25 25 1020 Gloves -- 100 pk 9/3/2022 9/8/2022 100 100 1021 Caps -- 100 pk 9/3/2022 9/8/2022 100 100 1022 Brush style 120 9/3/2022 9/8/2022 50 50 1023 Brush style 121 9/3/2022 9/8/2022 50 75 1024 Brush style 122 9/3/2022 9/8/2022 50 50 1025 Brush style 123 9/3/2022 9/8/2022 50 50 1026 Glazer 6 oz 8/12/2022 8/20/2022 20 20 1028 Glazer 20 oz 8/12/2022 8/20/2022 20 20 1029 ColorFab Color 001 8/12/2022 8/19/2022 35 35 1030 ColorFab Color 002 8/12/2022 8/19/2022 35 35 1031 ColorFab Color 003 8/12/2022 8/19/2022 35 35 1032 ColorFab Color 004 8/12/2022 8/19/2022 35 37 1033 ColorFab Color 005 8/12/2022 8/19/2022 35 35 1034 ColorFab Color 006 8/12/2022 8/19/2022 35 35 1035 ColorFab Color 007 8/12/2022 8/19/2022 35 35 1036 ColorFab Color 008 8/12/2022 8/19/2022 35 33 1037 ColorFab Color 009 8/12/2022 8/19/2022 35 35 1039 ColorFab Color 011 8/12/2022 8/19/2022 35 35 1040 ColorFab Color 012 8/12/2022 8/19/2022 35 35 1041 ColorFab Color 013 8/12/2022 8/19/2022 35 35 1042 ColorFab Color 014 8/12/2022 8/19/2022 35 35 1043 ColorFab Color 015 8/12/2022 8/19/2022 35 35 Ordered Amount Received Amount

Report Date 9/13/2022 Unit Price Item ID $15.00 7 1010 $25.00 7 $14.00 7 $10.00 7 $13.00 7 $17.00 7 $10.00 21 $15.00 21 $25.00 21 $30.00 21 $12.00 21 $12.00 21 $12.00 21 $12.00 21 $12.00 21 $12.00 21 $12.00 21 $12.00 21 $12.00 21 $20.00 21 $19.00 21 $21.00 21 $16.00 5 $14.00 14 $24.00 14 $10.00 14 $25.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 $5.00 14 Delivery (Lead) Time, in Days

Item Order Value Order Status DermoMagic samples $300 Order Closed

New Contracts Region Jan Feb Mar Apr May West 33 35 35 34 33 South 13 13 14 15 18 East 24 19 30 22 33 0 400

Jun Jul Aug Sep Oct Nov Dec 34 32 27 25 23 22 20 20 18 16 21 26 29 31 28 19 21 24 19 16 21 West South East 353 234 276 275 West; 275 South; 275 East; 275 275 Contract Signed by Region versus Target Total Target

Total Target 275 West 353 275 South 234 275 East 276 275 275