Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
CeeBee
 
Posts: n/a
Default How do I forecast future payments by analyzing past payments?

I keep a ledger of payments on excel. It is literally a months column with
the payments from each remitter (Remitter's name in the Remitter's column).
I want to see if we have any upwards or downwards trends in payments. How do
I do this. I have looked at the instructions and I can't figure them out. I
don't want to know how it works. Just how to do it.
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

Do you want to do something graphically?

"CeeBee" wrote:

I keep a ledger of payments on excel. It is literally a months column with
the payments from each remitter (Remitter's name in the Remitter's column).
I want to see if we have any upwards or downwards trends in payments. How do
I do this. I have looked at the instructions and I can't figure them out. I
don't want to know how it works. Just how to do it.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PPMT formula that generates equal payments ExcelMonkey Excel Worksheet Functions 3 February 15th 05 07:39 PM
Best way to forecast individual sales territories? Bill_S Excel Discussion (Misc queries) 0 February 3rd 05 02:29 PM
How to calculate total interest on 12 month loan with early payments Fred Smith Excel Worksheet Functions 0 January 6th 05 02:33 AM
Loan amortization schedule with bi-monthly payments McCarthy_MF Excel Worksheet Functions 0 December 9th 04 09:45 PM
annuity future value? PeteK Excel Worksheet Functions 3 November 26th 04 06:21 PM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"