Forum Discussion
Excel and snowball debt calculators
Greetings all! I feel like I'm trying to re-invent the wheel. I'm "attempting" to create a monthly debt calculator that includes my fluctuating monthly income based on overtime per pay period, bills, and debt. I'd like to see the estimated payoff date, remaining balance based on the interest rate, and be able to enter any additional payments per month. I'm 90% there but something in my formulas has thrown everything off and I don't even know how to recover. Somehow I ended up having to use indexes because Excel didn't like the format I was using the formulas which ended up complicating things even more. I've googled, and looked at Etsy, do you think this is a one off calculator that I'm trying to build? I tried using co-pilot and chatgpt but neither were helpful.
2 Replies
You'll get a solution (or three) very quickly here if you're able to provide a basic sample of the data with desired results.
Are you willing to share that spreadsheet that is 90% there? The actual spreadsheet; not just an image.
It would help us help you to see how you've approached it so far. Change the numbers if you need to, so as to preserve the privacy of your actual data, but show the structure, formulas,, etc.
