How to make a Fixed Rate Loan/Mortgage Calculator in Excel

[mortgageratecalculat]

This video was very interesting... well done. Check out my Mortgage rate calculator video if you get chance.

[VFRodriguez]

Good for you. Well done.

[vijaykhubchandani]

Test

[samse15]

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.

[ExcelisHell]

@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.

[grupotusolucion]

interesting

[calcularhipoteca]

thanks for the video

[xzy113]

that s how I play bowling

[110mhay]

where is the second part of this tutorials can you show it plzzzzzzzz.thank a lot i'll wait the part of this tutorials

[110mhay]

where is the second part of this video...how can i add..down



[jeffrykevans]

Nice combo of mortgage calculator and amortization schedule, nice work.

[mortgagecalculator12]

This is an awesome idea. Theres also a lot of excellent pre-made mortgage calculators online. I find that the FREE variety and quality of the ones at mortgagecanadacalculator.ca are great for whatever information you're looking for! They also post the current rates which is helpful :)

[lichandler]

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.

[ExcelisHell]

@lichandler Replied via personal message on here.

[altha2008]

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.

[ExcelisHell]

@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.

[c6cole]

Where can I get the 2nd part to this video? I cant find it or the excel download on the site. :( Thanks

[ben75h]

Thanks Bro, You are great teacher. I wish I had you as my good teacher before. Again, thank you very much!!

[adityagusman]

many thanks for the video, it helps me a lot. I didn't know about the PMT function before.