Working from the top down, enter data needed from the text question. Calculate a solution for each cell back-lighted in yellow. Build your formulas in calculation cells by referencing cells above that in turn reference numbers directly from the text problem.

fx A B D E F G H J K 1 c Calculating the legal APR Given Sub-Annual Compounding, PV, and Term 2 3 What APR is being earned on a deposit of $4,000.00 made 12 years ago today if the deposit is worth $9,700.00 today and the account pays interest semi-annually? 4 s 6 7 8 years 9 Original PV= $4,000.00 Current FV= $9,700.00 Term= 12 Semi-Annual Term= 24 SAPR= APR= EAR= half years 10 11 12