2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

trying to project balance in my debt tracker (me again!)

Our take

Creating a personalized debt tracker can empower you to take control of your financial journey. Your approach, which combines key elements like balance, interest rates, and monthly payments, is a solid way to visualize your progress. To troubleshoot the formula issue, ensure that your references are accurate and that there are no divisions by zero, which could result in a total of zero. Adjusting your formulas for clarity and accuracy will help you effectively project your debt repayment timeline and empower your financial decisions.

So I built my tracker, it'll tell me how many months it will take to pay something off, based off todays balance, interest rate, minimum monthly payments

I essentially want to build my own debt snowball tracker, because the way my brain works isn't conducive to the ones I can download for free.

So I want to make another chart on what it will look like 3 months from now, just down from todays balance.

So columns:

A= item

B = total

C= payoff date

D = Monthly payment

E= interest rate (some are 0)

F= months left.

first row is the labels

so the first item actually tracked is b2

I asked chat GPT and the formula wouldn't take, this it what it gave me:

=IF($B$2<=0,B16-$e$3*$j$16,B16*(1+$B$2/12)^$j$16 - $d$3*(((1+$B$2/12)^$j$16 - 1)/($B$2/12)))

and right now the total comes up to 0, which I think is because some of the totals are 0, so i looked at other ones and it always comes to 0.

any advice?

it may take awhile to response as I'm about to be away for the rest of the night

submitted by /u/tossedAF
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article

Tagged with