Exercise All Week - UAS
Exercise All Week - UAS
Exercise All Week - UAS
WACC 14%
a)
NPV A $ 0.87 Year Project A Project B
NPV B $ 1.23 0 $ -6 $ -18
1 $ 2 $ 5.6
2 $ 2 $ 5.6
IRR A 20% 3 $ 2 $ 5.6
IRR B 17% 4 $ 2 $ 5.6
5 $ 2 $ 5.6
MIRR A 17%
MIRR B 16%
Payback A 3.000
Payback B 3.214
d) Timing differences (cash flow came early/late) & The amount of investment is larger for project A compared to B
Cumulative
$ -18
$ -12
$ -7
$ -1
$ 4
$ 10
r project A compared to B
FINANCIAL ACCOUNTING ASSIGNMENT
Chapter 10 – Stocks and their valuation
DIVA TERTIA ALMIRA – NIU 470320
10 - 1
D1 $ 1.20
g1-2 10%
gn 5%
D1 D0 (1+g1) =
D2 D0 (1+g1) (1+g2) =
D3 D0 (1+g1) (1+g2) (1+gn) =
D4 D0 (1+g1) (1+g2) (1+gn) (1+gn) =
10 - 2
d1 $ 0.50
g 7%
Rs 15%
P̂0 = D1
rs - g
= $ 0.50
8.0%
= 6.25
10 - 3
P0 $ 25.00
r 15%
d0 $ 1.50
g ?
P0 = d0(1+g)
rs - g
25 = 1,5 (1 + g)
15% - g%
g = 8.5%
P1 = P0(1 + g)
= 27.12
10 - 4
D0 1.25
Non constant g 20%
Constant g 5%
r 10%
0 20% 1 2 5% 3
b)
Pn = D3
rs - g
1.89
5%
Pn = 37.8
c)
PV D1 $ 1.36
PV D2 $ 1.49
PV P3 $ 31.24
P0 $ 34.09
10 - 5
WACC 12%
FCF $ 200,000,000
g 6%
#Shares 100,000,000
0 12% 1 6% 2
MV Equity = $ 3,333,333,333
Value/Share = $ 33.33 -
10 - 6
Vp $ 50.00
D $ 4.00
rp ?
Vp = D
rp
$ 50 = $ 4.00
rp
rp = $ 4.00
$ 50.00
8%
10 - 7
D0 6
rp 10%
Vp = D
rp
Vp = 6
10%
Vp = 60
10 - 8
D $ 10.00
rp 8%
a) b)
Vp = D Vp = D
rp rp
Vp = $ 10.00 Vp = $ 10.00
8% 12%
Vp = $ 125.00 Vp = $ 83.33
10 - 9
D $ 1.00 Quarter
D $ 4.00 Annual
Vp $ 120.00
Vp = D
rp
120 = 4
rp
rp = 3%
10 - 9
D0 $ 5.00
rs 15%
g -5%
P0 = D1
rs - g
P0 = 4.75
20%
P0 = 23.75
10 - 10
$ 1.32
$ 1.45
$ 1.52
$ 1.601
11 - 1
Coupon 10%
PMT $ 100.00
rd 12%
T 35%
11 - 2
Pp $ 47.50
Dp $ 3.80
rp = Dp
Pp
rp = $ 3.80
$ 47.50
rp = 8%
11 - 3
wd 40%
wc 60%
rd 9%
T 40%
WACC 9.96%
WACC = wd rd(1 – T) + wp rp + wc rs
9,96% = 40% * 9% (1-40%) + 60% * rs
9,96% = 2% + 60%rs
rs = 13.27%
11 - 4
P 30
D 3
g 5%
a)
rs = D1 + g
P0
3 + 5%
30
rs = 15%
b)
rs = D1 + g
P0 (1 - F)
3 5%
+
30 (1 - 10%)
rs = 16.11%
11 - 5
WACC 10.50%
11 - 6
g 7%
D0 $ 2.00
D1 $ 2.14
P0 $ 23.00
a) DCF
rs = D1 g
+
P0
rs = $ 2.14 + 7%
$ 23.00
rs = 16.30%
b) CAPM
rs = rRF + (rM – rRF)b
rs = 9% + (13%-9%)1,6
rs = 15.40%
c) Bond-Yield-Plus-Risk-Premium
rs = rd + RP
rs = 12% + 4%
rs = 16%
11 - 7
D1 $ 3.18
g 6%
Ps $ 36.00
Pe $ 32.40
a)
rs = D1 + g
P0
rs = $ 3.18 + 6%
$ 36.00
rs = 14.83%
b)
F= $ 3.60
$ 36.00
F= 10%
c)
rs = D1 + g
P0 (1-F)
rs = $ 3.18 + 6%
$ 32.40
rs = 15.81%
11 - 8
wd 40%
wc 60%
rd (BT) 12%
T 40%
P0 $ 22.50
D0 $ 2.00
g 7%
rd (AT) = 7%
rs = D1 g
+
+
P0
rs = $ 2.14 + 7%
$ 22.50
rs = 16.51%
WACC = wd rd(1 – T) + wp rp + wc rs
12.79%
11 - 9
Weight
Long-term debt $ 1,152.00 40%
Equity $ 1,728.00 60%
$ 2,880.00
rd (BT) 13%
T 40%
rd (AT) 8%
rs 16%
WACC = wd rd(1 – T) + wp rp + wc rs
WACC = 12.7%
11 - 10
wd 40%
wc 60%
T 40%
Project $ 5,900,000
Debt $ 2,360,000
Equity $ 3,540,000
R/E $ 2,000,000
New Stock $ 1,540,000
rs 12%
re 15%
rd 10%
WACC = wd rd(1 – T) + wp rp + wc rs
WACC = 11.4%
11 - 11
rd 11%
D0 $ 2.00
P0 $ 24.75
g 7%
T 35%
WACC 13.95%
rd (AT) 7%
rs = D1 + g
P0
rs = $ 2.14 + 7%
$ 24.75
rs = 16%
WACC = wd rd(1 – T) + wp rp + wc rs
13,95% = 0,0715wd + 0,156464646464646(1-wd)
13,95% = 0,0715wd + 0,156464646464646 - 0,156464646464646wd
-2% -0,0849646464646465wd
wd = 20%
11 - 12
12 - 1
WACC 12%
Year CF
0 $ -52,125
1 $ 12,000
2 $ 12,000
3 $ 12,000
4 $ 12,000
5 $ 12,000
6 $ 12,000
7 $ 12,000
8 $ 12,000
NPV $ 7,487
12 - 2
IRR 16%
12 - 3
MIRR 14%
12 - 4
Year CF Cumulative
0 $ -52,125 $ -52,125
1 $ 12,000 $ -40,125
2 $ 12,000 $ -28,125
3 $ 12,000 $ -16,125
4 $ 12,000 $ -4,125
5 $ 12,000 $ 7,875
6 $ 12,000 $ 19,875
7 $ 12,000 $ 31,875
8 $ 12,000 $ 43,875
Payback 4.34
12 - 5
12 - 6
WACC 1 5%
WACC 2 10%
WACC 3 15%
a)
PROJECT A
PROJECT B
b)
PROJECT A
IRR 11%
PROJECT B
IRR 13%
12 - 7
WACC 14%
a)
NPV A $ -1.44
NPV B $ -0.25
IRR A 11%
IRR B 13%
MIRR A 12%
MIRR B 14%
Payback A 2.588
Payback B 2.167
Discounted Payback A ?
Discounted Payback B ?
d) Timing differences (cash flow came early/late) & The amount of investment is larger for project A compared to B
12 - 8
a)
NPV Mitigation $ 5.70
NPV W/o Mitigation $ 12.10
b)
c) W/o mitigation is more proftiable but company should use mitigation to avoid any bad effect to enviromant that wil
12 - 9
Cumulative
$ -20
$ -10
$ -1
$ 5
r project A compared to B
effect to enviromant that will in turn affect company's value to public
Integrated Case - 12
WACC 10%
Independent = Both
Mutually Exclusive = Project S
d)
IRR Project L 18.13%
IRR Project S 23.56%
Independent = Both
Mutually Exclusive = Project S
e)
Year Project L Project S ٨ CF
0 $ -100 $ -100 $ -
1 $ 10 $ 70 $ -60
2 $ 60 $ 50 $ 10
3 $ 80 $ 20 $ 60
g)
MIRR Project L 16.50%
MIRR Project S 16.89%
h)
i)
WACC 10%
Year Project L
0 $ -800
1 $ 5,000
2 $ -5,000
NPV $ -386.78
IRR 25%
MRR 6%
Reject Project
13 - 1
in IDR Mio
Equipment Cost $ 9
∆ NOWC $ 3
Tax 40%
a)
Initial Investment $ 12
b)
No, this is sunk cost not classified as incremental cost
c)
This is an opportunity cost, so it's possible to change the outcome
13 - 2
in IDR Mio
Sales Revenue $ 10
Operating Cost (Excl. Dep) $ 7
Depreciation $ 2
Interest Expense $ 2
Tax 40%
WACC 10%
a)
Total Revenues $ 10
Operating Cost excluding deprciation $ 7
Depreciation $ 2
Total Costs $ 9
EBIT (Operating Income) $ 1
Taxes on Operating Income $ 0.4
EBIT (1 - T) = After - Tax operating Income $ 0.6
Add back Depreciation $ 2
EBIT (1-T) + Depreciation $ 2.6
b)
Cannibalism is part of externalities so it will change the outcome
Total Revenues $ 10
Operating Cost excluding deprciation $ 7
Depreciation $ 2
Externalities $ 1
Total Costs $ 10
EBIT (Operating Income) $ -
Taxes on Operating Income $ -
EBIT (1 - T) = After - Tax operating Income $ -
Add back Depreciation $ 2
EBIT (1-T) + Depreciation $ 2.0
c)
Total Revenues $ 10
Operating Cost excluding deprciation $ 7
Depreciation $ 2
Total Costs $ 9
EBIT (Operating Income) $ 1
Taxes on Operating Income $ 0.3
EBIT (1 - T) = After - Tax operating Income $ 0.7
Add back Depreciation $ 2
EBIT (1-T) + Depreciation $ 2.7
13 - 3
in IDR Mio
Equipment Cost $ 20
Depreciation $ 16
Salvage Value $ 5
Tax 40%
13 - 4
13 - 6
a)
Year MACRS % Straight Line %
1 $ 264,000 33% $ 200,000 25%
2 $ 360,000 45% $ 200,000 25%
3 $ 120,000 15% $ 200,000 25%
4 $ 56,000 7% $ 200,000 25%
b)
Year CF MACRS CF Straight Line Difference Include Tax
1 $ 264,000 $ 200,000 $ 64,000 $ 25,600
2 $ 360,000 $ 200,000 $ 160,000 $ 64,000
3 $ 120,000 $ 200,000 $ -80,000 $ -32,000
4 $ 56,000 $ 200,000 $ -144,000 $ -57,600
$ 12,781.64
13 - 7
NPV $ 12
13 - 8
b)
Year 0 Year 1
Total Revenues $ 50
Operating Cost excluding deprciation $ -
Depreciation $ 56
Total Costs $ 56
EBIT (Operating Income) $ -6
Taxes on Operating Income $ -2.4
EBIT (1 - T) = After - Tax operating Income $ -4
Add back Depreciation $ 56
EBIT (1-T) + Depreciation $ 52.4
Don't Purchase
13 - 9
a)
Ignore it since it's a sunk cost and not incremental cost
b)
Equipment Cost $ 108 MACRS Depreciation Rate
Installation $ 12.5 Year 1
CAPEX $ 120.5 33%
Increase in Inventory $ 25.0
Increase in account payable $ 5.0 TAX 35%
∆ NOWC $ 5.5 WACC 12%
Investment Outlays $ 126.00
c)
Year 0 Year 1
Total Revenues $ 44
Operating Cost excluding deprciation $ -
Depreciation $ 40
Total Costs $ 40
EBIT (Operating Income) $ 4
Taxes on Operating Income $ 1.5
EBIT (1 - T) = After - Tax operating Income $ 3
Add back Depreciation $ 40
EBIT (1-T) + Depreciation $ 42.5
Year 2 Year 3
$ 50 $ 50
$ - $ -
$ 77 $ 26
$ 77 $ 26
$ -27 $ 25
$ -10.6 $ 9.8
$ -16 $ 15
$ 77 $ 26
$ 60.6 $ 40.2
$ 60
$ 12
$ 19
$ 41
$ 8
$ 60.60 $ 88.96 88.96
$ 65
$ 8
$ 20
$ 45
$ 6
$ 47.58 $ 85.63
End of Year 0
I. Investment Outlays
Equipment Cost $ 200
Installation $ 40
CAPEX $ 240
Increase in Inventory $ 25
Increase in account payable $ 5
∆ NOWC $ 20
IV. Results
NPV $ -3.66
IRR 9.3%
MIRR 9.6%
Payback 3.30
Year
0
1
2
3
4
NPV
EAA
(in thousands $)
1 2 3 4
$ 25
$ 10
$ 15
$ 20
$ 79.68 $ 91.20 $ 62.40 $ 89.72
$ -180.32 $ -89.12 $ -26.72 $ 63.00
TAX
40.00%
WACC
10%
CF Machine A CF Machine B
$ -50,000.00 $ -50,000.00
$ 17,500.00 $ 34,000.00
$ 17,500.00 $ -22,500.00
$ 17,500.00 $ 34,000.00
$ -32,500.00 $ 27,500.00
$ 17,500.00
$ 17,500.00
$ 17,500.00
$ 1,046.66 $ 6,641.62
b)
Tax 40%
EBIT $ 400,000
#Shares Outstanding 80,000
Shares Price $ 25
Total Invested Capital $ 2,000,000
EBIT(1 T)
ROIC
Total invested capital
($400,000) (0.6)
$2,000,000
12%
ROIC = 12%
c)
Standard deviation
Interest 12% N
(r r̂ ) 2 Pi
Tax 40% i 1
FIRM U
d) 3.
Tax 40%
EBIT $ 400,000
#Shares Outstanding 80,000
Shares Price $ 25
Total Invested Capital $ 2,000,000
Debt $ - EPS
(EBIT rdD)(1 T)
Shares outstandin g
EPS 3.00
($400,000) (0.6)
80,000
$3.00
EBIT $400,000
TIE 20x
Int. Exp. $20,000
Debt $ 250,000
Shared Repurchase $ 10,000
Shares Remain $ 70,000
EPS 3.26
Interest Expense $ 20,000
TIE 20
Debt $ 500,000
Shared Repurchase $ 20,000
Shares Remain $ 60,000
EPS 3.55
Interest Expense $ 45,000
TIE 8.9
d) 4.
Hamada Equation
rRF 6%
RPm 6%
bu 1
Debt $ 250,000
bl 1.09
rs 12.5%
Debt $ 500,000
bl 1.20
rs 13.2%
d) 5.
Amount borrowed Debt/Capital Ratio D/E Ratio
$ - 0 0
$ 250 13% 0.14
$ 500 25% 0.33
$ 750 38% 0.60
$ 1,000 50% 1.00
d) 6.
D1 EPS DPS Amount borrowed Debt/Capital Ratio D/E Ratio
P̂0
rs g rs rs
D1 EPS DPS
P̂0
rs g rs rs $ - 0 0
$ 250 13% 0.14
$ 500 25% 0.33
$ 750 38% 0.60
$ 1,000 50% 1.00
FIRM L
Bond Rating rd
0 0
AA 8%
A 9%
BBB 11.50%
B 14%
(EBIT rdD)(1 T)
EPS
Shares outstandin g
($400,000)(0.6)
80,000
$3.00
Debt $ 750,000
Shared Repurchase $ 30,000
Shares Remain $ 50,000
EPS 3.77
Interest Expense $ 86,250
TIE 4.6
Debt $ 1,000,000
Shared Repurchase $ 40,000
Shares Remain $ 40,000
EPS 3.90
Interest Expense $ 140,000
TIE 2.9
Debt $ -
bl 1.00
rs 12.0%
Debt $ 750,000
bl 1.36
rs 14.2%
Debt $ 1,000,000
bl 1.60
rs 15.6%
rd (1 - T) rs WACC
0.00% 12.0% 12.00%
4.80% 12.5% 11.55%
5.40% 13.2% 11.25%
6.90% 14.2% 11.44%
8.40% 15.6% 12.00%
rd (1 - T) rs EPS P0
0.00% 12.0% $ 3.0 $ 25.00
4.80% 12.5% $ 3.26 $ 26.03
5.40% 13.2% $ 3.55 $ 26.89
6.90% 14.2% $ 3.77 $ 26.59
8.40% 15.6% $ 3.90 $ 25.00
15 - 1
𝑸=𝑭/(𝑷−𝒗)
Q= 600,000
15 - 2
30% Debt & 70% Equity because it generate highest stock price
15 - 3
a)
Probability
Firm 0.1 0.2 0.4
A $ -1.50 $ 1.80 $ 5.10
B $ -1.20 $ 1.50 $ 4.20
C $ -2.40 $ 1.35 $ 5.10
b)
Firm EPS 𝜎 CV
A $ 5.10 3.615 0.709
B $ 4.20 2.958 0.704
C $ 5.10 4.108 0.805
Firm C is the most risky as it have the highest risk per share
15 - 4
Assets $ 10,000,000
Debt $ 3,000,000
Equity $ 7,000,000
D/E 43%
b 1.2
Tax 40%
bu = 0.9545
15 - 5
Tax 40%
Invested Capital $ 20,000,000.00
a)
HL LL
Equity $ 10,000,000 $ 14,000,000
Debt $ 10,000,000 $ 6,000,000
b)
LL
Equity $ 8,000,000
Debt $ 12,000,000
EBIT $ 4,000,000
Interest $ 1,800,000
Earnings Before Tax $ 2,200,000
Tax $ 880,000
Net Income $ 1,320,000
ROE 16.5%
15 - 6
a)
EBIT = PQ - VQ - F
EBIT (8,000 Watches) = $ -60,000
EBIT (18,000 Watches) = $ 40,000
b)
𝑸=𝑭/(𝑷−𝒗)
Q= 14,000
c)
Sales Price $ 31
Q= 8,750
Apart from Fixed cost, the difference between Price and variable cost also affect BEP quantity
The larger the profitability, the lower BEP quantity
d)
Variable Cost $ 23
Q= 17,500
15 - 7
15 - 8
Rrf 5%
RPm 6%
Tax 40%
Cost of Equity 14%
Equity 75% New Equity 50%
Debt 25% New Debt 50%
bl 1.5
bu 1.25
New bl 2.0
rs 17%
15 - 9
9%
11%
14%
c
1)
Capital $ 800,000
Net Income $ 600,000
Equity 60%
Debt 40%
T arg et Total
Dividends Net income equity capital
ratio budget
Dividends = $ 120,000
Dividend Payout = Dividends
Net Income
20%
Dividends = $ -80,000
Dividend Payout = -13%
0% issue new stock
Dividends = $ 320,000
Dividend Payout = 40%
16 - 1
Capital $ 3,000,000
Net Income $ 3,000,000
Equity 30%
Debt 70%
T arg et Total
Dividends Net income equity capital
ratio budget
Dividends = $ 2,100,000
Dividend Payout = Dividends
Net Income
70%
16 - 2
P0 $ 80
Split 4/2
P0 New $ 80
4/2
$ 40
16 - 3
P/E Ratio = P0
EPS
16
16 - 4
Dividend $ 0.9
Split 5/1
Increase 9%
16 - 5
Investment $ 10,000,000
Net Income $ 5,000,000
Equity 60%
Debt 40%
Dividend Payout ratio 45% Net Income
Dividend $ 2,250,000
External Equity $ 3,250,000
16 - 6
Dividend $ 2,287,500
Dividend Payout = Dividends
Net Income
31.39%
d
Loan $ 100,000
Interest 8% $ 8,000
Period 1 365 days
rNOM = 12 (0.012043)
= 0.1445 = 14.45%
EAR = (1.012043)12 – 1 = 15.45%
Rate 1.2043%
rNOM 14.452%
EAR 15.449%
monthly payments of $9,000 (like an annuity).
17 - 1
Sales $ 15,000,000
Inventories $ 2,000,000
A/R $ 3,000,000
A/P $ 1,000,000
COGS 80% Sales
$ 12,000,000
Interest 8%
Days Per Year 365
Inventory Conversion period 60.83
DSO /Average Conversion Perio 73
Payables deferral period 30.42
Inventory Average Payables
CCC conversion collection deferral
period period period
Payables
Days per year Days sales
CCC deferral
Inventory turnover outstandin g period
365
CCC 46 30
4.82
CCC 76 46 30 92 days
CCC 103.42
Inventories $ 1,800,000
A/R $ 2,700,000
A/P $ 1,100,000
Inventory Conversion period 54.75
DSO 65.70
Payables deferral period 33.46
New CCC 86.99
∆ Inventory $ 200,000
∆ A/R $ 300,000
∆ A/P $ 100,000
Cash Freed up $ 400,000
Pre-Tax profit $ 32,000
17 - 2
Sales $ 10,000,000
Credit Period 30 days
Accounts Receivable $ 2,000,000
Days Per Year 365
DSO 73 Days
Paid on time 30 Days
Capital if customer on time
Loan $ 8,000,000
Discount 3% 5 days
1 - Discount 97%
Period 60 days
i Bank 10%
Days Per Year 365
Month 12
rNOM 20.52%
Effective Annual Cost 22.40%
17 - 4
CCC 83.00
Sales $ 3,421,875
Sales per Day $ 9,375
A/R $ 356,250
COGS $ 2,566,406
COGS per day $ 7,031
Inventory $ 527,344
Inventory Turnover 4.87
17 - 5
Sales $ 912,500
Discount 3% 10 days
1 - Discount 97%
Period 30 days
Collection Period (40%) 10 days 40%
Collection Period (60%) 40 days 60%
Days Per Year 365
A/R $ 70,000 $ 60,000 $ 10,000
DSO 28
Average A/R $ 35,000
17 - 6
CCC 32
Capital 288,000
Sales $ 15,000,000
Inventories $ 2,000,000
A/R $ 3,000,000
A/P $ 1,000,000
COGS 80% Sales
$ 12,000,000
Interest 8%
Days Per Year 365
Inventory Conversion period 60.83
DSO /Average Conversion Perio 73
Payables deferral period 30.42
Inventory Average Payables
CCC conversion collection deferral
period period period
Payables
Days per year Days sales
CCC deferral
Inventory turnover outstandin g period
365
CCC 46 30
4.82
CCC 76 46 30 92 days
CCC 103.42
Inventories $ 1,800,000
A/R $ 2,700,000
A/P $ 1,100,000
Inventory Conversion period 54.75
DSO 65.70
Payables deferral period 33.46
New CCC 86.99
∆ Inventory $ 200,000
∆ A/R $ 300,000
∆ A/P $ 100,000
Cash Freed up $ 400,000
Pre-Tax profit $ 32,000
17 - 2
Sales $ 10,000,000
Credit Period 30 days
Accounts Receivable $ 2,000,000
Days Per Year 365
DSO 73 Days
Paid on time 30 Days
Capital if customer on time
Loan $ 8,000,000
Discount 3% 5 days
1 - Discount 97%
Period 60 days
i Bank 10%
Days Per Year 365
Month 12
rNOM 20.52%
Effective Annual Cost 22.40%
17 - 4
CCC 83.00
Sales $ 3,421,875
Sales per Day $ 9,375
A/R $ 356,250
COGS $ 2,566,406
COGS per day $ 7,031
Inventory $ 527,344
Inventory Turnover 4.87
17 - 5
Sales $ 912,500
Discount 3% 10 days
1 - Discount 97%
Period 30 days
Collection Period (40%) 10 days 40%
Collection Period (60%) 40 days 60%
Days Per Year 365
A/R $ 70,000 $ 60,000 $ 10,000
DSO 28
Average A/R $ 35,000
17 - 6
CCC 32
Capital 288,000