3 Assignment EXCEL PART: Submission format: Excel File WRITING PART: Submission format: Word Document ABC Corporation has a machine that requires repairs or should be replaced. You have recently been hired by XVZ corporation and your first assignment is to help ABC has evaluated the two options and calculated the cash flows resulting them decide which of these two options should be pursued. You would like to apply the from each option as follows: capital budgeting and Time Value of Money concepts you have learnt in FIN 301 to analyze the solution and present it to your boss in three days. Option A: Repairthe Machine Conduct the analysis and calculate Payback period for each option. IRR of each option and 1 PI and NW for each option at four Discount Rates ( R ) 019%, 12%, 15%, and 18% Write a memo to your boss, explainingthe results ofvour analysis, your decision 1 $18,500 00 and include a table and a chart showing your analysis. $15,200.00 Option B: Buy a new Machine ll Requirements: Cash Flow 1 Compute Pav Back for each Option $340,500 00 2 Compute IRR for each Option _il $105,000.00 Compute NW and PI for each option using disccount rates: I .1 ' $120,100.00 wmua mmhwa 10 11 NW Prole chart with R on X Axis and NPV on Y axis (Two lines one each for NFV A and NPV B] 12 A One page professional memo written In MS Word explaining your decision betwwen options A and B