ABC Corporation has a machine that requires repairs or should be replaced. ABC has evaluated the two options and calculated the cash flows resulting from each option as follows:

Option A: Repair the Machine

Year	Cash Flow
0	-50,000
1	15,500
2	20,100
3	18,900
4	17,100
5	13,700

Option B: Buy a new Machine

Year	Cash Flow
0	-400,000
1	51,300
2	155,000
3	127,800
4	126,900
5	125,100

You have recently been hired by ABC Corporation and your first assignment is to help them decide which of these two options should be pursued. You would like to apply Capital Budgeting and Time Value of Money concepts you have learnt in your finance class to analyze the problem and present your recommendation to your boss, Ms. Jane Austen.

The company has a Weighted Average Cost of Capital (WACC) of 12%. However, recent actions of the Federal Reserve indicated potential increase in interest rates in the near future.

Please post an Excel spreadsheet showing calculation of the capital budgeting method(s) you selected and various discount rates in addition to the WACC.