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:

this doesnt even work wth

@ntozzfs Me too! Needed some cash so spent the last few hours searching. These guys have got instant transfers and quick approval -> bit.ly/OGKan7?=tgcmyd

How do you do this using VBA

Can you please show how you calculated "Months" from A9 down?

Example 5 years has 60 rows, and 4 years has 48 rows?

I found a way to make money online.

Check this website Money94.Com

I subscribed to the website and after 15 days using the System

I will able to make at least $500 a month. Now I am working with this system for last three months and my current income is $3000 a month, by using the system part Time. I got all the tools and training that I need to build my online business Empire. Currently I am totally focused to achieve the goal of earring at least $10,000 a month at the end of this year.

ahhh this saved me for a school assignment! thank you!

hi this is great tutorial, very clear. thanks you. just wondering what formula to use to calculate weekly rate ?

Cheers

Great tools to use!

Yes about that monthly interest calculation. Please explain as other clips use APR/12

how the hell do you download it? your website is horrible

CHEAP MORTGAGE LOANS…COMPARE NOW ONLY AT

BANKOFINVESTORS . C O M

I tried everything to get that free template – I think you should do a video on how to download your free template?

Hey dude, cool videos. Only problem for me is… now which one is the next video? — would be cool if you had one of does pop up things at the end that said "click here for next video)

THANK YOU

CAVEAT: Hi ExcelisHell, be careful of the monthly rate. If the annual rate is APR then the monthly % rate, is APR/12.= 6.5%/12=.5416%, If the annual rate is expressed as "Effective Annual Rate" then the formula is what is given in the tutorial, Monthly rate = [(1+r) ^(1/M)]-1

how do you auto populate the months e.g. 4 years should have 48 months listed

How do i calculate the present value if i have the monthly payment, interest rate and number of payment.

watched your second vid, was great only had two problems

1) when I drag down the context the #val and #num signs fill in instead

2) how do you make the months change automatically

how to calculate the beginning and ending balance ?

Why cant you just do 6.5%/12?

Can you make a affordability calculator? or if you just have the payment and you want to find the loan amount?

#VALUE!

Would love to watch the next tutorial but could not find it on you site.

Nice- well spoken!