View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default How do I make a Coupon Book for payment from another party?

First, my own humble, personal opinion: most of what most people need to do
and use Excel for can be done in Excel 97. No need to upgrade until either
you wear out all the bits in it (tough to do, they seem to regenerate
regularly), the operating system you're using won't support 16-bit
applications, you find yourself regularly needing more room (as in more
rows/columns than '97 gives you), or you just get 'the urge'. <g

A couple of questions - do you want all of the 'stubs' to be on a single
sheet (could hit one of those limits depending on how many stubs you need),
or do you want the stubs on separate sheets (could end up being a slight
problem depending on the memory available in your computer).

While you're thinking about that, basically what you're looking for is a
Loan Amortization Schedule, and Microsoft has a template available for
download - and yes, it works with Excel 97:
http://office.microsoft.com/en-us/te...197771033.aspx

that's not going to give you late fees, but can probably be modified easily
enough to include those.


"FunDee" wrote:

I am selling something to a friend and would like to make up a coupon book,
like the bank does. So he will have a record of the transaction and a
reminder of the fact that he needs to pay this bill. I have Excel 97 never
upgrades as it works great for what I use it for.

I'd want the coupons to have the following items: Due Date, Amount, Late
After, Late Amount. Along with my name and address as Make Payments To.

It would be nice to have a stub For Your Records. With a place to write
Amount Paid, Check #, and Date Paid.