Mortgage Amortization Worksheet
Please share this video and the free mortgage amortization calculator using the links below!
I made a quick last-minute addition to this mortgage amortization spreadsheet download – watch the short video to get details below:
*You will need Excel but this should also work in Open Office
This just what I was looking for. Thank you.
Great Tool to have, Thanks
You’re welcome, Joseph!
Daniil, I’ve not bought your goods yet, because immediately prior to learning about your obviously excellent software, I bought quite a bit of other people’s stuff. Gotta wait for a year or so…
Anyway, I plan on buying your’s later on. Do not despair, my friend!
Hi Frank! Sounds great! We look forward to you becoming a premium member in the near future!
These are very powerful tools for anyone in the Real Estate and Mortgage business Thank you for these 2 great softwares Daniil.
I have been trying to find a mortgage amortization worksheet with no success until now.Thank You very much.In fact the timing is perfect
Daniil; it has been a couple months since i bought premium evaluator,although i did not get on board yet with any propertys,i went back over all the videos and pages,because i am a newbe at real estate ,these programs are awesome, the more i go over it ,time after time,i get more amazed every time,thank you for bringing this in to the educational world of real estate, this will speed up my effort and time and make me look like SUPERMAN,
This is one of the coollest tools I’ve seen/
Hey Jerome Heuser
Tell me the state and county where you would like to get a deal and I’ll show you the coolest site on the net for gertting deals.
email me at email@example.com and let’s get you started.
Thanks. Nice software. I am using it in open office with no problems so far.
Thanks daniil Kleyman I have just begone to undertake my real estate venture. And I like everything that you are offering to assist me in my endeavor. I will contact you soon with more questions.
Hey, thanks for the amortization calculator – nifty little tool to have around !
You never stop sharing! And what you share is above and beyond what most folks out there do. You build and share the tools that are waaaay above par, and put in video format, the education on how to use and implement the knowledge gained. Thanks a Billion! May the Lord continue to bless and prosper you and your businesses!
Daniil Kleyman thank you very much. It will help me a lot figuring out monthly payments on my deals.
Hi Daniil, As always you are thinking of us and ways to speed up our processes. I love reading all the comments. As for sharing this program all I see is a like button not a video share for Facebook.This amortization worksheet everyone can use investors and non-investors. One question, about the adjustable loans (TCM) or the (Libor) when you finally get rental and rehabvaluator online will these indexes updates automatically along with index history’s or should we look them up and fill them in. Daniil thanks again for another great presentation, explanation and keeping us informed. I see a Daniil Kleyman community here. Way to go!! Happy Holidays to you and your family.
Having owned my own mortgage corp. and also saw it crash, I missed not having this handy tool Thanks Dick Konetchy
Thanks again!!!! YOU ARE THE MAN!!!!!!!!!
Nice to hear from you again! As to your question, once we get our software online I will look into getting historical data for these indexes into our system. As far as making projections for the future and for where interest rates will be, that’s always a shot in the dark 🙂
Happy Holidays to you as well, Vince, and to anybody reading this! Daniil.
Daniil == I can tell you sure are having fun. All of your stuff is great. thank you for the amount of time you are saving me..
Daniil you have always been a God giving Real Estate Investor always trying help those who may need help taking care of there business. God sees you my brother and he’s pleased. In order to receive you have to give and every since I’ve been knowing you, you always been trying to help other Real Estate Investor. May God Bless You Mr. Daniil Kleyman
MERRY! CHRISTMAS! AND HAPPY! NEW YEARS! TO YOU! AND YOUR FAMILY! Mr. Daniil Kleyman.
Looks good, Thanks
Hope to use this soon.
this is a great video
thank for the program very good tool s ellis
This is useful for me and my clients. Good job. Thank you
great tool to show investors when getting funding.
Thank you Daniil,
With this not only I’ve learned how the Mortgage program works,
but when I start to explain this to my potential client, it will sound like they’re
hearing it from a real professional.
Thank you so much.
Thanks for the amortization worksheet, Daniil. I use an interest only for the first 60 months, and unlike many amortization programs, yours is so flexible that it allows me to modify the schedule anyway I want. I did notice that when I unprotect the schedule and make the first 5 years the same it does not reflect that in the graph or the summary, though.
Thanks for another great tool.
I must say I love the software you are sending. I am an investor and depend on people to send me deals that I can use. I sent your software to all my contacts so that we are all on the same page. I am located in Northern CA. If anyone would like to send deals for us to look at send them to firstname.lastname@example.org
Hi Daniil,can any of your software be implemented for entrepreneurs for raising capital other than real estate?
Don – we haven’t tried it but I suppose so. Depends on what you have in mind. Shoot me an email.
Over the years I have seen a lot of amortization spread sheets but this is the BEST!
Sometime I have what I call “Found $$$” and I want to make an extra loan payment that may match or may not match the same as the regular payment. Is there a way to apply this payment occasionally?
Also, I down loaded twice and both times got this problem:The program starts at column D. I can only see columns Q thru U by moving the curser bar and I can only print columns D thru J. Is this problem native to my system only?
Foster – glad you like it! There is way to enter a monthly prepayment there right now. You can enter a one-time prepayment by over-riding a formula in the month when you want to make the prepayment. Just unlock the sheet first (it’s not password protected).
As far as program starting in Column D – that’s correct. Unless you switch the input for Term (cell F3 to “Arm”) then columns A through C will populate. Try it.
Being able to see columns Q through U only by moving the cursor is normal. That’s how Excel works.
Daniil – Very cool! Thnx! Ralph
Thank you for this valuable tool and your voice-over adds to understanding how to use it.
Thanks for this cool tool which would come in handy for rehab / hold property and to know what your going to pay on a mortgage ahead of time.
Your great Dan, I know everyone appreciates what you share with us.
You are AWSOME!
Do you know of the website Phillip was talking about here on this post to find good deals I’m new and looking to land my 1st Deal and your program is awesome will be using it on my 1st Deal.
You are creating some much needed software for Real Estate Investors, this really is a valuable tool. Thanks for making it available.
Hi Daniil, to me it has been a useful tool I am goner use and improve my relation with my clients. I don’t have right vocabulary that fits you than to thank you.
Good Day Daniil,
I have seen lots of mortgage amortization spreadsheets but your version tops it all. It is clean, simple, user friendly and a strong tool to use for first time homebuyers as well as real estate investors. I would like to see it linked to the rehabvaluator program though for its additional feature.
I would like to take the opportunity to convey my sincere appreciation with all the trial rehabvaluator programs or even risk of sending me the full version to try, and some other useful tutorials/case scenarios sent via email. You are a very giving man with strong belief on a program that you passionately created and stands with pride of fulfillment to benefit others. You made me feel like you are my friend when we connect in facebook and see how the down to earth you are & share that ecstatic vacation time with your friends.
I’m the type of person who is always at the back of the room whenever there is a sales presentation. I do not pay a penny until it is proven worth paying. Your trial product and service has given me enough time to review and put it to a test. I found it to be very beneficial and will definitely simplify most of my legwork. Your product and services is worth every penny so I therefore conclude its importance as a tool and its primary function to my future real estate endeavor. This gave me a full motivation to engage and utilize it for my 2013 business plan. I’m ready to be on board.
I think this time, you’ve got me at “HELLO” (lol). I’m very glad to know you, friend.
Wilson dela Cruz, REALTOR®
Daniil: Thanks for the free software. I’m a bit of an Excel geek myself and really admire what you have created. I’m retired and pursuing an interest in real estate. I plan on rehabbing 1 or 2 homes per year tops; primarily to keep busy and earn a little spending money. My biggest question is how to find the best deals (I’m in the Spokane, WA market). I appreciate your videos…very informative. Thanks for all you’re doing and for sharing so much of your expertise. Rich
Hi Rich. You’re welcome! As far as your question, it really depends on your market. Different deal-sourcing strategies work in different markets. In my area, these days I am primarily sourcing deals from wholesalers (who in turn find off-market deals) and auctions. Every once in a while I find something on MLS but not as much these days. Another good source of deals is hard money lenders. Form relationships with them. They often take back properties that they need to get rid of quickly. There are of course a ton of other ways to find deals, way too many to talk about here. Hope that helps though! – Daniil
I am excited to see how this spreadsheet will work for me. Thanks alot!!!!!
This is extremely helpful and very much appreciated! Thanks so much for this free tool!
hi this is a wonderful program. good information, helped me understand mortages a lot. thankyou.
Great presentation Daniil. Thanks for allowing the download. I can always use a good tool in the business. I do plan to get upgraded to premium evaluator soon.
Being an investor gets easier and easier with the tools created by Daniil. I have rehabvaluator, and when he said he was hooking me up I jumped on it. No mistake there.
What a great spreadsheet! I have RehabValuator Lite – just starting in RE investing – and can see where both of these will be great help. Have not seen anything comparable at ANY price on the internet. Do you have a spreadsheet for buying/selling mortgage notes? Both performing and non performing. Or one for being a lender (hard money or private lending) to rehabbers?
We don’t have anything for notes at this time. However, I have heard that request more than a couple times so it might be something for us to consider. Glad you’re enjoying the lite version 🙂
DANIIL, I THANK YOU FOR PROVIDING SUCH A GREAT TOOL TO HELP ME WITH EXSPANDING MY REAL ESTATE EDUCATION ! ! !
I WISH YOU AND YOURS THE VERY BE, RICH
Thanks! Can’t wait to try it out.
Awesome work Daniil. Thank you! 🙂
Can you pre determine the write off of a under-water mortgage? If I was to purchase a house that is market at 425,000.00 and I could get a write off say 108,000 and purchase at say at 290,000,or less with a equity.
I was asking Daniil about this. Unfortunately we don’t really know if that’s possible or not. Sorry I couldn’t give you more information.
Thank you for this great tool!
Great video thanks
Showing how the loan can be paid off early in incentive for the buyer
and it shows you are there to help him.
Great tool that know one has ever explained to buyers.
Excellent Program for financial management of properties…..
Very helpful, much appreciated.
Very, Very Good Stuff! I Plan On Using This In The Future. Thanks Again For The Info.
this is what I need in my business
Creates an amortization table for BOTH fixed-rate and adjustable rate mortgages. This one is by far the most feature-packed of all my amortization calculators. It has has been refined and improved over years of use and feedback received from both professionals and every-day home buyers .
Looks like a great tool, thank you.
Thank you for this all you do your work is
not in vain.
Thanks great tool!
thanks Daniil..this calculator is worth sharing..
Thanks for the info this is very informative!
Thank you very much. I am still fairly new to Real Estate and I live in New York City where the market here is outrageous! I have learned so much from you and your videos and I brought your REHAB VALUATOR software which I must say is the best! I have also taken the time to educate myself by going to Real Estate seminars. The programs that I gone to have NOTHING on you and were a waste of time and money! Thank you for sharing your time and expertise with all of us and sharing with everyone the Free Amortization Workbook.
You are truly AWESOME and God Bless you!
Thanks Daniil, Thanks for caring, and sharing.
Thank you for sharing all your Great Videos & Software, it really is a Fantastic Tool to have. For anyone who wants to learn how to structure great deals for wholesalers, Flippers and Investors. personally look forward to implementing your Valuation software.
Again, Thank You Daniil for all your awesome software.
GREAT TOOL I ALWAYS WANTED THISTHANK YOU
I watched the entire video, however, when I went to try and download the free worksheet; I didn’t get it??
Sorry you’re having trouble. I just checked that link and it is definitely working. As soon as you click on it it starts downloading the file. What kind of issue are you having exactly? Please email us at email@example.com and give us further details so we can assist you.
What about a scenario of paying more to principle every month on a
30yr loan to pay it off quicker and have the option of a low payment when cash flow is low
Jim – there’s a prepayment option built into this calculator!
super cool uber tool!!! Thanks!
Hi Daniil, Most people don’t know that all mortgage contain anniversary clause which allows you to pay any amount you like on the anniversary day of your mortgage toward principle amount. This allows you to pay off your mortgage faster then planned. This feature should be added to your software..
IF FOUND THIS INFO VERY USEFUL, THANKS FOR SHARING
Thank you very much!
It is a very helpful tool.
Thank You once again Daniil,
You keep impressing me with the effort you put into what you do, any the way you keep giving.
Thank you so much, you have a life long follower.
Thanks for this easy to use calculator. It is a handy tool to have on hand. It works great.
flander flowers i can not download mortgage amortizotion work sheet will you help
Hi Mr. Flowers,
That’s simply an Excel workbook file that you download and open up. I did double check and it’s working great. What kind of trouble are you having exactly? Please email me at firstname.lastname@example.org and let me know where you’re getting stuck.
Thank you this is very goodI will make good use of this.
Thanks Daniil. I actually made such a spreadsheet with Works before Excel was even around.
Simple and great. I’ve been using online calculators, but could never save a scenario. Also, don’t have to deal with advertisements. Much appreciated.
this was very helpful! Thanx so much!
Thanks for providing this tool.
I would find it even more useful if it had the option to see how occasional additional payment amounts would effectively lower the total interest paid and accelerate pay off.
You can do that in the worksheet. Just over ride the individual payments in the dates when you want to add principal (you’ll need to unprotect the sheet first)
Hi Daniil, Thank you for your free amortization worksheet. I really like it and will guide me if I eventually have a mortgage of my own. Thank you again for your free training.
You are welcome James
Glad it worked out, Louis! You’re very welcome
You’re welcome, Henry!
Thank you so much Daniil!!!
You’re very welcome!
Daniil, thanks so much for this amortization spreadsheet. Very kind of you to offer this for free!
Thank you Daniil for the free Amortization Calculator, it would be most helpful in the near future .