Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment

Download file: http://people.highline.edu/mgirvin/
Learn how to use Goal Seek to change a formula input to cause a formula to evaluate to set amount. Goal Seek is like a "reverse" formula because we tell the formula what we want it to evaluate to and Goal Seek changes the formula input. Learn how to use the PMT function to calculate a loan payment with a 15% down requirement and a balloon payment at the end.

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2010
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Slaying
• Dragons
• Goal
• Seek
• to
• change
• formula
• input
• cause
• evaluate
• set
• amount
• PMT
• function
• calculate
• loan
• payment
• with
• 15%
• down
• requirement
• and
• balloon
• at
• the
• end

[npGuerreiro]

Can't say enough how much your videos have helped me. This one plus the Data Table videos were definitely what I needed for my exam preparation, thanks!

[ExcelIsFun]

You are welcome!

[dankroberto]

Dude I love your videos, Im in a CIS class in college and this is exactlly the stuff that we are going over. I love your videos man they save me so much frustration and hair ripping. THANKS MAN

[ExcelIsFun]

You are welcome!

[sov19871987]

Thank you. Great video.

[ExcelIsFun]

You are welcome!

[hanakox2]

thanks for your lesson :D

I want to change the pmt from -1563,19usd to -2000usd (in condition that the others the same) but only the Down price changed, so i used goalseek but i can not change the Down price (it said that the cell have to contain the value), what is the promblem and how can i fix that?