Creating a Loan Amortization Schedule in Google Sheets | Easy Step-by-Step Guide

Подписаться 10 тыс.

Просмотров 5 тыс.

50% 1

This video will show you how to create a simple loan amortisation schedule in Google Sheets, with minimal effort needed! As long as you know the loan amount, the term of the loan, and the interest rate, you can create the full breakdown quickly and easily.
// SOCIAL
🌏 Follow Me On Instagram @brentcolemaninvesting
// USEFUL LINKS
✅ Dosh NZ - Best Way To Pay: dosh.nz/app and use my referral code 00030886
✅ Get $5 FREE with Sharesies (NZ/AU): sharesies.com/r/C744KD
✅ Get $45 with DoorDash: drd.sh/yzemFEO8gYRTjiKt
✅ Free Month Car Insurance coveinsurance.co.nz/referred/...
✅ Get $10 FREE with Hatch Invest (NZ): app.hatchinvest.nz/share/hmwy...
✅ Hnry (NZ) Free $25 Freelance Accountant: app.hnry.io/r/BRENT82488
// TIMESTAMPS
► 0:00 Intro
► 0:24 Creating the Schedule
► 6:10 2nd Example - Switching Monthly to Weekly Repayments
► 6:40 Concluding Remarks
► 7:08 Outro
Disclaimer:
I am not a financial adviser. This video is for education and entertainment purposes only. Seek professional help before making any investment decision.
Song: Skylines - Anno Domini Beats
RU-vid Studio Copyright Free Music

Опубликовано:

4 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 25

@andrewbalazs7422 9 месяцев назад

refreshingly straightforward yet very educational youtube video

@BrentColeman 9 месяцев назад

Glad you found it useful!

@EmpeyRealtySanDiego 3 месяца назад

This is amazing, thank you!!

@BrentColeman 3 месяца назад

Glad it was useful!

@Premiumcribs 8 месяцев назад

thank you so much for this well detailed video

@BrentColeman 8 месяцев назад

Appreciate the comment - glad you enjoyed it!

@jteichma Месяц назад

Great video! Appreciate it.

@BrentColeman Месяц назад

Glad it was helpful!

@user-ot3ht9er8h Месяц назад

This was so helpful thank you

@BrentColeman Месяц назад

Glad it was useful!

@victoriab.3203 6 месяцев назад

Thank you

@BrentColeman 5 месяцев назад

Glad you enjoyed it!

@junjunreynoso86 10 месяцев назад

Good video. Could you do the solar power providers, pros and cons? Thanks

@BrentColeman 10 месяцев назад

Thanks for watching! Do you mean a comparison of companies selling solar power hardware?

@chellelaclare6748 4 месяца назад

Thank you for this, it's wonderful! BUT I'm trying to figure out what I did wrong here? The rates show up properly descending in interest and ascending in principal amounts as you go down the columns, and ends with the final payment being almost all principal, just $3.72 in interest in the final payment, BUT the Principal column stays the same down the entire column, it does not descend in value as you go down the column, it stays at $79,200 all the way down. :-/ I'm having to type in the dollar signs instead of F4, perhaps I wasn't supposed to somewhere along the line? In one place (interest field A10) you said NOT to lock it for one of the values, so I tried it both with and without the dollar signs (left it without them, as shown on yours) and it didn't seem to make a difference. Yikes, I’m pretty sure I did exactly what you said, but I seem to have messed up somewhere. Any help is greatly appreciated! (Wish I could attach a screenshot!)

@Alacarta-ji4vn 8 месяцев назад

I've seen car loans with fixed anual payments on top of the installments to lower the installment payments, how do you calculate the installments for this types of loans?

@BrentColeman 8 месяцев назад

Heya! I made a video a while back that explored making additional principal payments on top of the schedule, to reduce the loan term itself. To lower the repayments, this would be a restructured loan in New Zealand that often incurs a small fee. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GBU-AkWXxL8.html Alternatively, you could use this calculator and check at monthly installment #12 what the principal is at that point. You could then reinput the loan details into the calculator, however with a term of (n-12), and repeat this for the number of years the loan will run. Each time you rerun the numbers you'll see how the repayments would change. Hope this helps!

@gregorymalachilittle681 3 месяца назад

Why is "present_value" for the IPMT formula not B9 then carried down since the balance is decreasing? I know the way you show is correct, I'm just trying to understand it better. Thanks!

@BrentColeman 18 дней назад

Heya! Sorry for the late reply. The formula has a component that looks at the 'instalment' number. So it automatically determines the variable nature of interest costs as the loan amortises. If I was doing a specific interest calculation between dates (e.g. rate/365 * running balance * days between periods), then I'd have selected B9 and dragged the formula down. Hope this helps!

@patriciabomar8059 7 месяцев назад

What button are you referring to at the 4:01 mark in cell C10? I cannot understand what you're using to lock the formula?

@BrentColeman 7 месяцев назад

Heya! I am pressing the F4 key, which locks cells in Excel/Sheets. Here is a link explaining more: edu.gcfglobal.org/en/excel-tips/absolute-references-with-the-f4-key/1/ . Hope this helps!