FIN 301 – Principles of Finance Excel and Writing Assignment Assignment Description: ABC Corporation has a machine that requires repairs or should be replaced. ABC has evaluated the two options and...

1 answer below »

View more »
Answered Same DayAug 10, 2021

Answer To: FIN 301 – Principles of Finance Excel and Writing Assignment Assignment Description: ABC Corporation...

Neenisha answered on Aug 13 2021
154 Votes
Principles of Finance
We have two projects – Option A – Repair the Machine and Option B – Buy a New Machine. The cash flow from both the projects for next 5 years are shown as foll
ows.
    OPTION A: REPAIR THE MACHINE
    0
    1
    2
    3
    4
    5
     (50,000)
    31,500
    20,100
    18,900
     17,100
    13,700
    OPTION B: BUY A NEW MACHINE
    0
    1
    2
    3
    4
    5
    (4,00,000)
    91,300
    1,55,000
    1,27,800
     1,26,900
    1,25,100
Internal Rate of Return and Profitability Index
For both the option we have computed Internal Rate of Return (IRR) and Profitability Index (PI). The IRR of Option A is 35.32% which is higher than the Option B. Also, the profitability for Option A i.e. repairing the machine is higher as the initial investment is less and cash flows are still decent.
     
    Option A
    Option B
    Internal Rate of Return (IRR)
    35.32%
    16.56%
    Profitability Index (PI)
    52.48%
    11.92%
Three Scenarios – NPV and Payback period Calculation
Case 1
    WACC
    12%
    
    
    
    
     
    Option A
    Option B
    Net Present Value (NPV)
    26,242.35
    47,680.77
    Payback Period (PB) (Discounted) - Option A
     
    0
    1
    2
    3
    4
    5
    Cash Flows
     (50,000)
     31,500
     20,100
     18,900
     17,100
     13,700
    Discounted Cash Flows
     (50,000)
     28,125
     16,024
     13,453
     10,867
     7,774
    Cumulative Cash Flows
     (50,000)
     (21,875)
     (5,851)
     7,601
    
    
    
    
    
    
    
    
    
    Payback Period
     2.43
    
    
    
    
    
    Payback Period (PB) (Discounted) - Option B
     
    0
    1
    2
    3
    4
    5
    
     (4,00,000)
     91,300
     1,55,000
     1,27,800
     1,26,900
     1,25,100
    Discounted Cash Flows
     ...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30