How to make a loan amortisation schedule using dynamic array in MS Excel

In this video I explain how to build a debt amortisation schedule using dynamic array in Microsoft Excel which would automatically insert columns based on loan's repayment tenure

[@PraneethGala]

Amazing content... Thanks sir! 👍🏼

[@nikhilchowdhary8919]

Too good.. Keep posting sir, its really helpful..

[@venkatasivakrishnaabburi3633]

Sir, what if we have multiple debts including senior debts, revolvers. Do each kind we should have schedules ? How dynamic arrays handle this multiple debts as we will have multiple rate of interests, pmts, PV, and nper

[@ProfectusLearning]

That can be done but it is a bit more advanced and we need to use vector operations and it also requires a bit of advanced mathematics.

[@venkatasivakrishnaabburi3633]

@@ProfectusLearning can we expect these peculiar things to be covered in the course.