Original Financing Intermediate Car Luxury Car

Scenario Summary

Current Values: Original Financing Intermediate Car Luxury Car

Changing Cells:

Price 56,500$ 21,595$ 33,999$ 56,500$

CashBack 2,500$ -$ 1,500$ 2,500$

Months 60 24 36 60

APR 3.90% 1.90% 2.40% 3.90%

Result Cells:

Payment 946.13$ 811.47$ 864.50$ 946.13$

TotalCost 56,767.72$ 19,475.21$ 31,121.90$ 56,767.72$

Notes: Current Values column represents values of changing cells at

time Scenario Summary Report was created. Changing cells for each

scenario are highlighted in gray.

SOLUTION SAMPLE

 

 

Car Loan

1

2

3

4

5

6

7

8

9

10

11

12

A B

Loan Inputs

Sticker price 56,500$

Trade in 2,500$

Cash back offer 2,500$

Loan amount 51,500$

Loan term (months) 60

Loan interest (APR) 3.90%

Loan payment 946.13$

Total cost of the car 56,767.72$

New Car Loan

SOLUTION SAMPLE

 

 

My Car Data

1

4

9

12

15

19

22

25

28

31

34

37

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

A B C D E F G H I J K L M N O P

Model Displ Cyl Trans Drive Fuel Sales Area Stnd Veh Class A ir

 

P o

llu ti

o n

 

S co

re

City MPG Hwy MPG Cmb MPG G re

e n

h o

u s

e G

a s

S co

re

S m

a rt

W a

y

AUDI A3 Average 6.5 30 42 34 HONDA Civic Average 7.875 25 36 28.5 HONDA Fit Average 6.5 28 35 31 HYUNDAI Accent Average 6.5 27 36 30 KIA Forte Average 7.5 27 36 30 KIA Rio Average 6.5 27 36 30 SMART ForTwo Cabriolet Average 6.5 33 41 36 SMART ForTwo Coupe Average 6.5 33 41 36 TOYOTA Yaris Average 6.5 29 35 31 VOLKSWAGEN Golf Average 6.5 30 42 34 VOLKSWAGEN Jetta Average 6.5 30 42 34 VOLKSWAGEN Jetta SportWagen Average 6.5 30 42 34 Grand Average 6.814814815 28.7037037 38.37037037 32

Criteria

Model Displ Cyl Trans Drive Fuel Sales Area Stnd Veh Class A ir

 

P o

ll u

ti o

n

S co

re

City MPG Hwy MPG Cmb MPG G re

e n

h o

u s

e G

a s

S co

re

S m

a rt

W a

y

gasoline >35

Filtered Data

Model Displ Cyl Trans Drive Fuel Sales Area Stnd Veh Class A ir

 

P o

ll u

ti o

n S

co re

City MPG Hwy MPG Cmb MPG Cmb MPG Icon G re

e n

h o

u se

G a

s

S co

re

S m

a rt

W

a y

HONDA Civic 1.8 4 Auto-5 2WD Gasoline CA U2 small car 7 26 36 29 8 yes

HONDA Civic 1.8 4 Auto-5 2WD Gasoline FA B5 small car 6 26 36 29 8 yes

HYUNDAI Accent 1.6 4 Auto-4 2WD Gasoline CA U2 small car 7 27 36 30 8 yes

HYUNDAI Accent 1.6 4 Auto-4 2WD Gasoline FA B5 small car 6 27 36 30 8 yes

KIA Forte 2 4 Auto-5 2WD Gasoline CA S2 small car 9.5 27 36 30 8 yes

KIA Forte 2 4 Auto-5 2WD Gasoline CA U2 small car 7 27 36 30 8 yes

KIA Forte 2 4 Auto-5 2WD Gasoline FA B5 small car 6 27 36 30 8 yes

KIA Rio 1.6 4 Auto-4 2WD Gasoline CA U2 small car 7 27 36 30 8 yes

KIA Rio 1.6 4 Auto-4 2WD Gasoline FA B5 small car 6 27 36 30 8 yes

SMART ForTwo Cabriolet 1 3 AutoMan-5 2WD Gasoline CA U2 small car 7 33 41 36 9 yes

SMART ForTwo Cabriolet 1 3 AutoMan-5 2WD Gasoline FA B5 small car 6 33 41 36 9 yes

SMART ForTwo Coupe 1 3 AutoMan-5 2WD Gasoline CA U2 small car 7 33 41 36 9 yes

SMART ForTwo Coupe 1 3 AutoMan-5 2WD Gasoline FA B5 small car 6 33 41 36 9 yes

SOLUTION SAMPLE

 

 

MPG Data

1

2 42 46

869 870 872 874 885 888 914 916

1083 1087 1092 1101 1103 1800 1801 1802 1803 2044 2046 2075 2077 2091 2095 2103 2105

A B C D E F G H K L M N O P Q

Model Displ Cyl Trans Drive Fuel

Sales

Area Stnd Veh Class A ir

P o

ll u

ti o

n

S co

re City

MPG

Hwy

MPG

Cmb

MPG G re

e n

h o

u se

 

G a

s S

