So im having some trouble doing this Excel spreadsheet. Mainly because im terrible with numbers and math. I kind of need step by step directions for somethings and this is one of them even though you guys may seem like this is a walk in the park. Im just having a little trouble with the damn PMT function.

If anyone could help me that would be fantastic! Anyways heres what the problem goes.



1. Your friend has made several visits to the doctors office in the past month and he has asked you to calculate what will be owed after the insurance has been paid. The insurance company usually takes a month to process a claim and your friend is hoping you can help figure the amount right away so he or she can plan ahead.

2. Date of Visit

2/4/2010
2/5/2010
2/11/2010
2/12/2010
2/15/2010
2/18/2010
2/19/2010
2/22/2010
2/25/2010
2/27/2010
2/28/2010

Doctor

Goodman
Goodman
Loman
Goodman
Loman
Loman
Loman
Walker
Walker
Loman
Goodman

Cost of Visit
$113.00
$145.00
$120.00
$110.00
$140.00
$175.00
$135.00
$215.00
$235.00
$120.00
$105.00


3. Your friend has a co-payment of $25.00 and insurance will pay 80% of the remaining cost. Creat a formula for each visit that will calculate the amount your friend will have to pay.

4. The insurance company is suppose to respond within 30 days of billing. The doctors off have said they will bill within 3 days of the visit. Add a column that will indicate the date the insurance company will respond for each visit.

END

The Date of Visit, Doctor, Cost of Visit are 3 separate columns. So like A1,B1,C1