1. Re-save the file to either your desktop or other storage device using the name?firstName_LastName_L4_Titan_Property?. (Note?firstName?and?LastName?are your own first and last names).

2. The upper left area of the worksheet is a Payment Calculator. Use a function to calculate the monthly payment (D7) using the data provided.

3. In the Payment Calculator, use ?Goal Seek? to keep the payment per month at $3,000 by increasing thedown payment.

4. Copy the info from B4:B8 and paste to cells B10:B14. Copy D4:D7 and paste to D10:D13. Note: Remember to use ?Paste Special? and use Values and Number Formats.

5. Reset the value in B6 back to $75,000.

6. Perform a second ?Goal Seek? in the Payment Calculator again keeping the payment per month at

   $3,000 this time by lowering the property cost.

7. Copy the info from B4:B8 and paste to cells B16:B20. Copy D4:D7 and paste to D16:D19. See note in

   step 4.

8. Reset the value in B5 back to $750,000.

9. The upper right area of the worksheet will display the Payment Options. Create a two-variable Data

   Table to show the monthly payment for each of the interest rates by the number of monthly payments.(Note: all values in each cell will be different. If they aren?t, you can erase the table by highlightingcells H6: L20 and deleting them).

10. Format the numbers in your Data Table so the that top row is Accounting Style with 0 decimal places and the remaining numbers are Comma Style with 0 decimal places.

?

Transcribed Image Text:

Home Edit aste A1 A Fill ▼ Layout Clear ▾ Property Location Property Cost Down Payment 1 Property Location Property Cost Down Payment Loan Amount Period (Years) + Tables Calibri Light (He... 18 BIU Charts Font Loan Amount Period (Years) Goal # 1: Increase Down Payment Property Location Property Cost Down Payment Loan Amount Period (Years) Goal #2: Lower Property Cost Payment Calculator Fullerton Payments per year $750,000 Total Payments $75,000 Interest (APR) $675,000 30 X ✓ (= fx Titan Off-Campus Shops B T C | Payment (per month) Payments per year Total Payments Interest (APR) Payment (per month) SmartArt Payments per year Total Payments Interest (APR) Payment (per month) A- A+ A D 12 360 4.00% Formulas Data Alignment abc += Review Wrap Text E G Titan Off-Campus Shops Property Loan Analysis 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% Merge ▾ 6.75% 7.00% H 120 General Ke T IM % 9 I Number 180 T 4.0 .00 J Payment Options .00 .0 Monthly Payments 240 ES Conditional Formatting K 300 Format Title Total L 360 M N 1 EH Insert O Cells D XI. 24 Delete P Format Q Themes Aa Themes Aa R S T Home Edit aste A1 A Fill ▼ Layout Clear ▾ Property Location Property Cost Down Payment 1 Property Location Property Cost Down Payment Loan Amount Period (Years) + Tables Calibri Light (He... 18 BIU Charts Font Loan Amount Period (Years) Goal # 1: Increase Down Payment Property Location Property Cost Down Payment Loan Amount Period (Years) Goal #2: Lower Property Cost Payment Calculator Fullerton Payments per year $750,000 Total Payments $75,000 Interest (APR) $675,000 30 X ✓ (= fx Titan Off-Campus Shops B T C | Payment (per month) Payments per year Total Payments Interest (APR) Payment (per month) SmartArt Payments per year Total Payments Interest (APR) Payment (per month) A- A+ A D 12 360 4.00% Formulas Data Alignment abc += Review Wrap Text E G Titan Off-Campus Shops Property Loan Analysis 3.50% 3.75% 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% Merge ▾ 6.75% 7.00% H 120 General Ke T IM % 9 I Number 180 T 4.0 .00 J Payment Options .00 .0 Monthly Payments 240 ES Conditional Formatting K 300 Format Title Total L 360 M N 1 EH Insert O Cells D XI. 24 Delete P Format Q Themes Aa Themes Aa R S T

Answer rating: 100% (QA)

Titan OffCampus Shops Property Loan Analysis Payment Calculator Payment Options Property Location Fu... View the full answer