View the step-by-step solution to:

# Office 2013 - myitlab:grader - Instructions Exploring Excel Ch. 06 - A1 Project What-If Analysis Project Description: You are budgeting for the...

looking for help, someone to help me walk thru this worksheet

Ofce 2013 – myitlab:grader – Instructions Exploring Excel Ch. 06 - A1 Project Step Instructions Points Possible 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 25000 and 4.25% as the values For the scenario. Uncheck Prevent changes to change cell values. 5 12 Create a second scenario named Best loan option , using the same changing cells. Enter 16000 and 3.00% the values For the scenario. Uncheck Prevent changes to change cell values. 5 13 Create a third scenario named Worst loan option , using the same changing cells. Enter 30000 and 4.25% the values For the scenario. Uncheck Prevent changes to change cell values. 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 ±rst column, ±rst row, and inFormation in rows 11, 12 & 13 (in that order). 5 16 Load the Solver add-in iF it is not already loaded. Display the Auto Loan worksheet. Open Solver and set the objective cell For the lowest monthly payment possible. 5 17 Use the cells containing purchase price and down payment as the by 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 Updated: 07/18/2013 2 E_CH06_EXPV2_A1_Instructions.docx
Show entire document

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents