I have started an Excel spreadsheet that calculates the payoff of consumer debt using the a technique called the debt snowball. I've run into the complications with the equations and projections and need help completing the worksheet.
The calculations at the top of the page are all working correctly. It's the projection charts below that I need help finishing.
I've filled the blocks in with formulas as close as I could get to working. When I rean into difficulty, I entered the correct result so that the charts complete the projections as it shold when all formulas are working correctly.
The projection charts should show all the monthly payments projected out until all debts listed in the debt chart at the top are paid off. I need 7 more projection charts added to the worksheet to match the 10 rows in the debt chart at the top. All charts need to be extended out for 360 rows to account for 30 year mortgages.
Please review the chart and PM me with any questions concerning this project.