Problem:
A firm has an estimated pension liability of $1.5 million due 27 years from today. If the firm can invest in a risk-free security with an interest rate of 8%, how much must the firm invest today to be able to make the $1.5 million payment? (Must use Microsoft Excel)