Project Description:
You are budgeting for the purchase of a new automobile. You are evaluating your expenses to determine the monetary resources available for a monthly payment. As part of the project you will perform WhatIF Analysis and complete an amortization schedule.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name. 
0 
2 
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4. Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31. 
5 
3 
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table. 
7 
4 
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format. 
4 
5 
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium. 
4 
6 
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31) 
5 
7 
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments. 
5 
8 
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table. 
5 
9 
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places. 
10 
10 
Apply a custom number format to cell L2 to display Amount of Payment. 
5 
11 
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%. 
5 
12 
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%. 
5 
13 
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%. 
5 
14 
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results. 
5 
15 
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order). 
5 
16 
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible. 
5 
17 
Use the purchase price and down payment as changing variable cells. 
5 
18 
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000. 
5 
19 
Set a constraint for the interest rate, which must be at least .03. 
5 
20 
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet. 
5 
21 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0 

Total Points 
100 
Project Description:
You are budgeting for the purchase of a new automobile. You are evaluating your expenses to determine the monetary resources available for a monthly payment. As part of the project you will perform WhatIF Analysis and complete an amortization schedule.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name. 
0 
2 
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4. Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31. 
5 
3 
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table. 
7 
4 
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format. 
4 
5 
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium. 
4 
6 
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31) 
5 
7 
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments. 
5 
8 
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table. 
5 
9 
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places. 
10 
10 
Apply a custom number format to cell L2 to display Amount of Payment. 
5 
11 
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%. 
5 
12 
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%. 
5 
13 
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%. 
5 
14 
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results. 
5 
15 
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order). 
5 
16 
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible. 
5 
17 
Use the purchase price and down payment as changing variable cells. 
5 
18 
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000. 
5 
19 
Set a constraint for the interest rate, which must be at least .03. 
5 
20 
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet. 
5 
21 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0 

Total Points 
100 
Project Description:
You are budgeting for the purchase of a new automobile. You are evaluating your expenses to determine the monetary resources available for a monthly payment. As part of the project you will perform WhatIF Analysis and complete an amortization schedule.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name. 
0 
2 
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4. Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31. 
5 
3 
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table. 
7 
4 
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format. 
4 
5 
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium. 
4 
6 
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31) 
5 
7 
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments. 
5 
8 
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table. 
5 
9 
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places. 
10 
10 
Apply a custom number format to cell L2 to display Amount of Payment. 
5 
11 
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%. 
5 
12 
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%. 
5 
13 
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%. 
5 
14 
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results. 
5 
15 
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order). 
5 
16 
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible. 
5 
17 
Use the purchase price and down payment as changing variable cells. 
5 
18 
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000. 
5 
19 
Set a constraint for the interest rate, which must be at least .03. 
5 
20 
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet. 
5 
21 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0 

Total Points 
100 
Project Description:
Project Description: Project Description: Project Description:
You are budgeting for the purchase of a new automobile. You are evaluating your expenses to determine the monetary resources available for a monthly payment. As part of the project you will perform WhatIF Analysis and complete an amortization schedule.
You are budgeting for the purchase of a new automobile. You are evaluating your expenses to determine the monetary resources available for a monthly payment. As part of the project you will perform WhatIF Analysis and complete an amortization schedule.You are budgeting for the purchase of a new automobile. You are evaluating your expenses to determine the monetary resources available for a monthly payment. As part of the project you will perform WhatIF Analysis and complete an amortization schedule.You are budgeting for the purchase of a new automobile. You are evaluating your expenses to determine the monetary resources available for a monthly payment. As part of the project you will perform WhatIF Analysis and complete an amortization schedule.
Instructions:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
For the purpose of grading the project you are required to perform the following tasks:
Step 
Instructions 
Points Possible 
1 
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name. 
0 
2 
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4. Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31. 
5 
3 
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table. 
7 
4 
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format. 
4 
5 
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium. 
4 
6 
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31) 
5 
7 
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments. 
5 
8 
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table. 
5 
9 
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places. 
10 
10 
Apply a custom number format to cell L2 to display Amount of Payment. 
5 
11 
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%. 
5 
12 
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%. 
5 
13 
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%. 
5 
14 
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results. 
5 
15 
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order). 
5 
16 
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible. 
5 
17 
Use the purchase price and down payment as changing variable cells. 
5 
18 
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000. 
5 
19 
Set a constraint for the interest rate, which must be at least .03. 
5 
20 
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet. 
5 
21 
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 
0 

