Please calculate dep$, ebit, tax$, Net income, Nominal cash flow, PV, NPV, irr,
ID: 2731749 • Letter: P
Question
Please calculate dep$, ebit, tax$, Net income, Nominal cash flow, PV, NPV, irr, payback, and discounted payback? Equipment can be Salvaged at ($50,000,00) with intial cost of $170,000,000. Average cost of capital is 20.30%.
Sales 50,000,000 130,000,000 150,000,000 160,000,000 110,000,000 80,000,000 var % 30% 30% 30% 30% 30% 30% Var $ 15,000,000 39,000,000 45,000,000 48,000,000 33,000,000 24,000,000 Fixed $ 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 Dep % 20.00% 32.00% 19.00% 12.00% 11.00% 6.00% Dep $ EBIT tax % 20.3% 20.3% 20.3% 20.3% 20.3% 20.3% Tax $ NI ncf PV NPV IRR Payback Disc. PayExplanation / Answer
Sales
50000000
130000000
150000000
160000000
110000000
80000000
Var %
30
30
30
30
30
30
Var $
15000000
39000000
45000000
48000000
33000000
24000000
Fixed
10000000
10000000
10000000
10000000
10000000
10000000
Dep %
20
32
19
12
11
6
Dep $
33990000
54384000
32290500
20394000
18694500
10197000
EBIT
8990000
26616000
62709500
81606000
48305500
35803000
Tax %
20.3
20.3
20.3
20.3
20.3
20.3
Tax $
1824970
5403048
12730029
16566018
9806016.5
7268009
Net Income
7165030
21212952
49979471
65039982
38499483.50
28534991
Sales
50000000
130000000
150000000
160000000
110000000
80000000
Var %
30
30
30
30
30
30
Var $
15000000
39000000
45000000
48000000
33000000
24000000
Fixed
10000000
10000000
10000000
10000000
10000000
10000000
Dep %
20
32
19
12
11
6
Dep $
33990000
54384000
32290500
20394000
18694500
10197000
EBIT
8990000
26616000
62709500
81606000
48305500
35803000
Tax %
20.3
20.3
20.3
20.3
20.3
20.3
Tax $
1824970
5403048
12730029
16566018
9806016.5
7268009
Net Income
7165030
21212952
49979471
65039982
38499483.50
28534991