In: Operations Management
1. Buy Option | |||||||||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
Cash outflow | -$700,000 | ||||||||||
Cash inflow | $600,000 | $500,000 | $300,000 | $200,000 | $100,000 | ||||||
PV @ 8% | $555,556 | $428,669 | $257,202 | $158,766 | $79,383 | (Formula: cash flow / (1+0.08)^Number of years | |||||
Sum of PV | $1,479,576 | ||||||||||
Initia Outlay | -$700,000 | ||||||||||
NPV | $779,576 | ||||||||||
IRR | 58% | (Furmula in excel: IRR(C4:H5) | |||||||||
2. Lease Option | |||||||||||
Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||
Cash outflow | -$50,000 | -$70,000 | -$120,000 | -$120,000 | -$120,000 | -$120,000 | |||||
Cash inflow | $600,000 | $500,000 | $300,000 | $200,000 | $100,000 | ||||||
PV inflow @ 18% | $555,556 | $428,669 | $257,202 | $158,766 | $79,383 | (Formula: cash flow / (1+0.08)^Number of years | |||||
PV outflow @ 18% | -$50,000 | -$59,322 | -$86,182 | -$73,036 | -$61,895 | -$101,695 | |||||
Sum of inflow PV | $1,479,576 | ||||||||||
Sum of outflow PV | -$432,129 | ||||||||||
NPV | $1,047,447 | ||||||||||
IRR | 26% | (Furmula in excel: IRR(C4:H5) | |||||||||