excel

profileasdsadasdasd
project_k_yourname.xlsx
Home>Business & Finance homework help>Management homework help>excel

inventory

Make Model Year Mileage Price Payment Financial Information
Ford Explorer 2012 48631 $ 19,850 $ 370.88
Buick LaCrosse 2013 23698 $ 21,471 $ 401.16 Client Loan Information
Volkswagen Passat 2016 6079 $ 28,254 $ 527.90 Credit Rating Good
Buick Enclave 2014 57100 $ 26,500 $ 495.13 APR 4.59%
Ford Focus 2015 14798 $ 15,850 $ 296.14 Years in Loan 5
Honda Civic 2015 11456 $ 19,700 $ 368.07 PMTs per Year 12
Ford Crown Vic 2014 34000 $ 15,275 $ 285.40 Total PMTs 60
Dodge Durango 2016 92525 $ 27,900 $ 521.28
Ford Taurus 2014 40921 $ 20,888 $ 390.27 Lookup Table
Buick Regal 2014 19276 $ 20,977 $ 391.93 Credit Rating APR
Kia Reo 2016 4925 $ 15,750 $ 294.27 Excellent 2.39%
Ford Fusion 2016 12395 $ 18,626 $ 348.01 Fair 8.99%
Acura TSX 2014 18540 $ 22,500 $ 420.39 Good 4.59%
Toyota Cruiser 2014 46985 $ 28,000 $ 523.15 Poor 17.99%
Fiat Sport 2015 1743 $ 14,755 $ 275.68
Volkswagen Jetta 2014 22575 $ 19,995 $ 373.59
Honda Civic 2012 52500 $ 16,475 $ 307.82
Volkswagen Jetta 2011 55887 $ 15,995 $ 298.85
Buick LaCrosse 2011 66843 $ 11,450 $ 213.93
Mercedes C300 2014 25541 $ 30,388 $ 567.77
Honda Civic 2013 19982 $ 17,699 $ 330.69
Toyota Camry 2014 26164 $ 23,997 $ 448.36
Volkswagen Jetta 2014 33656 $ 14,900 $ 278.39
Ford Focus 2015 20080 $ 22,898 $ 427.83
Chevy Impala 2014 44991 $ 12,987 $ 242.65
Chevy Malibu 2015 31658 $ 14,495 $ 270.82
Kia Forte 2014 30080 $ 14,896 $ 278.32
Hyundai Accent 2016 6250 $ 16,245 $ 303.52
Toyota Camry 2014 25282 $ 15,750 $ 294.27
Nissan Sentra 2014 43678 $ 14,298 $ 267.14
Toyota Cruiser 2013 30000 $ 25,500 $ 476.44

Reynolds Used Cars