Please help with setting up each problem with the correct numbers in each white cell & the final answer in the green cell. Thanks so much in advance!! :)
I/Y= period interest rate
P/Y= # of periods per year
PMT= payment per period
2. How many periods will the following take? a. $500 to grow to $1,039.50 if invested at 5 percent compounded annually. Semi-annually. b. $35 to grow to $53.87 if invested at 9 percent compounded annually. Quarterly. c. $100 to grow to $298.60 if invested at 20 percent compounded annually. Monthly. d. $53 to grow to $78.76 if invested at 2 percent compounded annually. Monthly. Problem # 2a 2b 2c 2d Annually Semi-Annually Annually Quarterly Annually Monthly Annually Monthly P/Y N I/Y PV PMT FV