Author Topic: Spreadsheet to Test Different Debt Payment Scenarios  (Read 2390 times)

FarmFam

  • 5 O'Clock Shadow
  • *
  • Posts: 63
Spreadsheet to Test Different Debt Payment Scenarios
« on: October 31, 2014, 12:32:31 PM »
I recently in the last couple of days saw a link to a spreadsheet to put in numbers to see different debt payment scenarios.  Does anyone know where that forum post is or the link?  The person who posted it said they didn't have the original file, but then someone noticed that the link to the original was at the top corner. 

I can't find that post again.  Been using search but no luck.

schimt

  • Bristles
  • ***
  • Posts: 308
  • Age: 33
  • Location: New Jersey
Re: Spreadsheet to Test Different Debt Payment Scenarios
« Reply #1 on: October 31, 2014, 12:37:48 PM »
I attached the one that i have posted before. The only modification i made to the sheet is the condition formatting on the second tab to make the payment schedule more visual. This link to the site is in there too

Enjoy

Professor Ecks

  • Stubble
  • **
  • Posts: 103
  • Age: 43
  • Location: Kansas City
    • My Journal
Re: Spreadsheet to Test Different Debt Payment Scenarios
« Reply #2 on: October 31, 2014, 03:00:00 PM »
Thanks for posting this link (and to OP for posting the question). I have my own simple spreadsheet that I am using, but my formatting made it a pain in the ass to change the scenarios around.

FarmFam

  • 5 O'Clock Shadow
  • *
  • Posts: 63
Re: Spreadsheet to Test Different Debt Payment Scenarios
« Reply #3 on: November 03, 2014, 04:17:24 PM »
Thank you!!!!

davisgang90

  • Handlebar Stache
  • *****
  • Posts: 1266
  • Location: Roanoke, VA
    • Photography by Rich Davis

FarmFam

  • 5 O'Clock Shadow
  • *
  • Posts: 63
Re: Spreadsheet to Test Different Debt Payment Scenarios
« Reply #5 on: November 04, 2014, 03:03:59 PM »
I also thought I would share that online there is a simple calculator I found at http://ballofsnow.org that shows different scenarios. 

However, I love the spreadsheet because I can keep record of it and add additional payments on certain months and a custom order of the debts as well.

damize

  • Stubble
  • **
  • Posts: 102
  • Age: 48
  • Location: Southern California