Trying to make a payoff sheet, any ideas?

[beepbeep27]

I am trying to make a payoff spreadsheet calculator. Basically it would have a field for the amount owed and the minimum payment. Then it would calculate how many payments are left, what date the payoff would be from today's date, and what length of time is left in years so for example "4.5 years left" something like that. Any ideas guys/gals?

Thanks in advance!

[galvinpaddy]

Hi, welcome to the forums!
If you post a sample worksheet showing 2 things.
The raw data (what you start with)
The finished look (what you want the result to be)
Then it may make things easier for us to help, as currently we will need to guess what you are working with and the layout.

In the words of Jaslake - Show us what you have & want.

galvinpaddy

[beepbeep27]

Anytime I post if the format I should always do with posts, ie posting a sample worksheet? what I have so far?

Hi, welcome to the forums!
If you post a sample worksheet showing 2 things.
The raw data (what you start with)
The finished look (what you want the result to be)
Then it may make things easier for us to help, as currently we will need to guess what you are working with and the layout.

In the words of Jaslake - Show us what you have & want.

galvinpaddy

[galvinpaddy]

Sorry im a little lost by that comment Load a sample worksheet of what you are working with. (an actaul excel workbook) showing us what the layout is and what you want help with.

[beepbeep27]

I need help getting this to work, the stuff in " ( ) " is what I want that cell to be able to do

Sorry im a little lost by that comment Load a sample worksheet of what you are working with. (an actaul excel workbook) showing us what the layout is and what you want help with.

[galvinpaddy]

Thanks for that, much better to read your request now
Question time
1) Min Payment - is this yearly/monthly?

[beepbeep27]

Thanks for that, much better to read your request now
Question time
1) Min Payment - is this yearly/monthly?

Minimum payments would be weekly? then bi weekly, monthly, etc