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) The upper left area of the worksheet is a Payment Calculator Use a function to calculate the monthly payment (D7) using the data provided In the Payment Calculator, use Goal Seek to keep the payment per month at $3,000 by increasing thedown payment 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 Reset the value in B6 back to $75,000 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 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 Reset the value in B5 back to $750,000 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) 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

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 12, 2024

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

image text in transcribed

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).
The upper left area of the worksheet is a Payment Calculator. Use a function to calculate the monthly payment (D7) using the data provided.
In the Payment Calculator, use Goal Seek to keep the payment per month at $3,000 by increasing thedown payment.
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.
Reset the value in B6 back to $75,000.
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.
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.
Reset the value in B5 back to $750,000.
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).
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