Please answer the question using excel and show the calculation

Please answer the question using excel and show the calculation

Case 2 (15pts) LO-4: apply Calculation of Cost of Capital, Capital Budgeting Cash Flow Weston, Co. is a basic consumption industry company, has a plan to buy a set of new machines with 2 options, they are machine A at cost of Rp 400,000,000, and the cost of machine B Rp 500,000,000. Verified by, Kartika Dewi (D4402) and sent to Department/Program on August 09, 2021 Page 2 of 4 FM-BINUS-AA-FPU-78/V2RO Estimates economic life of each machine is 5 years, and annually requirement return rate is 10%. Net cash receipts are estimated as follows: Year 0 1 2 3 4 5 Machine A (Rp) 400.000.000 160.000.000 120.000.000 100.000.000 80.000.000 60.000.000 Machine B (Rp) 500.000.000 140.000.000 140.000.000 140.000.000 140.000.000 140.000.000 Based on above information, calculate! a. Payback periods of machine A and B b. Net Present Values of machine A and B c. Profitability Index of machine A and B. For each above results, give recommendations which machine to be selected