Emanuel Levy
New member
- Joined
- Jan 14, 2013
- Messages
- 19
- Reaction score
- 0
- Points
- 0
I figured out how to count how many accounts I have open with balances. What I want to do next is start working on a snowball calculator. Before I can do that though I need to pull out to a separate tab the following
Issuing Bank, Card Name. Balance Limit Utilization, Minimum Payment and Amount to goal.
All this information is on the Credit Cards Data tab
My ultimate goal right now is to have the following snowball methods
1) Snowball by Utilization Goal
2) Snowball by balance smallest to largest
3) Snowball by balance largest to smallest
4) Snowball by interest rate lowest to highest
5) Snowball by interest rate highest to lowest
I figured I can break that out by a sort possibly by a radio button to choose a pre-defined sort on the Payment calculation sheet then put the results back to the credit card data sheet. I would use the values on the bank balances tab minus the Fixed Monthly payment tab and what is left will go to the credit card payments
I hope this makes sense as I am tired and my brain is a bit foggy right now.
Issuing Bank, Card Name. Balance Limit Utilization, Minimum Payment and Amount to goal.
All this information is on the Credit Cards Data tab
My ultimate goal right now is to have the following snowball methods
1) Snowball by Utilization Goal
2) Snowball by balance smallest to largest
3) Snowball by balance largest to smallest
4) Snowball by interest rate lowest to highest
5) Snowball by interest rate highest to lowest
I figured I can break that out by a sort possibly by a radio button to choose a pre-defined sort on the Payment calculation sheet then put the results back to the credit card data sheet. I would use the values on the bank balances tab minus the Fixed Monthly payment tab and what is left will go to the credit card payments
I hope this makes sense as I am tired and my brain is a bit foggy right now.