### Free Educational Resources

• > Exploring Excel Ch. 06 - A1 Project What-If Analysis Project
+

# Exploring Excel Ch. 06 - A1 Project What-If Analysis Project

##### Rating:
(1)
• (0)
• (0)
• (0)
• (0)
• (1)
Author: matthew stock
##### Description:

http://homework.plus/exploring-excel-ch-06-a1-project-what-if-analysis-project/

What-If Analysis

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 What-IF 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

0

2

Use Goal Seek to set the monthly payment of the auto loan to\$304.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 one-variable data table.

7

4

Complete the one-variable 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: H2-Monthly Payment, I2-% of Available Income, J2-Insurance Premium.

4

6

Copy the loan amount values from the one-variable table (range G3:G31) into the two-variable table starting in cell L3.

5

7

Type 3.00% into cell M2. Complete the series from 3.00% to4.25% using .25% increments through R2.

5

8

Enter the reference to the monthly payment formula in the cell L2 for a two-variable data table.

5

9

Complete the two-variable 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

(more)
##### Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial