Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(a)In the payment calculator, use goal seek to keep the payment per month at 3,000 by increasing the down payment. My question is how do
(a)In the payment calculator, use "goal seek" to keep the payment per month at 3,000 by increasing the down payment. My question is how do what values do i chose for the set cell: To Value: and by changing cell?
Property Loan Analysis 2 Payment Calculator Payment Options |4 Property Location |5 Property Cost 6 Down Payment Fullerton Payments per year Monthly Payments 12 $750,000 $75,000 $675,000 Total Payments 360 120 180 240 300 360 Interest (APR) 4.00% 3.50% $3,222.55 Loan Amount Payment (per month) 7 3.75% 8 Period (Years) 30 4.00% 9 Goal #1 : Increase Down Payment 10 Property Location 11 Property Cost 12 Down Payment 13 Loan Amount 14 Period (Years) 15 Goal #2: Lower Property Cost 16 Property Location 17 Property Cost 18 Down Payment 19 Loan Amount 20 Period (Years) 4.25% 4.50% Payments per year Total Payments 4.75% Interest (APR) 5.00% Payment (per month) 5.25% 5.50% 5.75% 6.00% Payments per year Total Payments 6.25% Interest (APR) 6.50% Payment (per month) 6.75% 7.00% 21 22Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started