Bill Jelen
Rank: 2166 / 5440
3 selected videos
Learn Excel 2013 - "Loan Amortization Table": Podcast #1664
In the United States, Spring season is traditionally the New Home buying season. The question is: "Have you ever wanted to learn how to calculate a loan payment on your own?" Today, in Episode #1664, Bill shows us how to calculate loan payments on the Loan Amount as well as a monthly breakdown over the life of the loan using Excel 2013.
...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every...
Related topics : loan calculator payment amount / calculating loan payments in excel / amortization loan calculator in excel download
Learn Excel - Insert Functions & Loan Payments - Podcast 2022
How to discover which Excel calculation function to use. This episode shows how to use the PMT function to calculate a loan payment and how the Function Arguments helps with tricky arguments like dividing the interest rate by 12. Episode recap:
There are over 400 calculation functions in Excel.
If you don't know what function to use, click the fx button.
This button is on the Formulas tab and also to the left of the formula bar.
Type what you are trying to do and Search.
The results will show...
Related topics : loan payment calculator excel
Learn Excel 2010 - "Variable Rate Loan Payment": Podcast #1438
"I was in Milwaukee this week at the IIA Regional Conference when Heidi asked me about calculating a loan payment for a loan, with variable interest rates." Understanding that "PMT" makes this easy for a fixed rate, in today's podcast, Episode #1438, Bill shows us how to use Goal Seek to back into this answer.
Related topics : calculating loan payments in excel / interest rates loan
3 Resources