Excel Forum
Similar Content
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
Create a Custom Function in Excel - UDF
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Get User Submitted Data from a Prompt in Excel using VBA Macros
Tutorial: How to prompt a user for their input in Excel. There is a simple way to do this using VBA ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.





Got a Question? Ask it Here in the Forum.