1. Re-save the file to either your desktop or other storage device using the namefirstName_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 arent, 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.

U NU! UU SU LUUD 22 - EP 000 Font Number Format Cells Themes Title Fill - Clear EE General Merge - $ % , oO Total Formatting Insert Delete Format Themes Aa' I J K L M N O P Q R S T Home Layout Tables Charts SmartArt Formulas Data Review Edit Alignment , Calibri Light (He... - 18 - A- A- = = = abc Wrap Text Este B 1 y 2. SA A1 % fx Titan Off-Campus Shops A B C D E F G H Titan Off-Campus Shops Property Loan Analysis Payment Calculator Property Location Fullerton Payments per year Property Cost $750,000 Total Payments 360 120 Down Payment $75,000 Interest (APR) 4.00% 3.50% Loan Amount $675,000 Payment (per month 3.75% Period (Years) 4.00% Goal #1: Increase Down Payment 4.25% Property Location Payments per year 4.50% Property Cost Total Payments 4.75% Down Payment Interest (APR) 5.00% Loan Amount Payment (per month) 5.25% Period (Years) 5.50% Goal #2: Lower Property Cost 5.75% Property Location Payments per year 6.00% Property Cost Total Payments 6.25% Down Payment Interest (APR) 6.50% Logn Amount Payment (per month) 6.75% Period (Years) 7.00% Payment Options Monthly Payments 180 $750.000 240 300 360 30 ET