Use Goal seek on the loan amount of $825,000.  You would like the monthly payment to be $4500.00.  Find a solution for new term

 

Transcribed Image Text:

Loan Amount $700,000.00 $825,000.00 Interest Rate 7.50% 7.50% Term 30 30 Monthly Payment $4,894.50 $5,768.52 Goal Seek Solution New Loan amount Term Interest Rate 643579.32 5.14% Loan Amount $700,000.00 $825,000.00 Interest Rate 7.50% 7.50% Term 30 30 Monthly Payment $4,894.50 $5,768.52 Goal Seek Solution New Loan amount Term Interest Rate 643579.32 5.14%

Answer rating: 100% (QA)

GOALSEEKmonthly payment cell 4500 term cell This will use Goa... View the full answer