Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Why can't goal seek find the solution? Am I doung something wrong? when I use goal seek I put down Set Cell: D7 To Value:

image text in transcribed
Why can't goal seek find the solution? Am I doung something wrong?
when I use goal seek I put down
Set Cell: D7
To Value: 3000
By changing cell: $B$6
And it says that it cant find the solution. What am i doing wrong?
Property Loan Analysis Payment Options Monthly Payments 180 240 120 300 360 12 360 400X 3222 55 3.50% 3.75% Goal Seek Status X 12 Step 360 Goal Seeking with Cell 07 may not have found a solution. Target value 3000 Current value: 3222.55 4.00% $3,222.55 Pause OK Cancel Payment Calculator Property latin Fullerton Payments per war Preity Cont $750,000 Total Payments Down Payment Interest (APR) Icon Amount $675,000 Payment per month Perkad (Years) 30 Goal 01: Increase Down Payment Party Location Fullerton Payments per year nyerty Cost $750,000 Total Payments 2 Down Payment $75,0X10 Interest (APR) 3 loan Amount $675,000 Pryment per month 4 Period (Year) 30 5 Goal 2: Lower Property Cost 6 Party Location Payments per year 7 Property Cout Total Payments 28 Down Payment Interest (APR) 19 toon Amount Payment per month 20 Perlod Years 21 22 23 24 25 26 27 Property 6.25% 6.50% 6.75% 7.00% Ready CS Scanned with CamScanner I Type here to search ORI 62F

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

Financial Sorcery Magical Strategies To Create Real And Lasting Wealth

Authors: Jason Miller

1st Edition

1601632185, 9781601632180

More Books

Students also viewed these Finance questions