Please solve using Excel only & show solution

Here AAA = 1, BBB= 43708 CCC = 43708

(15 pts) Consider a cash flow profile in which $ BBB is received at t1, spent at t 2, and received at t-5, and S CCC is received at t 3. Suppose the interest rate is (AAA 2) % the first 2 periods, (AAA + 4) % the next two periods and is (AAA + 6) % the 5th period. ( Note: t denotes end of period t.) Find the equivalents for the cash flow profile for the following items. a) Present worth b) Uniform series equivalent e) Geometric series equivalent (j AAA % for the entire period) Show your calculation in detail and explain how the results are obtained. $ B $ BB $CCC 4 0 (A+2)% 1 (AAA+2)% 2 (AAA+4)% 3 (A+4)% (AA+6)% $ B LO (15 pts) Consider a cash flow profile in which $ BBB is received at t1, spent at t 2, and received at t-5, and S CCC is received at t 3. Suppose the interest rate is (AAA 2) % the first 2 periods, (AAA + 4) % the next two periods and is (AAA + 6) % the 5th period. ( Note: t denotes end of period t.) Find the equivalents for the cash flow profile for the following items. a) Present worth b) Uniform series equivalent e) Geometric series equivalent (j AAA % for the entire period) Show your calculation in detail and explain how the results are obtained. $ B $ BB $CCC 4 0 (A+2)% 1 (AAA+2)% 2 (AAA+4)% 3 (A+4)% (AA+6)% $ B LO