Track Your Next Loan in Microsoft Excel

Bill Jelen http://www.mrexcel.com Use =PMT to figure out the monthly payment Use =ROW(A1) and copy to number the months. Use =PPMT() to calculate the principal portion of each payment Use =IPMT() to calculate the interest portion of each payment Create a quick chart * I will post show notes at http://www.mrexcel.com/tip150.shtml RELATED WEBSITE LINKS http://www.MrExcel.com … Continue reading

Track Your Next Loan in Microsoft Excel

Bill Jelen http://www.mrexcel.com Use =PMT to figure out the monthly payment Use =ROW(A1) and copy to number the months. Use =PPMT() to calculate the principal portion of each payment Use =IPMT() to calculate the interest portion of each payment Create a quick chart * I will post show notes at http://www.mrexcel.com/tip150.shtml RELATED WEBSITE LINKS http://www.MrExcel.com … Continue reading