Very Simple Amortization Table in Excel

This short video shows how to easily create a simple amortization table in Excel.

[@JSark-by2ts]

Great job Maggie! You communicate in a very intelligent manner. Thank you.

[@jackjackjackjack4527]

omg thank you so much Maggie, you helped me ace my finance exam

[@tomwells936]

Perfect! Exactly what I was looking for. Thank You!

[@lone9585]

Thank you!

[@meizhang8522]

It is great! I did right at the first time! Thank you Maggie!

[@naskkal4047]

Thank you very much!!

[@simulation001]

Hey! Great video! Is it possible I could change ten years into months and it wouldn’t effect anything?

[@cradleofrelaxation6473]

Thanks ma’am. Can you show manually how the amount is calculated?

[@MrPoiuy99]

Does the investment show up as a negative value in the function bar on top of the sheet?

[@Inlearningmode]

Thanks you

[@OriginalPrincess32]

How come when i drag mine, nothing happens? Is something up with my settings.

[@muhammadobaidullah561]

Cool

[@wheresthekaas]

how do I do it if my interest is compounded monthly and not annually

[@gaz2002]

Yes, want to know the same, the payment periods

[@kenara]

You need to divide the interest rate by 12 and multiply the number of years by 12