Excel Magic Trick 1007: Loan PMT Semi-Monthly Schedule: A Few Finance and Date Tricks

Описание к видео Excel Magic Trick 1007: Loan PMT Semi-Monthly Schedule: A Few Finance and Date Tricks

Download Excel Start File: https://people.highline.edu/mgirvin/Y...

Download Excel File: http://people.highline.edu/mgirvin/Ex...
Learn these things:
1. How to use PMT function
2. Period rate calculation
3. Cash flow direction: negative or positive
4. Fill Handle Smart Tag to fill dates by month: this allows to to populate a column with only dates at the 15th of each month, or the end of the month.
5. EDATE function to increment dates for the 15th of each month with a formula.
6. EOMONTH function to increment dates for the end of each month.
7. Absolute and relative cell references.
8. Build a semi-monthly amortization table.

Комментарии

Информация по комментариям в разработке

Похожие видео