A) Create a generic excel spreadsheet where the interest rate, i, can be changed at the top and all tabulated values in the rest of the sheet will change accordingly. 1 2 3 71 B C D E F G Yr Interest i% SINGLE PAYMENT UNIFORM SERIES CAF PWF SCA SFF SPW CRF (F/P) (P/F) (FA) (A/F) (P/A) (AP) =(1+$CSY A4 1 (1 + $C$1)^A4 (1 + $C$1) 44-1 1 C+ $C$1 E+ $C$1*(1 + $C$1) A4 G+ 4 n 1 = = = = = 5 8 Note: After creating this sheet, all problems can use the spreadsheet to create a table for any interest rate, i, or year, n, needed, instead of using the formulas. Use interest rate, i = 10% and n = 8 years to calculate each factor in row 5. B) Then use the table you created in part A to calculate the numerical values of the following factors: a) (F/P,5%,10) b) (P/F,6%,8) c) (F/A,10%, 10) d) (A/F,2%,30) e) (P/A,4%, 9) f) (A/P,35%, 15) A) Create a generic excel spreadsheet where the interest rate, i, can be changed at the top and all tabulated values in the rest of the sheet will change accordingly. 1 2 3 71 B C D E F G Yr Interest i% SINGLE PAYMENT UNIFORM SERIES CAF PWF SCA SFF SPW CRF (F/P) (P/F) (FA) (A/F) (P/A) (AP) =(1+$CSY A4 1 (1 + $C$1)^A4 (1 + $C$1) 44-1 1 C+ $C$1 E+ $C$1*(1 + $C$1) A4 G+ 4 n 1 = = = = = 5 8 Note: After creating this sheet, all problems can use the spreadsheet to create a table for any interest rate, i, or year, n, needed, instead of using the formulas. Use interest rate, i = 10% and n = 8 years to calculate each factor in row 5. B) Then use the table you created in part A to calculate the numerical values of the following factors: a) (F/P,5%,10) b) (P/F,6%,8) c) (F/A,10%, 10) d) (A/F,2%,30) e) (P/A,4%, 9) f) (A/P,35%, 15)