what is the formula for Cell B4

3. Create Tables of Compound Factor In formula FV=PV(I+r)t, the term (I+r) is called the compound factor of interest rate r for t years. We can use Excel to create a table of compound factor for convenient reference (you can download templates of the following tables on Canvas): Table 1. Table of the compound factor A(r=1% to 30%, Period =1 to 30) Question: What is the formula for Cell B4? Requirement: use appropriate references in your formula, so that you can directly copy and paste it to the entire table (Area B4 to AE33) to get the right data of each cell