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:

Amanda fthis doesnt even work wth

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

yungstud171How do you do this using VBA

David AtwellCan you please show how you calculated "Months" from A9 down?

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

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

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

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

Cheers

Benjamin YoccaGreat tools to use!

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

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

Nilli PatelCHEAP MORTGAGE LOANS…COMPARE NOW ONLY AT

BANKOFINVESTORS . C O M

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

agentmaster47Hey 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)

Clarence FrazierTHANK YOU

marieearthangelCAVEAT: 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

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

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

Richard Vargaswatched 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

shurui siahow to calculate the beginning and ending balance ?

GoVir4lWhy cant you just do 6.5%/12?

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

Salish-sea#VALUE!

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

Jay DempseyNice- well spoken!