If the value of Q for the cash flow shown in the table below is $5,000, what is the value of R? The interest rate is 4% per year and the cash flow is balanced and equivalent.

MUST BE IN EXCELL AND SHOW FORMULAS

\begin{tabular}{|c|c|} \hline Year & Cash Flow \\ \hline 0 & +16R \\ \hline 1 & 10Q \\ \hline 2 & +3Q \\ \hline 3 & 0 \\ \hline 4 & +2Q \\ \hline 5 & 4Q \\ \hline 6 & 12Q \\ \hline 7 & +6Q \\ \hline 8 & 0 \\ \hline 9 & +5Q \\ \hline 10 & 20Q \\ \hline \end{tabular}