CA Inter Financial Mgmt Guide
CA Inter Financial Mgmt Guide
DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
FINANCIAL MANAGEMENT
REVISION BOOK
FOR CA INTER
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 1
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
TABLE OF CONTENTS
CHAPTER-WISE MARK BREAK UP ...................................................................... 3
SUMMARY OF SYLLABUS ...................................................................................... 4
CHAPTER 3: RATIO ANALYSIS ............................................................................. 5
CHAPTER 4: COST OF CAPITAL .......................................................................... 27
CHAPTER 5: FINANCING DECISIONS – CAPITAL STRUCTURE ............. 49
CHAPTER 6: FINANCING DECISIONS – LEVERAGES ................................. 72
CHAPTER 7: INVESTMENT DECISIONS .......................................................... 87
CHAPTER 8: RISK ANALYSIS IN CAPITAL BUDGETING ......................... 121
CHAPTER 9: DIVIDEND DECISIONS .............................................................. 141
CHAPTER 10: MANAGEMENT OF WORKING CAPITAL ........................... 151
New Additional Problems...................................................................................... 186
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 2
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER-WISE MARK BREAK UP
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 3
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
SUMMARY OF SYLLABUS
No of
S.No Chapter Name question
s
1 Scope and Objectives of Financial Management 0
2 Types of Financing 0
3 Financial Analysis and Planning – Ratio Analysis 19
4 Cost of Capital 17
5 Financing Decisions – Capital Structure 20
6 Financing Decisions – Leverages 15
7 Investment Decisions 25
8 Risk Analysis in Capital Budgeting 16
9 Dividend Decisions 11
10 Management of Working Capital 34
Total 157
Note: Revision book covers questions till May 2022 RTP, Dec 2021 suggested
answers and Nov 2021 MTP
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 4
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 3: RATIO ANALYSIS
• Availability of funds to
meet short term
Cash in hand commitments.
Cash • A ratio of >1 may
Cash + Marketable Securities (+) Cash at Bank
3 ratio/absolute As above indicate that the firm
Current Liabilities (+) Marketable securities
liquidity ratio has liquid resources
/short term investments
which are low in
profitability
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 5
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
B. CAPITAL STRUCTURE RATIOS – INDICATOR OF LONG TERM SOLVENCY
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 6
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Preference Indicates ability to pay
EAT
3 dividend Earnings after tax Preference dividend dividend on preference
coverage ratio Preference Dividend capital
Equity dividend EAES Earnings available to equity Indicates available coverage
4 Equity dividend
coverage ratio Equity Dividend shareholders for equity dividends
This ratio shows how many
EBIT + Depreciation
Fixed charges Interest + (Principal divided by times the cash flows are
5 Principal EBIT + Depreciation
coverage ratio Interest + [ ] 1- tax rate) available for covering all
1 − Tax
fixed financing charges
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 7
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
E. PROFITABILITY RATIOS RELATED TO SALES
Ratio Formula Numerator Denominator Significance/ Indicator
Gross profit Gross Profit Gross profit as per trading Indicator of basic
1 x 100 Sales net of returns
ratio Sales account profitability
Net Profit Indicator of overall
2 Net profit ratio x 100 Net profit as per P&L A/c Sales net of returns
Sales profitability
Pre-tax profit PBT Indicator of overall
3 x 100 Earnings before tax Sales net of returns
ratio Sales profitability excluding taxes
Sales – cost of sales
(or)
Operating profit Operating Profit (or ) EBIT Indicator of operating
4 x 100 Net Profit Sales net of returns
ratio Sales performance of business
(+) Non-operating expenses
(-) Non-operating incomes
COGS Indicator of basic cost of the
5 COGS ratio x 100 Cost of goods sold Sales net of returns
Sales product
Measures the proportion of
Operating Operating Expenses Admin expense + Selling &
6 x 100 Sales net of returns operating expense per rupee
expenses ratio Sales Distribution expense
of sales
COGS + Operating Expenses COGS + Operating Measures the overall cost of
7 Operating ratio x 100 Sales net of returns
Sales expenses the product
Financial Financial Expenses Measures the interest cost
8 x 100 Interest expenses Sales net of returns
expense ratio Sales pre rupee of sale
F. PROFITABILITY RELATED TO OVERALL RETURN ON ASSETS / INVESTMENTS
Ratio Formula Numerator Denominator Significance/ Indicator
Return on EBIT Earnings after tax Overall profitability of the
investment x 100 Fixed assets + Net current assets
Capital Employed (+) Income Tax business on the total funds
(ROI) or Return (or) (or)
1 (+) Interest on debt funds employed
on capital Equity + Long term debt +
EBIT x (1 Tax) (+) Non-operating If ROCE> Interest rate, use
employed x 100 Preference
Capital Employed adjustments of debt funds is justified
(ROCE)
Return on
Equity (ROE) or Indicates profitability of
EAES Earnings after tax (-) Equity capital + Reserves &
2 Return on x 100 owners funds invested in
Equity shareholders ′ funds preference dividend surplus – fictitious assets
networth the business
(RONW)
Return on assets Net Profit after taxes Average of opening total assets Indicates net income pre
3 x 100 Earnings after tax
(ROA) Average Total Assets & closing total assets rupee of average total assets
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 8
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 9
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Question No.1 – Nov 2016, Nov 2020 RTP, May 2019, Nov 2021 MTP
The following information and ratios are related to a company:
Sales for the year (all credit) Rs.30,00,000
Gross Profit Ratio 25 percent
Fixed assets turnover based on COGS 1.5 times
Stock turnover ratio based on COGS 6 times
Liquid ratio 1:1
Current ratio 1.5:1
Debtors collection period 2 months
Reserves & surplus to share capital 0.6:1
Capital gearing ratio 0.5
Fixed assets to networth 1.20:1
You are required to prepare a balance sheet
Answer:
Balance Sheet:
Liabilities Amount Assets Amount
Share capital (Note 7) 7,81,250 Fixed Assets (Note 2) 15,00,000
Reserves and Surplus (Note 7) 4,68,750 Inventory (Note 3) 3,75,000
Fixed charge bearing capital (Note 8) 6,25,000 Debtors (Note 5) 5,00,000
Current Liabilities (Note 4) 7,50,000 Cash (Note 6) 2,50,000
Total 26,25,000 Total 26,25,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 10
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Cash = 11,25,000 – 3,75,000 – 5,00,000 = Rs.2,50,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 12
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
COGS COGS
Stock Turnover Ratio = ;7 = ; 𝐂𝐎𝐆𝐒 = 𝐑𝐬. 𝟒𝟐, 𝟎𝟎, 𝟎𝟎𝟎
Stock 6,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 13
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Note 1: Computation of Current Assets and Current Liabilities:
Current Assets CA
Current Ratio = ; 2.5 = ; 𝐂𝐀 = 𝟐. 𝟓𝐂𝐋
Current Liabilities CL
Net working capital = Rs. 2,40,000; 𝐂𝐀 − 𝐂𝐋 = 𝟐, 𝟒𝟎, 𝟎𝟎𝟎
Substituting CA in NWC formula:
2.5CL − CL = Rs. 2,40,000; 1.5CL = Rs. 2,40,000; 𝐂𝐋 = 𝐑𝐬. 𝟏, 𝟔𝟎, 𝟎𝟎𝟎
CA = 1,60,000 x 2.50 = Rs.4,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 14
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Reserves and Surplus (Note 1) 45,00,000 Closing stock (Note 2) 15,00,000
15% debentures [6,00,000/15%] 40,00,000 Trade receivables (Given) 20,00,000
Trade payables (Given) 20,00,000 Cash and Bank (Note 3) 5,00,000
Total 2,10,00,000 2,10,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 15
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Fixed Assets (balancing figure) 7,92,000
Total 9,00,000 Total 9,00,000
Question No.7 [Jan 2021, May 2021 MTP, May 2019 MTP]
With the help of following information complete the balance sheet of ABC Limited:
Equity share capital Rs.1,00,000
Current debt to total debt 0.40
Total debt to owners equity 0.60
Fixed assets to owner’s equity 0.60
Total assets turnover 2 times
Inventory turnover 8 times
Answer:
Balance Sheet of ABC Limited:
Liabilities Amount Assets Amount
Equity share capital 1,00,000 Fixed assets 60,000
Long-term debt 36,000 Inventory 40,000
Current debt 24,000 Other current assets (b/f) 60,000
Total 1,60,000 Total 1,60,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 17
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Total 1,37,00,000 Total 1,37,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 18
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 19
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Note 5: Computation of average payment period:
365 365
Average Payment Period = = = 36.50 days
Creditors Turnover Ratio 10
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 20
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• The average inventory to be carried by the company
• Average collection period
(Assume 360 days year)
Answer:
Note 1: Computation of average inventory:
• Total credit sales is Rs.12,80,000. It is assumed that there is no cash sales and hence total sales is
Rs.12,80,000
• Gross profit margin is 15% and hence GP is 15% of sales
• This would further mean that cost of goods sold is 85% of sales. COGS = 12,80,000 x 85% =
Rs.10,88,000
COGS
Inventory Turnover =
Average Stock
10,88,000 10,88,000
4= ; Average stock = = Rs. 2,72,000
Average Stock 4
Average inventory to be carried by the company = Rs.2,72,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 21
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Note 2: Computation of sundry debtors:
3 3
Accounts receivables = Sales x = 16,00,000 𝑥 = 𝑅𝑠. 4,00,000
12 12
• Accounts’ receivable = Debtors + Bills’ receivables
• 4,00,000 = Debtors + 25,000; Debtors = Rs.3,75,000
Answer:
Computation of Return on capital employed:
EBIT
ROCE = x 100
Capital Employed
• In this question Net profit will be taken as proxy for EBIT
• Total assets will be taken as capital employed as indicated in question
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 23
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Question No.15 – Nov 2020, Nov 2019 MTP:
MNP Limited has made plans for the next year 2010 -11. It is estimated that the company will employ total
assets of Rs. 25,00,000; 30% of assets being financed by debt at an interest cost of 9% p.a. The direct costs for
the year are estimated at Rs..15,00,000 and all other operating expenses are estimated at Rs. 2,40,000. The sales
revenue are estimated at Rs. 22,50,000. Tax rate is assumed to be 40%. Required to calculate:
(i) Net profit margin;
(ii) Return on Assets;
(iii) Asset turnover; and
(iv) Return on Equity.
Answer:
WN 1: Income statement of MNP Limited
Particulars Calculation Amount
Sales 22,50,000
Less: Direct cost -15,00,000
Less: Other operating expenses -2,40,000
EBIT 5,10,000
Less: Interest 25,00,000 x 30% x 9% -67,500
EBT 4,42,500
Less: Tax @ 40% 4,42,500 x 40% -1,77,000
EAT 2,65,500
WN 2: Solution:
Note 1: Computation of Net Profit Margin:
Net Profit 2,65,500
Net Profit Margin = x 100 = 𝑥 100 = 11.80%
Sales 22,50,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 24
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Computation of sales:
Net profit 3,60,000
= 0.12; = 0.12; Sales = Rs. 30,00,000
sales Sales
Computation of total assets:
Sales 30,00,000 30,00,000
Asset Turnover = 2.5; = 2.5; = 2.5; Assets = = Rs. 12,00,000
Assets Assets 2.5
Computation of Equity Multiplier
Assets 12,00,000
Equity Multiplier = = = 3 Times
Equity 4,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 25
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
(iii) Profitability Ratios- The shareholder would use the profitability ratios to measure the profitability or
the operational efficiency of the firm to see the final results of business operations. A shareholder may use
return on equity, earning per share and dividend per share.
(iv) Activity Ratios- The finance manager would use these ratios to evaluate the efficiency with which the
firm manages and utilises its assets. Some important ratios are (a) Capital turnover ratio (b) Current and fixed
assets turnover ratio (c) Stock, Debtors and Creditors turnover ratio.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 26
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 4: COST OF CAPITAL
Cost of Equity:
Dividend Price Approach with Under this situation the amount of dividend remains constant. The cost
no growth in dividend [May of equity is calculated with the help of formula for PV for Perpetuity.
2019 MTP, Nov 2006] Dividend
Cost of Equity =
CMP − Floatation cost
Dividend Price Approach with Under this approach the rate of dividend growth remains constant. The
constant growth in dividend cost of equity is calculated with the help of formula for PV for growing
[May 2019 MTP] Perpetuity
D1
Ke = + Growth rate
P0 − F
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 27
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Where D1 = Dividend of next year;
P0 = Current market price; F = Floatation cost
Earnings/Price Approach with Earnings
Ke =
constant earnings P0 − F
Earnings/Price Approach with E1
Ke = + Growth rate
growth in earnings [Nov 2006] P0 − F
Where E1 = Earnings of next year; P0 = Current market price; F =
Floatation cost
Realized yield approach Under this method the cost of equity is calculated on the basis of past
dividend and capital appreciation. We need to find out the cash flows
and compute the IRR. The computed IRR is the cost of equity as per
realized approach
CAPM Approach Cost of Equity = Rf + Beta * (Rm – Rf)
Where Rf = Risk-free rate of return and Rm = Market return
Sum of Products
WACC =
Sum of weights
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 28
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
(b) If the anticipated growth rate is 8% per annum, calculate the indicated market price per share
(c) If the company issues 10% debentures of face value of Rs.100 each and realizes Rs.96 per debenture
while the debentures are redeemable after 12 years at a premium of 12%, what will be the cost of
debenture?
Assume tax rate to be 50%
Answer:
Part (a):
Basic information:
Dividend of next year Rs.2
CMP/Issue price Rs.25
IRR/ROE/ROI NA
Retention ratio NA
Growth rate 6%
Floatation cost 0
D1
Ke = + Growth rate
P0 − F
𝟐
𝐊𝐞 = + 𝟎. 𝟎𝟔 = 𝟎. 𝟎𝟖 + 𝟎. 𝟎𝟔 = 𝟎. 𝟏𝟒(𝐨𝐫)𝟏𝟒. 𝟎𝟎%
𝟐𝟓 − 𝟎
• Company’s cost of capital = 14.00%
Note:
• It is assumed that dividend of Rs.2 is next year dividend
Part (b):
D1
Ke = + Growth rate
P0 − F
2 2
0.14 = + 0.08; 0.06 =
P0 − 0 P0
𝟐
𝐏𝟎 = = 𝐑𝐬. 𝟑𝟑. 𝟑𝟑 𝐩𝐞𝐫 𝐬𝐡𝐚𝐫𝐞
𝟎. 𝟎𝟔
Part (c):
Cost of debt:
Type of debt Redeemable
Face value Rs.100 (assumed)
Coupon rate 10%
Tax rate 50%
Net proceeds Issue price – FC = Rs.96
Redeemable value Rs.112
Balance life 12 years
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 30
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Question No.4 – May 2017 RTP
XYZ Limited is currently earning a profit after tax of Rs.25,00,000 and its shares are quoted in the market at
Rs.450 per share. The company has 1,00,000 shares outstanding and has not raised debt in its capital structure.
It is expected that the same level of earnings will be maintained for future years also. The company has 100
percent pay-out policy.
Required:
(a) Calculate the cost of equity
(b) If the company’s payout ratio is assumed to be 70% and it earns 20% rate of return on its investment,
then what would be the firm’s cost of equity?
Answer:
WN 1: Computation of cost of equity for original scenario:
Basic information:
Dividend of next year 25,00,000/1,00,000 = Rs.25 per share
CMP/Issue price Rs.450 per share
IRR/ROE/ROI NA
100% - Payout ratio
Retention ratio 100% - 100% = 0%
Growth rate 0%
Floatation cost 0
D1
Ke = + Growth rate
P0 − F
𝟐𝟓
𝐊𝐞 = + 𝟎. 𝟎𝟎 = 𝟎. 𝟎𝟓𝟓𝟔 + 𝟎. 𝟎𝟎 = 𝟎. 𝟎𝟓𝟓𝟔(𝐨𝐫)𝟓. 𝟓𝟔%
𝟒𝟓𝟎 − 𝟎
Required: Determine the required rate of return for equity share (cost of equity) before the issue and after the
issue
Answer:
• Required rate of return on equity is basically cost of equity.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 31
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Floatation cost 0
Note:
Computation of price:
MPS MPS
PE Multiple = ; 6.25 = ; MPS = 125
EPS 20
EPS 20
ROE = ; ROE = ; ROE = 0.16 (or)16%
Book value per share 125
• It is assumed that book value per share and market value per share is same.
D1
Ke = + Growth rate
P0 − F
𝟏𝟐
𝐊𝐞 = + 𝟎. 𝟎𝟔𝟒 = 𝟎. 𝟎𝟗𝟔 + 𝟎. 𝟎𝟔𝟒 = 𝟎. 𝟏𝟔(𝐨𝐫)𝟏𝟔. 𝟎𝟎%
𝟏𝟐𝟓 − 𝟎
Conclusion:
The company should go ahead with NCD option as the cost of NCD is lower than cost of term loan.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 32
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
TT Ltd. issued 20,000, 10% convertible debenture of Rs. 100 each with a maturity period of 5 years. At
maturity the debenture holders will have the option to convert debentures into equity shares of the company
in ratio of 1:5 (5 shares for each debenture). The current market price of the equity share is Rs. 20 each and
historically the growth rate of the share is 4% per annum. Assuming tax rate is 25%. Compute the cost of 10%
convertible debenture using Approximation Method and Internal Rate of Return Method
PV Factors are as under:
Year 1 2 3 4 5
PV Factor @ 10% 0.909 0.826 0.751 0.683 0.621
PV Factor @ 15% 0.870 0.756 0.658 0.572 0.497
Answer:
Basic information
Type of debt Redeemable and convertible
Face value Rs.100
Coupon rate 10%
Tax rate 25%
Issue price – Floatation cost
Net proceeds 100 – 0 = Rs.100
Redeemable value Rs.121.67 (Note 1)
Balance life 5 years
Note 1: Computation of redeemable value:
• Debenture holder at the expiry of five years has the option to convert debentures into shares or
redeem the same
• Redeemable value will be higher of the following:
o Conversion into equity: One debenture will be converted into 5 equity shares. Current
market price of one equity share is Rs.20. Equity shares will grow at 4 percent and expected
price per share in year 5 is Rs.24.333 (20x (1.05) 5). Value of 5 shares received on redemption
is equal to Rs.121.67
o Redemption as debt: Debenture can be redeemed and debenture holder receive Rs.100
IRR Method:
Year Cash flow PVF @ 10% DCF PVF @ 15% DCF
0 -100.00 -1.000 -100.000 -1.000 -100.000
1 to 5 7.50 3.790 28.425 3.353 25.148
5 121.67 0.621 75.557 0.497 60.470
NPV +3.982 -14.382
𝟑. 𝟗𝟖𝟐
𝐈𝐑𝐑 (𝐨𝐫)𝐂𝐨𝐬𝐭 𝐨𝐟 𝐝𝐞𝐛𝐭 = 𝟏𝟎 + [ 𝐱 (𝟏𝟓 − 𝟏𝟎)] = 𝟏𝟎 + 𝟏. 𝟎𝟖𝟒 = 𝟏𝟏. 𝟎𝟖𝟒%
𝟑. 𝟗𝟖𝟐 − (−𝟏𝟒. 𝟑𝟖𝟐)
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 33
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
with a trial rate and then increase/decrease the same till we get one positive and one negative NPV to
compute IRR [Concept of IRR will be explained in investment decision chapter]
IRR computation:
Year Cash flow PVF @ 15% DCF PVF @ 16% DCF
0 -3,750 -1.000000 -3,750 -1.000000 -3,750
25 1,50,000 0.030378 4,556.7 0.024465 3,669.75
NPV 806.70 -80.25
Note: YTM approach is basically computing the IRR of the instrument. Normally we have an outflow in IRR
approach on day 0 and hence the first cash flow has been taken as outflow and other cash flows are taken as
inflows to compute IRR. The answer would remain same even if 3,750 is taken as inflow and 1,50,000 is taken
as outflow.
𝟖𝟎𝟔. 𝟕𝟎
𝐈𝐑𝐑 (𝐨𝐫)𝐂𝐨𝐬𝐭 𝐨𝐟 𝐝𝐞𝐛𝐭 = 𝟏𝟓 + [ 𝐱 (𝟏𝟔 − 𝟏𝟓)] = 𝟏𝟓 + 𝟎. 𝟗𝟏 = 𝟏𝟓. 𝟗𝟏%
𝟖𝟎𝟔. 𝟕𝟎 − (−𝟖𝟎. 𝟐𝟓)
Question No.9 [Nov 2020 MTP, Nov 2018 MTP, Nov 2019 RTP, May 2020 MTP, May 2020 RTP, Nov 2010]
JKL Ltd. has the following book-value capital structure as on March 31, 2003.
Particulars Amount
Equity share capital (2,00,000 shares) 40,00,000
11.5% preference shares 10,00,000
10% debentures 30,00,000
Total 80,00,000
The equity share of the company sells for Rs. 20. It is expected that the company will pay next year a dividend
of Rs. 2 per equity share, which is expected to grow at 5% p.a. forever. Assume a 35% corporate tax rate.
Required:
I. Compute weighted average cost of capital (WACC) of the company based on the existing capital
structure.
II. Compute the new WACC, if the company raises an additional Rs. 20 lakhs debt by issuing 12%
debentures. This would result in increasing the expected equity dividend to Rs. 2.40 and leave the growth
rate unchanged, but the price of equity share will fall to Rs. 16 per share.
Answer:
WN 1: Computation of cost of individual components of capital:
Cost of equity:
Basic information:
Dividend of next year Rs.2.00 per share
CMP/Issue price Rs.20 per share
IRR/ROE/ROI NA
Retention ratio NA
Growth rate 5 percent
Floatation cost 0
D1
Ke = + Growth rate
P0 − F
𝟐. 𝟎
𝐊𝐞 = + 𝟎. 𝟎𝟓 = 𝟎. 𝟏𝟎 + 𝟎. 𝟎𝟓 = 𝟎. 𝟏𝟓(𝐨𝐫)𝟏𝟓. 𝟎𝟎%
𝟐𝟎. 𝟎𝟎
Cost of preference:
Cost of preference = Rate of dividend on preference shares = 11.50%
Cost of debentures:
Cost of debentures = Interest rate x (1 – tax rate) = 10% x (1 – 35%) = 6.50%
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 34
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Preference 11.50% 10,00,000 1,15,000
Debentures 6.50% 30,00,000 1,95,000
Total 80,00,000 9,10,000
Sum of product 9,10,000
WACC = = x 100 = 𝟏𝟏. 𝟑𝟕𝟓%
sum of weights 80,00,000
Question No.10 [May 2018 MTP, May 2019 RTP, Nov 2020 MTP]
XYZ Ltd., has the following book value capital structure:
Equity Capital (in Shares of Rs.10 each, fully paid up-at par) Rs.15 Crores
11% preference Capital (in shares of Rs.100 each, fully paid up – at par) Rs.1 Crore
Retained Earnings Rs.20 Crores
13.5% Debentures (of Rs.100 each) Rs.10 Crores
15% Term Loans Rs.12.5 Crores
• The next expected dividend on equity shares per share is Rs.3.60; the dividend per share is
expected to grow at the rate of 7%. The market price per share is Rs.40.
• Preference stock, redeemable after ten years, is currently selling at Rs.75 per share.
• Debentures, redeemable after six years, are selling at Rs.80 per debenture.
• The Income-tax rate for the company is 40%.
(i) Required:
Calculate the weighted average cost of capital using:
(a) book value proportions; and
(b) Market value proportions.
(ii) Define the weighted marginal cost of capital schedule for the company, if it raises Rs.10 Crores next year,
given the following information:
(a) The amount will be raised by equity and debt in equal proportions:
(b) The company expects to retain Rs.1.5 Crores earnings next year:
(c) The additional issue of equity shares will result in the net price per share being fixed at Rs.32;
(d) The debt capital raised by way of term loans will cost 15% for the first Rs.2.5 Crores and 16% for the next
Rs.2.5 Crores.
Answer:
WN 1: Computation of cost of individual components of capital:
Cost of equity:
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 35
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Basic information:
Dividend of next year Rs.3.60 per share
CMP/Issue price Rs.40 per share
IRR/ROE/ROI NA
Retention ratio NA
Growth rate 7 percent
Floatation cost 0
D1
Ke = + Growth rate
P0 − F
𝟑. 𝟔𝟎
𝐊𝐞 = + 𝟎. 𝟎𝟕 = 𝟎. 𝟎𝟗 + 𝟎. 𝟎𝟕 = 𝟎. 𝟏𝟔(𝐨𝐫)𝟏𝟔. 𝟎𝟎%
𝟒𝟎 − 𝟎
Cost of preference:
Basic information
Type of preference Redeemable
Face value Rs.100
Coupon rate 11%
Net proceeds Current market price = Rs.75
Redeemable value Rs.100 (assumed at par)
Balance life 10 years
Dividend distribution tax 0
Computation of Cost of preference:
RV − NP
Preference Dividend + Average other costs Preference Dividend + Balance life
Kp = =
Average funds employed RV + NP
2
100 − 75
11.00 + 11.00 + 2.50
Kp = 10 = x 100 = 15.43%
100 + 75 87.50
2
Cost of debentures:
Basic information:
Type of debt Redeemable
Face value Rs.100
Coupon rate 13.50%
Tax rate 40%
Net proceeds Current market price = Rs.80
Redeemable value Rs.100 (assumed at par)
Balance life 6 years
Computation of Cost of Debt:
RV − NP
Interest after tax + Average other costs Interest after tax + Balance life
Kd = =
Average funds employed RV + NP
2
100 − 80
8.10 + 8.10 + 3.33
Kd = 6 = x 100 = 12.70%
100 + 80 90
2
WN 2: Computation of WACC
Weight (in lacs) Product (in lacs)
Source Cost BV MV BV MV
Equity 16.00% 1,500 2,571 240.00 411.36
75
Preference capital 15.43% 100 [1 lac x 75] 15.43 11.57
Retained earnings 16.00% 2,000 3,429 320.00 548.64
800
Debentures 12.70% 1,000 [10 lac x 80] 127.00 101.60
Term loan 9.00% 1,250 1,250 112.50 112.50
Total 5,850 8,125 814.93 1,185.67
• Market value of equity shares = 150 lacs shares x 40 = 6,000 lacs. This has been split in the ratio of
3:4 to get value of equity and retained earnings.
WACC Computation:
Sum of product 814.93
WACC(based on BV weights) = = x 100 = 13.93%
sum of weights 5,850
Sum of product 1,185.67
WACC(based on MV weights) = = x 100 = 14.59%
sum of weights 8,125
WN 3: Computation of WMCC:
Part 1: Money to be raised:
Money to be
raised = 10 Cr
Equity = Debt = 5
5cr cr
The company can issue 14 percent new debenture. The company’s debenture is currently selling at Rs.98. The
new preference issue can be sold at a net price of Rs.9.80, paying a dividend of Rs.1.20 per share. The
company’s marginal tax rate is 50%.
(i) Calculate the after tax cost (a) of a new debts and new preference share capital, (b) of ordinary equity,
assuming new equity comes from retained earnings.
(ii) Calculate the marginal cost of capital.
(iii) How much can be spent for capital investment before new ordinary share must be sold? Assuming that
retained earnings available for next year’s investment are 50% of 2004 earnings
(iv) What will be marginal cost of capital (cost of funds raised in excess of the amount calculated in part (iii))
if the company can sell new ordinary shares to net Rs.20 per share? The cost of debt and of preference capital
is constant.
Answer:
WN 1: Computation of cost of individual components of capital:
Cost of debt:
Basic information
Type of debt Irredeemable
Face value Rs.100
Coupon rate 14%
Tax rate 50%
Issue price – floatation cost
Net proceeds 100 (assumed at par) – 0 = Rs.100
Redeemable value NA
Balance life NA
Interest after tax 7
Kd = = x 100 = 7.00%
Net proceeds 100
Cost of preference:
Basic information
Type of preference Irredeemable
Dividend Rs.1.20 per share
Net proceeds Rs.9.80 per share
Redeemable value NA
Balance life NA
Computation of Cost of Preference:
Preference Dividend 1.20
Kp = = x 100 = 12.24%
Net proceeds 9.80
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 38
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Retention ratio NA
Growth rate 12% [Increase in dividend is 12% every year]
Floatation cost 0
D1
Kr = + Growth rate
P0
𝟏. 𝟑𝟖𝟔𝟓
𝐊𝐫 = + 𝟎. 𝟏𝟐 = 𝟎. 𝟎𝟓 + 𝟎. 𝟏𝟐 = 𝟎. 𝟏𝟕(𝐨𝐫)𝟏𝟕. 𝟎𝟎%
𝟐𝟕. 𝟕𝟓
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 39
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
(b) Market value weights.
The capital structure of Ganpati Limited is as under:
Particulars Amount
Debentures (Rs.100 per debenture) 5,00,000
Preference shares (Rs.100 per share) 5,00,000
Equity shares (Rs.10 per share) 10,00,000
The market prices of these securities are:
• Debentures : 105 per debenture
• Preference Shares : 110 per preference share
• Equity Shares : 24 each.
Additional information:
(i) 100 per debenture redeemable at par, 10% coupon rate, 4% floatation costs, 10 year maturity.
(ii) 100 per preference share redeemable at par, 5% coupon rate, 2% floatation cost and 10 year maturity.
(iii) Equity shares has Rs. 4 floatation cost and market price Rs. 24 per share. The next year expected dividend
is Rs. 1 with annual growth of 5 percent. The firm has practice of paying all earnings in the form of dividend.
The corporate tax rate is 50 percent.
Answer:
WN 1: Computation of cost of individual components of capital:
Cost of debt:
Type of debt Redeemable
Face value Rs.100
Coupon rate 10%
Tax rate 50%
Net proceeds Issue price – Floatation cost
[issue assumed at par] 100 – 4 = Rs.96
Redeemable value Rs.100
Balance life 10 years
Cost of preference:
Basic information
Type of preference Redeemable
Face value Rs.100
Coupon rate 5%
Net proceeds Issue price – Floatation cost
[issue assumed at par] 100 -2 = Rs.98
Redeemable value Rs.100
Balance life 10 years
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 40
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Cost of equity:
Basic information:
Dividend of next year Rs.1 per share
CMP/Issue price Rs.24 per share
IRR/ROE/ROI NA
Retention ratio NA
Growth rate 5 percent
Floatation cost Rs.4 per share
D1
Ke = + Growth rate
P0 − F
𝟏
𝐊𝐞 = + 𝟎. 𝟎𝟓 = 𝟎. 𝟎𝟓 + 𝟎. 𝟎𝟓 = 𝟎. 𝟏𝟎(𝐨𝐫)𝟏𝟎. 𝟎𝟎%
𝟐𝟒 − 𝟒
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 41
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Cost of debt:
Basic information
Type of debt Irredeemable
Face value Rs.100 (assumed)
Coupon rate 12%
Tax rate 50%
CMP
Net proceeds =7,20,000/6,000 = Rs.120
Redeemable value NA
Balance life NA
WN 2: Computation of WACC:
Weight Product
Source Cost BV MV BV MV
Equity 15.09% 10,00,000 10,00,000 1,50,900 1,50,900
Retained earnings 12.07% 1,00,000 1,00,000 12,070 12,070
Preference shares 9.09% 4,00,000 4,40,000 36,360 39,996
Debentures 5.00% 6,00,000 7,20,000 30,000 36,000
Total 21,00,000 22,60,000 2,29,330 2,38,966
Sum of product 2,29,330
WACC(based on BV weights) = = x 100 = 10.92%
sum of weights 21,00,000
Sum of product 2,38,966
WACC(based on MV weights) = = x 100 = 10.57%
sum of weights 22,60,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 43
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Sum of product 3,25,670
WACC(based on MV weights) = = x 100 = 10.15%
sum of weights 32,10,000
Question No.15 [May 2018 RTP, Nov 2019, May 2008, May 2015, Nov 2015 RTP, May 2015 RTP, Nov 2017
RTP, July 2021]
Navya Limited wishes to raise additional capital of Rs.10 lakhs for meeting its modernization plan. It has
Rs.3,00,000 in the form of retained earnings available for investment purposes. The following are the further
details:
Debt/equity mix 40%/60%
Cost of debt (before tax)
Upto Rs.1,80,000 10%
Beyond Rs.1,80,000 16%
Earnings per share Rs.4
Dividend Payout Rs.2
Expected growth rate in dividend 10%
Current market price per share Rs.44
Tax rate 50%
Required:
a) To determine the pattern for raising the additional finance
b) To calculate the post-tax average cost of additional debt
c) To calculate the cost of retained earnings and cost of equity and
d) To determine the overall weighted average cost of capital (after tax)
Answer:
WN 1: Pattern of raising additional finance:
Money to be
raised = 10 lacs
Equity = 6 Debt = 4
lacs lacs
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 44
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
𝟐. 𝟐𝟎
𝐊𝐞 = + 𝟎. 𝟏𝟎 = 𝟎. 𝟎𝟓 + 𝟎. 𝟏𝟎 = 𝟎. 𝟏𝟓(𝐨𝐫)𝟏𝟓. 𝟎𝟎%
𝟒𝟒 − 𝟎
WN 4: Computation of WACC:
Source Cost Weight Product
Equity 15.00% 3,00,000 45,000
Retained earnings 15.00% 3,00,000 45,000
Debt 6.65% 4,00,000 26,600
Total 10,00,000 1,16,600
Sum of product 1,16,600
WACC = = x 100 = 11.66%
sum of weights 10,00,000
IRR computation:
Year Cash flow PVF @ 5% DCF PVF @ 7% DCF
0 -112.70 -1.000 (112.70) 1.000 (112.70)
1 to 10 7 7.722 54.05 7.024 49.17
[10 x 70%]
10 100.00 0.614 61.40 0.508 50.80
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 45
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
NPV +2.75 -12.73
Note: YTM approach is basically computing the IRR of the instrument. There will be a net inflow of Rs.112.70
on day 0. The company would be paying Rs.7 every year and Rs.100 at end of life. Normally we have an
outflow in IRR approach and hence the first cash flow has been taken as outflow and other cash flows are
taken as inflows to compute IRR.
𝟐. 𝟕𝟓
𝐈𝐑𝐑 (𝐨𝐫)𝐂𝐨𝐬𝐭 𝐨𝐟 𝐝𝐞𝐛𝐭 = 𝟓 + [ 𝐱 (𝟕 − 𝟓)] = 𝟓 + 𝟎. 𝟑𝟔 = 𝟓. 𝟑𝟔%
𝟐. 𝟕𝟓 − (−𝟏𝟐. 𝟕𝟑)
Cost of preference:
Type of preference Redeemable
Face value Rs.100
Coupon rate 5%
Current market price Rs.120
Net realization at CMP 120 – 2% = Rs.117.60
Redeemable value Rs.100
Balance life 10 years
IRR computation:
Year Cash flow PVF @ 2% DCF PVF @ 5% DCF
0 -117.60 -1.000 (117.60) 1.000 (117.60)
1 to 10 5 8.983 44.92 7.722 38.61
10 100.00 0.820 82.00 0.614 61.40
NPV +9.32 -17.59
9.32
IRR (or)Cost of preference = 2 + [ x (5 − 2)] = 2 + 1.04 = 3.04%
9.32 − (−17.59)
Cost of equity:
Basic information:
Dividend of next year Rs.5 per share
CMP/Issue price Rs.265 per share
IRR/ROE/ROI NA
Retention ratio NA
Growth rate 15 percent
Floatation cost Rs.1 per share
D1
Ke = + Growth rate
P0 − F
𝟓
𝐊𝐞 = + 𝟎. 𝟏𝟓 = 𝟎. 𝟏𝟔𝟖𝟗(𝐨𝐫)𝟏𝟔. 𝟖𝟗%
𝟐𝟔𝟓 − 𝟏
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 46
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Cost of preference:
Basic information
Type of preference Irredeemable
Face value Rs.100
Coupon rate 15%
Issue price – floatation cost
Net proceeds Rs.105
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 47
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Redeemable value NA
Balance life NA
Cost of debt:
Type of debt Redeemable
Face value Rs.100 (assumed)
Coupon rate 15%
Tax rate 35%
Issue price – FC
Net proceeds 93.75 – 2 = Rs.91.75
Redeemable value Rs. 100 (assumed at par)
Balance life 11 years
WN 2: Computation of WACC:
Weight Product
Source Cost BV MV BV MV
Equity 18.50% 1,20,00,000 1,60,00,000 22,20,000 29,60,000
Retained earnings 18.00% 30,00,000 40,00,000 5,40,000 7,20,000
Preference shares 14.29% 9,00,000 10,40,000 1,28,610 1,48,616
Debentures 10.95% 36,00,000 33,75,000 3,94,200 3,69,563
Total 1,95,00,000 2,44,15,000 32,82,810 41,98,179
• There is no separate market value given for retained earnings. Market value given in question is
combined market value for equity and retained earnings. Hence we split the market value of
Rs.2,00,00,000 in the ratio of book values (4:1) to get market value of equity and retained earnings.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 48
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 5: FINANCING DECISIONS – CAPITAL STRUCTURE
MM Approach:
MM approach without tax (1958):
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 49
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Specific assumptions ❖ Capital markets are perfect. All information is freely available and
there are no transaction costs.
❖ All investors are rational.
❖ Firms can be grouped into ‘Equivalent risk classes’ on the basis of their
business risk.
❖ Non-existence of corporate taxes.
Conclusion ❖ Total market value of a firm is equal to its expected net operating
income divided by the discount rate appropriate to its risk class decided
by the market
❖ A firm having debt in capital structure has higher cost of equity than an
unlevered firm. The cost of equity will include risk premium for the
financial risk.
❖ The structure of the capital (financial leverage) does not affect the
overall cost of capital. The cost of capital is only affected by the business
risk.
Justification for irrelevancy The operational justification of Modigliani-Miller hypothesis is
of capital structure explained through the functioning of the arbitrage process and
substitution of corporate leverage by personal leverage. Arbitrage refers
to buying asset or security at lower price in one market and selling it at a
higher price in another market. As a result, equilibrium is attained in
different markets.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 50
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
EBIT x (1 − Tax Rate)
Value of Firm =
Cost of Capital
Optimal Capital Structure:
❖ The basic objective of financial management is to design an appropriate capital structure which
can provide the highest earnings per share (EPS) over the company’s expected range of earnings
before interest and taxes (EBIT). The firm can use the EBIT-EPS analysis to decide an optimal capital
structure.
❖ Following are the steps involved in EBIT-EPS analysis:
Step 1 Identify the various alternatives for raising money
Step 2 Calculate Preference Dividend, Interest and Number of Equity shares for various
alternatives
Step 3 Calculate EPS/Market value of Firm and select the alternative which maximizes EPS/
Market value of Firm
WN 2: Computation of interest, preference dividend and no of equity shares for three alternatives:
Particulars Alt 1 Alt 2 Alt 3
Interest
Existing interest - - -
New Interest 25,000 1,37,500 2,37,500
[2,50,000 x 10%] [2,50,000 x 10% + [2,50,000 x 10% +
7,50,000 x 15%] 7,50,000 x 15% +
5,00,000 x 20%]
Total Interest 25,000 1,37,500 2,37,500
Preference dividend
Existing - - -
New - - -
Total dividend - - -
No of equity shares
Existing - - -
New 15,000 10,000 8,000
(22,50,000/150) (15,00,000/150) (10,00,000/125)
Total 15,000 10,000 8,000
• It is assumed that interest rates given in the question are slab rates.
WN 3: Computation of EPS:
Particulars Alt 1 Alt 2 Alt 3
EBIT 5,00,000 5,00,000 5,00,000
Less: Interest [WN 2] -25,000 -1,37,500 -2,37,500
EBT 4,75,000 3,62,500 2,62,500
Less: Tax @ 50% -2,37,500 -1,81,250 -1,31,250
EAT 2,37,500 1,81,250 1,31,250
Less: Preference dividend - - -
EAES 2,37,500 1,81,250 1,31,250
No of shares 15,000 10,000 8,000
EPS (EAES/No of shares) 15.8333 18.1250 16.4063
The company should go ahead with Alternative 2 as the same results in maximum EPS.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 52
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Particulars Alt 1 Alt 2
Interest
Existing interest - -
New Interest 48,000 48,000
Total Interest 48,000 48,000
Preference dividend
Existing - -
New - 28,000
Total dividend - 28,000
No of equity shares
Existing - -
New (issue price assumed as Rs.10) 60,000 40,000
Total shares 60,000 40,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 54
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
EPS of Plan 1 = EPS of Plan 2
0.6X 0.6X − 75,000 1,50,000
= ; 0.6X = 1.2X − 1,50,000; X = = 𝟐, 𝟓𝟎, 𝟎𝟎𝟎
3,12,500 1,56,250 0.6
• Indifference point between Plan 1 and Plan 2 = EBIT of Rs.2,50,000
Selection of alternative:
Alternative to be selected would depend on level of EBIT and the same is tabulated below:
Level of EBIT Plan to be selected
< 2,50,000 Plan 1
At 2,50,000 Plan 1 or Plan 2 (Indifferent)
> 2,50,000 Plan 2
• Plan 3 is not analyzed as Plan 2 dominates Plan 3
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 55
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Particulars Alt 1 Alt 2
EBIT 2,40,000 2,40,000
Less: Interest -24,000 -
EBT 2,16,000 2,40,000
Less: Tax -64,800 -72,000
EAT 1,51,200 1,68,000
-16,800
Less: Preference dividend - [1,16,800-1,151,200]
EAES 1,51,200 1,51,200
No of shares 40,000 40,000
EPS (EAES/No of shares) 3.78 3.78
𝟏𝟔, 𝟖𝟎𝟎
𝐑𝐚𝐭𝐞 𝐨𝐟 𝐝𝐢𝐯𝐢𝐝𝐞𝐧𝐝 𝐨𝐧 𝐩𝐫𝐞𝐟𝐞𝐫𝐞𝐧𝐜𝐞 𝐬𝐡𝐚𝐫𝐞𝐬 = 𝐱 𝟏𝟎𝟎 = 𝟖. 𝟒𝟎%
𝟐, 𝟎𝟎, 𝟎𝟎𝟎
Note:
• We will compute EPS of Alternative 1. It works out to be Rs.3.78 per share
• At indifferent point, EPS of Alternative 1 and 2 will match and hence EPS of Alt 2 is Rs.3.78. We will
reverse-work and preference dividend of Rs.16,800 will be balancing figure.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 56
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• CMP of share = EPS x PE Multiple = 4 x 10 = Rs.40
• New shares issued = 4,00,000/40 = 10,000
WN 3: Computation of EPS:
Particulars Alt 1 Alt 2
EBIT [Note 1] 4,76,000 4,76,000
Less: Interest [WN 2] -1,68,000 -1,20,000
EBT 3,08,000 3,56,000
Less: Tax @ 50% -1,54,000 -1,78,000
EAT 1,54,000 1,78,000
Less: Preference dividend - -
EAES 1,54,000 1,78,000
No of shares [WN 2] 80,000 1,20,000
EPS (EAES/No of shares) 1.9250 1.4833
Conclusion: The company should go ahead with Alternative 1 to maximize EPS
The company expects to improve its rate of return by 2 percent as a result of modernization, but P/E ratio is
likely to go down to 8 if the entire amount is raised as term loan.
a) Advise the company on the financial plan to be selected
b) If it is assumed that there will be no change in the P/E ratio if either of the two alternatives is adopted,
would your advice still hold good?
Answer:
WN 1: Computation of interest, preference dividend and no of equity shares:
Particulars Alt 1 Alt 2
Interest
Existing interest 2,20,000 2,20,000
New Interest 3,60,000 1,20,000
[30,00,000 x 12%] [10,00,000 x 12%]
Total Interest 5,80,000 3,40,000
Preference dividend
Existing - -
New - -
Total dividend - -
No of equity shares
Existing 5,00,000 5,00,000
New - 1,00,000
Total shares 5,00,000 6,00,000
• Note: Debentures would be paid off and hence existing interest will be Rs.2,20,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 61
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Indifference point between Plan 2 and Plan 3:
EPS of Plan 2 = EPS of Plan 3
0.6X − 6,56,000 0.6X − 2,16,000
= ; 6.3X − 68,80,000 = 4.8X − 17,28,000; 1.5X = 51,60,000
8,00,000 10,50,000
51,60,000
X= = Rs. 34,40,000
1.5
Indifference point between Plan 2 and Plan 3 = EBIT of Rs.34,40,000
Question No.9 [Nov 2020, May 2018 MTP, Nov 2018 MTP, Nov 2018, Nov 2019 RTP, May 2018]
The management of Z Company Ltd. wants to raise its funds from market to meet out the financial demands
of its long-term projects. The company has various combinations of proposals to raise its funds. You are given
the following proposals of the company:
Proposals % of Equity % of Debt % of preference shares
P 100 - -
Q 50 50 -
R 50 - 50
I. Cost of debt – 10%
Cost of preference shares – 10%
II. Tax rate – 50%
III. Equity shares of the face value of Rs. 10 each will be issued at a premium of Rs. 10 per share.
IV. Total investment to be raised Rs. 40,00,000.
V. Expected earnings before interest and tax Rs. 18,00,000.
From the above proposals the management wants to take advice from you for appropriate plan after
computing the following:
• Earnings per share
• Financial break-even-point
• Compute the EBIT range among the plans for indifference. Also indicate if any of the plans dominate
Answer:
WN 1: Computation of financial break-even point:
Step 1: Identification of alternatives:
• Plan P – Issue equity of Rs.40,00,000 at issue price of Rs.20 per share
• Plan Q – Issue equity of Rs.20,00,000 and 10% debt of Rs.20,00,000
• Plan R – Issue equity of Rs.20,00,000 and 10% preference shares of Rs.20,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 62
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Existing interest - - -
New Interest - 2,00,000 -
Total Interest - 2,00,000 -
Preference dividend
Existing - - -
New - - 2,00,000
Total dividend - - 2,00,000
No of equity shares
Existing - - -
New 2,00,000 1,00,000 1,00,000
Total shares 2,00,000 1,00,000 1,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 63
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
EPS of Plan Q = EPS of Plan R
0.5X − 1,00,000 0.5X − 2,00,000
= ;
1,00,000 1,00,000
• There is no indifference point between Plan Q and Plan R. This would mean that one plan is
dominating the other plan
• Plan with low financial break-even point will dominate the plan with high financial break-even
point.
• In this case, Plan Q has lower financial BEP and hence Plan Q dominates Plan R
10,00,000 4,00,000
Value of debt [20,00,000 x 50%] [20,00,000 x 20%]
10,00,000 16,00,000
Value of equity [20,00,000 x 50%] [20,00,000 x 80%]
Value of firm
[EBIT/Cost off Capital] 20,00,000 20,00,000
Notes:
• Overall capitalization rate (Cost of capital) of company Alpha is 18%. Company Beta will also have
the same capitalization rate as they are identical companies
• Value of firm = EBIT/Cost of capital. Value of firm for both companies is same at Rs.20,00,000
• Value of firm is split into debt and equity as per the ratio given in question
Solution:
• Return of investor = 2,80,000 [EBT/EAT/EAES] x 2% = Rs.5,600
• Implied rate of return on equity of company Alpha = 28.00%
• Implied rate of return on equity of company Beta = 20.50%
• Implied required rate of return on equity of Beta Ltd. is lower than that of Alpha Ltd. because Beta
Ltd. uses less debt in its capital structure. As the equity capitalisation is a linear function of the debt-
to-equity ratio when we use the net operating income approach, the decline in required equity
return offsets exactly the disadvantage of not employing so much in the way of “cheaper” debt
funds
Value of debt
[Interest/Cost of debt] 1,00,00,000 2,00,00,000
Value of equity
[EAT/Cost of equity] 2,00,00,000 2,00,00,000
Value of firm 3,00,00,000 4,00,00,000
• Cost of debt continues to be 10% as the new debt was taken at interest rate of 10%
• Value of equity is assumed to remain same in revised scenario and hence cost of equity will increase
due to increase in debt.
Question No.15 [May 2021 MTP, May 2018 MTP, Nov 2019 MTP, May 2017]
There are two firms P and Q which are identical except P does not use any debt in its capital structure while
Q has Rs. 8,00,000, 9% debentures in its capital structure. Both the firms have earnings before interest and tax
of Rs. 2,60,000 p.a. and the capitalization rate is 10%. Assuming the corporate tax of 30%, calculate the value
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 67
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
of these firms according to MM Hypothesis.
Answer:
Valuation of firm as per MM Approach:
Particulars Firm P Firm Q
EBIT 2,60,000 2,60,000
Less: Interest
[Debt x Rate of interest] - -72,000
EBT 2,60,000 1,88,000
Less: Tax -78,000 -56,400
EAT 1,82,000 1,31,600
Cost of debt
[Interest rate x (1 – Tax rate)] NA 6.30%
Cost of equity
[EAT/Amount of equity] 10.00% 10.44%
Cost of capital
[EBIT x (1 – Tax)]/Value of firm 10.00% 8.83%
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 68
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Value of firm 1,00,00,000 1,00,00,000
• There are no taxes. We start with valuation of unlevered firm and the same is Rs.1,00,00,000
• Valuation of levered firm will remain same as unlevered firm as there are no taxes
• Cost of equity of Firm A = (11,52,000/46,00,000) x 100 = 25.04%
7.20%
Cost of debt [12% x 60%] NA
25.04% 18.00%
Cost of equity [6,91,200/27,60,000] [Given]
Cost of capital 13.24% 18.00%
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 69
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
5.00%
Cost of debt [10% x 50%] NA
15.00% 15.00%
Cost of equity [Given] [Given]
9.38% 15.00%
Cost of capital [6,00,000 x 50%]/32,00,000 [6,00,000 x 50%]/20,00,000
18,00,000
Value of debt [Given] -
14,00,000 20,00,000
Value of equity [2,10,000/15%] [3,00,000/20%]
Value of firm 32,00,000 20,00,000
5.00%
Cost of debt [10% x 50%] NA
19.09% 15.00%
Cost of equity [2,10,000/11,00,000] [Given]
10.34%
Cost of capital [6,00,000 x 50%]/29,00,000 15.00%
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 70
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Net operating income is similar to MM approach. In this question we have taxes and hence we should
value unlevered company (company Q) first.
• Value of company P (Levered) = Value of company Q + (Amount of debt x Tax rate)
• Value of company P (Levered) = 20,00,000 + (18,00,000 x 0.5) = Rs.29,00,000
10.50%
Cost of debt NA [15% x 70%]
21.98%
Cost of equity 21.00% [4,72,500/21,50,000]
19.81%
Cost of capital 21.00% [7,50,000 x 70%]/26,50,000
Comments:
• WACC of the company reduces from 21% to 19.81%. Improvement in WACC is due to higher
valuation of firm post restructuring. Value of RES Limited improves due to tax benefit on interest
payment of perpetual debt
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 71
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
It is expected that for debt financing upto 30%, the rate of interest will be 10% and equity capitalization rate
will increase to 17%. If the company opts for 50% debt, then the interest rate will be 12% and equity
capitalization rate will be 20%.
You are required to compute value of the company; its overall cost of capital under different options and also
state which is the best option.
Answer:
Particulars Existing 30% buyback 50% buyback
EBIT 4,00,000 4,00,000 4,00,000
-60,000 -1,20,000
Less: Interest - [6,00,000 x 10%] [10,00,000 x 12%]
EBT 4,00,000 3,40,000 2,80,000
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 72
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 6: FINANCING DECISIONS – LEVERAGES
Format for calculation of leverages:
Particulars Amount
Sales XXX
Less: Variable costs (XXX)
Contribution XXX
Less: Fixed Costs (XXX)
Earnings before interest and tax (EBIT) XXX
Less: Interest (XXX)
Earnings before Tax (EBT) XXX
Less: Tax (XXX)
Earnings after Tax (EAT) XXX
Less: Preference Dividend (XXX)
Earnings available to equity shareholders (EAES) XXX
No of equity shares XXX
Earnings Per share (EPS) [EAES / No of shares] XXX
Formulae:
Type of Leverage Formula
Operating Leverage Contribution % Change in EBIT
(or)
EBIT % change in Sales
Financial Leverage EBIT % Change in EPS
(or)
PD % change in EBIT
EBT −
1 − Tax rate
Combined Leverage Contribution % Change in EPS
(or) (or) OL x FL
PD % change in sales
EBT −
1 − Tax rate
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 73
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
RST Limited 25% 32% 1.2800
TUV Limited 23% 36% 1.5652
WXY Limited 21% 40% 1.9048
• Operating income refers to EBIT. Operating leverage = Change in EBIT/Change in sales
Comments:
High operating leverage leads to high Beta. So when Operating leverage is lowest, Beta is minimum at 1 time
and when operating leverage is maximum (1.9048), beta is highest at 1.40 Times
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 74
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Sales 3,40,000
Operating expenses (including Rs.60,000 depreciation) 1,20,000
EBIT 2,20,000
Less: Interest 60,000
EBT 1,60,000
Less: Taxes 56,000
EAT 1,04,000
a. Determine the degree of operating, financial and combined leverages at the current sales level, if all
operating expenses, other than depreciation, are variable costs.
b. If total assets remain at the same level, but sales (i) increase by 20 percent and (ii) decrease by 20 percent,
what will be the EPS at the new sales level.
Answer:
WN 1: Computation of leverages:
Particulars Amount
Sales 3,40,000
Less: Variable cost -60,000
Contribution 2,80,000
Less: Fixed cost -60,000
EBIT 2,20,000
Less: Interest -60,000
EBT 1,60,000
Less: Tax @ 35% -56,000
EAT 1,04,000
Less: PD 0
EAES 1,04,000
No of shares 80,000
EPS 1.30
Contribution 2,80,000
Operating leverage = = = 1.27 Times
EBIT 2,20,000
EBIT 2,20,000
Financial leverage = = = 1.375 Times
PD
EBT − ( ) 1,60,000 − 0
1 − Tax rate
Contribution 2,80,000
Combined leverage = = = 1.75 Times
PD
EBT − ( ) 1,60,000 − 0
1 − Tax rate
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 75
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
WN 1: Income statement:
Particulars Amount
Sales 90,00,000
Less: Variable cost -54,00,000
Contribution 36,00,000
Less: Fixed cost -10,00,000
EBIT 26,00,000
Less: Interest -4,80,000
EBT 21,20,000
Less: Tax @ 30% -6,36,000
EAT 14,84,000
Less: PD -
EAES 14,84,000
No of shares 4,00,000
EPS 3.71
WN 2: Solution:
Note 1: Computation of leverages:
Contribution 36,00,000
Operating leverage = = = 1.3846 Times
EBIT 26,00,000
EBIT 26,00,000
Financial leverage = = = 1.2264 Times
PD 21,20,000 −0
EBT − ( )
1 − Tax rate
Contribution 36,00,000
Combined leverage = = = 1.6981 Times
PD
EBT − ( ) 21,20,000 − 0
1 − Tax rate
Note 2: EPS:
• EPS = 3.71 Times
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 76
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Contribution 10,50,000
Less: Fixed cost (b/f) -3,00,000
EBIT [Note 1] 7,50,000
Less: Interest (b/f) -1,50,000
EBT [Note 2] 6,00,000
Verification:
Particulars Amount
Sales [15,00,000 + 15%] 17,25,000
Less: Variable cost [Sales x 30%] -5,17,500
Contribution 12,07,500
Less: Fixed cost -3,00,000
EBIT 9,07,500
Less: Interest -1,50,000
EBT 7,57,500
Old EBT 6,00,000
% increase in EBT [1,57,500/6,00,000] 26.25
Verification:
Particulars Amount
Sales [15,00,000 - 10%] 13,50,000
Less: Variable cost [Sales x 30%] -4,05,000
Contribution 9,45,000
Less: Fixed cost -3,00,000
EBIT 6,45,000
Old EBIT 7,50,000
% fall [1,05,000/7,50,000 x 100] 14.00
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 77
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• EBIT will increase by 15% and hence taxable income will increase by18.75% [15 x 1.25]
Verification:
Particulars Amount
EBIT [7,50,000 + 15%] 8,62,500
Less: Interest -1,50,000
EBT 7,12,500
Old EBT 6,00,000
% increase in EBT [1,12,500/6,00,000] 18.75
WN 2: Analysis of ROE:
Particulars Calculation Amount
ROCE EBIT x (1 − Tax) 360x0.6 12.00%
=
Capital employed 1,000 + 200 + 600
ROE EAES 136 13.60%
=
Amount of equity 1,000
Note:
• The company is earning return of 12% on capital employed. However, equity shareholders earn rate
of return of 13.60%.
• Excess return earned by equity shareholders could be because the company is paying lower return
to debt and preference shareholders
Type of Amount of Return eligible @ Actual Return Excess/lower
capital capital 12% paid return
Debt 600 72 54 -18
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 78
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
[90 x 60%]
Preference 200 24 26 2
Equity 1,000 120 136 16
• Debenture holders should have been paid a return of 12% as the company is having ROCE of 12%.
They are eligible to get return of Rs.72 lacs. However, they have been paid after-tax interest of Rs.54
lacs (90 lacs x 60%). Hence, we have paid Rs.18 lacs less to debenture holders and the same would be
given to equity shareholders
• Preference holders should have been paid a return of 12% as the company is having ROCE of 12%.
They are eligible to get return of Rs.24 lacs. However, they have been paid preference dividend of
Rs.26 lacs. Hence, we have paid Rs.2 lacs excess to equity shareholders and the same would be
compensated by equity shareholders
• Return to equity shareholders = 120 lacs (1,000 x 12%) + 18 lacs – 2 lacs = Rs.136 lacs
• ROE segments:
o Company’s ROCE = 12%
o Excess return due to lower payment to debenture holders = (18/1,000) x 100 = 1.80%
o Lower return due to higher payment to preference = (2/1,000) x 100 = -0.20%
o Final ROE = 12% + 1.80% - 0.20% = 13.60%
WN 2: Solution:
Note 1: Computation of financial leverage:
EBIT 5,10,000
Financial leverage = = = 2 Times
PD
EBT − ( ) 2,55,000
1 − Tax
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 80
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Hence, Combined Leverage measures percentage change in EBT for percentage change in sales in
this question
Particulars Amount
Target EBT 0
% fall in EBT 100%
Combined leverage 2.80
% fall in sales (100/2.80) 35.7142857
Sales at zero EBT (30,00,000 – 35.7142857%) 19,28,571
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 81
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Industry is operating at capital turnover ratio of 3 times whereas the firm operates at capital turnover
of 0.75 Times. This would mean that firm has low capital turnover ratio.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 82
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Sales 91,000 1,05,000
Less: Variable cost -56,000 -63,000
Contribution 35,000 42,000
Less: Fixed cost -20,000 -31,500
EBIT 15,000 10,500
Less: Interest -12,000 -9,000
EBT 3,000 1,500
Less: Tax -900 -450
EAT 2,100 1,050
WN 2: Analysis of Company A:
Note 1: Computation of EBIT:
• Let us assume EBIT of company A to be X
• EBT = X – 12,000
EBIT X
Financial leverage = ;5 = ; 5X − 60,000 = X; 4X = 60,000; X = 15,000
EBT X − 12,000
WN 3: Analysis of Company B:
Note 1: Computation of EBIT:
Contribution 42,000 42,000
Operating leverage = ;4 = ; EBIT = = Rs. 10,500
EBIT EBIT 4
WN 2: Solution:
Contribution 10,73,100
(i)Operating leverage = = = 1.48 Times
EBIT 7,25,100
Contribution 10,73,100
(ii)Combined leverage = = = 2.06 Times
PD
EBT − ( ) 5,21,600 − 0
1 − Tax
(iii)EPS = Rs. 1.36
EPS 1.36
(iv)Earnings Yield = x 100 = x100 = 6.80%
MPS 20
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 84
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Variable cost ratio 66.66666% 75.00% 50.00%
Profit volume ratio (100 – VCR) 33.33333% 25.00% 50.00%
Contribution 1,200 2,000 6,000
Sales (Contribution/PVR) 3,600 8,000 12,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 86
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 7: INVESTMENT DECISIONS
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 87
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Add: Depreciation XXX
Cash flow after tax (CFAT) XXX
Add/Less: Increase/decrease in Working capital XXX
Less: Purchase of additional machinery / payment for original machine (XXX)
Revised CFAT XXX
Net salvage value (Sale value + Tax saved – Tax Paid) XXX
Step 4: Consolidate the cash flows in the below format and calculate appropriate technique (assuming life
of 5 years):
Year Cash flow
0 Step 1
1 Step 2
2 Step 2
3 Step 2
4 Step 2
5 Step 2 + Step 3
Payback:
Meaning Payback refer to the time period in which initial investment in the project will be recovered
Formula Base year + (Unrecovered cash flow of base year / Cash flow of next year)
Note: Base year refer to the last year in which cumulative cash flow is negative
Format Year Cash flow Cumulative cash flow
0 Outflow
1 Inflow
2 Inflow
3 Inflow
Payback reciprocal:
Payback reciprocal = (Average annual cash inflow / Initial investment)
Discounted Payback:
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 88
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Meaning Discounted payback refer to the time period in which initial investment in the project will be
recovered considering time value of money
Formula Base year + (Unrecovered discounted cash flow of base year / Discounted cash flow of nest
year)
Note: Base year refer to the last year in which cumulative cash flow is negative
Format Year Cash flow PVF DCF Cumulative DCF
0 Outflow
1 Inflow
2 Inflow
3 Inflow
Profitability Index:
Meaning This measure the ratio of benefits (PV of cash inflows) to costs (PV of cash outflows)
Formula PV of cash inflows
PV of cash outflows
Format Year Cash flow PVF Discounted Cash Flow
0
1
2
3
Capital Rationing:
Meaning The term capital rationing means money in short supply. Shorty supply means the
money is less than demand for money
Types Divisible Projects and indivisible projects
Divisible ❖ Step 1: Identify acceptable projects – Only those projects which has positive NPV is
Projects to be accepted
❖ Step 2: Identify whether capital rationing exist – Capital rationing exists when the
money available is not sufficient to take up all the acceptable projects
❖ Step 3: Rank the projects in the order of NPV/Initial outflow
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 89
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
❖ Step 4:
o Allot money to projects in the order of rank
o If money is not available to undertake a project, part of the project should be
undertaken
❖ Step 5: Compute aggregate NPV of selected projects
Indivisible ❖ Step 1: Identify acceptable projects – Only those projects which has positive NPV is
Projects to be accepted
❖ Step 2: Identify whether capital rationing exist – Capital rationing exists when the
money available is not sufficient to take up all the acceptable projects
❖ Step 3: Rank the projects in the order of NPV/Initial outflow
❖ Step 4: Identify the various feasible combinations and compute the aggregate NPV
❖ Step 5: Select the combination which has the highest aggregate NPV
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 90
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
A Ltd. is considering the purchase of a machine which will perform some operations which are at present
performed by workers. Machines X and Y are alternative models. The following details are available:
Particulars Machine X Machine Y
Cost of machine 1,50,000 2,40,000
Estimated life of machine 5 years 6 years
Estimated cost of maintenance p.a. 7,000 11,000
Estimated cost of indirect material p.a. 6,000 8,000
Estimated savings in scrap p.a. 10,000 15,000
Estimated cost of supervision p.a. 12,000 16,000
Estimated savings in wages p.a. 90,000 1,20,000
Depreciation will be charged on straight line basis. The tax rate is 30%. Evaluate the alternatives according
to:
(i) Average rate of return method, and
(ii) Present value index method assuming cost of capital being 10%.
(The present value of Rs. 1.00 @ 10% p.a. for 5 years is 3.79 and for 6 years is 4.354)
Answer:
WN 1: Computation of cash flows:
Particulars Machine X Machine Y
Revenue/cost reduction
Savings in scrap 10,000 15,000
Savings in wages 90,000 1,20,000
Less: Maintenance cost (7,000) (11,000)
Less: Indirect material (6,000) (8,000)
Less: Supervision (12,000) (16,000)
Profit before Depreciation and Tax (PBDT) 75,000 1,00,000
Less: Depreciation (30,000) (40,000)
Profit before tax (PBT) 45,000 60,000
Less: Tax @ 30% (13,500) (18,000)
Profit after tax (PAT) 31,500 42,000
Add: Depreciation 30,000 40,000
Cash flow after taxes (CFAT) 61,500 82,000
𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐏𝐀𝐓
𝐀𝐑𝐑 𝐨𝐧 𝐚𝐯𝐞𝐫𝐚𝐠𝐞 𝐢𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭 = 𝐱 𝟏𝟎𝟎
𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐢𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭
31,500
ARR of Machine X = x 100 = 42.00%
75,000
42,000
ARR of Machine Y = x 100 = 35.00%
1,20,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 91
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
𝐏𝐕 𝐨𝐟 𝐢𝐧𝐟𝐥𝐨𝐰𝐬 𝟐, 𝟑𝟑, 𝟎𝟖𝟓
𝐏𝐫𝐨𝐟𝐢𝐭𝐚𝐛𝐢𝐥𝐢𝐭𝐲 𝐈𝐧𝐝𝐞𝐱 (𝐢𝐧 %) = 𝐱 𝟏𝟎𝟎 = 𝐱 𝟏𝟎𝟎 = 𝟏𝟓𝟓. 𝟑𝟗%
𝐏𝐕 𝐨𝐟 𝐨𝐮𝐭𝐟𝐥𝐨𝐰𝐬 𝟏, 𝟓𝟎, 𝟎𝟎𝟎
𝐏𝐕 𝐨𝐟 𝐢𝐧𝐟𝐥𝐨𝐰𝐬 𝟐, 𝟑𝟑, 𝟎𝟖𝟓
𝐏𝐫𝐨𝐟𝐢𝐭𝐚𝐛𝐢𝐥𝐢𝐭𝐲 𝐈𝐧𝐝𝐞𝐱 (𝐢𝐧 𝐓𝐢𝐦𝐞𝐬) = = = 𝟏. 𝟓𝟓 𝐓𝐢𝐦𝐞𝐬
𝐏𝐕 𝐨𝐟 𝐨𝐮𝐭𝐟𝐥𝐨𝐰𝐬 𝟏, 𝟓𝟎, 𝟎𝟎𝟎
WN 2: Analysis of Machine I
Year CF CCF PVF @ 8% DCF CDCF Depreciation PAT
0 -10,00,000 -10,00,000 1.000 -10,00,000 -10,00,000
1 3,01,500 -6,98,500 0.926 2,79,189 -7,20,811 2,00,000 1,01,500
2 3,01,500 -3,97,000 0.857 2,58,386 -4,62,425 2,00,000 1,01,500
3 3,01,500 -95,500 0.794 2,39,391 -2,23,034 2,00,000 1,01,500
4 3,01,500 2,06,000 0.735 2,21,603 -1,431 2,00,000 1,01,500
5 3,01,500 5,07,500 0.681 2,05,322 2,03,891 2,00,000 1,01,500
• CCF = Cumulative values of Cash flow column
• DCF = CF x PVF
• CDCF = Cumulative values of DCF column
• PAT = Cash flow - Depreciation
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 92
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Payback Unrecovered cash flow of Base year 3.32 years (or)
Base year +
Cash flow of next year 3 years and 4 months
95,500
=3+ = 3 + 0.32
3,01,500
Discounted Unrecovered discounted cash flow of Base year 4.01 years
Base year +
Payback Discounted flow of next year
1,431
=4+ = 4 + 0.01
2,05,322
ARR on Average PAT 1,01,500 10.15%
x 100 = x 100
initial Initial investment 10,00,000
investment
ARR on Average PAT 1,01,500 20.30%
x 100 = x 100
average Average investment 10,00,000 + 0
investment 2
1,01,500
= x 100
5,00,000
NPV = PV of inflows – PV of outflow Rs.2,03,891
= 12,03,891 – 10,00,000
Profitability PV of inflows 12,03,891 120.39%
x 100 = x 100
Index (in %) PV of outflows 10,00,000
Profitability PV of inflows 12,03,891 1.20 Times
=
Index (in PV of outflows 10,00,000
Times)
WN 3: Analysis of Machine II
Year CF CCF PVF @ 8% DCF CDCF Depreciation PAT
0 -15,00,000 -15,00,000 1.000 -15,00,000 -15,00,000
1 4,08,500 -10,91,500 0.926 3,78,271 -11,21,729 3,00,000 1,08,500
2 4,08,500 -6,83,000 0.857 3,50,085 -7,71,644 3,00,000 1,08,500
3 4,08,500 -2,74,500 0.794 3,24,349 -4,47,295 3,00,000 1,08,500
4 4,08,500 1,34,000 0.735 3,00,248 -1,47,047 3,00,000 1,08,500
5 4,08,500 5,42,500 0.681 2,78,189 1,31,142 3,00,000 1,08,500
𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐏𝐀𝐓
𝐀𝐑𝐑 𝐨𝐧 𝐚𝐯𝐞𝐫𝐚𝐠𝐞 𝐢𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭 = 𝐱 𝟏𝟎𝟎
𝐀𝐯𝐞𝐫𝐚𝐠𝐞 𝐢𝐧𝐯𝐞𝐬𝐭𝐦𝐞𝐧𝐭
39,000
ARR of Project A = x 100 = 57.78%
67,500
38,400
ARR of Project B = x 100 = 32.00%
1,20,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 95
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
4 84,000 0.552 46,368
5 84,000 0.476 39,984
NPV 58,254
• NPV = Present value of inflows – Present value of outflows
• NPV = 1,93,254 – 1,35,000 = Rs.58,254
WN 9: Selection of project:
Particulars Project A Project B Choice
Payback 2 years & 10 months 3 years A
Discounted Payback 3 years & 7 months 4 years & 2 months A
ARR on initial investment 28.89% 16.00% A
ARR on average investment 57.78% 32.00% A
NPV 58,254 34,812 A
Profitability Index 1.43 Times 1.15 Times A
• Company should go ahead with project A
WN 2: Analysis of Project B:
Year CF PVF @ 15% DCF CDCF
0 -5,80,000 1.00 -5,80,000 -5,80,000
1 2,00,000 0.87 1,74,000 -4,06,000
2 2,10,000 0.76 1,59,600 -2,46,400
3 1,80,000 0.66 1,18,800 -1,27,600
4 1,70,000 0.57 96,900 -30,700
5 1,00,000 0.50 50,000 19,300
Note:
• Initial outflow = Purchase price of Rs.5,00,000 – Inflow of Rs.1,00,000 (sale value of old machine) +
Purchase of utilities of Rs.2,00,000 – inflow of Rs.20,000 (sale value of utilities) = Rs.5,80,000
• Year 5 inflow = Rs.40,000 + Rs.60,000 (salvage value) = Rs.1,00,000
Conclusion:
We should go ahead with Project A as it has better NPV and profitability index. Discounted payback for both
projects is almost similar.
Question No.5 [May 2020 MTP, Nov 2018 MTP, Nov 2019 MTP, May 2017]
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 97
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
H Limited is considering a new product line to supplement its range of products. It is anticipated that the
new product line will involve cash investments of Rs.70,00,000 at time 0 and Rs.1,00,00,000 in year 1. Net cash
flow after taxes but before depreciation of Rs.25,00,000 are expected in year 2, Rs.30,00,000 in year 3,
Rs.35,00,000 in year 4 and Rs.40,00,000 each year thereafter through year 10. Although the product line might
be viable after year 10, the company prefers to be conservative and end all calculations at that time.
(a) If the required rate of return is 15 percent, Find out the net present value of the project? Is it
acceptable?
(b) Compute NPV if the required rate of return were 10 percent?
(c) Compute the internal rate of return?
Answer:
Net cash flow after taxes but before depreciation is basically Cash flow after taxes as depreciation is a non-
cash item.
WN 1: Computation of NPV at 15% and 10%
Year CF PVF @ 15% DCF PVF @ 10% DCF
0 -70,00,000 1.000 -70,00,000 1.000 -70,00,000
1 -1,00,00,000 0.870 -87,00,000 0.909 -90,90,000
2 25,00,000 0.756 18,90,000 0.826 20,65,000
3 30,00,000 0.658 19,74,000 0.751 22,53,000
4 35,00,000 0.572 20,02,000 0.683 23,90,500
5 40,00,000 0.497 19,88,000 0.621 24,84,000
6 40,00,000 0.432 17,28,000 0.564 22,56,000
7 40,00,000 0.376 15,04,000 0.513 20,52,000
8 40,00,000 0.327 13,08,000 0.467 18,68,000
9 40,00,000 0.284 11,36,000 0.424 16,96,000
10 40,00,000 0.247 9,88,000 0.386 15,44,000
NPV -11,82,000 25,18,500
Note:
• Project is not acceptable if the required rate of return is 15 percent as NPV is negative
• Project is acceptable if the required rate of return is 10 percent as NPV is positive
WN 2: Computation of IRR:
𝐍𝐏𝐕 𝐚𝐭 𝐋𝟏
𝐈𝐑𝐑 = 𝐋𝟏 + 𝐱 (𝐋𝟐 − 𝐋𝟏 )
𝐍𝐏𝐕 𝐚𝐭 𝐋𝟏 − 𝐍𝐏𝐕 𝐚𝐭 𝐋𝟐
25,18,500
IRR = 10% + x (15% − 10%) = 10% + 3.40% = 13.40%
25,18,500 − (−11,82,000)
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 98
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Initial guess rate 𝟐 8.63 ~ 9%
𝐱 𝟏𝟐. 𝟗𝟒
𝟑
WN 2: Computation of IRR
Let us assume an initial discount rate of 9 percent and compute NPV
Year Cash flow PVF @ 9% DCF PVF @ 11% DCF
0 (1,36,000) 1.000 (1,36,000) 1.000 (1,36,000)
1 30,000 0.917 27,510 0.901 27,030
2 40,000 0.842 33,680 0.812 32,480
3 60,000 0.772 46,320 0.731 43,860
4 30,000 0.708 21,240 0.659 19,770
5 20,000 0.650 13,000 0.593 11,860
NPV 5,750 (1,000)
• NPV is positive at a discount rate of 9 percent. We should increase the discount rate and check
whether we get NPV as zero or NPV become negative
𝐍𝐏𝐕 𝐚𝐭 𝐋𝟏
𝐈𝐑𝐑 = 𝐋𝟏 + 𝐱 (𝐋𝟐 − 𝐋𝟏 )
𝐍𝐏𝐕 𝐚𝐭 𝐋𝟏 − 𝐍𝐏𝐕 𝐚𝐭 𝐋𝟐
5,750
IRR = 9% + x (11% − 9%) = 9% + 1.70% = 𝟏𝟎. 𝟕𝟎%
5,750 − (−1,000)
WN 2: Computation of NPV:
PV of inflows
Profitability index =
PV of outflows
PV of inflows
1.064 = ; 𝐏𝐕 𝐨𝐟 𝐢𝐧𝐟𝐥𝐨𝐰𝐬 = (𝟏, 𝟏𝟒, 𝟐𝟎𝟎 𝐱 𝟏. 𝟎𝟔𝟒) = 𝐑𝐬. 𝟏, 𝟐𝟏, 𝟓𝟎𝟗
1,14,200
𝐍𝐏𝐕 = 𝐏𝐕 𝐨𝐟 𝐢𝐧𝐟𝐥𝐨𝐰 − 𝐏𝐕 𝐨𝐟 𝐨𝐮𝐭𝐟𝐥𝐨𝐰 = 𝟏, 𝟐𝟏, 𝟓𝟎𝟗 − 𝟏, 𝟏𝟒, 𝟐𝟎𝟎 = 𝐑𝐬. 𝟕, 𝟑𝟎𝟗
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 99
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
WN 4: Computation of Payback:
Year Cash flow Cum Cash flow
0 -1,14,200 -1,14,200
1 40,000 -74,200
2 40,000 -34,200
3 40,000 5,800
4 40,000 45,800
𝐔𝐧𝐫𝐞𝐜𝐨𝐯𝐞𝐫𝐞𝐝 𝐜𝐚𝐬𝐡 𝐟𝐥𝐨𝐰 𝐨𝐟 𝐁𝐚𝐬𝐞 𝐘𝐞𝐚𝐫
𝐏𝐚𝐲𝐛𝐚𝐜𝐤 = 𝐁𝐚𝐬𝐞 𝐲𝐞𝐚𝐫 +
𝐂𝐚𝐬𝐡 𝐟𝐥𝐨𝐰 𝐨𝐟 𝐧𝐞𝐱𝐭 𝐲𝐞𝐚𝐫
34,200
Payback = 2 + = 2 + 0.855 = 𝟐. 𝟖𝟓𝟓 𝐲𝐞𝐚𝐫𝐬 (𝐨𝐫)𝟐 𝐲𝐞𝐚𝐫𝐬 𝐚𝐧𝐝 𝟏𝟎 𝐦𝐨𝐧𝐭𝐡𝐬
40,000
WN 3: Terminal flow:
Particulars Amount
Sale value 6,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 100
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Less: Book value (6,000)
Capital gain 0
Tax paid 0
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 101
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Add: Depreciation 15.00 15.00 16.50 16.50 16.50 16.50 16.50 16.50
CFAT 8.50 28.00 85.25 85.25 85.25 58.25 58.25 58.25
Less: Purchase of
additional machine -10.00
Revised CFAT 8.50 18.00 85.25 85.25 85.25 58.25 58.25 58.25
• Depreciation on original equipment (all 8 years) = (120 – 0)/8 = 15 lacs
• Depreciation on additional equipment (3 to 8 years) = (10 – 1)/6 = 1.5 lacs
• Company makes loss in year 1. It is an existing profit-making company and hence would save taxes
due to loss
• Additional machine has been purchased at beginning of year 3. Beginning of year 3 will be taken as
end of year 2 in cash flow analysis. This is because it is generally assumed that cash flows happen at
end of the year
WN 2: In-between flows:
Particulars Existing New
Sales 1,60,00,000 2,00,00,000
Less: Material cost -60,00,000 -63,75,000
Less: Wages and salaries -41,00,000 -37,50,000
Less: Supervision -16,00,000 -25,00,000
Less: Repairs and maintenance -9,00,000 -7,50,000
Less: Power and fuel -12,40,000 -14,25,000
Less: Allocated corporate Overheads - -
PBDT 21,60,000 52,00,000
Less: Depreciation - -11,50,000
PBT 21,60,000 40,50,000
Less: Tax @ 40% -8,64,000 -16,20,000
PAT 12,96,000 24,30,000
Add: Depreciation - 11,50,000
CFAT 12,96,000 35,80,000
Note:
• Allocated corporate overheads are an irrelevant expenditure and hence not considered in cash flow
computation
• Depreciation has been computed as per Income Tax Act and not companies’ books
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 103
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
WN 3: Terminal flow:
Particulars Existing New
NSV of asset in year 5 21,000 2,50,000
Working capital released 0 0
Total terminal flow 21,000 2,50,000
Note: Life of the project increases to 20 years. However, we don’t have information beyond 12 years and
hence the analysis has been restricted to 12 years. Cash flow of year 13 to 20 is indirectly factored in higher
value of asset at end of year 12
WN 4: Computation of NPV:
Year CF PVF @ 12% DCF
0 -2,10,00,000 1.000 -2,10,00,000
1 to 12 33,00,000 6.194 2,04,40,200
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 104
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
12 67,50,000 0.257 17,34,750
NPV 11,74,950
Conclusion: Since the NPV is positive, the improvements produce a satisfactory return to the firm
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 105
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Revenue/cost reduction
Savings in labour cost 8,000
Less: Depreciation (40,000/8 years) (5,000)
Profit before tax (PBT) 3,000
Less: Tax @ 35% (1,050)
Profit after tax (PAT) 1,950
Add: Depreciation 5,000
Cash flow after taxes (CFAT) 6,950
Note:
• Existing cash flows are not relevant for analysis. The only benefit of the machine is cost reduction
and the same has been considered as inflow in our analysis
WN 4: Computation of NPV:
Year Cash flow PVF @ 10% DCF
0 (40,000) 1.000 (40,000)
1 to 8 6,950 5.335 37,078
8 - 0.467 -
NPV (2,922)
Conclusion: Since the NPV is negative, the machine is not to be purchased.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 106
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
6-8 5,00,000
• Income tax is 25%
• Straight line method of depreciation is permissible for tax purpose
• Cost of capital is 10%
• Assume that loss cannot be carried forward
Advise about the project acceptability.
Answer:
WN 1: Initial outflow:
Amount
Particulars (in lacs)
Capital expenditure (240)
Working capital (30)
Initial outflow (270)
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 107
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
3 103.50 0.751 77.73
4 103.50 0.683 70.69
5 103.50 0.621 64.27
6 89.25 0.564 50.34
7 89.25 0.513 45.79
8 119.25 0.467 55.69
NPV 118.83
Conclusion: The company should go ahead with project as it results in positive NPV of Rs.118.83 lacs.
The existing machine was brought 3 years ago for Rs.15,40,000. It was depreciated on straight line basis and
has a remaining useful life of 7 years. Its annual maintenance cost is expected to increase by Rs.40,000 from
the sixth year of its installation. Its present realizable value is Rs.6,50,000.
The purchase price of CNC machine is Rs.27,00,000 and installation expenses of Rs.95,000 will be incurred.
Subsidy equal to 15% of the purchase price will be received at the end of first year of its installation. It is
subject to same rate of depreciation. Its realizable value after 7 years is Rs.5,70,000. With the CNC machine,
annual cash operating costs are expected to decrease by Rs.2,16,000. In addition, CNC machine would
increase productivity on account of which net cash revenue would increase by Rs.2,76,000 per annum.
The tax rate applicable to firm is 30% and cost of capital is 11%.
Required:
Advise the firm whether to replace the existing machine with CNC machine on the basis of net present value
Answer:
WN 1: Initial outflow
Particulars Existing New
NSV of existing machine on day 0 (7,78,400) -
Working capital blocked - -
Capital expenditure - (27,95,000)
Total outflow (7,78,400) (27,95,000)
WN 2: In-between flows:
Existing New
Particulars Year 1 to 2 Year 3 to 7 Year 1 Year 2 to 7
Revenues - - 2,76,000 2,76,000
Saving in operating cost - - 2,16,000 2,16,000
Less: Maintenance cost - -40,000 - -
PBDT - -40,000 4,92,000 4,92,000
Less: Depreciation -1,54,000 -1,54,000 -2,60,000 -2,60,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 108
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
PBT -1,54,000 -1,94,000 2,32,000 2,32,000
Less: Tax @ 30% 46,200 58,200 -69,600 -69,600
PAT -1,07,800 -1,35,800 1,62,400 1,62,400
Add: Depreciation 1,54,000 1,54,000 2,60,000 2,60,000
CFAT 46,200 18,200 4,22,400 4,22,400
Subsidy 4,05,000
Revised CFAT 46,200 18,200 8,27,400 4,22,400
Note:
• Depreciable value of new machine = Original cost + Installation expenses – subsidy – salvage value
= 27,00,000 + 95,000 – 5,70,000 – 4,05,000 = Rs.18,20,000
• Depreciation of new machine = 18,20,000/7 years = Rs.2,60,000
• It is assumed subsidy is adjusted against the cost of the asset
WN 3: Terminal flow:
Particulars Existing New
NSV of asset in year 7 0 5,70,000
Working capital released 0 0
Total terminal flow 0 5,70,000
Conclusion: The company should not ahead with replacement decision as the project generates positive
NPV
You are required to calculate the NPV of the project and advise the management to take appropriate decision.
Also calculate the IRR of the project.
Note: Present values of Re.1 at different rates of interest are as follows:
Year 10% 12% 14% 16% 20%
1 0.91 0.89 0.88 0.86 0.83
2 0.83 0.80 0.77 0.74 0.69
3 0.75 0.71 0.67 0.64 0.58
4 0.68 0.64 0.59 0.55 0.48
5 0.62 0.57 0.52 0.48 0.40
Answer:
WN 1: Initial outflow:
Amount
Particulars (in lacs)
Capital expenditure (800)
Working capital 0
Initial outflow (800)
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 111
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
0 -2,50,000 1.000 -2,50,000
1 1,80,000 0.893 1,60,740
2 2,00,000 0.797 1,59,400
3 2,00,000 0.712 1,42,400
4 2,00,000 0.636 1,27,200
5 1,70,000 0.567 96,390
6 2,00,000 0.507 1,01,400
7 2,00,000 0.452 90,400
8 2,00,000 0.404 80,800
NPV 7,08,730
Conclusion: The company should go ahead with the project as it generates positive NPV.
Note:
• Depreciation is entirely charged in year 1. The company is an existing profit-making company and
hence the loss can be set-off against other existing profits. Therefore, it will save tax of Rs.115 lacs in
year 1.
WN 3: Terminal flow:
Amount
Particulars (in lacs)
Salvage value of land 90.00
Salvage value of power plant 0.00
Recapture of working capital 0.00
Total terminal flow 90.00
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 113
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
The company has an after-tax cost of funds at 10% per annum. The applicable tax rate is 30%. You are required
to determine whether it is advisable to purchase the machine.
Answer:
WN 1: Initial Outflow:
Particulars Amount
Capital expenditure (20,00,000)
Working capital 0
Initial outflow (20,00,000)
WN 4: Computation of NPV:
Year Cash flow PVF @ 10% DCF
0 -20,00,000 1.000 -20,00,000
1 to 10 11,10,000 6.144 68,19,840
10 - 0.386 -
NPV 48,19,840
Conclusion: The company should go ahead with purchase of machine as NPV is positive.
The company has another alternative to buy a new machine at a cost of Rs. 3,50,000 with an economic life of
5 years and salvage value of Rs. 60,000. The new machine is expected to be more efficient in reducing costs
of material handling, labour, maintenance & repairs, etc.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 114
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
WN 2: In-between flows:
Particulars Modernization New machine
Saving in cost 49,500 80,500
[1,20,000 – 70,500] [1,20,000 – 39,500]
Less: Depreciation 22,000 58,000
[1,40,000-30,000]/5 [3,50,000-60,000]/5
PBT 27,500 22,500
Less: Tax @ 50% -13,750 -11,250
PAT 13,750 11,250
Add: Depreciation 22,000 58,000
CFAT 35,750 69,250
WN 3: Terminal flow:
Particulars Modernization New machine
Salvage value 30,000 60,000
Recapture of working capital 0 0
Total terminal flow 30,000 60,000
WN 4: Computation of NPV:
Cash flow DCF
Year Modernization New PVF @ 10% Modernization New
0 -1,40,000 -3,50,000 1.000 -1,40,000 -3,50,000
1 to 5 35,750 69,250 3.790 1,35,493 2,62,458
5 30,000 60,000 0.621 18,630 37,260
NPV 14,123 -50,282
Conclusion: The company should modernize its existing equipment and not buy a new machine because
NPV is positive in modernization of equipment.
Note:
• Depreciation of old machine = 3,75,000/10 = Rs.37,500
• Depreciation of new machine = (5,25,000 – 60,000)/5 = Rs.93,000
• Depreciation is not charged in year of sale and hence the same is not considered
WN 3: Terminal flow:
Particulars Old New
Sale value 0 60,000
Less: Book value (37,500) (93,000)
[one year of depreciation as no depreciation is charged in last year]
Capital loss 37,500 93,000
Tax saved @ 30% 11,250 27,900
Net salvage value {Sale value + Tax saved} 11,250 87,900
• Incremental terminal flow = 87,900 – 11,250 = Rs.76,650
WN 4: Computation of NPV:
Year Cash flow PVF @ 11% DCF
0 -4,05,750 1.000 -4,05,750
1 to 4 1,84,650 3.103 5,72,969
2,44,650
5 [1,68,000 + 76,650] 0.593 1,45,077
NPV of project 3,12,296
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 116
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Comment: It is advisable to replace the existing machine since NPV is positive
WN 1: Computation of PV of outflow:
Machine A:
Year Cash flow PVF @ 9% DCF
0 7,50,000 1.000 7,50,000
1 to 3 2,00,000 2.531 5,06,200
PV of outflow 12,56,200
Machine B:
Year Cash flow PVF @ 9% DCF
0 5,00,000 1.000 5,00,000
1 to 2 3,00,000 1.759 5,27,700
PV of outflow 10,27,700
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 117
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
(a) Advise which brand of X-ray machine should be acquired assuming that the use of machine shall be
continued for a period of 20 years
(b) State which of the option is most economical if machine is likely to be used for a period of 5 years
The cost of capital of BT Labs is 12%
Answer:
WN 1: Evaluation of project if requirement is for 20 years:
Available alternatives:
• Buy Brand XYZ which has a life of 15 years
• Buy Brand ABC which has a life of 10 years
• Take ABC on rent for a period of 10 years
Analysis:
• All three alternative has a life of less than 20 years. We should compute PV of outflow and then
decide alternative on the basis of Equated Annual Cost
Computation of EAC:
Particulars Option 1 Option 2 Option 3
PV of outflow 7,62,927 6,51,786 6,65,188
Life 15 years 10 years 10 years
PVAF [Annuity factor for 12% and Life] 6.811 5.650 5.650
EAC [PV of outflow/PVAF] 1,12,014 1,15,360 1,17,732
Conclusion: Company should buy Brand XYZ as the same has the lowest Equated Annual Cost.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 119
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Project Money invested Balance Money NPV
Beta 6,00,000 2,00,000 1,50,000
20/26 of Gamma 2,00,000 - 44,615
Total NPV 1,94,615
• NPV of Gamma Project = 58,000 x (20/26) = Rs.44,615
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 120
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 8: RISK ANALYSIS IN CAPITAL BUDGETING
Expected Value:
Expected value is the weighted average value with probability of occurrence being the assigned weight
❖ Expected value is a measure of return
Expected Value = ∑P * R
P = Probability of occurrence; R = Return
❖ Other things remaining same, the alternative with higher expected value is to be selected
Standard Deviation:
❖ Standard deviation is the deviation from the mean
❖ It is a measure of risk
SD = √pd2
d = X − (Average of X)
❖ Other things remaining same the alternative with lower standard deviation should be selected
Co-efficient of variation:
❖ Co-efficient of variation measures risk per unit of return
𝐄𝐱𝐩𝐞𝐜𝐭𝐞𝐝 𝐕𝐚𝐥𝐮𝐞
𝐂𝐕 =
𝐒𝐭𝐚𝐧𝐝𝐚𝐫𝐝 𝐃𝐞𝐯𝐢𝐚𝐭𝐢𝐨𝐧
❖ The project with lower CV should be selected
❖ CV forces every decision maker. Aggressive investor would like to select a project with higher return
and conservative investor will like to select a project with lower risk
RADR Approach:
❖ The project with a higher risk will be discounted at a higher rate (RADR). Select the project with
higher risk adjusted NPV
❖ RADR = Risk free rate + Risk Premium
❖ Even for a single project the company can discount the different types of cash flows at different rate.
For instance, certain cash flows like depreciation tax shield, guaranteed salvage value can be
discounted at normal cost of capital and uncertain cash flows like sales, cost structure, salvage value
can be discounted at RADR
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 121
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Scenario Analysis:
❖ Sensitivity analysis is probably the most widely used risk analysis technique, it does have
limitations. Therefore, we need to extend sensitivity analysis to deal with the probability
distributions of the inputs.
❖ In addition, it would be useful to vary more than one variable at a time so we could see the
combined effects of changes in the variables. Scenario analysis provides answer to these situations
of extensions.
❖ This analysis brings in the probabilities of changes in key variables and also allows us to change
more than one variable at a time.
❖ This analysis begins with base case or most likely set of values for the input variables. Then, go for
worst case scenario (low unit sales, low sale price, high variable cost and so on) and best case
scenario. So, in a nutshell Scenario analysis examine the risk of investment, so as to analyse the
impact of alternative combinations of variables, on the project’s NPV (or IRR).
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 122
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
(in ‘000s)
NPV Probability Product Deviation 𝐏𝐝𝟐
Selection of project:
• Project A and B give same amount of NPV. Hence, we can say that we are indifferent between A and
B if return is criteria to select the project
• Project B carries lower risk and hence the investor would prefer Project B if risk is criteria to select
the project
• Considering the above analysis, it is recommended that company goes ahead with Project B.
2. Computation of expected cash flow, standard deviation and co-efficient of variation [Nov 2020,
Nov 2019 MTP]
A Ltd. is considering two mutually exclusive projects X and Y. You have been given below the Net Cash flow
probability distribution of each project:
Project X Project Y
Net cash flow Probability Net cash flow Probability
50,000 0.30 1,30,000 0.20
60,000 0.30 1,10,000 0.30
70,000 0.40 90,000 0.50
Compute the following:
• Expected net cash flow of the project
• Variance of each project
• Standard deviation of each project
• Co-efficient of variation
• Identify which project do you recommend and why
Answer:
WN 1: Analysis of project X:
(in ‘000s)
Cash flow Probability Product Deviation 𝐏𝐝𝟐
50 0.30 15.00 -11.00 36.30
60 0.30 18.00 -1.00 0.30
70 0.40 28.00 9.00 32.40
Total 61.00 69.00
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 123
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
WN 2: Analysis of project Y:
(in ‘000s)
Cash flow Probability Product Deviation 𝐏𝐝 𝟐
Conclusion:
In project X risk per rupee of cash flow is 0.136 (approx.) while in project Y it is 0.15 (approx.). Therefore,
Project X is better than Project Y.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 124
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Total 48.50 185.25
Year 2:
(in lacs)
Cash flow Probability Product Deviation 𝐏𝐝𝟐
Year 3:
(in lacs)
Cash flow Probability Product Deviation 𝐏𝐝𝟐
30 0.3 9.00 -8.50 21.68
40 0.4 16.00 1.50 0.90
45 0.3 13.50 6.50 12.67
Total 38.50 35.25
Expected SD:
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 125
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
SD if cash flows are dependent Sum of DSD Rs.24.89 lacs
SD if cash flows are independent √DSD2 = √237.87 Rs.15.42 lacs
WN 4: Computation of expected cash flow and standard deviation of Project Y for year 1, 2 and 3:
Year 1 to 3:
(in lacs)
Cash flow Probability Product Deviation 𝐏𝐝 𝟐
Expected SD:
SD if cash flows are dependent Sum of DSD Rs.8.70 lacs
SD if cash flows are independent √DSD2 = √25.38 Rs.5.04 lacs
The Company wishes to take into consideration all possible risk factor relating to an airline operations. The
company wants to know:
1. The expected NPV assuming with 6 % risk free rate of interest.
2. The possible deviation in the expected value
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 126
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
a) If the cash flows are independent
b) If the cash flows are dependent
Answer:
WN 1: Computation of expected cash flow and standard deviation of year 1, 2 and 3:
Year 1:
(in lacs)
Cash flow Probability Product Deviation 𝐏𝐝𝟐
Year 2:
(in lacs)
Cash flow Probability Product Deviation 𝐏𝐝𝟐
Year 3:
(in lacs)
Cash flow Probability Product Deviation 𝐏𝐝𝟐
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 127
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
3 27.90 0.840 23.44
Expected NPV 24.98
• Expected NPV = Rs.24,98,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 128
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
WN 3: Solution:
Probable NPV (WN 2) 760
Worst-case NPV (WN 1) -40,180
Best-case NPV (WN 1) 31,700
Probability of worst-case NPV 10%
[Cash flows are dependent]
WN 2: Computation of NPV:
Project 1
Year Cash flow PVF @ 19% DCF
0 -15,00,000 1.000 -15,00,000
1 6,00,000 0.840 5,04,000
2 6,00,000 0.706 4,23,600
3 6,00,000 0.593 3,55,800
4 6,00,000 0.499 2,99,400
Risk-adjusted NPV 82,800
Project 2:
Year Cash flow PVF @ 15% DCF
0 -11,00,000 1.000 -11,00,000
1 6,00,000 0.870 5,22,000
2 4,00,000 0.756 3,02,400
3 5,00,000 0.658 3,29,000
4 2,00,000 0.572 1,14,400
Risk-adjusted NPV 1,67,800
Project 3:
Year Cash flow PVF @ 13% DCF
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 129
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
0 -19,00,000 1.000 -19,00,000
1 4,00,000 0.885 3,54,000
2 6,00,000 0.783 4,69,800
3 8,00,000 0.693 5,54,400
4 12,00,000 0.613 7,35,600
Risk-adjusted NPV 2,13,800
Conclusion:
• The company should go ahead with Project 3 as it has highest risk-adjusted NPV
7. RADR [May 2018 MTP, Nov 2018 MTP, May 2019 RTP, Nov 2019 RTP]
An enterprise is investing Rs.100 lakhs in a project. The risk-free rate of return is 7%. Risk premium expected
by the management is 7%. The life of the project is 5 years. Following are the cash flows that are estimated
over the life of the project.
Year Cash flows (in lacs)
1 25
2 60
3 75
4 80
5 65
Calculate NPV of the project based on risk-free rate and also on the basis of risk adjusted discount rate.
Answer:
WN 1: Computation of NPV based on risk-free rate of 7%:
Year Cash flow PVF @ 7% DCF
(in lacs) (in lacs)
0 -100.00 1.000 -100.00
1 25.00 0.935 23.38
2 60.00 0.873 52.38
3 75.00 0.816 61.20
4 80.00 0.763 61.04
5 65.00 0.713 46.35
NPV 144.34
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 130
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
High 8 10
Demonstrate the acceptability of the project on the basis of risk adjusted rate
Answer:
WN 1: Calculation of risk-adjusted discount rate:
Risk Level Risk free rate (%) Risk Premium (%) Risk-adjusted discount rate (%)
Low 8 4 12
Medium 8 7 15
High 8 10 18
WN 2: Computation of NPV:
Project X:
Year Cash flow PVF @ 16% DCF
0 -21,0,000 1.000 -2,10,000
1 to 5 70,000 3.274 2,29,180
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 131
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Risk-adjusted NPV 19,180
Project Y:
Year Cash flow PVF @ 14% DCF
0 -1,20,000 1.000 -1,20,000
1 to 5 42,000 3.433 1,44,186
Risk-adjusted NPV 24,186
Project Z:
Year Cash flow PVF @ 12% DCF
0 -1,00,000 1.000 -1,00,000
1 to 5 30,000 3.605 1,08,150
Risk-adjusted NPV 8,150
Change 5,86,40,000
Sensitivity % = 𝑥 100 = 𝑥100 = 48.87%
Base 12,00,00,000
• Base represents current plant cost of Rs.12,00,00,000
Running cost:
• The project will have zero NPV if the PV of running cost increases by Rs.5,86,40,000 (amount of
NPV). This is because any increase in increase in running cost will reduce NPV and finally it will
become zero
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 133
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Change 5,86,40,000
Sensitivity % = 𝑥 100 = 𝑥100 = 49.61%
Base 11,81,90,000
• Base represents current running cost of Rs.11,81,90,000
Savings:
• The project will have zero NPV if the PV of savings decline by Rs.5,86,40,000 (amount of NPV).
This is because any decline in savings will reduce NPV and finally it will become zero
Change 5,86,40,000
Sensitivity % = 𝑥 100 = 𝑥100 = 19.75%
Base 29,68,30,000
• Base represents current savings cost of Rs.29,68,30,000
Conclusion: Project is most sensitive to savings factor as only a change beyond 19.75% in savings makes
the project unacceptable.
WN 2: In-between flows:
(in lacs)
Particulars Year 1 Year 2 Year 3 Year 4 Year 5
Units sold 10.00 10.00 10.00 10.00 10.00
Contribution per unit [500-250] 250.00 250.00 250.00 250.00 250.00
Total Contribution 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00
Less: Fixed cost -300.00 -300.00 -300.00 -300.00 -300.00
PBDT 2,200.00 2,200.00 2,200.00 2,200.00 2,200.00
Less: Depreciation [Note 1] -500.00 -375.00 -281.25 -210.94 -158.20
PBT 1,700.00 1,825.00 1,918.75 1,989.06 2,041.80
Less: Tax @ 35% -595.00 -638.75 -671.56 -696.17 -714.63
PAT 1,105.00 1,186.25 1,247.19 1,292.89 1,327.17
Add: Depreciation 500.00 375.00 281.25 210.94 158.20
CFAT 1,605.00 1,561.25 1,528.44 1,503.83 1,485.37
WN 3: Terminal flow:
Amount
Particulars (in lacs)
Salvage value 474.61
Working capital 800.00
Total terminal flow 1,274.61
WN 4: Computation of NPV:
(in lacs)
Year Cash flow PVF @ 15% DCF
0 -2,800.00 1.000 -2,800.00
1 1,605.00 0.869 1,394.74
2 1,561.25 0.756 1,180.31
3 1,528.44 0.657 1,004.18
4 1,503.83 0.571 858.68
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 135
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
5 2,759.98 0.497 1,371.71
Amount of NPV 3,009.62
The NPV of the project is positive, hence, the project is viable.
Computation of NPV:
Year Cash flow PVF @ 15% DCF
0 -2,800.00 1 -2,800.00
1 1,280.00 0.869 1,112.32
2 1,236.25 0.756 934.61
3 1,203.44 0.657 790.66
4 1,178.83 0.571 673.11
5 2,434.98 0.497 1,210.19
Amount of NPV 1,920.89
• NPV of the project has reduced from Rs.3,009.62 lacs to Rs.1,920.89 lacs
• Fall in NPV = 3009.62 lacs – 1,920.89 lacs = 1,083.73 lacs
• % fall in NPV = (1,083.73/3,009.62) x 100 = 36%
WN 2: In-between flows:
(in lacs)
Particulars Year 1 Year 2 Year 3 Year 4 Year 5
Units sold 10.00 10.00 10.00 10.00 10.00
Contribution per unit [500-250] 250.00 250.00 250.00 250.00 250.00
Total Contribution 2,500.00 2,500.00 2,500.00 2,500.00 2,500.00
Less: Fixed cost -300.00 -300.00 -300.00 -300.00 -300.00
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 136
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
PBDT 2,200.00 2,200.00 2,200.00 2,200.00 2,200.00
Less: Depreciation [Note 1] -550.00 -412.50 -309.38 -232.04 -174.03
PBT 1,650.00 1,787.50 1,890.62 1,967.96 2,025.97
Less: Tax @ 35% -577.50 -625.63 -661.72 -688.79 -709.09
PAT 1,072.50 1,161.87 1,228.90 1,279.17 1,316.88
Add: Depreciation 550.00 412.50 309.38 232.04 174.03
CFAT 1,622.50 1,574.37 1,538.28 1,511.21 1,490.91
WN 3: Terminal flow:
Amount
Particulars (in lacs)
Net Salvage value (Note 1) 491.22
Working capital 800.00
Total terminal flow 1,291.22
WN 4: Computation of NPV:
(in lacs)
Year Cash flow PVF @ 15% DCF
0 -3,000.00 1.000 -3,000.00
1 1,622.50 0.869 1,409.95
2 1,574.37 0.756 1,190.22
3 1,538.28 0.657 1,010.65
4 1,511.21 0.571 862.90
5 2,782.13 0.497 1,382.72
Amount of NPV 2,856.44
• NPV of the project has reduced from Rs.3,009.62 lacs to Rs.2,856.44 lacs
• Fall in NPV = 3009.62 lacs – 2,856.44 lacs = 153.18 lacs
• % fall in NPV = (153.18/3,009.62) x 100 = 5.09%
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 137
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Fixed costs per year Rs.50 Crores
Discount rate 6%
❖ Calculate NPV of the Project
❖ Find the impact on the project’s NPV of a 2.5 percent adverse variance in each variable. Which
variable is having maximum effect
Answer:
WN 1: Computation of base NPV:
Part 1: Computation of cash flows:
Particulars Amount
(in cr)
Units sold 5.00
Selling price 100.00
Sales (A) 500.00
Variable cost per unit 50.00
Total variable cost (B) 250.00
Total Fixed cost (C) 50.00
Profit/Cash flow (A – B – C) 200.00
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 138
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
[Old NPV – New
NPV]
% Change in NPV 3.41 7.39 14.78 7.39 1.48 0.82
Conclusion:
• The project is most sensitive to selling price as 2.5 percent change in SP will impact NPV by 14.78%
Note:
Sensitivity analysis of discount rate:
• The current discount rate of the project is 6%. There is going to be an adverse variation of 2.5% in
discount rate.
• New discount rate = 6 + (6 x 2.5%) = (6 + 0.15) = 6.15%
• PVAF for 4 years at 6.15% = 3.453
WN 2: Scenario Analysis:
• It is given that most likely scenario will happen. However, there is uncertainty about third year and
for that year we are going to assume worst case scenario
Year Cash flow PVF @ 9% DCF
0 -14,00,000 1.000 -14,00,000
1 5,50,000 0.917 5,04,350
2 4,50,000 0.842 3,78,900
3 7,00,000 0.772 5,40,400
Expected NPV 23,650
Kanoria Enterprises wishes to evaluate two mutually exclusive projects X and Y. The particulars are as under:
Particulars Project X Project Y
Initial investment 1,20,000 1,20,000
Estimated cash inflows (per annum for 8 years)
Pessimistic 26,000 12,000
Most likely 28,000 28,000
Optimistic 36,000 52,000
The cut-off rate is 14%. Advise management about the acceptability of projects X and Y.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 139
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Answer:
Computation of NPV of Project X and Project Y for different scenarios:
Project X:
Year Cash flow PVF DCF
Pessimistic Most Likely Optimistic @ 14% Pessimistic Most Likely Optimistic
0 -1,20,000 -1,20,000 -1,20,000 1.000 -1,20,000 -1,20,000 -1,20,000
1 to 8 26,000 28,000 36,000 4.639 1,20,614 1,29,892 1,67,004
Expected NPV 614 9,892 47,004
Project Y:
Year Cash flow PVF DCF
Pessimistic Most Likely Optimistic @ 14% Pessimistic Most Likely Optimistic
0 -1,20,000 -1,20,000 -1,20,000 1.000 -1,20,000 -1,20,000 -1,20,000
1 to 8 12,000 28,000 52,000 4.639 55,668 1,29,892 2,41,228
Expected NPV -64,332 9,892 1,21,228
Conclusion:
In pessimistic situation project X will be better as it gives low but positive NPV whereas project Y yield highly
negative NPV under this situation. In most likely situation both the project will give same result. However,
in optimistic situation project Y will be better as it gives very high NPV. So project X is a risk less project as
it gives positive NPV in all situations whereas project Y is a risky project as it will result into negative NPV
in pessimistic situation and highly positive NPV in optimistic situation. So acceptability of project will largely
depend on the risk taking capacity (risk seeking/risk aversion) of the management.
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 140
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 9: DIVIDEND DECISIONS
MM Approach:
❖ Market value of equity shares of its firm depends solely on its earning power and is not influence
by the manner in which its earnings are split between dividends and retained earnings. Market value
of equity shares is not affected by dividend size.
((n + m)P1 ) − I1 + X1
nP0 =
1 + Ke
Where:
P0 = CMP; n = Present no. of shares; P1 = Year end MP
m = Additional shares issues at year end market price to finance capex
I1 = Investment made at year end; X1 = Earnings of year 1
Ke = Cost of equity
Note: The market capitalization is not affected whereas market price does change
Steps:
Description Formula
Step 1: Compute year-end MP P1 = P0 * (1 + Ke) – D1
Step 2: Compute money available as retained earnings Retained earnings = PAT – Equity dividend
Step 3: Compute money to be raised at year end Fresh equity = Investment in Y1 – Step 2
Walter’s Model:
The market price of a share is the present value of infinite cash flows of
❖ Constant dividend
❖ Capital gain
r
D ( ) x (E − D)
Ke
P0 = ( ) +
Ke Ke
Where:
P0 = Current Market Price; D = Dividend per share
E = Earnings per share; r = Rate of return ; K e = Cost of equity
THE COST OF EQUITY AT TIMES IS EXPRESSED AS THE INVERSE OF PE RATIO AND THIS
WOULD MEAN THAT ALL EARNINGS ARE DISTRIBUTED AND THAT THERE IS NO GROWTH
IN DIVIDEND
1 EPS
Ke = (or)
PE Multiple MPS
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 141
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
P0 = Current Market Price; D1 = Dividend of next year Ke = Cost of equity;
G = Growth rate in dividend
Growth rate = Retention ratio x Return on equity
Lintner’s approach:
Dividend amount under this model is calculated as follows:
D1 = D0 + [ (EPS * Target Payout) – D0 ] * AF
Steps:
❖ Step 1: Find tentative DPS using CY EPS and target DPO
❖ Step 2: Find tentative increase in EPS
❖ Step 3: Actual increase = Step 2 * Adjustment Factor
❖ Step 4: Current year dividend = Last year dividend + Step 3
Dividend is declared:
P1 = P0 x (1 + Ke ) − D1 = 100 x (1 + 9.6%) − 6.40 = Rs. 125.12
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 142
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
year. The capitalization rate for the risk class of which the company belongs is 12%. What will be the
market price of the share at the end of the year, if
❖ a dividend is not declared ?
❖ a dividend is declared ?
❖ assuming that the company pays the dividend and has net profits of Rs.5,00,000 and makes
new investments of Rs.10,00,000 during the period, how many new shares must be issued? Use
the MM model?
❖ Prove that the value of the firm does not get affected by the dividend decision?
Answer:
WN 1: Computation of market price as per MM Model:
P1 = P0 x (1 + Ke ) − 𝐷1
Dividend is declared:
P1 = P0 x (1 + Ke ) − D1 = 100 x (1 + 12%) − 10 = Rs. 102
Part (i):
Valuation of share as per Walter’s model:
r
D K e x (E − D)
Price = +
Ke Ke
9.25
1.20 x (1.48 − 1.20)
Price = + 4.84 = 24.79 + 11.06 = 𝑅𝑠. 35.85
4.84% 4.84%
Comment on dividend policy:
The firm has a dividend payout of 81.08% (i.e., Rs. 3 crores) out of Profit after tax of Rs. 3.7 crores with
value of the share at Rs. 35.85. The rate of return on investment (r) is 9.25% and it is more than the Ke of
4.84%, therefore, by distributing 81.08% of earnings, the firm is not following an optimal dividend policy.
Part (ii):
Under Walter’s model, when return on investment is more than cost of capital (r > Ke), the market share
price will be maximum if 100% retention policy is followed. So, the optimal payout ratio would be to
pay zero dividend and in such a situation, the market price would be
9.25
0.00 x (1.48 − 0.00)
Price = + 4.84 = 0.00 + 58.44 = 𝑅𝑠. 58.44
4.84% 4.84%
Part (iii):
The P/E ratio at which dividend payout will have no effect on share price is at which the Ke would be
equal to the rate of return (r) of the firm i.e. 9.25%.
D1
Cost of equity = + Growth
P0
(1.20 + 1.75%)
0.0925 = + 0.0175
P0
(1.20 + 1.75%) 1.221
0.075 = ; Po = = Rs. 16.28
P0 0.075
Price of 16.28
PE Multiple = = 11 Times
EPS of 1.48
Therefore, at the P/E ratio of 11, the dividend payout will have no effect on share price.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 144
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
using Walter model?
• DETERMINE the optimum dividend pay-out ratio and the price of the share at such pay-out
• PROVE that the dividend pay-out ratio as determined above in (b) is optimum by using random pay-
out ratio
Answer:
Basic information:
Particulars Amount
Dividend per share ?
Earnings per share 6.00
Return on Equity/Investment 20%
Cost of equity 16%
Part (b):
• Return on equity is 20 percent whereas cost of equity is 16% and hence optimum payout ratio is 0%
• Price of share at 0% payout:
0.20
0 x (6 − 0)
Price = + 0.16 = Rs. 46.875
0.16 0.16
Part (c):
The optimality of the above pay-out ratio can be proved by using 25%, 50%, 75% and 100% as pay- out
ratio:
25% payout 50% payout 75% payout 100% payout
0.20 0.20 0.20 0.20
1.5 x (6 − 1.5) 3.00 0.16 x (6 − 3.00) 4.50 0.16 x (6 − 4.5) 6.00 0.16 x (6 − 6)
0.16
+ + + +
0.16 0.16 0.16 0.16 0.16 0.16 0.16 0.16
Rs.44.53 Rs.42.19 Rs.39.84 Rs.37.50
From the above it can be seen that price of share is maximum when dividend pay-out ratio is ‘zero’ as
determined in (b) above.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 146
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
R = 15% 0.15 0.15 0.15
5 x (10 − 5) 7.5 x (10 − 7.5) 10 x (10 − 10)
0.10 0.10 0.10
+ + +
0.10 0.10 0.10 0.10 0.10 0.10
= 50 + 75 = Rs.125 = 75 + 37.50 = Rs.112.50 = 100 + 0 = Rs.100
R = 10% 0.10 0.10 0.10
5 x (10 − 5) 7.5 x (10 − 7.5) 10 x (10 − 10)
0.10 0.10 0.10
+ + +
0.10 0.10 0.10 0.10 0.10 0.10
= 50 + 50 = Rs.100 = 75 + 25 = Rs.100 = 100 + 0 = Rs.100
R = 5% 0.05 0.05 0.05
5 x (10 − 5) 7.5 x (10 − 7.5) 10 x (10 − 10)
0.10 0.10 0.10
+ + +
0.10 0.10 0.10 0.10 0.10 0.10
= 50 + 25 = Rs.75 = 75 + 12.50 = Rs.87.50 = 100 + 0 = Rs.100
Gordon’s model:
Particulars Amount
Dividend per share (3 x 60%) 1.80
Growth rate (IRR x Retention ratio) 6.00%
Cost of equity 12%
• It is assumed that DPS of Rs.1.80 is D1
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 147
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
D1 1.80 1.80
Price = = = = Rs. 30
K e − G 12% − 6% 6%
D1 2.50 2.50
Price = = = = −250
K e − G 14% − 15% −1%
As per Gordon’s model of Dividend relevance model, the cost of equity should be greater than the growth
rate. In this case, growth rate is higher than cost of equity and hence price cannot be computed as per
Gordon’s model
D1 5.00 5.00
Price = = = = Rs. 125
K e − G 14% − 10% 4%
D1 10.00 10.00
Price = = = = Rs. 71.43
K e − G 14% − 0% 14%
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 148
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Question No.10 – Jan 2021, May 2021 MTP, Nov 2020 RTP
The following information is given for QB Ltd.
Net Profit for the year 30,00,000
12% preference share capital 1,00,00,000
Equity share capital (of Rs.10 each) 15,00,000
Retention ratio 75%
Cost of capital 18%
Internal Rate of Return on investment 22%
Calculate the market price per share using
❖ Gordon’s formula
❖ Walter’s formula
Answer:
Computation of EPS:
Particulars Amount
PAT 30,00,000
Less: Preference Dividend [1,00,00,000 x 12%] -12,00,000
EAES 18,00,000
No of equity shares (15,00,000/10) 1,50,000
Earnings per share [EAES/No of equity shares] 12
Dividend per share [12 x (100% – 75%)] 3
Basic information:
Particulars Amount
Dividend per share 3.00
Earnings per share 12.00
Return on Equity/Investment 22%
Cost of equity 18%
r
D K e x (E − D)
Price = +
Ke Ke
𝟎. 𝟐𝟐
𝟑 𝐱 (𝟏𝟐 − 𝟑)
𝐏𝐫𝐢𝐜𝐞 = + 𝟎. 𝟏𝟖 = 𝟏𝟔. 𝟔𝟕 + 𝟔𝟏. 𝟏𝟏 = 𝟕𝟕. 𝟕𝟖
𝟎. 𝟏𝟖 𝟎. 𝟏𝟖
Gordon’s model:
Particulars Amount
Dividend per share 3.00
Payout ratio (3/12) 25%
Retention ratio (1 – Payout ratio) 75%
Growth rate (IRR x Retention ratio) 16.50%
Cost of equity 18%
• It is assumed that DPS of Rs.3.00 is D1
D1 3.00 3.00
Price = = = = Rs. 200
K e − G 18% − 16.5% 1.50%
WN 2: Rework scenario:
Note 1: Computation of DPS:
• The company will be earning 15% on book equity. Growth rate for revised scenario will be IRR x
Retention ratio = 15% x 60% = 9%
• Growth rate for the original scenario was 11.25%. This is further analyzed below:
Original scenario Analysis:
Growth rate = ROE x Retention ratio
11.25% = 15% x Retention ratio
𝟏𝟏. 𝟐𝟓%
𝐑𝐞𝐭𝐞𝐧𝐭𝐢𝐨𝐧 𝐫𝐚𝐭𝐢𝐨 = = 𝟕𝟓%
𝟏𝟓%
Payout ratio in original scenario = 25%
5.04
EPS = = 20.16
25%
Revised DPS =20.16 x 40% = 8.064
D1 8.064
Cost of equity = + Growth rate = + 0.09 = 0.0368 + 0.09 = 0.1268 (or)12.68%
P0 219
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 150
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CHAPTER 10: MANAGEMENT OF WORKING CAPITAL
Cash
Raw
Debtors
Material
Stock WIP
❖ The various components of working capital is calculated with the help of the following formulae:
Raw Material Storage Period Average stock of Raw Material * 365
Raw material consumed
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 151
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Depreciation XXX NA
Gross Works Cost/ Net Works cost/ Cost of Production/ Cost of XXX XXX
Goods Sold
Add: Other overheads XXX XXX
Cost of sales XXX XXX
Profit XXX NA
Sales XXX XXX
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 153
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
❖ The term “Core Current Assets” was framed by Tandon Committee while explaining the amount of
stock a company can hold in its current assets. Generally, such assets are financed by long term
funds. Sometimes core current assets are also referred to as “Hardcore Working Capital”.
❖ Examples of Core Current Assets are Raw materials, Work in Progress, Finished Goods, Cash in
Hand and at Bank etc.
❖ Examples of Non-Core Assets are natural resources, bonds, options and so on.
Answer:
(a) Computation of operating cycle:
Operating cycle = RM days + WIP days + FG days + Debtor days – Creditor days
Operating cycle = 45 + 20 + 25 + 30 – 60 = 60 days
(b) and (c): Computation of number of operating cycles and amount of working capital requirement:
Particulars Calculation Amount
60 days = 1 operating cycle
Number of operating cycles 360 days = ? operating cycle 6 cycles
OC in days
Annual Cash operating cost x
365
60
Amount of working capital required = 22,50,000 x ( ) Rs.3,75,000
360
Note: It is assumed that company is following cash cost approach for estimating the working capital
requirement.
(e): Increase in working capital requirement due to all purchases being made in cash:
• Revised operating cycle = 45 days + 20 days + 25 days + 30 days – 0 days = 120 days
• Amount of working capital required = 22,50,000 x (120/360) = Rs.7,50,000
• Increase in working capital requirement = 7,50,000 – 3,75,000 = Rs.3,75,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 154
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Raw material 45,000 65,356
Work in process 35,000 51,300
Finished goods 60,181 70,175
Debtors 1,12,123 1,35,000
Creditors 50,079 70,469
Annual purchase of raw material (all credit) 4,00,000
Annual cost of production 7,50,000
Annual cost of goods sold 9,15,000
Annual operating cost 9,50,000
Annual sales (all credit) 11,00,000
You may take one year as equal to 365 days.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 155
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
To opening stock By sales (credit) 20,00,000
Raw material 1,80,000 By closing stock
Work in process 60,000 Raw material 2,00,000
Finished goods 2,60,000 5,00,000 Work in process 1,00,000
To Purchases (Credit) 11,00,000 Finished goods 3,00,000 6,00,000
To wages 3,00,000
To production expenses 2,00,000
To Gross Profit 5,00,000
26,00,000 26,00,000
To Administration expenses 1,75,000 By Gross Profit 5,00,000
To Selling expenses 75,000
To Net profit 2,50,000
5,00,000 5,00,000
The opening and closing balances of debtors were Rs. 1,50,000 and Rs. 2,00,000 respectively whereas opening
and closing creditors were Rs. 2,00,000 and Rs. 2,40,000 respectively.
You are required to ascertain the working capital requirement by operating cycle method.
Answer:
WN 1: Cost Sheet of Beta Limited for the year ended 31 st March 2011
Particulars Amount Amount
Direct Material:
Opening stock of RM 1,80,000
Purchases 11,00,000
Less: Closing stock of RM -2,00,000 10,80,000
Direct Labour 3,00,000
Direct expenses 0
Factory Overheads 2,00,000
Gross works cost 15,80,000
Add: Opening WIP 60,000
Less: Closing WIP -1,00,000
Net works cost 15,40,000
Admin OH relating to production 0
Cost of Production 15,40,000
Add: Opening FG 2,60,000
Less: Closing FG -3,00,000
Cost of Goods sold 15,00,000
General and administrative overheads 1,75,000
Selling and distribution overheads 75,000
Cost of sales 17,50,000
Profit 2,50,000
Sales 20,00,000
• It is assumed that admin overheads is general and administrative overheads
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 156
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
60,000 + 1,00,000
= 2 x 365
15,40,000
Average FG
x 365
Cost of Goods Sold
2,60,000 + 3,00,000
= 2 x 365
FG Days 15,00,000 68.13 days
Average Debtors
x 365
Credit sales
1,50,000 + 2,00,000
= 2 x 365
Debtor days 20,00,000 31.94 days
Average creditors
x 365
Credit Purchases
2,00,000 + 2,40,000
= 2 x 365
Creditor days 11,00,000 73 days
Operating cycle (in days) 64.21+18.96+68.13+31.94-73 110 days
Question No.: 4 (May 2019 RTP, May 2019, May 2020 MTP)
A proforma cost sheet of a Company provides the following data:
Particulars Amount
Raw material cost per unit 117
Direct labour cost per unit 49
Factory overheads cost per unit 98
(includes depreciation of Rs.18 per unit at budgeted level of activity)
Total cost per unit 264
Profit 36
Selling price per unit 300
WN 1: Cost sheet:
Particulars Calculation Amount
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 157
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
RM consumed/purchased 78,000 units x 117 91,26,000
Direct labour 78,000 units x 49 38,22,000
FOH other than depreciation 78,000 units x 80 62,40,000
Depreciation 78,000 units x 18 14,04,000
GWC/NWC/COP/COGS/COS 2,05,92,000
Profit 28,08,000
Sales 78,000 units x 300 2,34,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 158
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Credit allowed by creditors 1 month
• Wages are paid in the next month following the month of accrual.
• In the work-in-progress 50% of wages and overheads are supposed to be conversion costs.
• The ratios of cost to sales price are:
o Raw materials 60%
o Direct wages 10% and
o Overheads 20%.
• Cash is to be held to the extent of 40% of current liabilities and safety margin of 15% will be
maintained.
Calculate amount of working capital required for the company on a cash cost basis.
Answer:
WN 1: Cost sheet:
Particulars Calculation Amount
Material consumed/purchased 54,000 x 200 x 60% 64,80,000
Direct wages 54,000 x 200 x 10% 10,80,000
Factory overheads 54,000 x 200 x 20% 21,60,000
GWC/NWC/COP/COGS/COS 97,20,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 159
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Overall stock of WIP 6,75,000
WN 1: Cost sheet:
Particulars Calculation Amount
RM consumed/purchased 1,44,000 units x 45 64,80,000
Direct labour 1,44,000 units x 20 28,80,000
Factory overheads 1,44,000 units x 40 57,60,000
GWC/NWC/COP/COGS/COS 1,51,20,000
Current Liabilities
Creditors 2
(Based on credit purchases) 9,00,000 x ( ) 1,50,000
12
Outstanding wages 1
(Based on total wages) 7,20,000 x ( ) 60,000
12
Outstanding manufacturing expenses Given 80,000
1
Outstanding admin expenses 2,40,000 x ( ) 20,000
12
Current liabilities (B) 3,10,000
Working capital (A – B) 7,20,000
Add: Safety margin (20%) 7,20,000 x 20% 1,44,000
Final Working Capital 8,64,000
Current Liabilities
Creditors 2
(Based on credit purchases) 9,00,000 x ( ) 1,50,000
12
Outstanding wages 1
(Based on total wages) 7,20,000 x ( ) 60,000
12
Outstanding manufacturing expenses Given 80,000
1
Outstanding admin expenses 2,40,000 x ( ) 20,000
12
Current liabilities (B) 3,10,000
Working capital (A – B) 6,00,000
Add: Safety margin (20%) 6,00,000 x 20% 1,20,000
Final Working Capital 7,20,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 162
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Lag in payment of manufacturing expenses (cash) – 1 month 10,80,000
Lag in payment of administration expenses – 1 month 2,40,000
Sales promotion expenses payable quarterly in advance 1,50,000
Income tax payable in four instalments of which one falls in the next financial year 2,25,000
• Rate of gross profit is 20%.
• Ignore work-in-progress and depreciation.
• The company keeps one month’s stock of raw materials and finished goods (each) and believes in
keeping Rs. 2,50,000 available to it including the overdraft limit of Rs. 75,000 not yet utilized by the
company.
• The management is also of the opinion to make 12% margin for contingencies on computed figure.
You are required to prepare the estimated working capital statement for the next year
Answer:
• It is assumed that the company follows total approach for working capital estimation:
WN 1: Cost sheet of MNP Company Limited:
Particulars Calculation Amount
Direct material 9,00,000
Direct wages 7,20,000
Manufacturing expenses 10,80,000
Other expenses Bal figure 1,80,000
GWC/NWC/COP/COGS 19,20,000 + 9,60,000 28,80,000
Admin expenses 2,40,000
Sales promotion 1,50,000
Cost of sales 32,70,000
Profit Bal figure 2,10,000
Sales 34,80,000
Note:
Note 1: Computation of COGS:
Particulars Domestic Export
Actual Sales 24,00,000 10,80,000
Adjusted sales 12,00,000
(adjusted for discount) 24,00,000 (10,80,000x 100/90)
COGS @ 80% of adjusted sales 19,20,000 9,60,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 163
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
1
Outstanding manufacturing expenses 10,80,000 x ( ) 90,000
12
Outstanding admin expenses 1
2,40,000 x ( ) 20,000
12
1
Income tax payable 2,25,000 x ( ) 56,250
4
Total Current Liabilities (B) 3,46,250
Working capital (A-B) 6,51,250
Add: Contingencies @ 12% 78,150
Final working capital 7,29,400
You are required to estimate the working capital requirement of Electropipes Limited.
Answer:
It is assumed that the company follow cash cost approach for estimation of working capital
WN 1: Cost sheet:
Particulars Calculation Amount
RM consumed/purchased 6,000 units x 80 4,80,000
Direct labour 6,000 units x 20 1,20,000
Factory overheads 6,000 units x 60 3,60,000
GWC/NWC/COP/COGS/COS 9,60,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 166
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Question No.11 [Nov 2020 MTP, May 2018 MTP, Nov 2018 MTP]
Aneja Limited, a newly formed company, has applied to the commercial bank for the first time for
financing its working capital requirements. The following information is available about the projections
for the current year:
Estimated level of activity: 1,04,000 completed units of production plus 4,000 units of work-in- progress.
Based on the above activity, estimated cost per unit is:
Raw material Rs.80 per unit
Direct wages Rs.30 per unit
Overheads (exclusive of depreciation) Rs.60 per unit
Total cost Rs.170 per unit
Selling price Rs.200 per unit
Raw materials in stock: Average 4 weeks consumption, work-in-progress (assume 50% completion
stage in respect of conversion cost) (materials issued at the start of the processing).
Finished goods in stock 8,000 units
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 167
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Stock of FG 13,60,000
Debtors (1,92,00,000 x 8/52) 29,53,846
Cash 25,000
Total Current Assets (A) 55,03,461
Current Liabilities:
Creditors 93,04,615 x (4/52) 7,15,740
Wages payable 31,80,000 x (1.5/52) 91,731
Total current liabilities (B) 8,07,471
Working capital (A-B) 46,95,990
Note:
Computation of RM consumed:
• The company has incurred Rs.8,40,000 as Raw material cost. This cost is incurred only for units
produced
• Let us assume that the company has produced 100 units. 15% of year’s production (in terms of
physical units) is closing WIP. Hence closing WIP is 15 units
• DOC of material for closing WIP = 100%
• Equivalent units produced (for computing RM cost) = 100 units of FG + 15 units of WIP = 115 units
• RM consumed = (8,40,000/100) x 115 = Rs.9,66,000
Closing WIP:
Particulars Equivalent units Value
Materials 15 1,26,000
(8,400 x 15)
Wages and manufacturing expenses 6 37,500
(6,250 x 6)
Total 1,63,500
2 x ( 12 x 2,62,500) x 25
Optimum cash balance = √ = 𝐑𝐬. 𝟒𝟓, 𝟖𝟐𝟔
0.075
Other information:
• Of the sales, 80% is on credit and 20% for cash. 75% of the credit sales are collected within one month
and the balance in two months. There are no bad debt losses
• Purchases amount to 80% of sales and are made on credit and paid for in the month preceding the
sales
• The firm has 10% debentures of Rs.1,20,000. Interest on these has to be paid quarterly in January,
April and so on
• The firm has to make and advance payment of tax of Rs.5,000 in July, 2017
• The firm had a cash balance of Rs.20,000 on April 1, 2017, which is the minimum desired level of cash
balance. Any cash surplus/deficit above/below this level is made up by temporary
investments/liquidation of temporary investments or temporary borrowings at the end of each
month (interest on these to be ignored)
Answer:
Cash budget for six months from April 2007:
Particulars Apr May Jun Jul Aug Sep
Opening cash balance (A) 20,000 20,000 20,000 20,000 20,000 20,000
Add: Receipts
Cash sales 16,000 12,000 16,000 20,000 16,000 12,000
Collections
Feb month sales 24,000
Mar month sales 84,000 28,000
Apr month sales 48,000 16,000
May month sales 36,000 12,000
June month sales 48,000 16,000
July month sales 60,000 20,000
August month sales 48,000
Total receipts (B) 1,24,000 88,000 68,000 80,000 92,000 80,000
Payments
Payment to suppliers
(80% of preceding month sales) 48,000 64,000 80,000 64,000 48,000 80,000
Wages and salaries 9,000 8,000 10,000 10,000 9,000 9,000
Interest on debentures 3,000 3,000
Advance tax 5,000
Total Payments (C) 60,000 72,000 90,000 82,000 57,000 89,000
Closing cash (A+B-C) 84,000 36,000 -2,000 18,000 55,000 11,000
New deposit/liquidation of deposit -64,000 -16,000 22,000 2,000 -35,000 9,000
Revised cash 20,000 20,000 20,000 20,000 20,000 20,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 172
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Prepare a cash budget for the months of January, February and March and calculate the cash balance
at the end of each months in the three months period
• Calculate the forecast current ratio at the end of three months period
Answer:
WN 1: Cash budget for the months of January, February and March:
Particulars Jan Feb Mar
Opening cash balance (A) 35,000 3,57,500 6,87,500
Add: Receipts
Collections (previous month sales) 10,80,000 11,25,000 11,70,000
Long term loan 2,00,000
Total receipts (B) 10,80,000 11,25,000 13,70,000
Payments
Payment to suppliers (units sold x 2 x 500)
(Purchase = One month before sales)
(Payment = after one month and hence payment month equal to
sales month) 5,62,500 5,85,000 6,30,000
Variable Overheads
(Next month sales x 100) 1,95,000 2,10,000 2,25,000
Payment for machinery 3,00,000
Total Payments (C) 7,57,500 7,95,000 11,55,000
Closing cash (A+B-C) 3,57,500 6,87,500 9,02,500
Other information:
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 173
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Of the sales, 80% is on credit and 20% for cash. 75% of the credit sales are collected within one month
and the balance in two months. There are no bad debt losses
• Purchases amount to 80% of sales and are made on credit and paid for in the month preceding the
sales
• The firm has 10% debentures of Rs.1,20,000. Interest on these has to be paid quarterly in January,
April and so on
• The firm has to make and advance payment of tax of Rs.5,000 in July, 2017
• The firm had a cash balance of Rs.20,000 on April 1, 2017, which is the minimum desired level of cash
balance. Any cash surplus/deficit above/below this level is made up by temporary
investments/liquidation of temporary investments or temporary borrowings at the end of each
month (interest on these to be ignored)
Answer:
Cash budget for six months from April 2007:
Particulars Apr May Jun Jul Aug Sep
Opening cash balance (A) 20,000 20,000 20,000 20,000 20,000 20,000
Add: Receipts
Cash sales 16,000 12,000 16,000 20,000 16,000 12,000
Collections
Feb month sales 24,000
Mar month sales 84,000 28,000
Apr month sales 48,000 16,000
May month sales 36,000 12,000
June month sales 48,000 16,000
July month sales 60,000 20,000
August month sales 48,000
Total receipts (B) 1,24,000 88,000 68,000 80,000 92,000 80,000
Payments
Payment to suppliers
(80% of preceding month sales) 48,000 64,000 80,000 64,000 48,000 80,000
Wages and salaries 9,000 8,000 10,000 10,000 9,000 9,000
Interest on debentures 3,000 3,000
Advance tax 5,000
Total Payments (C) 60,000 72,000 90,000 82,000 57,000 89,000
Closing cash (A+B-C) 84,000 36,000 -2,000 18,000 55,000 11,000
New deposit/liquidation of deposit -64,000 -16,000 22,000 2,000 -35,000 9,000
Revised cash 20,000 20,000 20,000 20,000 20,000 20,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 174
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Answer:
Evaluation of credit policy:
(in lacs)
Particulars Present Policy 1 Policy 2 Policy 3 Policy 4
Sales 60.00 65.00 70.00 74.00 75.00
Less: Variable cost (70% of sales) -42.00 -45.50 -49.00 -51.80 -52.50
Less: Fixed cost -8.00 -8.00 -8.00 -8.00 -8.00
Gross Benefit 10.00 11.50 13.00 14.20 14.50
Less: Interest cost (Note 1) -0.70 -1.12 -1.58 -2.08 -2.52
Net Benefit 9.30 10.38 11.42 12.12 11.98
• The company should go ahead with Policy option 3 (Collection period of 50 days) as the same has
highest net benefit.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 175
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
XYZ Corporation is considering relaxing its present credit policy and is in the process of evaluating two
proposed policies. Currently, the firm has annual credit sales of Rs. 50 lakhs and accounts receivable turnover
ratio of 4 times a year. The current level of loss due to bad debts is Rs. 1,50,000. The firm is required to give a
return of 25% on the investment in new accounts receivables. The company’s variable costs are 70% of the
selling price.
Given the following information, which is the better option?
Particulars Present Policy Policy Option I Policy Option II
Annual credit sales 50,00,000 60,00,000 67,50,000
Debtors turnover ratio 4 Times 3 Times 2.4 Times
Loss due to bad debts 1,50,000 3,00,000 4,50,000
Answer:
Evaluation of credit policy:
Particulars Present Option 1 Option 2
Sales 50,00,000 60,00,000 67,50,000
Less: Variable cost (70% of sales) -35,00,000 -42,00,000 -47,25,000
Less: Fixed cost - - -
Gross Benefit 15,00,000 18,00,000 20,25,000
Less: Interest cost (Note 1) -2,18,750 -3,50,000 -4,92,188
Less: Bad debt -1,50,000 -3,00,000 -4,50,000
Net Benefit 11,31,250 11,50,000 10,82,812
• The company should go ahead with option 1 as the same leads to higher net benefit.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 176
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Question No.: 22 – May 2015 exam
As a part of the strategy to increase sales and profits, the sales manager of a company proposes to sell goods
to a group of new customers with 10% risk of non-payment. This group would require one and a half months
credit and is likely to increase sales by Rs.1,00,000 p.a. Production and Selling expenses amount to 80% of
sales and the income-tax rate is 50%. The company’s minimum required rate of return (after tax) is 25%.
Should the sales manager’s proposal be accepted? Also find the degree of risk of non-payment that the
company should be willing to assume if the required rate of return (after tax) were (i) 30%, (ii) 40% and (iii)
60%.
Answer:
WN 1: Computation of actual post-tax return:
Particulars Amount
Sales 1,00,000
Less: Production and selling expenses -80,000
Gross Benefit 20,000
Less: Bad debt -10,000
Profit before tax 10,000
Less: Tax @ 50% -5,000
Profit after tax 5,000
Debtors (Full cost x 1.5/12) 10,000
Return on investment (PAT/Debtors x 100) 50%
• The company should go ahead with sales as actual return (50%) is higher than required return
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 177
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Net Benefit 3,17,778 3,07,792
• Company should not go ahead with revised scheme as the same leads to lower net benefit
Customer B:
Particulars 0 days 30 days 60 days 90 days
Sales 90,00,000 1,35,00,000 1,80,00,000 2,25,00,000
Less: Variable cost -72,00,000 -1,08,00,000 -1,44,00,000 -1,80,00,000
Less: Fixed cost - - - -
Gross Benefit 18,00,000 27,00,000 36,00,000 45,00,000
Less: Interest cost (Note 1) - -1,80,000 -4,80,000 -9,00,000
Net Benefit 18,00,000 25,20,000 31,20,000 36,00,000
• Company should provide 90 days credit to customer B. They would be able to sell 2,500 units and
will have the highest net benefit
Customer C:
Particulars 60 days 90 days
Sales 90,00,000 1,35,00,000
Less: Variable cost -72,00,000 -1,08,00,000
Less: Fixed cost - -
Gross Benefit 18,00,000 27,00,000
Less: Interest cost (Note 1) -2,40,000 -5,40,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 178
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Net Benefit 15,60,000 21,60,000
• Company should provide 90 days credit to customer C. They would be able to sell 1,500 units and
will have the highest net benefit
Question No.28 [Nov 2020 RTP, May 2013 RTP, Nov 2014 RTP]
H Ltd. has present annual sales of 10,000 units at Rs. 300 per unit. The variable cost is Rs. 200 per unit and
the fixed costs amount to Rs. 3,00,000 per annum. The present credit period allowed by the company is 1
month. The company is considering a proposal to increase the credit period to 2 months and 3 months and
has made the following estimates:
Particulars Existing Proposed 1 Proposed 2
Credit period 1 month 2 months 3 months
Increase in sales - 15% 30%
% of bad debts 1% 3% 5%
There will be increase in fixed cost by Rs. 50,000 on account of increase of sales beyond 25% of present level.
The company plans on a pre-tax return of 20% on investment in receivables. You are required to calculate the
most paying credit policy for the company.
Answer:
Evaluation of credit policy:
Particulars Present Option 1 Option 2
Sales 30,00,000 34,50,000 39,00,000
Less: Variable cost -20,00,000 -23,00,000 -26,00,000
Less: Fixed cost -3,00,000 -3,00,000 -3,50,000
Gross Benefit 7,00,000 8,50,000 9,50,000
Less: Interest cost (Note 1) -30,000 -1,03,500 -1,95,000
Less: Bad debt (% of sales) -38,333 -86,667 -1,47,500
Net Benefit 6,31,667 6,59,833 6,07,500
• The company should go ahead with option 1 as the same leads to higher net benefit.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 181
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Note 1: Computation of interest cost:
Particulars Existing Revised
Full cost of Sales (VC + FC) 5,04,000 5,18,000
Debtors (Full Cost x CP/360) 42,000 28,778
Interest cost (Debtors x Return %) 4,200 2,878
• Credit period for existing scenario = 30 days
• Credit period for revised scenario = (10 x 50%) + (30 x 50%) = 20 days
• It is assumed a year consist of 360 days
• It is assumed debtors are valued based on full cost of sales
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 183
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Annual benefit of availing cash discount is 18.53%. Opportunity cost is 15%. Hence the company should go
ahead with availing of cash discount
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 185
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
New Additional Problems
The section covers new additions from Nov 2021 RTP, May 2022 RTP, Nov 2021 MTP, July 2021 and Dec
2021 Suggested Answers
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 186
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Earnings available to equity shareholders [EAES] 4,47,500
No of equity shares 1,00,000
EPS [4,47,500/1,00,000] 4.475
MPS 28
PE Multiple [28/4.475] 6.26
Balance Sheet
(in ‘000s)
Particulars 2018-19 2019-20 2021-21
Assets
Non-current assets:
Fixed assets (net of depreciation) 3,800 5,000 9,400
Current Assets:
Cash and cash equivalents 80 200 212
Accounts receivable 600 3,000 4,200
Inventories 640 3,000 4,500
Total 5,120 11,200 18,312
Equity and Liabilities:
Equity share capital of Rs.10 each 2,400 3,200 4,000
Other equity 728 2,072 3,752
Non-current borrowings 1,472 2,472 5,000
Current liabilities 520 3,456 5,560
Total 5,120 11,200 18,312
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 187
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Current Ratio 2.30:1
Acid test ratio (quick ratio) 1.20:1
Receivables turnover ratio 7 Times
Inventory turnover ratio 4.85 Times
Long-term debt to total debt 24%
Debt-to-equity ratio 35%
Net profit ratio 18%
Return on total assets 10%
Interest coverage ratio (times interest earned) 10
As a loan officer of Expo-Impo Bank, you are REQUIRED to apprise the loan proposal on the basis of
comparison with industry average of key ratios considering closing balance for accounts receivable of Rs.
6,00,000 and inventories of Rs. 6,40,000 respectively as on 31st March, 2018
Answer:
Computation of Ratios:
Particulars Formula 2018-19 2019-20 2020-21 Industry
average
Current Ratio Current Assets 1,320 6,200 8.912 2.30:1
Current Liabilities 520 3,456 5,560
= 2.54 = 1.80 = 1.60
Acid Test Ratio Quick Assets 680 3,200 4,412 1.20:1
Current Liabilities 520 3,456 5,560
= 1.31 = 0.93 = 0.79
Receivables Credit Sales 3,600 8,640 14,400 7 Times
Turnover Ratio Average receivables 600 + 600 600 + 3,000 3,000 + 4,200
[ ] [ ] [ ]
2 2 2
= 6.00 = 4.80 = 4.00
Inventory COGS 2,480 5,664 9,600 4.85
Turnover Ratio Average Stock 640 + 640 640 + 3,000 3,000 + 4,500 Times
[ ] [ ] [ ]
2 2 2
= 3.88 = 3.11 = 2.56
Long-term debt Long term debt 1,472 2,472 5,000 24.00%
x 100 x 100 x 100 x 100
to total debt Total debt 1,992 5,928 10,560
= 73.90% = 41.70% = 47.35%
Debt-to-equity Long term debt 1,472 2,472 5,000 35.00%
x 100 x 100 x 100 x 100
ratio Shareholder equity 3,128 5,272 7,752
= 47.06% = 46.89% = 64.50%
Net Profit Ratio Net Profit 728 1,344 1,680 18.00%
x 100 x 100 x 100 x 100
Sales 4,000 9,600 16,000
= 18.20% = 14.00% = 10.50%
Return on total Net Profit 728 1,344 1,680 10.00%
x 100 x 100 x 100 x 100
assets Total Assets 5,120 11,200 18,312
= 14.22% = 12.00% = 9.17%
Interest EBIT 1,160 2,236 3,080 10.00
coverage ratio Interest 120 316 680
= 9.67 = 7.08 = 4.53
Conclusion:
• In the last two years, the current ratio and quick ratio are less than the ideal ratio (2:1 and 1:1
respectively) indicating that the company is not having enough resources to meet its current
obligations.
• Receivables are growing slower. Inventory turnover is slowing down as well, indicating a relative
build-up in inventories or increased investment in stock.
• High Long-term debt to total debt ratio and Debt to equity ratio compared to that of industry average
indicates high dependency on long term debt by the company.
• The net profit ratio is declining substantially and is much lower than the industry norm.
Additionally, though the Return on Total Asset(ROTA) is near to industry average, it is declining as
well.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 188
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• The interest coverage ratio measures how many times a company can cover its current interest
payment with its available earnings. A high interest coverage ratio means that an enterprise can
easily meet its interest obligations, however, it is declining in the case of Jensen & Spencer and is also
below the industry average indicating excessive use of debt or inefficient operations.
• On overall comparison of the industry average of key ratios than that of Jensen & Spencer, the
company is in deterioration position. The company’s profitability has declined steadily over the
period.
• However, before jumping to the conclusion relying only on the key ratios, it is pertinent to keep in
mind the industry, the company dealing in with i.e. manufacturing of pharmaceutical drugs. The
pharmaceutical industry is one of the major contributors to the economy and is expected to grow
further. After the covid situation, people are more cautious towards their health and are going to
spend relatively more on health medicines. Thus, while analysing the loan proposal, both the factors,
financial and non-financial, needs to be kept in mind.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 191
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
[1,50,000 x 10%]
EBT 45,000 60,000
WN 3: Sell shares of levered firm (high risk) and invest in equity of unlevered company:
• Investor has to sell shares of levered company and invest in equity of unlevered company
• We are moving from high risk company to low risk company. This would lead to risk reduction. In
order to maintain same risk, we should borrow money in line with corporate leverage
Particulars Amount
Sell shares of unlevered company 75,000
Borrow money @ 10% (1,50,000 x 20%) 30,000
Total amount available 1,05,000
Invest in equity of unlevered company 1,05,000
% stake of other company [1,05,000/5,00,000] x 100 21.00
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 192
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Fixed cost per annum (excluding interest) = Rs.6 Crores
• Variable operating cost ratio = 60%
• Total assets turnover ratio = 2.5
• Income-tax rate = 40%
Calculate the following and comment:
a) Earnings per share
b) Operating leverage
c) Financial leverage
d) Combined leverage
Answer:
WN 1: Income statement:
Particulars Rs. Crores
Revenues [30 x 2.5 Times] 75.00
Less: Variable cost [75 x 60%] -45.00
Contribution 30.00
Less: Fixed cost -6.00
EBIT 24.00
Less: Interest on 15% debentures [15 x 15%] -2.25
Earnings before tax 21.75
Less: Tax @ 40% -8.70
Earnings after tax 13.05
No of equity shares 0.75
Earnings per share [13.05/0.75] 17.40
Note:
• EPS indicates the amount the company earns per share. Investors use this as a guide while valuing
the share and making investment decisions. It is also an indicator used in comparing firms within
an industry or industry segment.
WN 2: Computation of leverages:
Contribution 30.00
Operating leverage = = = 1.25 Times
EBIT 24.00
• It indicates the choice of technology and fixed cost in cost structure. It is level specific. When
firm operates beyond operating break-even level, then operating leverage is low. It indicates
sensitivity of earnings before interest and tax (EBIT) to change in sales at a particular level.
EBIT 24.00
Financial leverage = = = 1.103 Times
PD
EBT − ( ) 21.75
1 − Tax rate
• The financial leverage is very comfortable since the debt service obligation is small vis -àvis
EBIT.
Contribution 30.00
Combined leverage = = = 1.379 Times
PD
EBT − ( ) 21.75
1 − Tax rate
• The combined leverage studies the choice of fixed cost in cost structure and choice of debt in
capital structure. It studies how sensitive the change in EPS is vis-à-vis change in sales. The
leverages operating, financial and combined are used as measurement of risk.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 193
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Profit volume ratio 25% 33.33%
Tax rate 45% 45%
You are required to PREPARE Income Statement for both the companies.
Answer:
Income statement of Company P and Company Q:
Particulars Company P Company Q
Sales [Contribution/PVR] 40,00,000 18,00,000
Less: Variable cost -30,00,000 -12,00,000
Contribution 10,00,000 6,00,000
Less: Fixed cost -8,00,000 -4,50,000
EBIT (Note 1) 2,00,000 1,50,000
Less: Interest -1,50,000 -1,00,000
EBT 50,000 50,000
Less: Tax (45%) -22,500 -22,500
EAT 27,500 27,500
10. Leverages:
The following particulars relating to Navya Ltd. for the year ended 31st March 2021 is given:
Output 1,00,000 units at normal capacity
Selling price per unit Rs.40
Variable cost per unit Rs.20
Fixed cost Rs.10,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 194
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
The following alternative schemes for financing the proposed expansion programme are planned:
• Entirely by equity shares of Rs. 10 each at par.
• Rs. 5 lakh by issue of equity shares of Rs. 10 each and the balance by issue of 6% debentures of Rs.
100 each at par.
• Entirely by 6% debentures of Rs. 100 each at par.
FIND out which of the above-mentioned alternatives would you recommend for Navya Ltd. with reference
to the risk and return involved, assuming a corporate tax of 40%.
Answer:
Evaluation of alternatives:
(in lacs)
Particulars Existing Alternative (i) Alternative (ii) Alternative (iii)
Equity share capital (Existing) 10.00 10.00 10.00 10.00
New issues - 10.00 5.00 -
Total equity capital 10.00 20.00 15.00 10.00
7% debentures 10.00 10.00 10.00 10.00
6% debentures - - 5.00 10.00
Total debentures 10.00 10.00 15.00 20.00
Debenture interest (7%) 0.70 0.70 0.70 0.70
Debenture interest (6%) - - 0.30 0.60
Total Interest 0.70 0.70 1.00 1.30
Output (in lacs) 1.00 1.50 1.50 1.50
Contribution per unit 20.00 22.00 22.00 22.00
Total contribution 20.00 33.00 33.00 33.00
Less: Fixed cost 10.00 15.00 15.00 15.00
EBIT 10.00 18.00 18.00 18.00
Less: Interest 0.70 0.70 1.00 1.30
EBT 9.30 17.30 17.00 16.70
Less: Tax @ 40% -3.72 -6.92 -6.80 -6.68
EAT 5.58 10.38 10.20 10.02
No of shares 1.00 2.00 1.50 1.00
EPS 5.58 5.19 6.80 10.02
Operating leverage (Cont/EBIT) 2.00 1.83 1.83 1.83
Financial leverage (EBIT/EBT) 1.08 1.04 1.06 1.08
Combined leverage (Cont/EBT) 2.15 1.91 1.94 1.98
Risk Lowest Lower than Highest
option (3)
Return Lowest Lower than Highest
option (3)
From the above figures, we can see that the Operating Leverage is same in all alternatives though Financial
Leverage differs. Alternative (iii) uses the maximum amount of debt and result into the highest degree of
financial leverage, followed by alternative ( ii). Accordingly, risk of the company will be maximum in these
options. Corresponding to this scheme, however, maximum EPS (i.e., Rs. 10.02 per share) will be also in
option (iii).
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 195
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
So, if Navya Ltd. is ready to take a high degree of risk, then alternative (iii) is strongly recommended. In case
of opting for less risk, alternative (ii) is the next best option with a reduced EPS of Rs. 6.80 per share. In case
of alternative (i), EPS is even lower than the existing option, hence not recommended.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 196
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
EBIT 1,50,000
Financial leverage = = = 1.25 Times
EBT 1,20,000
Combined leverage = Financial leverage x Operating leverage = 1.25 times x 4 Times = 5 Times
The purchase price of the system for installation of artificial intelligence is Rs. 20,00,000 with installation cost
of Rs. 1,00,000. The life of the system is 5 years and it will be depreciated on a straight -line basis. The salvage
value is zero which will be its market value after the end of its life of five years.
However, the operation of the new system for AI requires two computer specialists with annual salaries of
Rs. 5,00,000 per person. Also, the estimated maintenance and operating expenses of 1,50,000 is required. The
company’s tax rate is 30% and its required rate of return is 12%.
From the above information:
(i) CALCULATE the initial cash outflow and annual operating cash flow over its life of 5 years.
(ii) You are also REQUIRED to obtain the cash flows and NPV on the assumption that book salvage
value for depreciation purposes is Rs. 2,00,000 even though the machine is having no real worth in
terms of its resale value. Also, the book salvage value of Rs. 2,00,000 is allowed for tax purposes.
Answer:
Part (i) of the question:
Note 1: Initial outflow:
Particulars Amount
Capital expenditure -20,00,000
Installation cost -1,00,000
Initial outflow -21,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 197
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Particulars Amount
Capital expenditure -20,00,000
Installation cost -1,00,000
Initial outflow -21,00,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 198
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
[48 hours x 8 locations
x Rs.300]
Rental cost 5,76,000
[48 hours x 8 location x
Rs.1,500]
Telephone cost 1,53,600
[48 hours x 8 location x
Rs.400 per hour]
Total relevant cost 7,56,000 14,35,200 7,29,600
Analysis: The annual cash outflow is minimum, if video conferencing facility is engaged on rental basis.
Therefore, Option III is suggested
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 199
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Profit after tax 1,71,640 2,01,992 2,26,274 2,45,699
Add: Depreciation 2,16,800 1,73,440 1,38,752 1,11,002
Cash flow after taxes 3,88,440 3,75,432 3,65,026 3,56,701
Note 1: Computation of depreciation:
Particulars Year 1 Year 2 Year 3 Year 4
Opening WDV 10,84,000 8,67,200 6,93,760 5,55,008
Less: Depreciation @ 20% -2,16,800 -1,73,440 -1,38,752 -1,11,002
Closing WDV 8,67,200 6,93,760 5,55,008 4,44,006
• WDV of block at beginning of year 1 = 10,00,000 (capital expenditure) + 3,84,000 (WDV of existing
asset – computed in note 2) – 3,00,000 (sale value of old asset) = Rs.10,84,000
Existing Machine:
Particulars Year 1 Year 2 Year 3 Year 4
Units sold [300 days x 6 hours x 20 units] 36,000 36,000 36,000 36,000
Revenues [Units sold x Rs.10] 3,60,000 3,60,000 3,60,000 3,60,000
Less: Material cost -72,000 -72,000 -72,000 -72,000
Less: Labour cost [1800 hours x 20] -36,000 -36,000 -36,000 -36,000
Less: Fixed overhead -1,00,000 -1,00,000 -1,00,000 -1,00,000
Profit before depreciation and taxes [PBDT] 1,52,000 1,52,000 1,52,000 1,52,000
Less: Depreciation (Note 2) -76,800 -61,440 -49,152 -39,322
Profit before tax 75,200 90,560 1,02,848 1,12,678
Less: Tax @ 30% -22,560 -27,168 -30,854 -33,803
Profit after tax 52,640 63,392 71,994 78,875
Add: Depreciation 76,800 61,440 49,152 39,322
Cash flow after taxes 1,29,440 1,24,832 1,21,146 1,18,197
WN 4: Computation of NPV:
Cash flow
Year Existing New Incremental PVF @ 10% DCF
0 -3,00,000 -11,00,000 -8,00,000 1.000 -8,00,000
1 1,29,440 3,88,440 2,59,000 0.909 2,35,431
2 1,24,832 3,75,432 2,50,600 0.826 2,06,996
3 1,21,146 3,65,026 2,43,880 0.751 1,83,154
4 1,18,197 3,56,701 2,38,504 0.683 1,62,898
4 1,00,000 2,00,000 1,00,000 0.683 68,300
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 200
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Incremental NPV 56,779
Conclusion: The company should go ahead with the replacement as the same results in incremental positive
NPV of Rs.56,779.
Further, the company follows straight line depreciation method but for tax purpose, written down value
method depreciation @ 7.5% is allowed taking that this is the only machine in the block of assets.
Given below are the expected sales and costs from both old and new machine:
Particulars Old Machine New Machine
Sales 8,10,000 8,10,000
Material cost 1,80,000 1,26,250
Labour cost 1,35,000 1,10,000
Variable OH 56,250 47,500
Fixed OH 90,000 97,500
Depreciation 24,000 41,500
PBT 3,24,750 3,87,250
Tax @ 30% 97,425 1,16,175
PAT 2,27,325 2,71,075
From the above information, ANALYSE whether the old machine should be replaced or not if required rate
of return is 10%? Ignore capital gain tax.
Answer:
WN 1: Initial outflow:
Particulars Amount
Capital expenditure -4,50,000
Sale price of old machine 1,00,000
Net outflow -3,50,000
• Capital gain on sale of old asset is to be ignored as question says to ignore capital gain tax
WN 2: In-between flows:
Particulars Calculation Amount
Incremental PBT of new machine 3,87,250 – 3,24,750 62,500
Add: Incremental depreciation as per books 41,500 – 24,000 17,500
Incremental PBDT of new machine 80,000
Cash flows:
Particulars Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 Y9 Y10
PBDT 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000
Less: Depreciation -26,250 -24,281 -22,460 -20,776 -19,217 -17,776 -16,443 -15,210 -14,069 -13,014
Profit before tax 53,750 55,719 57,540 59,224 60,783 62,224 63,557 64,790 65,931 66,986
Less: Tax @ 30% -16,125 -16,716 -17,262 -17,767 -18,235 -18,667 -19,067 -19,437 -19,779 -20,096
Profit after tax 37,625 39,003 40,278 41,457 42,548 43,557 44,490 45,353 46,152 46,890
Add: Depreciation 26,250 24,281 22,460 20,776 19,217 17,776 16,443 15,210 14,069 13,014
Cash flow after taxes 63,875 63,284 62,738 62,233 61,765 61,333 60,933 60,563 60,221 59,904
Depreciation:
Particulars Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 Y9 Y10
Opening WDV 3,50,000 3,23,750 2,99,469 2,77,009 2,56,233 2,37,016 2,19,240 2,02,797 1,87,587 1,73,518
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 201
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Less: Depn -26,250 -24,281 -22,460 -20,776 -19,217 -17,776 -16,443 -15,210 -14,069 -13,014
Closing WDV 3,23,750 2,99,469 2,77,009 2,56,233 2,37,016 2,19,240 2,02,797 1,87,587 1,73,518 1,60,504
WN 3: Terminal flow:
Particulars Amount
Salvage value 35,000
Recapture of working capital 0
Net cash inflow 35,000
WN 4: Computation of NPV:
Year Cash flow PVF @ 10% DCF
0 (3,50,000) 1.000 (3,50,000)
1 63,875 0.909 58,062
2 63,284 0.826 52,273
3 62,738 0.751 47,116
4 62,233 0.683 42,505
5 61,765 0.621 38,356
6 61,333 0.564 34,592
7 60,933 0.513 31,259
8 60,563 0.467 28,283
9 60,221 0.424 25,534
10 94,904 0.386 36,633
NPV 44,613
Conclusion: Since the Incremental NPV is positive, the old machine should be replaced
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 202
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
1 -15,00,000 0.870 -13,05,000
[-18,00,000 – 5,00,000 – 2,00,000]
2 to 9 -2,00,000 3.902 -7,80,400
9 4,00,000 0.284 1,13,600
PV of outflow 19,71,800
No of years 9 years
PVAF (15%, 8 years) 4.772
EAC 4,13,202
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 203
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Stand Ltd. is contemplating replacement of one of its machines which has become outdated and inefficient.
Its financial manager has prepared a report outlining two possible replacement machines. The details of each
machine are as follows:
Particulars Machine 1 Machine 2
Initial investment 12,00,000 16,00,000
Estimated useful life 3 years 5 years
Residual value 1,20,000 1,00,000
Contribution per annum 11,60,000 12,00,000
Fixed maintenance costs per annum 40,000 80,000
Other fixed operating costs per annum 7,20,000 6,10,000
The maintenance costs are payable annually in advance. All other cash flows apart from the initial investment
assumed to occur at the end of each year. Depreciation has been calculated by straight line method and has
been included in other fixed operating costs. The expected cost of capital for this project is assumed as 12%
p.a.
Required:
a) Which machine is more beneficial, using Annualized Equivalent Approach? Ignore tax.
b) Calculate the sensitivity of your recommendation in part (a) to changes in the contribution generated
by machine 1.
Answer:
WN 1: Computation of cash flows:
Machine 1:
Year Investment Salvage Contribution Maintenance Other fixed Net cash
value cost cost flow
0 -12,00,000 - -40,000 -12,40,000
1 - - 11,60,000 -40,000 -3,60,000 7,60,000
2 - - 11,60,000 -40,000 -3,60,000 7,60,000
3 - 1,20,000 11,60,000 -3,60,000 9,20,000
Note:
• Depreciation per annum = [12,00,000 – 1,20,000]/3 = Rs.3,60,000
• Other fixed cash cost = 7,20,000 – 3,60,000 = Rs.3,60,000
Machine 2:
Machine 1:
Year Investment Salvage Contribution Maintenance Other fixed Net cash
value cost cost flow
0 -16,00,000 - -80,000 - -16,80,000
1 - - 12,00,000 -80,000 -3,10,000 8,10,000
2 - - 12,00,000 -80,000 -3,10,000 8,10,000
3 - - 12,00,000 -80,000 -3,10,000 8,10,000
4 - - 12,00,000 -80,000 -3,10,000 8,10,000
5 - 1,00,000 12,00,000 -3,10,000 9,90,000
Note:
• Depreciation per annum = [16,00,000 – 1,00,000]/5 = Rs.3,00,000
• Other fixed cash cost = 6,10,000 – 3,00,000 = Rs.3,10,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 204
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Machine 2:
Year Cash flow PVF @ 12% DCF
0 -16,80,000 1.000 -16,80,000
1 8,10,000 0.893 7,23,330
2 8,10,000 0.797 6,45,570
3 8,10,000 0.712 5,76,720
4 8,10,000 0.636 5,15,160
5 9,90,000 0.567 5,61,330
NPV of Project 13,42,110
PVAF (12%,5 years) 3.605
EAB of Project 3,72,291
Recommendation: Machine 2 is more beneficial using Equivalent Annualized Criterion.
WN 3: Sensitivity Analysis:
Approach 1:
Difference in Equivalent Annualized Criterion of Machines required for changing the recommendation in
part (i) = 3,72,291- 2,91,191 = Rs.81,100
𝟖𝟏, 𝟏𝟎𝟎
𝐒𝐞𝐧𝐬𝐢𝐭𝐢𝐯𝐢𝐭𝐲 % = 𝐱 𝟏𝟎𝟎 = 𝟔. 𝟗𝟗% (𝐨𝐫)𝟕% 𝐨𝐟 𝐜𝐨𝐧𝐭𝐫𝐢𝐛𝐮𝐭𝐢𝐨𝐧 𝐨𝐟 𝐌𝐚𝐜𝐡𝐢𝐧𝐞 𝟏
𝟏𝟏, 𝟔𝟎, 𝟎𝟎𝟎
WN 2: Computation of NPV:
Particulars Worst Base Best
Initial outlay 15,00,000 15,00,000 15,00,000
Cash inflow per year 88,750 5,20,000 10,26,250
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 205
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Cumulative PVF for 5 years 3.353 3.353 3.353
PV of cash inflows 2,97,579 17,43,560 34,41,016
NPV -12,02,421 2,43,560 19,41,016
21. Working capital forecast, P&L and Balance Sheet [Nov 2021 MTP]
On 01st April, 2020, the Board of Director of ABC Ltd. wish to know the amount of working capital that
will be required to meet the programme they have planned for
the year. From the following information, PREPARE a working capital requirement forecast and a forecast
profit and loss account and balance sheet:
• Issued share capital = Rs.6,00,000
• 10% debentures = Rs.1,00,000
• Fixed assets = Rs.4,50,000
Production during the previous year was 1,20,000 units; it is planned that this level of activity should be
maintained during the present year. The expected ratios of cost to selling price are: raw materials 60%, direct
wages 10% overheads 20% Raw materials are expected to remain in store for an average of two months before
issue to production. Each unit of production is expected to be in process for one month. The time lag in wage
payment is one month. Finished goods will stay in the warehouse awaiting dispatch to customers for
approximately three months. Credit allowed by creditors is two months from the date of delivery of raw
materials. Credit given to debtors is three months from the date of dispatch. Selling price is Rs. 5 per unit.
There is a regular production and sales cycle and wages and overheads accrue evenly
Answer:
WN 1: Preparation of Profit and Loss Account:
Particulars Amount Particulars Amount
To Material consumed 3,60,000 By Sales [1,20,000 x 5] 6,00,000
[1,20,000 x 3]
To Direct wages 60,000
[1,20,000 x 0.50]
To Overheads 1,20,000
[1,20,000 x 1.00]
To Gross Profit 60,000
Total 6,00,000 Total 6,00,000
To Debenture interest 10,000 By Gross Profit 60,000
[1,00,000 x 10%]
To Net profit 50,000
Total 60,000 Total 60,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 207
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
(based on COP)
Stock of FG 3
(based on COGS) 5,40,000 x ( ) 1,35,000
12
Debtors 3
(based on credit sales) 6,00,000 x ( ) 1,50,000
12
Total Current Assets (A) 3,82,500
Current liabilities
Creditors 2
(Based on credit purchases) 3,60,000 x ( ) 60,000
12
Outstanding wages 1
(Based on total wages) 60,000 x ( ) 5,000
12
Total Current Liabilities (B) 65,000
Working capital (A-B) 3,17,500
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 209
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Particulars November December January February March Total
Total Sales 6,40,000 8,80,000 6,00,000 6,00,000 8,00,000
Cash sales 1,28,000 1,76,000 1,20,000 1,20,000 1,60,000
Credit sales 5,12,000 7,04,000 4,80,000 4,80,000 6,40,000
Collection in Jan 2,96,960 1,76,000 72,000 NA 5,44,960
Collection in Feb 4,08,320 1,20,000 72,000 6,00,320
Collection in Mar 2,78,400 1,20,000 96,000 4,94,400
• Credit sales are four times of cash sales. Cash sales + Credit sales = Total sales; Cash sales + 4 (cash
sales) = Total sales; 5 (Cash sales) = Total sales; Cash sales = 20% of credit sales
• Credit sales collection = 15% in same month + 25% in next month and 58% in second month
• Collection in January for Nov month sales = 5,12,000 x 58%
• Collection in January for Dec month sales = 7,04,000 x 25%
• Other amounts are computed in similar manner
Cost of Factoring:
Particulars Amount
Commission charges [2% x 24,00,000] 48,000
Less: Admin cost saving [1,250 + 1,750] x 12 -36,000
Net cost of factoring (excluding interest) 12,000
Annual Cost of Borrowing Rs.1,50,000 receivables through factoring would be:
(12% x 1,50,000) + 12,000 18,000 + 12,000
x 100 = 𝑥 100 = 20.00%
1,50,000 1,50,000
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 210
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Conclusion: The company should select alternative of Bank Loan as it has the lowest annual cost i.e. 16.67%
p.a.
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 211
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 212
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
CA – Intermediate Classes
CA Inter Full time & Shift 2 College Students
(Physical i.e. Face to Face Classes & Online Classes)
Coaching Time: 6.30AM to 11AM Monday to Friday and 6.30AM to 1PM on Saturday and
Sunday
CA inter Direct Entry & Shift 1 College Students
(Physical i.e. Face to Face Classes & Online Classes)
Coaching Time 6.30 AM to 9.30 AM Monday to Friday and 6.30AM to 1PM on Saturday and
Sunday
Unique Features of Classes @ Bharadwaj
Physical Classes: FACE-FACE Classes
• Expert Faculty Team Having More than Two Decades of Experience
• Researched Materials and Text books: Contains Past examination Questions In a step by step
approach
• Individual Attention: 60 Students Per Class
• Reading Room & Reading Library Facility to Learn beyond Class hours
• Tests on the completion of every topic and Mock Exam
• Periodical Counselling to ensure motivation and Focus in Studies
• Completion of 100% syllabus in depth and Revision Classes one month before exam
Students attending Physical Classes are also provided with 100% of Recorded classes as a
back-up to revise/learn which can be accessed in Laptop/Mobile for 18 months
Online Classes Options: LIVE Online / Google Drive / Pen Drive
• Lectures are in Simple and Understandable English (No other Regional Language is used)
• Periodical live sessions to clarify Doubts
• Lectures are made in Simple and Understandable English (No other Regional Language is
used)
• All students can Access the lectures from your Laptop/system for 18 months
• Tests and Assignments on regular intervals through Paper Pen mode & through our BI E-
Learning App
Satisfaction Guarantee: Students can get 100% of Fee refund if they are not
satisfied with classes. (Anytime Within 10 days of commencement of batch)
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 213
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 214
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
Group 1
• Access the lectures from your mobile/laptop from wherever you are
• Lectures are made in Simple and Understandable English (No other Regional
Language is used)
• Assignments/Tests are included in the package.
Students attending Physical Classes are also provided with 100% of Recorded classes as a
back-up to revise/learn which can be accessed in Laptop/Mobile for 18 months
www.bharadwajinstitute.com
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 216
CA Inter Group 2 Revision Sessions CA.DINESH JAIN
www.bharadwajinstitute.com 9790809900 9841537255
• Access the lectures from your mobile/laptop from wherever you are !!
• Lectures are made in Simple and Understandable English (No other Regional Language is
used)
• Assignments/Tests are included in the package.
Bharadwaj Institute Pvt Ltd No 58/19 North Mada St, Nungambakkam, Chennai-34 217