FM Books Solution - Nov 23
FM Books Solution - Nov 23
FM Books Solution - Nov 23
LEVERAGES
CLASSWORK SOLUTIONS
Solution 1:
Particulars 20,000 units 25,000 units 30,000 units
Sales 2,80,000 3,50,000 4,20,000
(-) Variable cost 1,80,000 2,25,000 2,70,000
Contribution 1,00,000 1,25,000 1,50,000
(-) Fixed cost (1,00, 000) (1,00,000) (1,00,000)
EBIT 0 25,000 50,000
1,25,000 1,50,000
OL 0
25,000 50,000
5 :1 3:1
Solution 2:
Sales 50
(-) Variable Cost (325)
Contribution 17.5
(-) Fixed Cost -4
EBIT 13.5
(-) Interest 1.5 Operating = 17.5 =
EBT 12 Leverage 13.5
(-) Tax 3.6 1.30 times
EAT 8.4
50 = Sales
13.5
Financial Leverage
12
1.125:1
Combined Leverage = 1.47
:1:
J.K.SHAH CLASSES INTER CA – F.M.
Solution 3:
(i) Income Statement
Sales 75,00,000
(-) V.C 42,00,000
Cant 33,00,000 Capital Employed = Debt + Equity
(-) F.C. (6,00,000) = 1 Cr.
EBIT 27,00,000
- Interest (4,05,000)
EBT 22,95,000
EBIT
(i) ROI = x 100
CE
27,00,000
= x 100
10,000,000
= 27%
= 75,00,000
10,00,000
= 0.75 Capital Turnover Ratio is lower
C
(iv) OL =
EBIT
= 1.2:1
FL = EBIT
EBT
= 1.18:1
CL = 1.41:1
:2:
J.K.SHAH CLASSES INTER CA – F.M.
(v)
Sales 22,84,091 100
(-) V.C (12,79,091) 56
Cant 10,05,000 44
(-) F.C. (6,00,000)
EBIT (4,05,000)
Interest (4,05,000)
EBT 0
% Δ in EBIT
1.22 = S 75,00,000 87,50,000
% Δ in EBT
- V.C. 42,00,000 46,20,000
X
1.22 = C 33,00,000 36,30,000
10%
6L 6L
- F.C.
27L 30.30L
X = 12.22% OR EBIT +12.22%
Int.
EBT
% Δ in EBIT
(7) Financial Leverage =
% Δ in EBT
X 27,00,000 3,30,000
1.18 = 20% 100 (?)
12.22%
= 23.6%
:3:
J.K.SHAH CLASSES INTER CA – F.M.
Solution 4:
Income Statement
Sales 12,10,000
- Variable cost 629200
Cont 580800
- FC 96800
EBIT 4,84,000 + 20% 5,80,000
Int 84000 - 84000
EBT 4,00,000 100 496300
Tax 1,20,000 30 - 149040
EAT 2,80,000 70 347760
- PD (50,000) - 50,000
N.P for ESH 2,30,000 ÷ 80,000 297760 ÷ 80,000
(-) Eq dividend 1,20,000 (8,00,000 x 15%)
Returned 1,10,000 2.875
. 3.722
.
WN.1 operating Exp = 1.5 x EBIT
= 1.5 x 4840000
= 726000
VC FC
629200 96800
(i) OL = C
EBIT
= 580000
484000
= 1.2:1
EBIT
(i) FC =
EBT – PD FL = % ∆ in EPS
1–t % ∆ in EBIT
= 484000 ⸫ 1.4730 = % ∆ in EPS
4,00,000 – 50,000 20
1 – 30% ⸫% ∆ in EPS = 29.46
= 484000 OR
4,00,000 - 50,000 ∆ in EPS = 29.46%
0.7
:4:
J.K.SHAH CLASSES INTER CA – F.M.
484000
4,00,000 - 71429
484000
328571
= 1.47:1 1.4730:1
Cover for
(ii) Cover for Equity dividend
preference
EAT NP for Eq shares
PD ED
= 2,80,000 2,30,000
50,000 1,20,000
= 5.6:1 = 1.92:1
Debts PS E
0.18 x 100 (0.02) x 100 1.2 x 100
10 10 10
= 1.8% + (0.02%) + 12%
= 13.6 %
Note: - The finance manager of the company should redeem the preference
shares because it leads to loss for equity shareholders.
(2)
FI = EBIT
EBT – PD (I + DDT)
1 – Tax
= 3.6
2.7 – (0.26) OL = C
1 – 0.4 EBIT
3.6 =
2.7 – (0.26) OL = CL
0.6 FL
3.6 OL = 3
2.7 – 0.43 1.59
3.6 = 1.89:1
2.27
= 1.59:1
:7:
J.K.SHAH CLASSES INTER CA – F.M.
Solution 6:
Estimation of Degree of Operating Leverage (DOL), Degree of Financial Leverage
(DFL) and Degree of Combined Leverage (DCL)
P Q R
Output (in units) 2,50,000 1,25,000 7,50,000
Rs. Rs. Rs.
Selling Price (per unit) 7.50 7 10
Sales Revenues (Output × Selling Price) 18,75,000 8,75,000 75,00,000
EBIT
DOI = EBT 2.5 1.07 1.00
:8:
J.K.SHAH CLASSES INTER CA – F.M.
Solution 7:
DFL = 1.8, F/C= 4,50,000, P/V = 27%
EBIT = 22,50,000,
Contribution = 27,00,000
Solution 8:
Calculation of Degree of Operating leverage and Degree of Combined leverage
Firm Degree of Operating Leverage Degree of Combined Leverage
(DOL) (DCL)
Solution 9:
Income Statement
EBIT 2,00,000
(-) Interest 70,000
1,30,000
(-) Tax 65,000 (50%)
EAT 65,000
(-) P.D. 15,000 N.P. = 50,000
:9:
J.K.SHAH CLASSES INTER CA – F.M.
(ii) FL = EBIT
EBT – PD (1 +DDT)
1 - Tax
= 2,00,000
1,30,000 - 15000
1 – 50 %
= 2,00,000
1,00,000
= 2
Solution 10:
Income Statement
Particulars Company A (`) Company B (`)
Sales 80,000 36,000
Less: Variable Cost 60,000 24,000
Contribution 20,000 12,000
Less: Fixed Cost 16,000 9,000
EBIT 4,000 3,000
Less: Interest 3,000 2,000
EBT 1,000 1,000
Tax (45%) 450 450
EAT 550 550
(i) Company A
Financial Leverage = EBIT/(EBIT- Interest)
4 = EBIT/(EBIT- ` 3,000)
4EBIT – ` 12,000 = EBIT
3EBIT = ` 12,000
EBIT = ` 4,000
: 10 :
J.K.SHAH CLASSES INTER CA – F.M.
Company B
Financial Leverage = EBIT/(EBIT - Interest)
3 = EBIT/(EBIT – ` 2,000)
3EBIT – ` 6000 = EBIT
2EBIT = ` 6,000
EBIT = ` 3,000
(ii) Company A
Operating Leverage = 1/Margin of Safety
= 1/0.20 =5
Operating Leverage = Contribution/EBIT
5 = Contribution/` 4,000
Contribution = ` 20,000
Company B
Operating Leverage = 1/Margin of Safety
= 1/0.25 =4
(iii) Company A
Profit Volume Ratio = 25%(Given)
Profit Volume Ratio = Contribution/Sales × 100
25% = ` 20,000/Sales
Sales = ` 20,000/25%
Sales = ` 80,000
Company B
Profit Volume Ratio = 33.33%
Therefore, Sales = ` 12,000/33.33%
Sales = ` 36,000
: 11 :
J.K.SHAH CLASSES INTER CA – F.M.
CAPITAL STRUCTURE
CLASSWORK SOLUTIONS
Solution 1:
Summary of Financial Plan.
Plan 1 Plan 2
Eq. Shares 2,00,000 4,00,000
15% Loan 2,00,000 -
4,00,000 4,00,000
No. of ESH 2000 4000
Recommendation:
In either case of EBIT Plan 1 should be selected if the EPS is higher.
( )( ) ( )
( )( ) ( )
12
J.K.SHAH CLASSES INTER CA – F.M.
Hence verified.
EBIT
F BEP = Int + PD
(1 t)
Plan 1 = 30,000 + 0
1 0.35
= 30,000 + 0 = 30,000
*Plan 2 : - F BEP = 0
In an all equity plan F BEP is always Zero
Solution 2:
Summary of financial Plan:
Plan 1 Plan 2 Plan 3
[Bal. fig.] Eq. share 22,50,000 15,00,000 10,00,000
To loan 2,50,000 10,00,000 15,00,000
13
J.K.SHAH CLASSES INTER CA – F.M.
Solution No. 3
Summary of financial plan.
Plan A Plan B Plan C
Equity Share 2,00,000 1,00,000 1,00,000
8% Debt - 1,00,000 -
8% Pref. shares - - 1,00,000
F - BEP =
Plan 1 =
= 0
Plan 2: -
= 8000
Plan 3: -
14
J.K.SHAH CLASSES INTER CA – F.M.
= 16,000
Solution 4:
(i) Capital Structure
Eq. shares 40,00,000
Retained Earnings 10,00,000
7 % Debentures 25,00,000
15
J.K.SHAH CLASSES INTER CA – F.M.
(ii) Existing ROCE = 12% (Given)
In absence of information about new ROCE it is information about new ROCE it is assured to
be the same as existing ROCE i.e. 12%
(iv) New EBIT = New capital x Existing ROCE
1,25,000 x 12%
= 15,00,000
16
J.K.SHAH CLASSES INTER CA – F.M.
Recommendation:
Plan 1 should be elected as Uu MPS is highest
(b) We have selected plan 1 because the MPS is highest and higher the MPS, greater
would be the wealth of shareholder which is the main objective of every company.
Solution 5:
Before After
Ebgt 200000 200000
(-) gnt (70000) -
EBT (500000 x 14%)
130000 200000
(-) Tax (35%) (45500) (70000)
PAT 84500 130000
(-) P.D - -
Pr. for ESH 84500 130000
No of eq.sh 10000 15000
EPS 8.45 8.67
(x) P/E 20 25
MPS 169 216.67
Solution 6:
The capital investment can be financed in two ways i.e.
(i) By issuing equity shares only worth ` 4.5 crore or
(ii) By raising capital through taking a term loan of ` 3 crores and ` 1.50 crores
through issuing equity shares (as the company has to comply with the 2 : 1 Debt
Equity ratio insisted by financing agencies).
In first option interest will be Zero and in second option the interest will be ` 36,00,000
Point of Indifference between the above two alternatives =
EBIT 1 x (1 t) = (EBIT Interest) x (1 t)
No. of equity shares (N 1) No. of equity share (N 2)
Or, EBIT (1 - 0.50) = (EBIT- ` 36,00,000) x (1 - 0.50)
45,00, 000 shares 15,00,000 shares
Or, 0.5 EBIT = 1.5 EBIT ` 54,00,000
EBIT = ` 54,00,000
17
J.K.SHAH CLASSES INTER CA – F.M.
Solution 7:
Ascertainment of probable price of shares of Akash limited
Plan – I Plan – II
If `4,00,000 is If `4,00,000 is raised
Particulars
raised as debt (`) by issuing equity
shares (`)
Earnings Before Interest and Tax (EBIT) 3,60,000 3,60,000
{20% of new capital i.e. 20% of
(`14,00,000 + `4,00,000)}
(Refer working note 1)
Less: Interest on old debentures (10% of (40,000) (40,000)
`4,00,000)
Less: Interest on new debt (12% of (48,000) ---
`4,00,000)
Earnings before Tax (EBT) 2,72,000 3,20,000
Less: Tax @ 50% (1,36,000) 1,60,000
Earnings for equity shareholders (EAT) 1,36,000 1,60,000
No. of Equity Shares (refer working note 2) 30,000 40,000
Earnings per Share (EPS) `4.53 `4.00
Price / earnings (P/E) Ratio (refer working 8 10
note 3)
Probable Price Per Share (PE Ratio EPS) `36.24 `40
Working Notes:
1. Calculation of existing Return of Capital Employed (ROCE):
(`)
Equity Share capital (30,000 shares `10) 3,00,000
100 4,00,000
10% Debentures ` 40,000 ×
10
Reserves and Surplus 7,00,000
Total Capital Employed 14,00,000
Earnings before interest and tax (EBIT) (given) 2,80,000
`2,80,000 20%
ROCE = × 100
`14,00,000
18
J.K.SHAH CLASSES INTER CA – F.M.
Solution 8:
(a)
Alternatives
Alternative – I: Alternative – II: Alternative – III:
Particulars Take additional Issue 11% Issue further
debt Preferences Equity Shares
Shares
` ` `
EBIT 15,00,000 15,00,000 15,00,000
Interest on Debts
- on existing debt @ 10% (3,60,000) (3,60,000) (3,60,000)
- on new debt @ 12% (4,80,000) --- ---
Profit before taxes 6,60,000 11,40,000 11,40,000
Taxes @ 40% (2,64,000) (4,56,000) (4,56,000)
Profit after taxes 3,96,000 6,84,000 6,84,000
Preference shares --- (4,40,000) ---
dividend
Earnings available to 3,96,000 2,44,000 6,84,000
equity Shareholders
Number of shares 8,00,000 8,00,000 8,00,000
Earnings per share 0.495 0.305 0.651
(b) For the Present EBIT level, equity shares are clearly preferable. EBIT would
need to increase by `2,376 - `1,500 = `876 before an indifference point
with debt is reached. One would want to be comfortably above this
19
J.K.SHAH CLASSES INTER CA – F.M.
indifference point before a strong case for debt should be made. The
lower the probability that actual EBIT will fall below the indifference point,
the stronger the case that can be made for debt, all other things the same.
Working Note:
Calculation of indifference point between debt and equity shares (in
thousands)-
EBIT -`840 EBIT -`360
=
800 1,050
EBIT (1,050) - `840 (1,050) = EBIT (800) - `360 (800)
250EBIT = `5,94,000
EBIT = `2,376
20
J.K.SHAH CLASSES INTER CA – F.M.
COST OF CAPITAL
CLASSWORK SOLUTIONS
Solution 1:
(a) (i) Issue is at par
Or
Solution 2:
Calculation of Ke (existing)
As per Gordon’s formula,
Calculation of Ke (new)
As per Gordon’s formula,
21
J.K.SHAH CLASSES INTER CA – F.M.
Solution 3:
Solution 4:
Solution 5:
Calculation of Ke (existing)
As per Gordon’s formula,
Solution 6:
(a) Pattern of raising additional finance
22
J.K.SHAH CLASSES INTER CA – F.M.
Working Notes
Calculation of Ke (new)
As per Gordon’s formula,
Solution 7:
(a) Calculation of WACC using Book Value Weights
Sources Amounts Weights Cost in % W* C
Debentures 5,00,000 0.25 5.51 1.38
Preference Shares 5,00,000 0.25 5.25 1.31
Equity Shares 10,00,000 0.50 10 5.00
20,00,000 1 7.69 Ko
23
J.K.SHAH CLASSES INTER CA – F.M.
Working Notes
Calculation of Ke (new)
As per Gordon’s formula,
Solution 8:
(A)
(1)
24
J.K.SHAH CLASSES INTER CA – F.M.
(3) Calculation of Kr = Ke (existing)
As per Gordon’s formula,
(B) Calculation of Marginal Cost of Capital when no new shares are issued
Sources Amounts Weights Cost in %
W*C
Debentures ? 0.15 1.25 8.33
Preference Share Capital ? 0.05 0.60 11.96
Retained Earnings ? 0.8 12.00 15
13.85%
(C) Calculation of Maximum Capital Investment without Fresh Issue of Equity
Solution 9:
As per Gordon’s Formula
25
J.K.SHAH CLASSES INTER CA – F.M.
Solution 10:
Growth rate = Retention Ratio * Return on Equity
= 0.6*0.2
= 0.12 i.e. 12%
Solution 11:
Calculation of Cost of Retained Earnings
Maximum amount available for Investment (including brokerage) 103 7,50,000
Less: Brokerage 3 21,845
Maximum amount available for Investment (excluding brokerage) 100 7,28,155
Income on Investment 72,816
Less: Tax@ 30% 21,845
Profit after Tax 50,971
Kr = Rate of Return = 50971/750000*100 6.80%
Solution 12:
(a) Calculation of WACC using Market Value WeZZZ
Sources Amount Weights Cost W*C
in (%)
Equity Share Capital 9,000 0.81 15 12.20
(150 m shares * ` 60)
10.5% Preference Share Capital 98.15 0.01 10.97 0.10
(1 m shares * ` 98.15 )
W
9.5% Debentures 1,471.58 0.13 6.89 0.92
o
(1.5 m Debt * 981.05)
r
8.5% Term Loans 500 0.05 5.525 0.25
k
11,069.725 1.00 13.46 Ko
i
Working Notes
(i) As per CAPM,
(ii)
26
J.K.SHAH CLASSES INTER CA – F.M.
(iii)
(iv)
As per CAPM,
27
J.K.SHAH CLASSES INTER CA – F.M.
Solution 13:
As per Gordon’s Formula
Solution 14:
Ko = book value wt.
Source Cost Wt. Product
Equity share 14 45 630
R.E. 14 15 210
Pref. share 10 10 100
Debentures 5 30 150
100 1,090
Total Product 1090
K0 = = = 10.90%
Total Weight 100
Ko = Market Value Weight
Solution 15:
D1 `15
(i) Cost of Equity (Ke) = +g= + 0.06 *
P0 - F `125 - ` 5
Ke = 0.125 + 0.06 = 0.185
*Calculation of g:
` 10.6(1+g)5 = ` 14.19
28
J.K.SHAH CLASSES INTER CA – F.M.
14.19
Or, (1+g)5 = = 1.338
10.6
Table (FVIF) suggests that ` 1 compounds to ` 1.338 in 5 years at the
compound rate of 6 percent. Therefore, g is 6 per cent.
D1 `15
(ii) Cost of Retained Earnings (Kr) = +g= + 0.06 = 0.18
P0 `125
PD `15
(iii) Cost of Preference Shares (Kp) = = = 0.1429
P0 `105
RV - NP
I1 - t +
(iv) Cost of Debentures (K d) =
n
RV - NP
2
`100 - `91.75*
`15 1 - 0.35 +
= 11 years
`100 + `91.75*
2
`15 × 0.65 + ` 0.75 `10.5
= = = 0.1095
`95.875 `95.875
*Since yield on similar type of debentures is 16 per cent, the company would
be required to offer debentures at discount.
Market price of debentures (approximation method)
= ` 15 ÷ 0.16 = ` 93.75
Sale proceeds from debentures = ` 93.75 – ` 2 (i.e., floatation cost) = `91.75
Market value (P0) of debentures can also be found out using the
present value method:
(16%, 11 years)
*Market Value of equity has been apportioned in the ratio of Book Value of
equity and retained earnings i.e., 120:30 or 4:1.
Weighted Average Cost of Capital (WACC):
`32.8281
Using Book Value = = 16.83%
`195
` 41.99
Using Market Value = = 17.19%
`195
30
J.K.SHAH CLASSES INTER CA – F.M.
CLASSWORK SOLUTIONS
Solution 1:
Calculation of V and Ko as per NI Approach
Value of the Firm = Value of Debt(D) + Value of Equity (E)
= 8,00,000 + 9,60,000
= 17,60,000
EBIT 2,00,000
Less: Interest 80,000
Dividend 1,20,000
Solution 2:
I II III
Debt = 0 Debt = 6L Debt = 10L
Kd = NA Kd = 10% Kd = 12%
Ke = 16% Ke = 17% Ke = 20%
EBIT 3,00,000 3,00,000 3,00,000
(-) Int. ---- (60,000) (1,20,000)
EBT / Div 3,00,000 2,40,000 1,80,000
E = Div. /Ke 3,00,000 2,40,000 1,80,000
0.16 0.17 0.20
= 18,75,000 = 14,11,765 = 9,00,000
14,11,765 + 9,00,000 +
V=E+D 18,75,000
6,00,000 10,00,000
= 20,11,765 = 19,00,000
Ko = EBIT 3,00,000 3,00,000 3,00,000
31
J.K.SHAH CLASSES INTER CA – F.M.
V 18,75,000 20,11,765 19,00,000
= 0.16 = 0.1491 = 0.1579
= 16% = 14.91% = 15.79%
Solution 3:
Calculation of V and Ke
Particulars 10% Debt 10% Debt 11% Debt 12% Debt 14% Debt
= 3 Lakhs = 4 Lakhs = 5 Lakhs = 6 Lakhs = 7 Lakhs
1) EBIT 3,00,000 3,00,000 3,00,000 3,00,000 3,00,000
Less: Interest 30,000 40,000 55,000 72,000 98,000
Dividend 2,70,000 2,60,000 2,45,000 2,28,000 2,02,000
2) E= Dividend / Ke 22,50,000 20,80,000 18,14,815 15,20,000 11,22,222
3) V = E + D 11.76% 12.10% 12.96% 14.15% 16.46%
4) Ko = EBIT / V 11.76% 12.10% 12.96% 14.15% 16.46%
Company is advised to select Capital structure 1 as Ko is minimum.
Solution 4:
Calculation of Value of Firm and Ke as per NOI Approach
Particulars 8% Debt = 4 Lakhs 8% Debt = 7 Lakhs 8% Debt = 10 Lakhs
1) EBIT 4,00,000 4,00,000 4,00,000
Less: Interest 32,000 56,000 80,000
Dividend 3,68,000 3,44,000 3,20,000
2) V= EBIT / Ko 40,00,000 40,00,000 40,00,000
3) E = V –D 36,00,000 33,00,000 30,00,000
4) Ke = Dividend /E 10.22% 10.42% 10.67%
Solution 5:
32
J.K.SHAH CLASSES INTER CA – F.M.
Solution 6:
Calculation of Value of Co. P and Co. Q
As per MM Approach, if there are taxes
Value of Co. Q = Value of Co. P + Debt * Tax Rate
= 18,20,000 + 2,40,000
= 20,60,000
Value of Co. P
Solution 7:
a) Value of RES Ltd (after restructuring)
As per MM Approach, if there are taxes
Value of RES Ltd (after Restructuring) = Value of RES Ltd (before restructuring)
+ Debt * Tax Rate
= 25,00,000 + 5,00,000* 30%
= 26,50,000
b) Cost of Equity (Ke) (after restructuring)
c) Ko (after restructuring)
33
J.K.SHAH CLASSES INTER CA – F.M.
Solution 8:
(a) Assuming no tax as per MM Approach.
Calculation of Value of Firms ‘A Ltd.’ and ‘B Ltd’ according to MM
Hypothesis
Market Value of ‘B Ltd’ *Unlevered(u)+
Total Value of Unlevered Firm (Vu) = [NOI/ke] = 18,00,000/0.18 = `
1,00,00,000
Ke of Unlevered Firm (given) = 0.18
Ko of Unlevered Firm (Same as above = ke as there is no debt) = 0.18
Market Value of ‘A Ltd’ *Levered Firm (I)+
Total Value of Levered Firm (VL) = Vu + (Debt× Nil) = ` 1,00,00,000 +
(54,00,000 × nil) = `1,00,00,000
34
J.K.SHAH CLASSES INTER CA – F.M.
(b) Assuming 40% taxes as per MM Approach
Calculation of Value of Firms ‘A Ltd.’ and ‘B Ltd’ according to MM
Hypothesis
Market Value of ‘B Ltd’ *Unlevered (u)]
Total Value of unlevered Firm (Vu) = [NOI (1 - t)/ke] = 18,00,000 (1 – 0.40)]
/ 0.18
= `60,00,000
Ke of unlevered Firm (given) = 0.18
Ko of unlevered Firm (Same as above = ke as there is no debt) = 0.18
Market Value of ‘A Ltd’ *Levered Firm (I)+
Total Value of Levered Firm (VL) = Vu + (Debt× Tax)
= ` 60,00,000 + (54,00,000 × 0.4)
= ` 81,60,000
Computation of Weighted Average Cost of Capital (WACC) of ‘B Ltd.’
= 18% (i.e. Ke = Ko)
Solution 9:
Particulars M Ltd N Ltd
EBIT 20,000 20,000
Less: Interest 7,000 -
Dividend 13,000 20,000
Ke 11.50% 10%
E = Dividend/Ke 1,13,043 2,00,000
Debt (D) 1,00,000 -
V=E+D 2,13,043 2,00,000
35
J.K.SHAH CLASSES INTER CA – F.M.
Invest 20,000 Rs in N Ltd to make 10% holding
Income from N Ltd
Dividend from N Ltd 2000
Less: Interest on Loan taken 700
Net income after switch over 1300
Solution 10:
Particulars L Ltd. U Ltd.
EBIT 20,000 20,000
Less: Interest 7,000 -
Dividend 13,000 20,000
Ke 18.00% 10%
E = Dividend / Ke 72,222 2,00,000
Debt (D) 1,00,000 -
V=E+D 1,72,222 2,00,000
36
J.K.SHAH CLASSES INTER CA – F.M.
CLASSWORK SOLUTIONS
Solution 1:
Calculation of Average Rate of Return (ARR)
Solution 2:
Calculation of NPV for the respective projects
Project A Project B
Year DF @ 12% FVCI PVCI FVCI PVCI
1 0.8929 50,000 44,645 40,000 35,716
2 0.7972 50,000 39,860 50,000 39,860
3 0.7118 50,000 35,590 70,000 49,826
4 0.6355 50,000 31,775 75,000 47,633
5 0.5674 50,000 28,370 75,000 42,555
Total PVCI 1,80,240 2,15,620
(-) PVCO -2,00,000 -1,90,000
NPV (19,760) 25,620
Alternative calculation of NPV for Project A as cash flows are in the form of
Annuity
(i) PVCO
Cost of the Project 2,00,000 (a)
(ii) PVCI
Year Annuity PVAF (12%, 5yrs) PVCI
1-5 50,000 36,048 1,80,240 (b)
37
J.K.SHAH CLASSES INTER CA – F.M.
(iii) NPV = PVCI – PVCO
= b–a
= - 19,760
Solution 3:
Calculation of IRR
PVCO
Cost of the Project 1,36,000
Year FVCI DF @ 10% PVCI DF @ 11% PVCI
1 30,000 0.9091 27,273 0.9009 27,027
2 40,000 0.8264 33,056 0.8116 32,465
3 60,000 0.7513 45,078 0.7312 43,871
4 30,000 0.683 20,490 0.6587 19,762
5 20,000 0.6209 12,418 0.5935 11,869
1,38,315 1,34,994
-
= 10% = 10.70%
-
Solution 4:
Projects PVCO PVCI NPV PI Rankings
A 50,000 65,400 15,400 1.31 5
B 40,000 58,700 18,700 1.47 2
C 25,000 35,100 10,100 1.40 3
D 30,000 41,200 11,200 1.37 4
E 35,000 54,300 19,300 1.55 1
38
J.K.SHAH CLASSES INTER CA – F.M.
Solution 5:
Year| -), Cash flow – ` 1,36,000
The MIRR is calculated on the basis of investing the inflows at the cost of capital. The
table below shows the value of the inflows if they are immediately reinvested at 8%
Year Cash Flow @ 8% reinvestment rate factor `
1 30,000 1.3605* 40,815
2 40,000 1.2597 50,388
3 60,000 1.1664 69,984
4 30,000 1.0800 32,400
5 20,000 1.0000 20,000
2,13,587
* Investment of ` 1 at the end of the year 1 is reinvested for 4 year (at the end of
5 year) shall become 1(1.08)4 = 1.3605. Similarly, reinvestment rate factor for
remaining years shall be calculated. Please note investment at the end of 5th
year shall be reinvested for zero year hence reinvestment rate factor shall be
1.00.
The total cash outflow in year 0 (` 1,36,000) is compared with the possible
inflow at year 5 and the resulting figure of = 0.6367 is the discount factor
in year 5. By looking at the 5 row in the present value tables, you will see that
this gives a return of 9%. This means that the ` 2,13,587 received in year 5 is
equivalent to ` 1,36,000 in year 0 if the discount rate is 9%. Alternatively, we
can compute MIRR as follows:
Solution 6:
Calculation of PBP, D-PBP, NPV and IRR
(i) PVCO
Cost of the Equipment 6,00,000
Investment in Working Capital 80,000
6,80,000 (a)
39
J.K.SHAH CLASSES INTER CA – F.M.
(ii) Calculation of Cash Inflows
Particulars Year 1 Year 2 Year 3 Year 4 Year 5
CFBT / NPBT 2,40,000 2,75,000 2,10,000 1,80,000 1,60,000
Less: Depreciation 1,20,000 1,20,000 1,20,000 1,20,000 1,20,000
NPBT 1,20,000 1,55,000 90,000 60,000 40,000
Less: Tax @35% 42,000 54,250 31,500 21,000 14,000
NPAT @ 65% 78,000 1,00,750 58,500 39,000 26,000
Add: Depreciation 1,20,000 1,20,000 1,20,000 1,20,000 1,20,000
Add: Recovery of
---- ---- ---- ---- 80,000
Working Capital
CFAT / FVCI 1,98,000 2,20,750 178,500 1,59,000 2,26,000
( - -
40
J.K.SHAH CLASSES INTER CA – F.M.
Solution 7:
Calculation of NPV and PI
(i) PVCO
Cost of the Machine 80,000 (a)
(iii) PV of Salvage
Year Salvage PVF PV
5 6,000 0.467 2802 ©
41
J.K.SHAH CLASSES INTER CA – F.M.
Solution 8:
(a) Cost of the Project
At IRR, PVCI = PVCO i.e. NPV = 0
L t th o t of th oj t ‘x’
(i) PVCO
Cost of the Project x (a)
(ii) PVCI
Year Annuity PVAF (15%, 4 yrs.) PVCI
1-4 60,000 2,855 1,71,300 (b)
Since at IRR of 15%, PVCI = PVCO, accordingly cost of the project will
be 1,71,300/-.
(d) NPV
t o
t o
(ii) PVCI
Year Annuity PVAF (?%, 4 yrs.) PVCI
1-5 60,000 x 182263.2 (b)
42
J.K.SHAH CLASSES INTER CA – F.M.
60000x = 182263.2
Therefore x = 3.038
Reference to PVAF table indicates that PVAF (12%, 4 years) = 3.038.
Therefore COC = 12%.
Solution 9:
Calculation of Annualised Net PVCO if Machine A is selected
(i) PVCO
Cost of the Machine 1,50,000 (a)
43
J.K.SHAH CLASSES INTER CA – F.M.
(iv) Annualised Net PVCO
t
Solution 10:
Calculation of NPV if existing machine is replaced
Particulars Existing New
(i) PVCO
Cost of the Machine IRRELEVANT 10,00,000
Less: Resale Value of Existing Machine 0 2,00,000
0 8,00,000 (a)
(iii) PV of Salvage
Salvage * PVF = 0 =40000 * .404
- 16,160 (c)
44
J.K.SHAH CLASSES INTER CA – F.M.
(iv) NPV
= PVC I- PVCO
=b+c–a 6,01,128 13,07,688
Company is advised to replace the existing machine as it will increase the NPV by
7,06,560.
Solution 11:
Calculation of ARR and Profitability Index
Particulars Machine X Machine Y
(i) PVCO
Cost of the Machine 1,50,000 2,40,000
(ii) Calculation of Cash Inflows and PVCI
Savings in Wages p.a. 90,000 1,20,000
Savings in Scrap p.a. 10,000 15,000
Increase in Cost of
Maintenance 7,000 11,000
Indirect Material 6,000 8,000
Supervision 12,000 16,000
Increase in Depreciation 30,000 40,000
Increase in NPBT 45,000 60,000
Less: Tax @ 30% 13,500 18,000
Increase in NPAT 31,500 42,000
Add: Increase in Depreciation 30,000 40,000
Increase in FVCI p.a. 61,500 82,000
* PVAF (10%, nyrs) 3.790 4.355
PVCI 2,33,085 3,57,135
t t
45
J.K.SHAH CLASSES INTER CA – F.M.
Solution 12:
Calculation of NPV if part of the machine is repaired at the end of Year 1
(i) PVCO
Cost of the Machine 50000 (a)
(ii) PV of Repairs
Year Repairs PVAF (10%, 1 yrs.) PVCI
1 10000 0.9091 9091 (b)
(iii) PVCI
Year Repairs PVAF (10%, 3 yrs.) PVCI
1-3 18000 2.4868 44762 (c)
(iv) PV of Salvage
Year Salvage PVAF (10%, 3 yrs.) PVCI
3 12500 0.7513 9391 (d)
(v) NPV
= PVCI – PVCO
=c+d–a-b
= (4,938)
(ii) PV of Repairs
Year Replacement cost PVAF (10%, 1 yrs.) PVCI
2 15400 0.8264 12727 (b)
46
J.K.SHAH CLASSES INTER CA – F.M.
(iii) PVCI
Year Annuity PVAF (10%, 4 yrs.) PVCI
1-4 18000 3.1698 57056 (c)
(iv) PV of Salvage
Year Salvage PVAF (10%, 4 yrs.) PVCI
4 9000 0.6830 6147 (d)
(v) NPV
= PVCI – PVCO
=c+d–a-b
= 476
Company is advised to replace the part of the machine at the end of the second
year as the NPV is positive.
Solution 13:
Of both the methods NPV method is considered to be the best and hence decision
making is to be done on the basis of NPV. Since life of both the machines is different
we decide on the basis of Annualised NPV
Project A Project B
47
J.K.SHAH CLASSES INTER CA – F.M.
Solution 14:
Statement to determine which project or projects to be selected
Project PVCO PVCI NPV
1 2,00,000 2,90,000 90,000
2 1,15,000 1,85,000 70,000
3 2,70,000 4,00,000 1,30,000
1+2 3,15,000 4,75,000 1,60,000
1+3 4,40,000 6,90,000 2,50,000
2+3 3,85,000 6,20,000 2,35,000
1+2+3 440000+115000+125000 620000+290000 2,30,000
Combination 1 and 3 should be selected as it will maximize the NPV
Solution 15:
(a) Calculation of NPV if Project is financed by Retained Earnings
PVCO
Cost of the Project 20,00,000 (a)
PVCI
Year Annuity PVAF (21.33%, 3 yrs.) PVCI
1-3 10,00,000 2.0634 20,63,400 (b)
NPV = PVCI – PVCO
=b–a
= 63,400
Since the project is finance out of Retained Earnings Kr=Ko, and since the
company is all equity Ko=Ke. Accordingly, Ko = Ke = Kr
p Go o ’ fo
48
J.K.SHAH CLASSES INTER CA – F.M.
NPV = PVCI – PVCO
=b–a
= 47,900
p Go o ’ fo
tp o
Solution 16:
Evaluation of Alternatives:
Saving in disposing off the waste
Particulars `
Outflow (50,000 × `1) 50,000
Less: tax savings @50% 25,000
Net Outflow per year 25,000
Solution 17:
NPV Yr CF DF @ 12% PV
1 33,12,000 0.893
2 63,69,000 0.797
3 1,37,64,500 0.712
4–5 1,70,71,500 1.203
6–8 1,10,23,500 1.363
8 S/V 42,50,000 0.404
PVCG = 5,51,13,078
(-) PVCO = (3,90,00,000)
NPV = 1,61,13,078
(240 - 60%)
(-) F/C (36,00,000) (36,00,000) (36,00,000) (36,00,000) (36,00,000)
(-) Dep (43,75,000) (43,75,000) (43,75,000) (48,25,000) (48,25,000)
PBT (10,63,000) 23,93,000 1,69,85,000 1,74,95,000 88,55,000
(-) tax @ 3,18,900 (7,17,900) (50,95,500) (52,48,500) (26,56,500)
30%
--- (39,9000)
50
J.K.SHAH CLASSES INTER CA – F.M.
30%
[23,93,000 –
10,63,000]
PAT (10,63,000) 19,94,000
(+) Dep 43,75,000 43,75,000 43,75,000 48,25,000 48,25,000
CF 33,12,000 63,69,000 1,62,64,500 1,70,71,500 1,10,23,500
(-) Pur of (25,00,000)
Add m/c
1,37,64,500
51
J.K.SHAH CLASSES INTER CA – F.M.
Solution 37:
I 1 - t +
RV - NP
Cost of debenture (Kd) = n
RV + NP
2
I = Interest on debenture = 10% of ` 100 = ` 10
NP = Current market price = ` 80
RV = Redemption value = ` 100
n = Period of debenture = 5 years
t = Tax rate = 35% or 0.35
`10 1 - 0.35 +
`100 - `80
5years
Kd =
`100 + `80
2
`10 × 0.65 + ` 4 `10.5
Or, Kd = = = 0.1166 or 11.67%
`90 `90
Solution 38:
Here,
Redemption Value (RV) = ` 1,00,000
Net Proceeds (NP) = ` 2,500
Interest = 0
Life of bond = 25 years
There is huge difference between RV and NP, therefore, in place of approximation
method, we should use trial & error method.
FV = PV x (1+r)n
1,00,000 = 2,500 x (1+r)25
40 = (1+r)25
Trial 1: r = 15%, (1.15)25 = 32.919
Trial 2: r = 16%, (1.16)25 = 40.874
Here:
L = 15%, H = 16%
52
J.K.SHAH CLASSES INTER CA – F.M.
NPVL = 32.919-40 = -7.081
NPVH = 40.874-40 = +0.874
NPVL
IRR = L+ H - L
NPVL - NPVH
-7.081
= 15% + × 16% - 15% = 15.89%
-7.081 - 0.874
Solution 39:
The amount of interest will go on declining as the outstanding amount of bond will
be reducing due to amortisation. The amount of interest for five years will be:
First year: ` 5,000 × 0.08 = ` 400;
Second year: (` 5,000 – ` 1,000) × 0.08 = ` 320;
Third year: (` 4,000 – ` 1,000) × 0.08 = ` 240;
Fourth year: (` 3,000 – ` 1,000) × 0.08 = ` 160; and
Fifth year: (` 2,000 – ` 1,000) × 0.08 = ` 80
The outstanding amount of bond will be zero at the end of fifth year.
Since RBML will have to return ` 1,000 every year, the outflows every year will
consist of interest payment and repayment of principal as follows:
First year: ` 1,000 + ` 400 = ` 1,400;
Second year: ` 1,000 + ` 320 = ` 1,320;
Third year: ` 1,000 + ` 240 = ` 1,240;
Fourth year: ` 1,000 + ` 160 = ` 1,160; and
Fifth year: ` 1,000 + ` 80 = ` 1,080
The above cash flows of all five years will be discounted with the cost of capital.
Here, cost of capital will be the minimum expected rate of return i.e. 6%.
Value of the bond is calculated as follows:
`1,400 `1,320 `1,240 `1,160 `1,080
VB = + + + +
1.06 1.06 1.06 1.06 1.06
1 2 3 4 5
53
J.K.SHAH CLASSES INTER CA – F.M.
Solution 40:
We know that as per the realised yield approach, cost of equity is equal to the
realised rate of return. Therefore, it is important to compute the internal rate of
return by trial and error method. This realised rate of return is the discount rate
which equates the present value of the dividends received in the past five years plus
the present value of sale price of ` 1,128 to the purchase price of ` 1,000. The
discount rate which equalises these two is 12 percent approximately. Let us look at
the table given for a better understanding:
Year Dividend Sale Proceeds Discount Factor Present
(`) (`) @ 12% Value (`)
1 100 - 0.893 89.3
2 100 - 0.797 79.7
3 100 - 0.712 71.2
4 100 - 0.636 63.6
5 100 - 0.567 56.7
6 Beginning 1,128 0.567 639.576
1,000.076
We find that the purchase price of Alpha Limit ’ h w ` 1,000 and the
present value of the past five years of dividends plus the present value of the sale
price at the discount rate of 12 per cent is ` 1,000.076. Therefore, the realised rate
of return may be taken as 12 percent. This 12 percent is the cost of equity
Solution 41:
In this question, we will first calculate the yield for last 4 years and then will
t t’ o t
Yield for last 4 years:
D1 + P1 1 + 9.75
1 + Y1 = = = 1.1944
P0 9
D2 + P2 1 + 11.50
1 + Y2 = = = 1.2821
P1 9.75
D3 + P3 1.2 + 11
1 + Y3 = = = 1.0609
P2 11.5
D4 + P4 1.25 + 10.60
1 + Y4 = = = 1.0772
P3 11
Geometric mean:
Ke = [(1+Y1)×(1+Y2 ×…… Yn)]1/n-1
Ke = [1.1944×1.2821×1.0609×1.0772]1/4-1 = 0.15 = 15%
54
J.K.SHAH CLASSES INTER CA – F.M.
CLASSWORK SOLUTIONS
Solution 1:
PVCO
(I) 100 x (DF =) 100
Cap. Exp.
Solution 2:
Coefficient of variation is a measure of risk and higher the coefficient of variation higher
the risk.
Project X has a coefficient of variation 1.2 and hence, the appropriate risk adjusted
discount rate will be 16%. Similarly for project Y, it will be 14% &, 12%.
Calculation of NPV –
X Y Z
(i) PVCO
2,10,000 1,20,000 1,00,000
Cap. Exp.
(ii) PVCI - OP. C.J. 2,29,180 1,08,150
1,44,186
70,000 x 3.274 (30,000 x
(42,000 x 3.4333)
3.605)
(iii) NPV=PVCI - PVCO 19,180 24,186 8,150
Solution 3:
Evaluation of Project M –
PVCO
(I) 8,50,000
Cap. Exp.
55
J.K.SHAH CLASSES INTER CA – F.M.
(II) PCVL – op C.I.
UCF CEF Certainty
Yr. Uncertain Equivalent CCF DF @ 6% PV
Cash flows Factor
1 4,50,000 0.8 3,60,000 0.943 3,39,480
2 5,00,000 0.7 3,50,000 0.890 3,11,500
3 5,00,000 0.5 2,50,000 0.840 2,10,000
8,60,980
Project N
PVCO
(i) 8,25,000
Cap. Exp.
Solution 4:
Cash of NPV
PVCO
(i) 1,20,000 x (DF = 1)
Cap. Exp.
PVAF @ 10% for 4 years
(c) W.r.t COC – If COC by 10%, Revised COC = 11% ( 10% + 10%) of 10
NPV @ Revised COC 11% will be determined OS –
PVCO
(I) 1,20,000
Cap. Exp.
Solution 5:
PVCO
(I) 14,00,000 x (DF = 1) 14,00,000
Cap. Exp.
(ii) PVCI
Year C.I. DF @ 9% PV CI PV CI PV
1 4,50,000 0.9174 4,12,830 5,50,000 5,04,570 650 596.31
2 4,00,000 0.8417 3,36,680 4,50,000 3,78,765 500 420.85
3 7,00,000 0.7722 5,40,540 8,00,000 6,17,760 900 694.98
12,90,050 15,01,095 1,712.14
57
J.K.SHAH CLASSES INTER CA – F.M.
II PVCI
Year CI DF @ 9% PV
1 5,50,000 0.9174 5,04,570
2 4,50,000 0.8417 3,78,765
3 7,00,000 0.7722 5,40,540
14,23,875
Solution 6:
Evaluation of project – A:
I. Calculation of Expected Value of Cash Flows
Event Cash Flow (C) Prob. (P) CxP
A 8,000 0.1 800
B 10,000 0.2 2,000
C 12,000 0.4 4,800
D 14,000 0.2 2,800
E 16,000 0.1 1,600
12,000
Evaluation of project – B
I. Calculation of EVCF
Event Cash Flow (C) Prob. (P) CxP
A 4,000 0.10 400
B 20,000 0.15 3,000
C 16,000 0.50 8,000
D 12,000 0.15 1,800
E 8,000 0.10 800
EVCF = 14,000
Solution 7:
Calculation of EVCF and Std. deviation of Cash flow
Year 1
Situation C.F. (C) Prob. (P) C x P
1 2,000 0.1 200
2 4,000 0.2 800
3 6,000 0.3 1,800
4 8,000 0.4 3,200
6,000
Year 2
Situation C.F. (C) Prob. (P) CxP
1 2,000 0.2 400
2 4,000 0.3 1,200
3 6,000 0.4 2,400
4 8,000 0.1 800
4,800
Year 3
Situation C.F. (C) Prob. (P) CxP
1 2,000 0.3 600
2 4,000 0.4 1,600
3 6,000 0.2 1,200
4 8,000 0.1 800
4,200
II. NPV
(a) PVCO = Cap. Exp = 10,000 x (DF – 1) 10,000
59
J.K.SHAH CLASSES INTER CA – F.M.
Solution 8:
Evaluation of
Project – A
Situation NPV (C) Prob. (P) C x P C- ̅ (C - ̅ 2 ( C - ̅ )2
1 15,000 0.2 3,000 6,000 3.6 cr. 72 L
2 12,000 0.3 3,600 - 3,000 90 L 27 L
3 6,000 0.3 1,800 - 3,000 90 L 27 L
4 3,000 0.2 600 - 6,000 3.6 cr. 72 L
9,000 1.98 cr.
Project – B
Situation NPV (C) Prob. (P) C x P C- ̅ (C - ̅ 2 ( C - ̅ )2
1 15,000 0.1 1,500 6,000 3.6 cr. 36 L
2 12,000 0.4 4,800 - 3,000 90 L 36 L
3 6,000 0.4 2,400 - 3,000 90 L 36 L
4 3,000 0.1 300 - 6,000 3.6 cr. 36 L
9,000 1.44 cr.
Conclusion:
We recommended project B because the projects have the same NPVs but project B
has lower risk.
The Concept used in Question No.’s & are omitted by the ICAI from the
Syllabus.
60
J.K.SHAH CLASSES INTER CA – F.M.
Solution 9:
Evaluation of Project – A:
Good Normal Worse
(i) PVCO. Cap. Exp 5,00,000 5,00,000 5,00,000
(ii) PVCI – Op. C.I. 24,60,120 16,40,080 8,20,040
(6,00,000 x 4.1002) (4,00,000 x 4.1002) (2,00,000 x 4.1002)
(iii) NPV=PVCI - PVCO 19,60,120 11,40,080 3,20,040
= 2,01,72,98,40,120
= 6,72,43,28,00,400
= 4,03,45,96,80,240
Evaluation of project B –
Good Normal Worse
(i) PVCO. Cap. Exp 5L 5L 5L
(ii) PVCI – Op. C.I. 20,50,100 16,40,080 12,30,060
(5L x 4.1002) (4L x 4.1002) (3L x 4.1002)
(iii) NPV=PVCI-PVCO= 15,50,100 11,40,080 7,30,060
Situation NPV (C) (P) CxP C-̅ (C - ̅ 2
P (C - ̅ )2
Good 15,50,100 0.3 4,65,030 4,10,020 168116400400 50434920120
Normal 11,40,080 0.4 4,56,032 0 0 0
Worse 7,30,060 0.3 2,19,018 4,10,020 168116400400 50434920120
11,40,080 100869840240
(i) NPV (Expected Avg. NPV)
Project A 11,40,080
Project B 11,40,080
(ii) Risk of NPV = NPVA = √ ( ̅ 2
Project A: NPVA = √
Project B: NPVB = √
= 3,17,600
= 6,35,202
61
J.K.SHAH CLASSES INTER CA – F.M.
Conclusion
Project B should be accepted since both project have the same NPV but project B
has lower risk as compared to project A.
Solution 10:
I II III
(i) PVCO. Cap. Exp 1,00,00 1,00,000 1,00,000
(ii) PVCI (i). C.I. 59,812 89,718 1,19,624
(20,000 x 2.9906) (30,000 x 2.9906) (4,00,000 x 2.9906)
+ (ii) salvage (0) + 8,038 12,057
(20,000 x 0.4019) (30,000 x 0.4019)
59,812 97,756 1,31,681
(iii) NPV (40,188) (2,224) 31,681
Solution 11:
P.V. of Cash Flows
Year 1 Running Cost ` 4,000 x 0.917 = (` 3,668)
Savings ` 12,000 x 0.917 = ` 11,004
Year 2 Running Cost ` 5,000 x 0.842 = (` 4,210)
Savings ` 14,000 x 0.842 = ` 11,788
` 14,914
Year 0 Less: P.V. of Cash Outflow ` 10,000 x 1 ` 10,000
NPV ` 4,914
62
J.K.SHAH CLASSES INTER CA – F.M.
Sensitivity Analysis
(i) Increase of Plant Value by ` 4,914
4,914
× 100 = 49.14%
10,000
Hence, savings factor is the most sensitive to affect the acceptability of the project
as in comparison of other two factors a slight % change in this fact shall more affect
the NPV than others.
Alternative Solution
P.V. of Cash Flows
Year 1 Running Cost ` 4,000 x 0.917 = (` 3,668)
Savings ` 12,000 x 0.917 = ` 11,004
Year 2 Running Cost ` 5,000 x 0.842 = (` 4,210)
Savings ` 14,000 x 0.842 = ` 11,788
` 14,914
Year 0 Less: P.V. of Cash Outflow ` 10,000 x 1 ` 10,000
NPV ` 4,914
Sensitivity Analysis
63
J.K.SHAH CLASSES INTER CA – F.M.
(ii) If Annual Running Cost is varied by say 10%*.
NPV (Revised) (` 4,914 – ` 400 X 0.917 – ` 500 X 0.843)
= ` 4,914 – ` 367 – ` 421= ` 4,126
` 4,914 - ` 4,126
Change in NPV = 16.04%
` 4,914
64
J.K.SHAH CLASSES INTER CA – F.M.
CLASSWORK SOLUTIONS
Solution 1:
WN1: - Breakup of Cost: (p.a) “Total cost”
1. Raw material consumed = (50 x 50,000) = 25,00,000
2. Direct Labour = (20 x 50,000) = 10,00,000
3. Factory O/H = (40 x 50,000) = 20,00,000
Factory cost / work cost / cost of production = 55,00,000
+ op. stock of FIG = NIL
(-) closing stock of EG = NIL
C.O.G.S = 55,00,000
+ Admin overheads = XX
(-) Selling overheads = XX
Total cost 55,00,000
65
J.K.SHAH CLASSES INTER CA – F.M.
Solution 2:
Estimation of WC on cash Basis.
C.A.:
Particulars Period Working Amt.
1. Debtors 2m 29,00,000 x 2/12 4,90,000
2. Prepaid Sales 3m 1,20,000 x 3/12 30,000
3. Stock of RM 1m 9,00,000 x 1/12 75,000
4. Stock F.G. 1m 25,80,000 x 1/12 2,15,000
5. Cash Balance given 1,00,000
A 9,10,000
C.L.:
Particulars Period Working Amt.
1. Creditors 2m 9,00,000 x 2/12 1,50,000
2. O/s Wages 1m 7,20,000 x 1/12 60,000
3. O/s Mfg. Expenses 1m Given 80,000
4. O/s Admin. Expenses 1m 2,40,000 x 1/12 20,000
B 3,10,000
WC = A – B = 6,00,000
+ Safety = 1,20,000
Margin
Total W.C. 7,20,000
W.N. 1 Excludes Profits
Breakup of cost (pa) “cash cost” Excludes depreciation
Raw Material Consumed = 9,00,000
Direct Wages = 7,20,000
Factory O/HS = 9,60,000
Factory Cost = 25,80,000
+ Opening Stock of F.G. =
- Closing Stock of F.G. =
C.O.G.S. 25,80,000
+ Admin Overhead 2,40,000
+ S.D. 1,20,000
Total Cash Cost 29,40,000
66
J.K.SHAH CLASSES INTER CA – F.M.
Extra:
Sales = 36,00,000
(-) GP = 25%
COP / COGS 27,00,000
(-) COP
COGS as (25,80,000)
Cash Cost basis
Depreciation 1,20,000
If estimation of working capital was asked on total cost Basis, we will include depreciation
of ` 1,20,000 in C.O.P, C.O.P / C.O.G.S will be ` 27,00,000.
Solution No. 3
WN : Breakup of cost : (pa) “ cash cost
Particulars SS DS
24,000 48,000
p.u Total p.u Total
1. R.M.C. 6 1,44,000 5.4 2,59,200
2. D.W.
Fixed 2 48,000 1 48,000
Variable 3 72,000 3 1,44,000
Prime Cost 11 2,64,000 9.4 4,51,200
3. Factory O/H
Fixed 4 96,000 2 96,000
Variable 1 24,000 1 48,000
FC / WC / COP / COGB 16 3,84,000 12.4 5,95,200
12
4 Debtors 3m 384000 x 3/12 96000 148800
595200 x 3/12
67
J.K.SHAH CLASSES INTER CA – F.M.
Ⓐ 226000 344000
CL
Cl Stock x
Stock of PGHP =
12
COGS
72000 x
= 384000 12
12
384000 72000 (?)
= 2.25 m = 2.25 m
36000 ?
= 94800
68
J.K.SHAH CLASSES INTER CA – F.M.
There are 2 ways to double the production
By Purchasing By working
Solution 4:
1. Working Notes:
1. Raw Material Storage Period (R)
Average Stock of Raw Material
= × 365
Annual Consumption of Raw Material
` 45 + `65
= 2 × 365 = 52.83 or 53 days
`380
Annual Consumption of Raw Material = Opening Stock + Purchases -
Closing Stock
= `45 + `400 – `65 = `380 lakh
69
J.K.SHAH CLASSES INTER CA – F.M.
3. Finished Stock Storage Period (F)
Average Stock of FinishedGoods
= × 365
Cost of Goods Sold
`60 + `70
= 2 × 365 = 45.19 or 45 days.
` 525
70
J.K.SHAH CLASSES INTER CA – F.M.
Solution 6:
Raw materials holding period 55 days
WIP 18 days
F.G Holding period 22 days
Debts collection 45 days
140 days
Less: Creditors’ Payment (60 days)
80 days
mount of C
evised in C –
= 236250 236250
Solution 7:
Conservation Moderate Aggressive
(a) Return on Total Assets
= EBIT x 100 = 3.1365 x 100 = 2.9325 x 100 = 2.55 x 100
Total Assets 6.63 + 11.45 6.63 + 9.945 6.63 + 6.63
= 17.32% = 17.69% = 19.23%
(b) Net working capital
= CA – CL = 11.475 –
= 9.945 – 5.967 = 6.63 – 5.967
5.967
= 3.978 = 0.663
= 5.508
(c) CA : FA Ratio
CA = 11.475 = 9.945 = 6.63
FA = 5.508 = 5.967 = 6.63
= 1.73:1 = 1.5:1 = 1:1
(d) Current Ratio
= CA = 11.475 = 9.945 = 6.63
CL 5.967 5.967 5.967
= 1.92:1 = 1.67:1 1.11:1
71
J.K.SHAH CLASSES INTER CA – F.M.
Both working capital gap & current Ratio are indicator of risk of non-payment of current
liabilities. Low WC gap & low current ratio indicates high risk of non-payment of CL &
Vice Versa. Risk under aggressive policy is more as current ratio is less but profitability is
also more as indicated by return on total Assets. Risk under conservative policy is less &
hence profitability is also less ccordingly universal rule prevails “Higher the risk
Higher would be the profit”
Solution 8:
I. w/c. statement
CA: Stock a) Rm 30000
b) wip 18750
c) FG 67500
Debtor (on (OST) 67500
C&B 20000
(A)…….. 203750
CL Cr 30000
o/s wages 2500
o/s o/t 5000
(B)…… 37500
W|c (A – B) 166250
II. Projected P&L
To, Rm 180000 By, sales 300000
To, Wages 30000
To, o/t 60000
To, Int 2500
To, NP 27500
X X
III. B/s
ESC 200000 FA 125000
RISOP (21250) CA
(+) NP 27500 (48750) S+ (Rm) 67500
5% Deb 50000 S+(WIP) 18750
CL Cr. 30000 S+ (FG) 67500
o/s wages 2500 CIB 20000
o/s o/t 5000 37500 Dr 75000 211250
(on Sales)
336250 336250
72
J.K.SHAH CLASSES INTER CA – F.M.
Solution 9:
Preparation of Statement of Working Capital Requirement for MNP Company Ltd.
(`) (`)
A. Current Assets
(i) Inventories :
Material (1 month) ` 9, 00, 000 x 1 month 75,000
12 months
3 2,52,500
For Export Sales 10,10, 000 x 12
73
J.K.SHAH CLASSES INTER CA – F.M.
Less : Gross Profit @ 20% on domestic sales and (4,80,000) (1,20,000) (6,00,000)
11.11% on export sales (Working Note-2)
Cost of Goods Sold 19,20,000 9,60,000 28,80,000
Working Note:
1. Calculation of Cost of Goods Sold and Cost of Sales
74
J.K.SHAH CLASSES INTER CA – F.M.
Solution 10:
W.N.
Material 8,00,000 (20 x 40,000)
(+) Wages 6,00,000 (15 x 40,000)
(+) FOH (V) 6,00,000 (15 x 40,000)
(F) 6,00,000 (10 x 60,000)
COP 26,00,000
COG 22,75,000
(+) S&D
(V) 1,05,000 (3 x 35,000)
(F) 60,000 (1 x 60,000)
COS 24,40,000
75
J.K.SHAH CLASSES INTER CA – F.M.
Solution 11:
Calculation of Net Working Capital requirement:
(`) (`)
A. Current Assets:
Inventories:
- Raw material stock (Refer to Working note 3) 6,64,615
- Work in progress stock (Refer to Working note 2) 5,00,000
- Finished goods stock(Refer to Working note 4) 13,60,000
Receivables (Debtors) (Refer to Working note 5) 25,40,769
Cash and Bank balance 25,000
Gross Working Capital 50,60,384 50,60,384
B. Current Liabilities:
Creditors for raw materials (Refer to Working note 6) 7,15,740
Creditors for wages (Refer to Working note 7) 91,731
8,07,471 8,07,471
Net Working Capital (A - B) 42,52,913
Working Notes:
1. Annual Cost of Production
(`)
Raw material requirements {(1,04,000 units × ` 80) + ` 86,40,000
3,20,000}
Direct wages {(1,04,000 units × ` 30) + ` 60,000} 31,80,000
Overheads (exclusive of depreciation) {(1,04,000 × ` 60)+ 63,60,000
` 1,20,000}
Gross Factory Cost 1,81,80,000
Less: Closing W.I.P (5,00,000)
Cost of Goods Produced 1,76,80,000
Less: Closing Stock of Finished Goods (` 1,76,80,000 × (13,60,000)
8,000/1,04,000)
Total Cash Cost of Sales 1,63,20,000
(`)
Raw material requirements (4,000 units × ` 80) 3,20,000
Direct wages (50% × 4,000 units × ` 30) 60,000
Overheads (50% × 4,000 units × ` 60) 1,20,000
5,00,000
76
J.K.SHAH CLASSES INTER CA – F.M.
3. Raw material stock
It is given that raw material in stock is average 4 weeks consumption. Since, the
company is newly formed, the raw material requirement for production and work in
progress will be issued and consumed during the year.
Hence, the raw material consumption for the year (52 weeks) is as follows:
(`)
For Finished goods (1,04,000 × ` 80) 83,20,000
For Work in progress (4,000 × ` 80) 3,20,000
86,40,000
Solution 12:
Ascertained as follows:
Method I: = 0.75 (CA – CL)
= 0.75 (510 – 160)
= `262.50 lakhs
Method II: = 0.75 CA – CL
= 0.75 510 – 160
= `222.50 lakhs
77
J.K.SHAH CLASSES INTER CA – F.M.
Method III: = 0.75 (CA – CCA) – CL
= 0.75 (510 – 200) – 160
= `72.50 lakhs
So, it may be noted that the MPBF decreases gradually from the first method to
second method and then to third method. As the firm, has already availed the bank
loan of 250 lakhs, it can still avail a loan of `12.50 lakhs as per the first method.
However, as per the second and third method, it is not eligible for additional
financing as maximum financing allowed is for `222.50 lakhs and `72.50 lakhs only
whereas its present bank borrowing are already `250 lakhs.
78