1A The future value of $500 invested at 8 percent for one year 1 Nper Number of periods 500 FV Future Value 8% Rate Interest Rate 540 Enter formula into A12 =500*(1.08)^1 540 Enter formula into A13 =A9*(1+A10)^A8 Enter Formula into A14 =FV(A10,A8,,-A9) 1B The future value of $500 invested at 8 percent for five years Nper Number of periods PV Present Value Rate Interest Rate Enter formula into A22 =500*(1.08)^5 Enter formula into A23 =A19*(1+A20)^A18 Enter formula into A24 =FV(A20,A18,,-A19) 1C The present value of $500 to be received in one year when the opportunity cost rate is 8 percent. Nper Number of periods FV Future Value Rate Interest Rate Enter formula into A32 =A29/(1+A30)^A28 Enter formula into A33 =PV(A30,A28,,-A29) 1D The present value of $500 to be received in five years when the opportunity cost rate is 8 percent. Nper Number of periods FV Future Value Rate Interest Rate Enter formula into A41 =A38/(1+A39)^A37 Enter formula into A42 =PV(A39,A37,,-A38) 2A The present value of $400 per year for ten years at 10 percent Nper Number of periods Pmt Payment Rate Interest Rate Enter formula into A50 =PV(A48,A46,A47) 2B The future value of $400 per year for ten years