FIN 301-Principles of Finance Excel and Writing Assignment ABC Corporation optio

Question

FIN 301-Principles of Finance Excel and Writing Assignment ABC Corporation options and calculated the cash flows resulting from each option as follows requires repairs or should be replaced ABC has evaluated the two Option A Repair the Machine Year Cash Flow 32 500 Option B: Buy a new Machine Cash low 450,000 95,300 165,000 137 800 26,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 ike to apply Capital Budgeting Time Value of Money concepts you have learnt in FIN 301 to analyze the problem and present your recommendation to your boss, Ms. Jane Austen. Conduct the analysis by calculating the following for each option 1. Net Present Value (NPV) 2 Internal Rate of Return (IRR) 3. Proftability Index(P) 4 Payback Period (PB) 5. Crossover Rate The company has a weighted Average Cost of Capital (WACC) ldiscount Rate) of 10%. For this anans your boss John Doe asked you to calculate NPV at ee different discount rates: 10% e current WACC), 12% and 14%.

Explanation / Answer

1. NPV

Option A : Repair the machine

Option B : Buy a New Machine

2. Internal Rate of Return (Repair the machine)

Internal Rate of Return (Buy a New Machine)

3. Profitability Index

Option A : Repair the machine - Discounted at 10%

Option B : Buy a New Machine - Discounted at 10%

4. PayBack Period

Calculation note = 0.382694 = -(29964.3)/78298.17

5. Crossovefr Rate

1. NPV

Option A : Repair the machine

Year Cah Flow Present Value Present Value Present Value 0 -50000 -50000.00 -50000.00 -50000.00 1 32500 29545.45 29017.86 28508.77 2 21100 17438.02 16820.79 16235.76 3 19900 14951.16 14164.43 13431.93 4 18100 12362.54 11502.88 10716.65 5 14700 9127.54 8341.17 7634.72 NPV 33424.72 29847.13 26527.84 (at 10%) (at 12%) (at 14%)

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.