Total Points 
100 
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints Possible
1
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name.
0
2
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4.
Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31.
5
3
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table.
7
4
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format.
4
5
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium.
4
6
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31)
5
7
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments.
5
8
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table.
5
9
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places.
10
10
Apply a custom number format to cell L2 to display Amount of Payment.
5
11
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%.
5
12
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%.
5
13
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%.
5
14
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results.
5
15
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order).
5
16
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible.
5
17
Use the purchase price and down payment as changing variable cells.
5
18
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000.
5
19
Set a constraint for the interest rate, which must be at least .03.
5
20
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet.
5
21
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0
Total Points
100
1
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name.
0
1
1
111
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name.
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name.
Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing “LastFirst” with your name.Download and open the file named exploring_e06_grader_a1.xlsx, and then save the file as e06c2auto loan_LastFirst, replacing exploring_e06_grader_a1.xlsxe06c2auto loan_LastFirst“LastFirst” with your name.
0
0
0
2
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4.
Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31.
5
2
2
222
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4.
Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31.
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4.
Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31.
Use Goal Seek to set the monthly payment of the auto loan to $305.69 (15% of available capital) by changing the purchase price in cell E4.
Beginning in cell G3, complete the series of loan amount values ranging from $16,000 to $30,000 in $500 increments in cells G3:G31.$305.69
$16,000
5
5
5
3
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table.
7
3
3
333
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table.
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table.
Enter references for monthly payment, percent of total, and insurance premium in the cell H2, cell I2, cell J2 respectively for a onevariable data table.
7
7
7
4
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format.
4
4
4
444
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format.
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format.
Complete the onevariable data table using Amount of Loan as the column input cell, and then ensure the results for monthly payment and insurance premium are formatted as Accounting Number Format with two decimal places. Format percent of available income as Percentage Number Format.
4
4
4
5
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium.
4
5
5
555
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium.
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium.
Apply custom number formats to make the formula references appear as the following descriptive column headings: H2Monthly Payment, I2% of Available Income, J2Insurance Premium.Monthly Payment% of Available IncomeInsurance Premium
4
4
4
6
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31)
5
6
6
666
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31)
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31)
Copy the loan amount values from the onevariable table into the twovariable table starting in cell L3 (Hint: copy the loan amount values from G3:G31)HintHint
5
5
5
7
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments.
5
7
7
777
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments.
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments.
Type 3.00% into cell M2. Complete the series from 3.00% to 4.25% in .25% increments.3.00%3.00%4.25%.25%
5
5
5
8
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table.
5
8
8
888
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table.
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table.
Enter the reference to the monthly payment formula in the cell L2 for a twovariable data table.
5
5
5
9
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places.
10
9
9
999
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places.
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places.
Complete the twovariable data table using cell E7 as the row input cell and E6 as the column input cell , and then format the results with Accounting Number Format with two decimal places.
10
10
10
10
Apply a custom number format to cell L2 to display Amount of Payment.
5
10
10
101010
Apply a custom number format to cell L2 to display Amount of Payment.
Apply a custom number format to cell L2 to display Amount of Payment.
Apply a custom number format to cell L2 to display Amount of Payment.Amount of Payment
5
5
5
11
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%.
5
11
11
111111
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%.
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%.
Create a scenario named Current loan option, using amount of loan and interest rate as variable cells. Enter these values for the scenario: 25000, 4.25%.Current loan option250004.25%
5
5
5
12
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%.
5
12
12
121212
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%.
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%.
Create a second scenario named Best loan option, using the same changing cells. Enter these values for the scenario: 16000, 3.00%.Best loan option160003.00%
5
5
5
13
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%.
5
13
13
131313
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%.
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%.
Create a third scenario named Worst loan option, using the same changing cells. Enter these values for the scenario: 30000, 4.25%.Worst loan option300004.25%
5
5
5
14
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results.
5
14
14
141414
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results.
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results.
Generate a scenario summary report using the amount of loan, monthly payment, and insurance premium as the results.
5
5
5
15
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order).
5
15
15
151515
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order).
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order).
Clean up the summary report by deleting the first column, row, and information in rows 11, 12 & 13 (in that order).
5
5
5
16
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible.
5
16
16
161616
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible.
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible.
Load the Solver addin if it is not already loaded. Set the objective cell for the lowest monthly payment possible.
5
5
5
17
Use the purchase price and down payment as changing variable cells.
5
17
17
171717
Use the purchase price and down payment as changing variable cells.
Use the purchase price and down payment as changing variable cells.
Use the purchase price and down payment as changing variable cells.
5
5
5
18
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000.
5
18
18
181818
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000.
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000.
Set a constraints for the purchase price and down payment. The purchase price must be at least $16000 but no more than $18000. The down payment must be at least $500 but no more than $5000.
5
5
5
19
Set a constraint for the interest rate, which must be at least .03.
5
19
19
191919
Set a constraint for the interest rate, which must be at least .03.
Set a constraint for the interest rate, which must be at least .03.
Set a constraint for the interest rate, which must be at least .03.
5
5
5
20
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet.
5
20
20
202020
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet.
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet.
Solve the problem, generate an Answer Report, but keep the original values in the Auto Loan worksheet.
5
5
5
21
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0
21
21
212121
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Answer Report 1, Auto Loan. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.
0
0
0
Total Points
100
Total Points
Total Points
Total PointsTotal PointsTotal Points
100
100
100100100