Solve Using Excel

Present values

ABC Corp. wishes to invest a fixed sum at 5.0% and withdraw $10,000 at the end of each month for the next three years. How much ABC will need to invest? In other words, what is the present value of an ordinary annuity of $10,000 for 36 periods, discounted at a rate of 5%/12 per period?

Assume that ABC Corp can earn 5%, but needs to withdraw $10,000 for 72, not 36 months. How much cash must it now invest to meet its $10,000 / month needs?

Assume that ABC Corp. can only earn 3.5% on its investment. What sum does it now need to invest to meet its $10,000 / month cash needs for 72 months?