Building Loan Amortisation Schedule in Excel
2,574 views · Published 14 November 2012 · 9:50 · Indexed 8 October 2026
Channel: FinTree · 2012 · Education
To know more about CFA/FRM training at FinTree, visit: http://www.fintreeindia.com For more videos visit: https://www.youtube.com/c/FintreeIndia?sub_confirmation=1 CFA | FRM | Financial Modeling Live Classes | Videos Available Globally Follow us on: Facebook: https://www.facebook.com/FinTree/ Instagram: https://www.instagram.com/fintreeeducation/?hl=en Twitter: https://x.com/askFinTree Linkedin: https://www.linkedin.com/company/fintree-education/ We love what we do, and we make awesome video lectures for CFA and FRM exams. Our Video Lectures are comprehensive, easy to understand and most importantly, fun to study with! This Video lecture was recorded by our Lead Trainer for CFA, Mr. Utkarsh Jain, during one of his live Session in Pune (India). To know more about CFA/FRM training at FinTree, visit: http://www.fintreeindia.com For more free resources and tutorials visit us at www.fintreeindia.com This video tutorial explains how to build Loan amortisation schedule in Excel. It also discusses about the behaviour of Interest expense and Principal component over the life of the loan.
More from this channel
-
1:01:44
CS Professional - Financial Management- Future Contracts- Part 1 (of 2)
-
28:31
Financial Modelling-Populating Balance Sheet - TVS Motors
-
5:54
CFA Level I- Understanding Income Statement- Part 3 (of 12)
-
2:43
CFA Level 1- Question Bank- Pure Play Beta Calculations
-
0:42
CFA Level 1- Question Bank- Impact of Operating Lease on Solvency Ratios
-
1:27
CFA Level 1- Question Bank- Impact of Inventory Turnover on Current and Quick Ratio
-
0:31
CFA Level 1- Question Bank- Exception to Retrospective Application is US GAAP
-
0:31
CFA Level 1- Question Bank-Business Risk Related Ratios