02.06-PR008 Develop a single spreadsheet that allows you to calculate the

(P|A1 i%,j%,n), (F|A1 , i%,j%,n), and (A|A1 i%,j%,n) factors. Note that the (A|A1

i%,j%,n) factor is not in Appendix A. For each cell where the calculation is performed, place above it a small “control panel” that allows you to enter whatever numbers you need to perform the calculation. For example, for the

(P|A1 i%,j%,n) factor, your control panel needs to include i, j, and n. Test the first two factors using i = 7%, j = 5% and n = 10 against the tables in Appendix A to ensure they work right. Then, using A1 = $1,000, i = 7%, and j = 5%, calculate A using the third factor and check it against (P|A1 i%,j%,n)*(A|P 

i%,n). Keep this handy. It will be useful to you.