Solver for budgeting



I am new to the solver function and would like to know how to set it up so
that I can determine 1)how many months it will take to pay off a credit card
balance with a fixed APR and a fixed monthly payment or 2)what a monthly
payment would have to be to pay off a credit card in a fixed number of months
with a fixed APR. Is there a way to figure in the max. amount of purchases
allowable per month for either scenario as well?

I am really excited to hear how to get started on this so if someone has any
suggestions or can point me towards something that might offer some help that
would be great!




Fred Smith

You don't need solver for financial functions.

For 1), use the Nper function
For 2), use the Pmt function
For "max. amount of purchases", you probably want PV


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question