hello, reposted: need help with this Capital budgeting: need to find payback period, discounted payback, NPV,and IRR. PLEASE PROVIDE EXCEL FORMULAS. will give good rating/thumbs up

D E F G H 1 3 K M N O Capital Budgeting Spreadsheet Example VIII Name: Date: Project 1 Project 2 Project 3 3 125,000 5 200.000 S 180.000 mont Capital Payback 8% 4 years 10% 4 years 12% 4 years Cash Flow Project 1 Cum CF Discounted CF Cum, CF Project 2 Cum CF Decounted CF Cum CF Project 3 Cum CF Decorated CF Cum CF vestment S (125.000) $ (125,000) $ (125,000) 3 (125,000) $200,000) 5 (200,000) 5 (200,000) $ (200,000) $ (160,000) $ (160,000) $ (160,000) $ (160,000) Year 1 $ 30,000 $ (95.000) $ 27.778 $ (97.222) 5 45,000 $ (155.000) $ 40,000 $ (169,091) S 35,000 $ (125,000) 31,250 $ (128,750) Year 2$ 30,000 $ (65,000) $25,720 $ 71,502) $ 45,000 3 (110,000) $ 37,100 $ (121,001) $ 40,000 $(85,000) S 31,888 S (96,862) Year 3$ 30,000$ (35,000) $ 23,815 $ (47,687) $ 80,000 $ (50,000) $ 45,079 $ 176,822) $ 45,000 $ (40,000) 32030 $ (64832) Year 45 30,000 $ (5,000) $ 22,051 $ (25,636) $ 60,000 $10,000 $ 40,981 $ (35,841) S 50,000 $ 10,000 $ 31.778 5 (33,056 Year 5$ 40.000 $ 35,000 $ 27.223 $ 1,587 $ 60.000 $ 70,000 $ 37.255 $ 1.414 $ 60,000 $70.000 $ 34,040 5 980 Project 1 Project 2 Period wted Payback Project 3 Which project() should be accepted? Roject Project Accept Project 23 Roject Project, 128 Accept Project 1,2,3 Accept Project 123 Financial Statements Statement of CF Financial Ratios Time Value Risk & Return tonds Stocks Capital Budgeting Cost of Capital MFM + WS