Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed (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 22

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jeff Madura

5th edition

132994348, 978-0132994347

More Books

Students also viewed these Finance questions