How To Create A Loan Amortization Table In Excel

  Рет қаралды 1,030

Pete - HowToAnalyst

Pete - HowToAnalyst

Күн бұрын

Пікірлер: 10
@nicknicolay972
@nicknicolay972 2 жыл бұрын
Great info. Can’t wait for the next one.
@HowToAnalyst
@HowToAnalyst 2 жыл бұрын
Coming soon!
@KyleSorenti
@KyleSorenti 2 жыл бұрын
I’m building one because I’m spending beyond my means on material items. I rationalize these decisions by acting like these items bring me happiness, but in the end, they never really do. Unrelated fun fact, the upgraded seats in the 2023 Ford Raptor are super tear absorbent
@HowToAnalyst
@HowToAnalyst 2 жыл бұрын
I want to take a ride!
@benfithian659
@benfithian659 2 жыл бұрын
Crazy that almost 90% of that first payment is just going towards interest on the loan and barely reducing the principal. Curious to know how much total interest was paid for borrowing $200k over 30 yrs @7%. Thanks for insightful video, Pete.
@HowToAnalyst
@HowToAnalyst 2 жыл бұрын
It is crazy Ben, actually going to calculate total interest for a mortgage payment in a few videos!
@RealwithAida
@RealwithAida Жыл бұрын
Dayum
@HowToAnalyst
@HowToAnalyst Жыл бұрын
Hopefully it helped!
@RealwithAida
@RealwithAida Жыл бұрын
Yes it did! I was wondering how I could add a formula for EXTRA principle payments ❤
@HowToAnalyst
@HowToAnalyst Жыл бұрын
@@RealwithAida check this one out - kzbin.info/www/bejne/jZWWmoedrLCZmcU
Microsoft Excel/Google sheets: Learn to create a loan amortization schedule
10:51
Luther Maddy - Helping Humans Learn
Рет қаралды 2,4 М.
How To Create an Amortization Table In Excel
11:01
The Organic Chemistry Tutor
Рет қаралды 526 М.
The Lost World: Living Room Edition
0:46
Daniel LaBelle
Рет қаралды 27 МЛН
How to build an Amortization table in EXCEL (Fast and easy) Less than 5 minutes
4:50
I Hate Math Group, Inc
Рет қаралды 1,4 МЛН
Amortization Schedule Car Loan Breakdown
10:13
Diamond Edwards
Рет қаралды 12 М.
What are Principal Payments and How Can They Help You...
6:22
Diamond Edwards
Рет қаралды 53 М.
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,6 МЛН
How Principal & Interest Are Applied In Loan Payments | Explained With Example
3:49
Real Estate Finance Academy
Рет қаралды 210 М.
How To Create Graphs For A Loan Amortization Table
5:46
Calon Heindel
Рет қаралды 7 М.