please explain how you derived to the answer

You deposit $300 in a bank account that pays an interest rate of 6%, compounded quarterly. In excel, compute how much your account balance will be at the end of each year for the next 5 years. Which of the following accurately depicts this calculation? PV Starting Balance $300 $300 $300 $300 $300 Interest rate 696 6% 6% 6% 6% rate period rate 0.06 0.03 002 0.015 0.012 Periods per year 1 2 3 4 6 PMT Payment amount 0 0 0 O 0 Number of years 5 5 un un UP nper Number of benods 5 10 15 20 25 FV Enalng Balance $40147 S403.17 $403 76 $404.05 $404.24 PV Starting Balance $300 $300 $300 $300 $300 Interest rate 156 296 3% 496 596 Tate period rate 0.0025 0.005 0.007 0.01 0.0125 Periods per year 4 4 4 4 PMT Payment amount 0 0 0 0 Number of years 1 2 3 5 nper Number of berods 4 8 12 16 20 FV Ending Balance 5303 01 $312.21 5328.14 $35172 5384 61 PV Starting Balance S300 $300 $300 5300 $300 Interest rate :59 be 51 O BE search Puso Num Backspace 8 0 9 5 6 o P. R. Enter K K G shi CV BNN Poup PV Starting Balance $300 $300 $300 $300 $300 Interest rate 6% 696 696 696 rate period rate 0.06 0.06 - 0.06 0.06 0.06 Periods per year 4 4 4 4 4 PMT Payment amount 0 0 0 o Number of years 1 2 3 4 5 nper Number of periods 8 12 16 20 FV Ending Balance $378.74 $478.15 5603 66 $762 11 $962.14 PV Starting Balance $300 $300 $300 $300 $300 Interest rate 5 DO DO 0015 Periods per year Paano o Prise PV Starting Balance $300 $300 $300 $300 $300 Interest rate 69 696 rate period rate 0.06 0.06 0.06 0.08 Periods per year PUT Payment amount Number of vers PV Starting Balance $300 $300 $300 $300 $300 Interest rate 6% 6% 6% 6% 696 rate period rate 0.015 0.015 0.015 0.015 0.015 Periods per year 4 4 PMT Payment amount 0 0 0 O Number of Vear's 4 5 r Number of beds 8 12 15 20 F Ending East 333749 9999:59 59800 8404.06 Incorrect 10 10 nts