excelisfun | Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21 @excelisfun | Uploaded 1 year ago | Updated 3 hours ago
Download Excel File: https://excelisfun.net/files/21-M365ExcelClass.xlsx
Pdf notes: https://excelisfun.net/files/21-M365ExcelClass.pdf
Learn how to build Mortgage Loan Schedule to break out interest and principal reduction from a loan payment. Theis same schedule works on Corporate Bonds to help record Interest on Income Statement6 and Principal Reduction on Balance Sheet.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:30) Build Mortgage Loan Schedule to break out interest and principal reduction from a loan payment using Standard Formulas and the PMT Function.
3. (10:25) Build Mortgage Loan Schedule with Dynamic Spilled Array Formulas. See the Functions SEQUENCE, IPMT, CUMPRINC and VSTACK.
4. (15:15) Video Summary and Conclusions
5. (15:30) Closing and Video Links

Song in video: Rock Intro 3 by Audionautix is licensed under a Creative Commons Attribution 4.0 license. https://creativecommons.org/licenses/by/4.0/ . Artist: http://audionautix.com/

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #finance #accounting #mortgage #mortgageinterestrates #mortgagesolutions