How do I make a Coupon Book for payment from another party?

[FunDee]

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.

 

[JLatham]

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/templates/TC010197771033.aspx

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

 

[FunDee]

I agree with you about Excel 97 = Sorry about posting in more than one place,
was unsure of where to post. I have 2.60GHz on this computer with 512 MB of
Ram. So I'm ok.

I have that Loan Amortization and it is good. I've calculated it all out and
have given them a copy.

But I thought it would be helpful if I handed them a coupon booklet. I'd
like stubs and more than one per page would be fine, with space inbetween.

I do not need to tell them how much is left on their loan. Not until I send
them a statement for tax purposes at the end of the year. I only need to
remind them that if they are late I will be adding late fees, and how much
that fee is. Just trying to look professional and as if I actually know what
I'm doing. LOL Thanks for getting back to me.