Loan Calculator with Balloon Payments

20 Responses to Loan Calculator with Balloon Payments

1. Heather Olson says:

   September 1, 2012 at 12:46 am

   This is the best!!!

   Reply
   • Derek Mallard says:

     June 25, 2014 at 1:59 am

     cool xcel calc

     Reply
   • :isaac :Richardson says:

     February 2, 2018 at 7:45 pm

     Some minor edits to the SPREADSHEET.
     The PAYMENT DUE DATE of each line entry will not populate because we are in a new millenium since the spreadsheet was created. HIGHLIGHT the payment date column. Click on edit in the title bar. Click on FIND & REPLACE. TYPE IN 1900 for what you want found and 2000 for what you want replaced.
     ALSO,the space for 120 payments in the GREEN space below the pink should be =(E7)*(12). This should bring everything up to snuff as designed.

     Reply
2. Heather Olson says:

   September 1, 2012 at 1:03 am

   I am wondering about a few of the squares – how can we find out what should be in the pink square marked with 10 in the example?

   Reply
   • David Woodside says:

     September 4, 2012 at 9:55 pm

     Hi Heather. I looked at the spreadsheet. The 10 is the number of years in which to amortize the loan.

     Reply
     • David Woodside says:

       September 4, 2012 at 10:14 pm

       BTW, I don’t see any use for the date in cell E9. It doesn’t appear to be used anywhere. I deleted that date with no apparent affect in the spreadsheet. Anyone know?

       Reply
3. Cresencio Mandujano says:

   September 7, 2012 at 5:33 am

   I can find the form

   Reply
4. David Woodside says:

   September 21, 2012 at 2:32 pm

   I think the form has some errors in the “Loan Details” data entry block at the top. Here’s what I think should be corrected:

   Cell A7 should read “Loan Term (years)”. Then you enter the number of years in the adjacent pink cell E7.

   The formula in Cell E11 seems to have been deleted before the spreadsheet was uploaded to the Club site. It should contain the formula: =E7*12 This is consistent with the spreadsheet’s instructions that green cells are calculated.

   Cell E9 doesn’t appear to be used and can be deleted and ignored. I searched the spreadsheet for a reference to cell E9, and it has none.

   Making these changes, the results are as expected, and they agree with my old reliable HP 12C calculator’s amortization functions.

   Heather: you seem to be using this spreadsheet. Do you agree?

   Reply
   • Mark Mahaffey says:

     March 27, 2014 at 12:01 pm

     David,

     Your suggestions seem correct. I just downloaded this spreadsheet, and as of March 27, 2014 it still has not been corrected. While cell E9 does not appear to be used elsewhere, perhaps it should be a “green” field that is calculated to show the final payment date based on the input origination date and loan term.

     Reply
5. Sharon Collins says:

   October 11, 2012 at 12:21 pm

   Great Thanks

   Reply
6. Elliott Days says:

   October 11, 2012 at 2:12 pm

   awesome

   Reply
7. Armond Wright says:

   December 9, 2012 at 4:11 pm

   In cell E9 insert the formula =TODAY() for today’s date..This will insert the date that you created the form

   Reply
8. Chris Harris says:

   December 15, 2012 at 12:46 am

   This is cool

   Reply
9. Mary Cannon says:

   November 14, 2016 at 6:24 pm

   Wow!

   Reply
10. Michael Myles Jr Myles says:

    June 26, 2017 at 3:18 pm

    File not working what’s going on?

    Reply
11. Tasha Campfield says:

    April 1, 2018 at 12:20 am

    This is super hott, thanks ron

    Reply
12. Ian Lemke says:

    June 7, 2019 at 7:57 am

    Heck ya. This one is the money maker!

    Reply
13. Luke Kohls says:

    April 2, 2020 at 8:56 pm

    This is very helpful

    Reply
14. Corine Judd says:

    September 10, 2021 at 9:33 am

    How do I unlock so I may use the calculator ?
    Thanks

    Reply
15. Ben Phillips says:

    September 29, 2022 at 6:44 pm

    What do you guys think about making E9 the date when Balloon is due?

    Reply