co re

S m

a rt

W a

y

AUDI A3 2 4 SemiAuto-6 2WD Diesel CA U2 station wagon 7 30 42 34 8 yes AUDI A3 2 4 SemiAuto-6 2WD Diesel FA B5 station wagon 6 30 42 34 8 yes HONDA Civic 1.8 4 Auto-5 2WD CNG CA S2 small car 9.5 24 36 28 9 yes HONDA Civic 1.8 4 Auto-5 2WD CNG FA B2 small car 9 24 36 28 9 yes HONDA Civic 1.8 4 Auto-5 2WD Gasoline CA U2 small car 7 26 36 29 8 yes HONDA Civic 1.8 4 Auto-5 2WD Gasoline FA B5 small car 6 26 36 29 8 yes HONDA Fit 1.5 4 Auto-5 2WD Gasoline CA U2 station wagon 7 28 35 31 8 yes HONDA Fit 1.5 4 Auto-5 2WD Gasoline FA B5 station wagon 6 28 35 31 8 yes HYUNDAI Accent 1.6 4 Auto-4 2WD Gasoline CA U2 small car 7 27 36 30 8 yes HYUNDAI Accent 1.6 4 Auto-4 2WD Gasoline FA B5 small car 6 27 36 30 8 yes KIA Forte 2 4 Auto-5 2WD Gasoline CA S2 small car 9.5 27 36 30 8 yes KIA Forte 2 4 Auto-5 2WD Gasoline CA U2 small car 7 27 36 30 8 yes KIA Forte 2 4 Auto-5 2WD Gasoline FA B5 small car 6 27 36 30 8 yes KIA Rio 1.6 4 Auto-4 2WD Gasoline CA U2 small car 7 27 36 30 8 yes KIA Rio 1.6 4 Auto-4 2WD Gasoline FA B5 small car 6 27 36 30 8 yes SMART ForTwo Cabriolet 1 3 AutoMan-5 2WD Gasoline CA U2 small car 7 33 41 36 9 yes SMART ForTwo Cabriolet 1 3 AutoMan-5 2WD Gasoline FA B5 small car 6 33 41 36 9 yes SMART ForTwo Coupe 1 3 AutoMan-5 2WD Gasoline CA U2 small car 7 33 41 36 9 yes SMART ForTwo Coupe 1 3 AutoMan-5 2WD Gasoline FA B5 small car 6 33 41 36 9 yes TOYOTA Yaris 1.5 4 Auto-4 2WD Gasoline CA U2 small car 7 29 35 31 8 yes TOYOTA Yaris 1.5 4 Auto-4 2WD Gasoline FA B5 small car 6 29 35 31 8 yes VOLKSWAGEN Golf 2 4 SemiAuto-6 2WD Diesel CA U2 small car 7 30 42 34 8 yes VOLKSWAGEN Golf 2 4 SemiAuto-6 2WD Diesel FA B5 small car 6 30 42 34 8 yes VOLKSWAGEN Jetta 2 4 SemiAuto-6 2WD Diesel CA U2 small car 7 30 42 34 8 yes VOLKSWAGEN Jetta 2 4 SemiAuto-6 2WD Diesel FA B5 small car 6 30 42 34 8 yes VOLKSWAGEN Jetta SportWagen 2 4 SemiAuto-6 2WD Diesel CA U2 station wagon 7 30 42 34 8 yes VOLKSWAGEN Jetta SportWagen 2 4 SemiAuto-6 2WD Diesel FA B5 station wagon 6 30 42 34 8 yes

All Models

SOLUTION SAMPLE

 

 

MPG PivotTable

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

A B C D E

Row Labels Average of Air Pollution Score Average of City MPG Average of Hwy MPG Average of Cmb MPG

large car 7.37 20.73 30.73 24.33

midsize car 7.03 24.41 31.99 27.18

minivan 6.00 22.00 28.00 24.00

pickup 6.50 22.00 27.00 24.00

small car 6.97 23.63 32.24 26.89

special purpose 7.00 22.00 25.00 23.00

station wagon 6.69 23.26 30.43 25.91

SUV 7.23 23.08 27.84 24.81

Grand Total 6.98 23.53 31.18 26.38

SmartWay

no

yes

SOLUTION SAMPLE

 

 

Bakery Business

1

2

3

4

5

6

7

8

9

10

11

12

13

14

A B C D E F

What is my profit? 182.75$

Available capital 200.00$

Working hours required 12 must be less than or equal to 12

Total cost of ingredients 77.25 must be less than or equal to 200.00$

Price (retail)

Optimal number to make each

day Cost (ingredients) Labor (hours) Max per day

Birthday Cake 60.00$ 1 14.00$ 3 1

Cupcakes (dozen) 25.00$ 4 8.00$ 1 4

Cookies, Shortbread (dozen) 18.00$ 0 6.00$ 1 6

Cookies, Lemon Bars (dozen) 20.00$ 5 6.25$ 1 6

Total cost must be less than or equal to capital

Total labor hours must be less than or equal to working hours per day

Number to make of each item cannot be more than the maximum per day possible

SOLUTION SAMPLE