How to make a Fixed Rate Loan/Mortgage Calculator in Excel
Loading...
Uploaded by ExcelisHell on Sep 12, 2008
http://www.TeachMsOffice.com
This video tutorial will show you how to make a fixed rate loan or mortgage calculator in excel. It is actually quite easy to do and after watching this step-by-step example and walk-through, you will be able to make your own also. This tutorial uses the PMT() function to calculate the required payments and it is also explained in the tutorial.
To follow along with the spreadsheet seen in the tutorial or to get some free excel macros or tips & tricks, go to the website:
http://www.TeachMsOffice.com
- 32 likes, 1 dislikes
-
Link to this comment:
Uploader Comments (ExcelisHell)
All Comments (22)
-
This video was very interesting... well done. Check out my Mortgage rate calculator video if you get chance.
-
Good for you. Well done.
-
Test
-
interesting
-
thanks for the video
-
that s how I play bowling
-
where is the second part of this tutorials can you show it plzzzzzzzz.thank a lot i'll wait the part of this tutorials
- 8:06Excel PMT() Function Basicsby peterdcasey2,279 views
Featured Video
- 5:11How to find Interest & Principal payments on a ...by ExcelisHell25,054 views
- 4:10Get the Net Present Value of a Project Calculat...by ExcelisHell65,738 views
- 7:12Calculate Value of Savings/Retirement Plan in E...by ExcelisHell7,948 views
- 9:57Bond Pricing, Valuation, Formulas, and Function...by ExcelisHell27,521 views
- 6:54Consolidating Data from Multiple Excel Workshee...by DannyRocksExcels18,807 views
- 10:28How to Make Your Own Weight Watcher Calculator ...by TarotLadyLissa27,060 views
- 5:12Use Goal Seek in Excel to Structure Your Loanby DannyRocksExcels9,027 views
- 9:19How To Calculate A Loan Payment & Principal Rem...by nextlevelpurchasing4,051 views
- 1:37Mortgage Loan Calculator - Part 1by VeryRecomended6,398 views
- 5:30Loan Calculator and Amortization Templateby yourtwobits4,091 views
- 2:48How to use a mortgage calculatorby craigthelender14,810 views
- 2:18Calculate a Loan Paymentby MrExcel32,558 views
- 3:43Re: Mortgage payment calculations formulaby mathproblems7,540 views
- 0:52How to protect your excel sheet by locking cellsby lautatlee18,760 views
- 9:59Loan Payment Formulaby gscoic13,308 views
- 0:42Fun Mortgage Calculatorby QuizTree8,265 views
- 7:54Amortization Schedule - Interest Paid, Principa...by REALPROforWindows4,072 views
- 4:44Loan amortization scheduleby westofvideo7,433 views
- 5:53Low Interest Rate Mortgage Myths Revealed, what...by VictorBeatteay5,704 views
Why do you use the formula for monthly interest payment if it is a fixed rate loan? When I compare your answer to an online mortgage calculator, it comes out that they just use yearly interest/12 for the monthly interest, not the whole "compounded" formula you have in there. Thanks.
samse15 1 month ago
@samse15 It all depends on the type of calculation that you want to make. And there are many different ways to make a mortgage calculator in Excel.
ExcelisHell 1 month ago
I really like this spreadsheet. Thanks for posting.
Here is my situation...hope you can help. These are for my school loans and I have started making payments before they are due (2016). I would like to incorporate these payments showing what was applied to the principal and interest and how much is left to pay.
lichandler 1 year ago
@lichandler Replied via personal message on here.
ExcelisHell 1 year ago
thanks for the post sir.
question
if a person got a 30 year loan say for $100,000 payments around $600
If a person makes the next prinipal payment each month.
also, if a person makes an extra whole payment at the first of each year.
also, if a person can set it up on a bi-weekly plan
how far will that reduce the loan.
altha2008 1 year ago
@altha2008 A lot lol. I'm sorry but I can't do your homework for you. Though, If you have a real problem that you need to calculate you can private message me.
ExcelisHell 1 year ago