What is the value of $600 per quarter for four years at the rate of 8% compounded quarterly?
There are 4 of these calculations per years so instead of using 8% at each calculation we use
Let the count of calculations be
Let the principle sum be
Let the Total in the account at count c be
Then we have:
This implies an output of a list comprising of the progressive value of the $600 plus interest at each quarterly stage over the 4 years.
Calculating for the total of compounded interest plus the principle sum
Built in Excel as a check