# How to make a Set Fee Mortgage/Property finance loan Calculator in Excel

This online video tutorial will display you how to make a preset rate personal loan or home loan calculator in excel. It is in fact fairly easy to do and right after looking at this step-by-step case in point and stroll-by means of, you will be able to make your very own also. This tutorial utilizes the PMT() function to estimate the necessary payments and it is also discussed in the tutorial.

To abide by together with the spreadsheet witnessed in the tutorial or to get some no cost excel macros or suggestions & tricks, go to the web site:

1. can't find your video that explains how you make excel add more rows with the corresponding formula in each, based on the "Term" value given.

2. i turn \$250 to \$1850 overnight with BinaryRobox get 100% free access at: facebook.com/binaryrobox/app/190322544333196/ it's certified and legit binary option robot 4 trading with winning average of 88% and up. Search on Google for binaryrobox

3. Nice- well spoken!

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

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

7. Why cant you just do 6.5%/12?

1) when I drag down the context the #val  and #num  signs fill in instead
2) how do you make the months change automatically

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

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

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

12. THANK YOU

13. 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)

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

15. CHEAP MORTGAGE LOANS…COMPARE NOW ONLY AT
BANKOFINVESTORS . C O M

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

18. Great tools to use!

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

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

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