Please help solve these questions. I will upvote and make it clear and consice thank you!

4 # B FIN 301 - Capital Budgeting Assignment EXCEL PART: Submission format: Excel File WRITING PART: Submission format: Word Document ABC Corporation has a machine that requires repairs or shof You have recently been hired by XYZ corporation and your first assignment is to help ABC has evaluated the two options and calculated the cash 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. ption A: Repair the Machir Year Cash Flow conduct the analysis and calculate Payback period for each option, IRR of each option and 0 $61.500.00 Pland NPV for each option at four Discount Rates (R) of 8%, 12%, 16%, and 20% 1 $16,500.00 2 $33,100.00 Write a memo to your boss, explaining the results of your analysis, your decision 3 $17.500.00 and include a table and a chart showing your analysis. $17,200.00 S $10,700.00 ption B: Buy a new Machir Requirements: Year Cash Flow 1 Compute Pay Back for each Option Pay Back o $340,500.00 2 Compute IRR for each Option 1 $54,300.00 2 $123,000.00 Compute NPV and PI for each option using disccount rates: 3 $113,800.00 R NPVA NPVB PIA PIB 4 $122,900.00 3 8% 7 8% 5 $120,100.00 4 12% 8 12% 16% 16% 6 20% 10 20% 11 NPV Profile chart with R on X Axis and NPV on Yaxis (Two lines one each for NPV A and NPV B) 12 A One page professional memo written in MS Word explaining your decision betwwen options A and B. Grading: Excel Analysis: 70% of overall assignment grade Word memo: 30% of overall assignment grade Timeliness: A 5% penalty for every day delayed. Assignment will not be accepted after 5 late days. Note: Use Workout Sheet to compute and showcase your work. IT IS IMPORTANT THAT NPV & IRR IS COMPUTED USING EX- IRR M N R 5 9