Use Goal Seek in Excel to Structure Your Loan

[zxcvbnmmasdfghjkl]

you did it three different times, is there a way to do it all in one or would you have to do all three separately like you did?!?!?!

[DannyRocksExcels]

@zxcvbnmmasdfghjkl

With Goal Seek, you can only change one variable at a time. So, in this case, I copied the cells to create 3 scenarios - changing, 1 at a time the Interest Rate, the amount borrowed and the number of payments.

In Excel, you can use the SCENARIO Manager to create a multiple variable Report. Typically, with Scenario Manager, you would create a "Best Case, Worst Case, Case Most Likely" Report. I have a few videos here that demonstrate Scenarios.

Danny Rocks

The Company Rocks

[nita098]

great example! thanks a lot :)

[DannyRocksExcels]

@nita098

Thank you! I am pleased that you liked the video tutorial.

Danny Rocks

The Company Rocks

[DannyRocksExcels]

@nita098

Thank you! I am pleased that you liked the video tutorial.

Danny Rocks

The Company Rocks

[gammaphoton]

Danny I find your videos very helpful. You have not made a video for Solver. I have a suggestion that I think your viewers will find helpful. I have a small spread sheet of my credit cards balance, % interest and payments. The Solver finds the minimum interest total from all the accounts to get all balances to zero. What I found is that paying off the highest interest rate card off first does not give you the smallest total interest paid. I am eager to see what you come up with.

[DannyRocksExcels]

@gammaphoton

I apologize for the late response.

Solver is one of the videos that I am planning to produce in the near future.

Danny Rocks

The Company Rocks

[ericdmann]

Another great tutorial!

[DannyRocksExcels]

@ericdmann

Thank you for letting me know that this helped you.

Please spread the word to your friends and colleagues.

I invite you to visit my website - thecompanyrocks - to view all of my training resources.

Danny Rocks

The Company Rocks

[MaksKelemina]

Awsome!

Can you post PMT function in reverse for retirement monthly income

[77mazinger]

Your instruction is very easy to follow. Thanks so much.

[wa82001]

Great Tutorial, Helped me out a lot

Thank You!

[tirathmistry]

Excellent tutorial

Very well use of Goal Seek function and awesome explanation with awesome example.

[DannyRocksExcels]

Thank you for your feedback. I try my best to include relevant examples in my teaching.

It is not sufficient to just understand "how" to use an Excel technique. You must understand "when" to use it and "why" it matters - to your audience.

I'm pleased that this lesson has helped you.