Compute ARR using
deduct method-Payback Period, AND NPV And IRR
Data Set
Make investment tto
increase/sales by qty. below
Qty
New machine /cost
$200,000
Pre investment Sales
18,000
Working capital turns
6.00
Resdiual at end of usage
$0
Beginning WC investment
$10,000
Life/Years
4
Added fixed Expense
$5,000
Hurdle Rate
13.50%
1
2
3
4
Added sales by year
15%
20%
25%
25%
Sales $s added
Existing Margin
Tax Rate
40%
SP Each
$70.00
Variable Cost each
$36.00
Margin $s
$34.00