118. Develop a single spreadsheet that allows you to calculate the (PZA1 i%,j%,n),

(FZA1, i%,j%,n), and (AZA1 i%,j%,n) factors. Note that the (AZA1 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

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

(PZA1 i%,j%,n)*(AZP i%,n). Keep this handy. It will be useful to you.