The present value of Mary Baileys pension is $104,238. She receives two checks of $5,000 each year one on January 1 and the other on July 1. a) If the annual interest is 8%, how many years will she be able to receive those checks? b) If she would like to receive the checks for 22 years, how much would each check be?

I have to enter the information into a spreadsheet w/ formulas like this one:

Relevant Information
Annual Interest Rate
Periods Per Year
Number of Years
Needed Information
Present Value					PV
Future Value					FV
Payment					PMT
Rate					RATE
Number of Periods					NPER
Additional Calculations (if needed)
Answer: