**Please use excel format for solving with equations**

As y 6 RAP4 24at a stand up 14 28061 12 salaod tu I said 2. at PA AMAN 2 > + 11. Ptates, MM #CH 144 Problem 12-21 (parts a and be only) Project A Project B INPUT (5 in millions Year 0 1 2 3 4 Cost of Capital OUTPUT -Cumulative Cash Flows and Regular Payback Year Cumulative CFA Cumulative CRB 0 1 2 3 Regular Payback Use PERCENTRANK.INCD for payback Use PVC) to solve for the present value, Le the discounted cash flow (DCF) OUTPUT - Discounted Cash Flows (OCFsl. Cumulative DCF and Discounted Payback Discounted CFS Cumulative DCFS Discounted CF Cumulative DCFS Year (DCFS) A (DCF) B 0 1 2 3 4 Discounted Payback Use PERCENTRANKINCI) for discounted payback As y 6 RAP4 24at a stand up 14 28061 12 salaod tu I said 2. at PA AMAN 2 > + 11. Ptates, MM #CH 144 Problem 12-21 (parts a and be only) Project A Project B INPUT (5 in millions Year 0 1 2 3 4 Cost of Capital OUTPUT -Cumulative Cash Flows and Regular Payback Year Cumulative CFA Cumulative CRB 0 1 2 3 Regular Payback Use PERCENTRANK.INCD for payback Use PVC) to solve for the present value, Le the discounted cash flow (DCF) OUTPUT - Discounted Cash Flows (OCFsl. Cumulative DCF and Discounted Payback Discounted CFS Cumulative DCFS Discounted CF Cumulative DCFS Year (DCFS) A (DCF) B 0 1 2 3 4 Discounted Payback Use PERCENTRANKINCI) for discounted payback