• Back To Content and Resources
  • Blog
  • Building New Construction Rentals Training
  • Buying and Flipping Land with Mark Podolsky
  • Buying and Wholesaling Buildable Lots Training
  • Daniil Kleyman Interview on Raising Private Money and Mindset
  • Daniil’s Book List
  • Glossary of Real Estate Terms
  • Mortgage Amortization Worksheet (free download!)
  • My motivation
  • Private Money Deal Structuring Course – Become a Transaction Engineer
  • Private Money Lending Explained Once and For All!
  • Rehabbing and New Construction Training with Chris Jefferson
  • Resources for Real Estate Investors
  • Wholesaling 101 – Free Course: Basics of How to Wholesale Real Estate
  • Content and Resources

    Mortgage Amortization Worksheet (free download!) -

    You can download the Free Amortization Workbook by clicking on the link below.  This simple calculator will allow you to input any mortgage and instantly get an amortization schedule, calculate payment amount, determine the effect of ARM resets, etc!

    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


    Comments (104 comments so far)

    1. jerome heuser

      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,

    2. Philip

      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 exracan@aol.com and let’s get you started.

    3. Thanks. Nice software. I am using it in open office with no problems so far.

    4. James Dwayne Mcpherson

      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.

    5. Greg

      Hey, thanks for the amortization calculator – nifty little tool to have around !

    6. Randy


      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!

      Kind Regards,


    7. mehrdad kaviani

      Daniil Kleyman thank you very much. It will help me a lot figuring out monthly payments on my deals.

    8. Vince Greaves

      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.

      • Daniil

        Hi Vince,

        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.

    9. Dale

      Thx Daniil!

    10. Dick Konetchy

      Having owned my own mortgage corp. and also saw it crash, I missed not having this handy tool Thanks Dick Konetchy

    11. Simon

      Thanks again!!!! YOU ARE THE MAN!!!!!!!!!

    12. David W

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

    13. Tony Davis

      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

    14. Tony Davis


    15. Ray Manning

      Looks good, Thanks

    16. Hank

      Thanks Daniil,
      Hope to use this soon.

    17. gilbert


      this is a great video

      thank you

    18. sharon ellis

      thank for the program very good tool s ellis

    19. This is useful for me and my clients. Good job. Thank you

    20. great tool to show investors when getting funding.

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

    22. Keith

      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.

    23. Dave Bruton

      Hi Daniil

      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 davebrutonconstruction@yahoo.com

      Great job

      Dave Bruton

    24. Hi Daniil,can any of your software be implemented for entrepreneurs for raising capital other than real estate?

      • Daniil

        Don – we haven’t tried it but I suppose so. Depends on what you have in mind. Shoot me an email.

    25. FosterCA

      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?


      • Daniil

        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.

    26. Ralph

      Daniil – Very cool! Thnx! Ralph

    27. charles Hill

      Thank you for this valuable tool and your voice-over adds to understanding how to use it.

    28. Daniil.
      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.

    29. Harry W.

      Your great Dan, I know everyone appreciates what you share with us.

      You are AWSOME!

    30. Alicia

      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.


    31. You are creating some much needed software for Real Estate Investors, this really is a valuable tool. Thanks for making it available.

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

    33. Wilson Dela Cruz

      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®

    34. Rich

      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

      • Daniil

        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

    35. Mike

      I am excited to see how this spreadsheet will work for me. Thanks alot!!!!!

    36. Judy Guardiola

      Great information.

    37. TimG.

      This is extremely helpful and very much appreciated! Thanks so much for this free tool!

    38. hi this is a wonderful program. good information, helped me understand mortages a lot. thankyou.

    39. Sharol Culverson

      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.

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

    41. Daniil Fan

      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?

      • Daniil

        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 🙂

    42. Richard B. Thomas


    43. Thanks! Can’t wait to try it out.

    44. Melody McLaughlin

      Awesome work Daniil. Thank you! 🙂

    45. George

      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.

      • Jacob

        Hi George,

        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.

    46. Jane White

      Thank you for this great tool!

    47. steve

      Great video thanks

    48. David

      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.

    49. Clint


      Excellent Program for financial management of properties…..



    50. gina

      Great tool!

    51. Wil


    52. Banbury

      Very helpful, much appreciated.

    53. thanks

    54. Very, Very Good Stuff! I Plan On Using This In The Future. Thanks Again For The Info.

    55. teresa wilson

      this is what I need in my business

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

    57. Robert

      Looks like a great tool, thank you.

    58. Thank you for this all you do your work is
      not in vain.

    59. Tom Story

      Thanks great tool!

    60. lennwe

      thanks Daniil..this calculator is worth sharing..

    61. Daniel

      Hey Daniil,

      Thanks for the info this is very informative!

    62. Nicola

      Hi Danill,

      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!

    63. Cathrine Francis

      Thanks Daniil, Thanks for caring, and sharing.

    64. Francisco

      Hi Daniil,
      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.

      Francisco M.Jr

    65. sante morrone


    66. Tammie

      I watched the entire video, however, when I went to try and download the free worksheet; I didn’t get it??

      • JacobC

        Hi Tammie,

        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 support@rehabvaluator.com and give us further details so we can assist you.

    67. Jim

      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

      • Daniil

        Jim – there’s a prepayment option built into this calculator!

    68. Toyya

      super cool uber tool!!! Thanks!

    69. Daniil


    70. balwant

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

    71. calvin jackson


    72. Mike

      Thank you very much!
      It is a very helpful tool.

    73. Michael Hill

      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.


    74. Jack Strong

      Thanks for this easy to use calculator. It is a handy tool to have on hand. It works great.

    75. Victor T Dombrowski

      Great information

    76. flander flowers

      flander flowers i can not download mortgage amortizotion work sheet will you help

      • JacobC

        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 support@rehabvaluator.com and let me know where you’re getting stuck.

    77. Thank you this is very goodI will make good use of this.

    78. Thanks Daniil. I actually made such a spreadsheet with Works before Excel was even around.

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

    80. this was very helpful! Thanx so much!

      • JacobC


    81. Helga

      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.

      • Daniil

        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)

    82. James Okhueleigbe

      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.

      • StefanieK

        You are welcome James

    83. Louis Campfield

      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 Kleyman

        Glad it worked out, Louis! You’re very welcome

    84. Henry C

      This just what I was looking for. Thank you.

      • Daniil Kleyman

        You’re welcome, Henry!

    85. Great Tool to have, Thanks

      • Rafael Diaz

        You’re welcome, Joseph!

    86. Hey,

      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!


      • Rafael Diaz

        Hi Frank! Sounds great! We look forward to you becoming a premium member in the near future!

    87. Mima

      Thank you so much Daniil!!!

    88. maurice

      Wealthy information