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 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.