Financial Management - 1 PDF
Financial Management - 1 PDF
Financial Management - 1 PDF
SECTION
J. K. SHAH CLASSES I.P.C.C. - FINANCIAL MANAGEMENT
CHAPTER - 1
ACCOUNTING RATIOS
Q. 1. Using the following information, complete the Balance Sheet given below :
(i) Total debt to net worth 1:2
(ii) Total assets turnover 2
(iii) Gross profit on sales 30%
(iv) Average collection period (Assume 360 days in a year) 40 days
(v) Inventory turnover ratio based on cost of goods sold and year - end inventory 3
(vi) Acid Test Ratio 0.75
Balance Sheet as on March 31, 2014
Liabilities ` Assets `
Equity Shares Capital 4,00,000 Plant and Machinery ----
Reserves and Surplus 6,00,000 and other Fixed Assets
Total Debt : Current Assets :
Current Liabilities ---- Inventory ----
Debtors ----
Cash ----
: 1 : ACCOUNTING RATIOS
J. K. SHAH CLASSES I.P.C.C. - FINANCIAL MANAGEMENT
Q. 3. The following accounting information and financial ratios of M Limited relate to the
year ended 31st March, 2014 :
Inventory Turnover Ratio 6 Times
Creditors Turnover Ratio 10 Times
Debtors Turnover Ratio 8 Times
Current Ratio 2.4
Gross Profit Ratio 25%
Total sales ` 30,00,000; cash sales 25% of credit sales; cash purchases ` 2,30,000;
working capital ` 2,80,000; closing inventory is ` 80,000 more than opening inventory.
You are required to calculate:
(i) Average Inventory (v) Average Payment Period
(ii) Purchases (vi) Average Collection Period
(iii) Average Debtors (vii) Current Assets
(iv) Average Creditors (viii) Current Liabilities
Q. 4. The financial statements of a company contain the following information for the year
ending 31st March, 2014:
Particulars `
Cash 1,60,000
Sundry Debtors 4,00,000
Short-term Investment 3,20,000
Stock 21,60,000
Prepaid Expenses 10,000
Total Current Assets 30,50,000
Current Liabilities 10,00,000
10% Debentures 16,00,000
Equity Share Capital 20,00,000
Retained Earnings 8,00,000
Statement of Profit for the year ended 31st March, 2014
Sales (20% cash sales) 40,00,000
Less: Cost of goods sold 28,00,000
Profit before Interest & Tax 12,00,000
Less: Interest 1,60,000
Profit before tax 10,40,000
Less: Tax @ 30% 3,12,000
Profit After Tax 7,28,000
You are required to calculate:
(i) Quick Ratio
(ii) Debt-equity Ratio
(iii) Return on Capital Employed, and
(iv) Average collection period (Assuming 360 days in a year).
: 2 : ACCOUNTING RATIOS
J. K. SHAH CLASSES I.P.C.C. - FINANCIAL MANAGEMENT
Q. 5. MN Limited gives you the following information related for the year ending 31st March, 2009:
(1) Current Ratio 2.5 : 1
(2) Debt-Equity Ratio 1 : 1.5
(3) Return on Total Assets 15%
(4) Total Assets Turnover Ratio 2
(5) Gross Profit Ratio 20%
(6) Stock Turnover Ratio 7
(7) Current Market Price per Equity Share ` 16
(8) Net Working Capital ` 4,50,000
(9) Fixed Assets ` 10,00,000
(10) 60,000 Equity Shares of ` 10 each
(11) 20,000, 9% Preference Shares of ` 10 each
(12) Opening Stock ` 3,80,000
You are required to calculate:
(i) Quick Ratio
(ii) Fixed Assets Turnover Ratio
(iii) Proprietary Ratio
(iv) Earnings per Share
(v) Price-Earning Ratio.
Q. 6. JKL Limited has the following Balance Sheets as on March 31, 2006 and March 31, 2005:
Balance Sheet
` in lakhs
March 31, 2006 March 31, 2005
Sources of Funds:
Shareholders Funds 2,377 1,472
Loan Funds 3,570 3,083
5,947 4,555
Applications of Funds:
Fixed Assets 3,466 2,900
Cash and bank 489 470
Debtors 1,495 1,168
Stock 2,867 2,407
Other Current Assets 1,567 1,404
Less: Current Liabilities (3,937) (3,794)
5,947 4,555
: 3 : ACCOUNTING RATIOS
J. K. SHAH CLASSES I.P.C.C. - FINANCIAL MANAGEMENT
The Income Statement of the JKL Ltd. for the year ended is as follows:
Required:
(i) Calculate for the year 2005-06:
(a) Inventory turnover ratio
(b) Financial Leverage
(c) Return on Investment (ROI)
(d) Return on Equity (ROE)
(e) Average Collection period.
(ii) Give a brief comment on the Financial Position of JKL Limited.
Q. 7. Ganpati Limited has furnished the following ratios and information relating to the year
ended 31st March, 2013.
Sales 60,00,000
Return on net worth 25%
Rate of income tax 50%
Share capital to reserves 7:3
Current ratio 2
Net profit to sales 6.25%
Inventory turnover (based on cost of goods sold) 12
Cost of goods sold 18,00,000
Interest on debentures 60,000
Sundry debtors 2,00,000
Sundry creditors 2,00,000
You are required to:
(a) Calculate the operating expenses for the year ended 31st March, 2013.
(b) Prepare a balance sheet as on 31st March in the following format:
Balance Sheet as on 31st March, 2013
Liabilities Assets
Share Capital Fixed Assets
Reserve and Surplus Current Assets
15% Debentures Stock
Sundry Creditors Debtors
Cash
: 4 : ACCOUNTING RATIOS
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
CHAPTER - 2
LEVERAGES
Q. 1. Complete the following financial statement from the information given below :
Particulars Company L (in ` ) Company M (in `)
Sales
Less : Variable Cost
Contribution
Less : Fixed Cost
Profit before Interest and Tax
Less : Interest
Profit before Tax
Less : Tax at 50%
Profit after Tax 25,000 40,000
Operating Leverage 2 times 3 times
Combined Leverage 4 times 3 times
Variable Cost Ratio 60% of Sales 70% of Sales
Q. 2. Calculate the degree of operating leverage, degree of financial leverage and the degree
of combined leverage for the following firms and interpret the results :
P Q R
Output (units) 2,50,000 1,25,000 7,50,000
Fixed Cost ( `) 5,00,000 2,50,000 10,00,000
Unit Variable Cost ( ` ) 5 2 7.50
Unit Selling Price ( `) 7.50 7 10.0
Interest Expenses (`) 75,000 25,000 ----
Q. 4. The following details of RST Limited for the year ended 31st March, 2014 are given below:
Operating Leverage 1.4
Combined Leverage 2.8
Fixed Cost (Excluding Interest) ` 2.04 lakhs
Sales ` 30.00 lakhs
12% Debentures of ` 100 each ` 21.25 lakhs
Equity Shares Capital of ` 10 each ` 17.00 lakhs
Income tax Rate 30 percent
: 5 : LEVERAGES
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Required :
(i) Calculate Financial Leverage.
(ii) Calculate P/V ratio and Earning per Share (EPS)
(iii) If the company belongs to an industry, whose assets turnover is 1.5, does it
have a high or low assets leverage?
(iv) At what level of sales the Earning before Tax (EBT) of the company will be
equal to zero?
Q. 6. Betatronics Ltd. has the following balance sheet and income statement information :
Balance Sheet as on March 31st
Liabilities (` ) Assets (` )
Equity Capital (`10 per share) 8,00,000 Net Fixed Assets 10,00,000
10% Debt 6,00,000 Current Assets 9,00,000
Retained Earnings 3,50,000
Current Liabilities 1,50,000
19,00,000 19,00,000
Income Statement for the year ending March 31st
(`)
Sales 3,40,000
Operating expenses (including ` 60,000 depreciation) 1,20,000
EBIT 2,20,000
Less : Interest 60,000
Earnings before Tax 1,60,000
Less : Taxes 56,000
Net Earnings (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 earnings per share at the new sales level?
: 6 : LEVERAGES
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
CHAPTER - 3
CAPITAL STRUCTURE
Q. 1.Goodluck Charm Ltd., a profit making company, has a paid-up capital of ` 100 lakhs
consisting of 10 lakhs shares of ` 10 each. Currently, it is earning an annual pre-
tax profit of ` 60 lakhs. The company's shares are listed and are quoted in the
range of ` 50 to ` 80. The management wants to diversify production and has
approved a project which will cost ` 50 lakhs and which is expected to yield a
pre-tax income of ` 40 lakhs per annum. To raise this additional capital, the following
options are under consideration of the management:
(a) To issue equity capital for the entire additional amount. It is expected that the
new shares (face value of ` 10) can be sold at a premium of ` 15.
(b) To issue 16% non-convertible debentures of ` 100 each for the entire amount.
(c) To issue equity capital for ` 25 lakhs (face value of ` 10) and 16%
non-convertible debentures for the balance amount. In this case, the company
can issue shares at a premium of ` 40 each.
You are required to advise the management as to how the additional capital can be
raised,keeping in mind that the management wants to maximise the earnings per
share. The company is paying income, tax at 50%.
Q. 2. Three financing plans are being considered by ABC Ltd. which requires ` 10,00,000 for
construction of a new plant. It wants to maximize the EPS and the current market price of
the share is 30. It has a tax rate of 50% and debt financing can be arranged as follows :
Up to ` 1,00,000 @ 10%; from ` 1,00,000 to ` 5,00,000 @ 14%; and over ` 5,00,000 @
18%. The three financing plans and the corresponding EBIT are as follows:
Plan I: ` 1,00,000 debt; expected EBIT ` 2,50,000
Plan II : ` 3,00,000 debt; expected EBIT ` 3,50,000
Plan III ` 6,00,000 debt; expected EBIT ` 5,00,000
Find out the EPS for all the three plans and suggest which plan is better from the
point of view of the cornpany.
Q. 3.Delta Ltd. currently has an equity share capital of ` 10,00,000 consisting of 1,00,000
equity share of ` 10 each. The company is going through a major expansion plan
requiring to raise funds to the tune of ` 6,00,000. To finance he expansion the
management has following plans:
Plan-I : Issue 60,000 Equity shares of ` 10 each.
Plan-II : Issue 40,000 Equity shares of ` 10 each and the balance through long-
term borrowing at 12% interest p.a.
Plan-Ill : Issue 30,000 Equity shares of ` 10 each and 3,000 ` 100, 9% Debentures.
Plan-IV : Issue 30,000 Equity shares of ` 10 each and the balance through 6%
preference shares.
The EBIT of the company is expected to be ` 4,00,000 p.a. assume corporate tax
rate of 40%.
Required:
(i) Calculate EPS in each of the above plans.
(ii) Ascertain the degree of financial leverage in each plan
: 7 : CAPITAL STRUCTURE
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Q. 4.A new project is under consideration in Zip Ltd., which requires a capital investment
of ` 4.50 crore. Interest on term loan is 12% and Corporate Tax Rate is 50%. If the
Debt Equity ratio insisted by the financing agencies is 2 :1, calculate the profit of
indifference of the project.)
Q. 5.Calculate the level of earnings before interest and tax (EBIT) at which the EPS
indifference point between the following financing alternatives will occur:
(i) Equity share capital of ` 6,00,000 and 12% debentures of ` 4,00,000
OR
(ii) Equity share capita! of ` 4,00,000, 14% preference share capital of ` 2,00,000
and 12% debentures of ` 4,00,000.
Assume the corporate tax rate is 35% and par value of equity share is ` 10 in each case.
Q. 6. A Company needs ` 31,25,000 for the construction of new plant. The following 3 plans
are feasible: The Company may issued 3,12,500 equity shares at ` 10 per share.
II The Company may issue 1,56,250 ordinary equity shares at ` 10 per share and
15,625 debentures of ` 100 denomination bearing a 8% rate of interest.
III The Company may issue 1,56,250 equity shares at ` 10 per share and 15,625
preference shares at ` 100 per share bearing a 8% rate of dividend.
(i) If the company's earnings before interest and taxes are ` 62,500, ` 1,25,000,
` 2,50,000, ` 3,75,000 and ` 6,25,000, what are the earnings per share under
each of three financial plans? Assume a Corporate Income tax rate of 40%.
(ii) Which alternative would you recommend and why?
(iii) Determine the EBIT-EPS indifference points by formulae between Financing Plan
I and Plan II, Plan I and Plan III.
Q. 7.PCB Corporation has plans for expansion which calls for 50% increase in assets.
The alternatives before the corporation are issue of equity shares or 14% debt. The
balance sheet of the firm and the income statement for the year ending
Dec.31, are as follows:
Balance sheet as on Dec. 31
Liabilities ` ) Assets
Amount (` `)
Amount (`
Equity share capital 100,00,000 Total assets 200,00,000
(10,00,000 shares)
Genera] reserves 75,00,000
12% debentures 25,00,000
200,00,000 200,00,000
: 8 : CAPITAL STRUCTURE
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Income Statement for the year ending Dec. 31
Sales ` 750,00,000
-Total Operating Cost 675,00,000
EBIT 75,00,000
Interest on Debenture 3,00,000
Profit before Tax 72,00,000
-Taxes 36,00,000
Profit after Tax (PAT) 36,00,000
Number of shares 10,00,000
EPS (`
`) 3.60
P/E Patio 5
Market price (`
`) 18.00
If the corporation finances the expansion with debt, the PE is expected to be 4
times. However, if equity shares are issued, then the issue is expected to be made
at 25% premium. Find out:
1. If the EBIT is 10%. of sales, calculate EPS at the sales level of ` 4 crores,
` 8 crores and ` 10 crores.
2. After expansion, determine at which level of EBIT, the EPS would be same
under both financing plans.
3. Using PE ratio, calculate the market price of the share at each sales level
and for both the financing plans.
Q. 8.A Company earns a profit of ` 3,00,000 per annum after meeting its Interest liability
of ` 1,20,000 on 12% debentures The Tax rate is 50%. The number of Equity
Shares of ` 10 each ore 80,000 and the retained earnings amount to 112,00,000.
The company proposes to take up an expansion scheme tor which a sum of
` 4,00,000 is required. It is anticipated that after expansion, the company will be
able to achieve the same return on investment as at present. The funds required for
expansion can be raised either through debt at the rate of 12% or by issuing Equity
Shares at par Required:
(i) Compute the Earnings Per Share (EPS), if:
- the additional funds were raised as debt
- the additional funds were raised by issue of equity shares,
(ii) Advise the company as to which source of finance is preferable.
: 9 : CAPITAL STRUCTURE
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
COST OF CAPITAL
CHAPTER - 4
Q. 1. Calculate the cost of capital in each of the following cases:
(i) A 7-y ears ` 100 bond of a firm can be sold for a net price of ` 97.75 and
is redeemable at a premium of 5%. The coupon rate of interest is 15% and
the tax rate is 55%.
(ii) A company issues 10% Irredeemable Preference Shares at` ` 105 each
(FV = 100).
(iii) The current market price of share is ` 90 and the expected dividend at the
end of current year is ` 4.50 with a growth rate of 8%.
(iv) The current market price of share is ` 100. The firm needs ` 1,00,000 for
expansion and the new shares can be sold only at ` 95. The expected dividend
at the end of current year is ` 4.75 with a growth rate of 6%. Also calculate
the cost of capital of new equity.
(v) A company is about to pay a dividend of ` 1.40 per share having a market
price of ` 19.50. Thecxpected future growth in dividends is estimated at 12%.
Q. 2. (a) A company raised preference share capital of ` 1,00,000 by the issue of 10%
Preference shares of ` 10 each. Find out the cost of preference share capital
when it is issued at (i) 10% premium, and (ii) 10% discount.
(b) A company has 10% redeemable preference share which are redeemable at
the end of 10th year from the dale ol issue. The underwriting expenses are
expected to 2%. Find out the effective cost of preference share capital.
(c) The entire share capital of a company consist of 1,00,000 equity share of ` 100
each. Its current earnings are ` 10,00,000 p.a. The company wants to raise
additional funds of ` 25,00,000 by issuing new shares. The flotation cost is
expected to be 10% of the face value. Find out the cost of new equity capita!
given that the earnings are expected to remain same for coming years.
Q. 3.The following figures are taken from the current balance sheet of Delaware & Co.
Capital ` 8,00,000
Share Premium 2,00,000
Reserves 6,00,000
Shareholder’s funds 16,00,000
12% Perpetual debentures 4,00,000
An annual ordinary dividend of ` 2 per share has just been paid. In the past, ordinary
dividends have grown at a rate of 10 per cent per annum and this rate of growth is expected
to continue. Annual interest has recently been paid on the debentures. The ordinary shares
are currently quoted at ` 27.5 and the debentures at 80 per cent Ignore taxation.
You are required to estimate the weighted average cost of capital (based on market
values) for Delaware & Co.
: 10 : COST OF CAPITAL
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Q. 4. The capital structure of XYZ & Co. is comprising of 8.57% debenture, 9% preference
share and some equity share of ` 100 each in the ratio of 3 : 2 : 5. The company is
considering to introduce additional capital to meet the needs of expansion plans by raising
10% loan from financial institutions. As a result of this proposal, the proportions of different
above sources would go down by 1/10, 1/15 and 1 /6 respectively.
In the light of the above proposal, find out the impact on the WACC of the firm given that
(i) tax rate is 30%, (ii) expected dividend of ` 9 at the end of the year; and (iii) the growth
rate, g, may be taken at 5%. No change is expected in dividends, growth rate, market
price of the share etc. after availing the proposed loan.
Q. 5. H Ltd-and Z Ltd. have the same levels of business risk and their market values and earnings
are summarised below :
H Ltd. Z Ltd.
Market Values :
Equity ` 6,00,000 ` 3,00,000
Debt ---- 2,50,000
6,00,000 5,50,000
Earnings 90,000 90,000
Less:Interest ---- 22,000
90,000 68,000
Calculate the post-tax cost of equity, cost of debt and weighted average cost of capital of
both the companies. Assume that the income-tax rate is 35% and the additional tax on
dividend distribution is 20%.
Q. 8. ABC Ltd wishes to raise additional finance of ` 20 Lakhs for meeting its investment
plans. The Company has ` 4,00,000 in the form of Retained Earnings available for
investment purposes. The following are further details
1. Debt Equity Ratio 25:75.
2. Cost of Debt at the rate of 10% (before tax) upto ` 2,00,000 and 13% (before
tax) beyond that,
3. Earnings Per Share = ` 12.
4. Dividend Payout = 50% of Earnings.
5. Expected Growth Rate in Dividend 10%.
6. Current Market Price per Share = ` 60.
7. Company's Tax Rate is 30% and Shareholder's Personal Tax Rate is 20%
Calculate the following -
1. Post Tax Average Cost of Additional Debt.
2. Cost of Retained Earnings and Cost of Equity.
3. Overall Weighted Average (after tax) Cost of Additional Finance.
Q. 9. The R & G Co. has following capital structure at 31st March 2010, which is considered
to be optimum -
Particulars Amount (in ` )
13% Debentures 3,60,000
11% Preference Share Capital 1,20,000
Equity Share Capital (2,00,000 Shares) 19,20,000
: 12 : COST OF CAPITAL
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
The Company's Share has a Current Market Price of ` 27.75 per Share. The expected
Dividend per Share in the next year is50% of the 2010 EPS. The EPS of last 10 years
is as follows. The past trends are expected to continue -
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
EPS( ` ) 1.00 1.120 1.254 1.405 1.574 1.762 1.974 2.211 2.476 2.773
The Company can issue 14% New Debenture. The Company's Debenture is currently
selling at ` 98. The New Preference Issue can be sold at a net price of ` 9.80,
paying a dividend of ` 1.20 per Share. The Company's Marginal Tax Rate is 50%.
Required:
1. Calculate the After Tax Cost - (a) of new Debt and new Preference Share Capital,
(b) of ordinary Equity, assuming new Equity comes from Retained Earnings.
3. How much can be spent for Capital Investment before new ordinary share must
be sold? Assuming that retained earning available for next year's investment
are 50% of 2010 earnings.
4. What will be Marginal Cost of Capital (cost of fund raised in excess of the amount
calculated in Part (3), if the Company can sell new Ordinary Shares to net ` 20
per share? Cost of Debt and of Preference Capital is constant.
: 13 : COST OF CAPITAL
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
CHAPTER - 5
CAPITAL BUDGETING
Q. 1.Machine A costs ` 1,00,000 payable immediately. Machine B costs ` 1,20,000 half
payable immediately and half payable in one year's time. The cash receipts expected
are as follows :
Year (at end) Machine A Machine B
1 ` 20,000 —
2 60,000 ` 60,000
3 40,000 60,000
4 30,000 80,000
5 20,000 —
At 7% opportunity cost, which machine should be selected on the basis of NPV?
Q. 2. A company is considering a new project for which the invest-ment data are as follows:
Capital outlay ` 2,00,000
Depreciation 20% p.a.
Forecasted annual income before charging depreciation, but after all other charges
are as follows:
Year 1 ` 1,00,000
2 1,00,000
3 80,000
4 80,000
5 40,000
4,00,000
On the basis of the available data, set out calculations, illustrating and comparing
the following methods of evaluating the return :
(a) Payback method.
(b) Rate of return on original investment.
Q. 5.P. Ltd. has a machine having an additional life of 5 years which costs ` 10,00,000 and
has a book value of ` 4,00,000. A new machine costing `20,00,000 is
available.Though its capacity is the same as that of the old machine, it will mean
a saving in variable costs to the extent of ` 7,00,000 per annum. The life of the
machine will be 5 years at the end of which it will have a scrap value of ` 2,00,000.
The rate of income-tax is 40% and P. Ltd.'s policy is not to make an investment if
the yield is less than 12% per annum. The old machine, if sold today, will realise
1,00,000; it will have no salvage value if sold at the end of 5 th year. Advise P. Ltd.
whether or not the old machine should be replaced.
Q. 6.The expected cash flows of three projects are given below. The cost of capital is 10
per cent.
(a) Calculate the payback period, net present value, internal rate of return and
accounting rate of return of each project.
(b) Show the rankings of the projects by each of the four methods.
Period Project A (`` ) Project B(` ` )
0 (5,000) (5,000)
1 900 700
2 900 800
3 900 900
4 900 1,000
5 900 1,100
6 900 1,200
7 900 1,300
8 900 1,400
9 900 1,500
10 900 1,600
: 15 : CAPITAL BUDGETING
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Q. 7. Lockwood Limited wants to replace its old machine with a new automatic machine. Two
models A and B are available at the same cost of ` 5 lakhs each. Salvage value of the
old machine is ` 1 lakh. The utilities of the existing machine can be used if the company
purchases A. Additional cost of utilities to be purchased in that case are ` 1 lakh. If the
company purchases B then all the existing utilities will have to be replaced with new
utilities costing ` 2 lakhs. The salvage value of the old utilities will be ` 0.20 lakhs. The
earnings after taxation are expected to be:
(cash in-flows of)
Year A B P.V. Factor
` ` @ 15%
1 1,00,000 2,00,000 0.87
2 1,50,000 2,10,000 0.76
3 1,80,000 1,80,000 0.66
4 2,00,000 1,70,000 0.57
5 1,70,000 40,000 0.50
Salvage Value at the end of Year 5 50,000 60,000
The targeted return on capital is 15%. You are required to (i) Compute, for the two
machines separately, net present value, discounted payback period and desirability factor
and (ii) Advice which of the machines is to be selected.
: 17 : CAPITAL BUDGETING
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Q. 2. ABC Ltd. is currently producing 2000 units per month. It is contemplating to increasing the
monthly production to 4000 units by working an extra shift in such a way that the work
started in the first shift will continue in the extra shift. A quantity discount of 10% on all
purchase of raw material is expected from supplier. The selling price, variable costs and
fixed costs would remain same. Following is the income statement for the current year :
Income Statement
Sales (24,000 x ` 18) ` 4,32,000
Less : Raw Material (24,000 x ` 6) ` 1,44,000
Wages - Variable (24,000 x ` 3) 72,000
- Fixed 48,000
Overheads - Variable (24,000 x 1) 24,000
- Fixed 96,000 3,84,000
Profit 48,000
: 18 : ESTIMATION OF WORKING CAPITAL
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Other Information :
(a) The credit period allowed to customers is 3 months and would remain same.
(b) The lag period for payment of suppliers would remain same at 2 months.
(c) Wages and overheads are paid with a lag of half a month and would be same.
(d) Finished goods stock at present is maintained at 4500 units. Raw material
holding period is 3 months.
(e) The work-in-progress period is 1 month and is valued at prime cost.
You are required to prepare the income statement for next year after the increase in
monthly production is introduced. Also find out the working capital requirement, both
at present and for next year.
Q. 3. Shellcal Limited sells goods at a uniform rate of gross profit of 20% on sales including
depreciation as part of cost of production. Its annual figure are as under :
(` )
Sales (At 2 months' credit) 24,00,000
Materials consumed (Suppliers credit 2 months) 6,00,000
Wages paid (Monthly at the beginning of the subsequent month) 4,80,000
Manufacturing expenses (Cash expenses are paid - one month in arrear) 6,00,000
Administration expenses (Cash expenses are paid - one month in arrear) 1,50,000
Sales promotion expenses (Paid quarterly in advance) 75,000
The company keeps one month stock each of raw materials and finished goods. A
minimum cash balance of ` 80,000 is always kept. The company wants to adopt a
10% safety margin in the maintenance of working capital. The company has not
work - in - progress.
Find out the requirements of working capital of the company on cash cost basis.
Q. 4. From the following information of XYZ Ltd., you are required to calculate :
(a) Net operating cycle period.
(b) Number of operating cycles ina year.
(` )
(i) Raw material inventory consumed during the year 6,00,000
(ii) Average stock of raw material 50,000
(iii) Work-in-progress inventory 5,00,000
(iv) Average work-in-progress inventory 30,000
(v) Finished goods inventory 8,00,000
(vi) Average finished goods stock held 40,000
(vii) Average collection period from debtors 45 days
(ix) No. of days in a year 360 days
RECEIVABLE MANAGEMENT
CHAPTER - 8
Q. 1.Radiance Garments Ltd. manufacturers ready-made garments and sells them on credit
basis through a network of dealers. Its present sale is ` 60 lakhs per annum with 20
days credit basis through a network of dealers. The company is contemplating an
increase in the credit period with a view to increasing sales. Present variable costs are
70% of sales and the total fixed costs ` 8 lakhs per annum. The company expects
pre-tax return on investment @ 25%. Some other details are given as under :
Proposed Credit Policy Average Collection Period Expected Annual Sales
(days) (` Lakhs)
I 30 65
II 40 70
III 50 74
IV 60 75
Required : Which credit policy should the company adopt? Present your answer in
a tabular form. Assume 360 days a year. Calculations should be made upto two
digits after decimal.
Q. 3.A company is presently having credit sales of ` 12 lakh. The existing credit terms are
1/10, net 45 days and average collection period is 30 days. The current bad debts
loss is 1.5%. In order to accelerate the collection process further as also to increase
sales, the company is contemplating liberalization of its existing credit terms of 2/
10, net 45 days. It is expected that sales are likely to increase by 1/3 of existing
sales, bad debts increase to 2% of sales and average collection period to decline
to 20 days. The contribution to sales ratio of the company is 22% and opportunity
cost of investment in receivables is 15 percent (pre-tax). 50 per cent and 80 per
cent of customers in terms of sales revenue are expected to avail cash discount
under existing and liberalization scheme respectively. The tax rate is 30%.
Should the company change its credit terms? (Assume 360 days in a year).
: 21 : RECEIVABLE MANAGEMENT
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Q. 4. A company currently has an annual turnover of ` 50 lakhs and an average collection
period of 30 days. The company wants to experiment with a more liberal credit
policy on the ground that increase in collection period will generate additional sales.
From the following information, kindly indicate which policy the company should adopt:
Credit Policy Average Collection Period Annual Sales ( ` lakhs)
A 45 days 56
B 60 days 60
C 75 days 62
D 90 days 63
Costs : Variable cost : 80% of sales
Fixed Cost : ` 6 lakhs per annum
Required (pre-tax) return on investment : 20%
A year may be taken to comprise of 360 days.
Q.5. A Ltd has total sales of ` 3.2 crores and its average collection period is 90 days.
The past experience indicates that bad-debts losses are 1.5% on sales. the
expenditure incurred by the firm in administering its reveivable collection efforts are
5,00,000. A factor is prepared to buy firm's receivable by charging 2% commission.
The factor will pay advance on reveivable to the firm at an interest rate of 18%
p.a. withholding 10% as Reserves. Calculate efective lost of factoring to the firm.
: 22 : RECEIVABLE MANAGEMENT
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
CHAPTER - 9
FUND FLOW STATEMENT
Q. 1. Balance Sheets of OP Ltd. as on 31st March 2013 and 2014 are as follows :
Additional Information :
1. New Machinery for 3,00,000 was purchased but an Old Machinery Costing 1,45,000
was sold for 50,000, and Accumulated Depreciation thereon was 75,000.
3. Investments were sold for 45,000, and its profit was transferred to General Reserve.
5. An Interim Dividend of 1,20,000 has been paid during the year 2013-2014.
6. Assume the Provision for Taxation as Current Liability and Proposed Dividend
as Non - Current Liability.
Prepare :
Note : Debtors are net of Provision for Doubtful Debts of 45,000 and 56,250
respectively for 2013 and 2014 respectively.
Additional Information :
1. During the year 2013-2014, Fixed Assets with a Net Book Value of 11,250
(Accumulated Depreciation = 33,750) was sold for 9,000.
5. During the year 2013-2014, Bad Debts of 15,750 were written off against the
Provision for Doubtful Debts A/c.
Balance Sheet
Income Statement for the year ended March 31, 2014 (in )
Additional Information :
1. Machinery with a Net Book Value of 9,150 was sold during the year.
Additional Information :
1. During the year, additional equity capital was issued to the extent of 25,000
by way of bonus shares fully paid up.
2. Final dividend on preference shares and an interim dividend of 4,000 on
equity shares were paid on 31st March, 2014.
3. Proposed dividends for the year ended 31st March, 2013 were paid in October, 2014.
4. Movement in Reserve for replacement of machinery account represents transfer
to Profit and Loss Account.
5. During the year, one item of plant was upvalued by 3,000 and credit for this
was taken in the Profit and Loss Account.
6. 1,700 being expenditure of fixed assets for the year ended 31st March, 2013
wrongly debited to Sundry Debtors then, was corrected in the next year.
7. Fixed Assets costing 6,000 (accumulated depreciation 4,800) were sold
for 250. Loss arising therefrom was written off.
8. Preference shares redeemed during the year were out of a fresh issue of equity
shares. Premium paid on redemption was 10%.
Q. 2. The Balance Sheet JK Limited as on 31st March for two years are given below - (` 000s)
Liabilities Year 1 Year 2 Assets Year 1 Year 2
Share Capital 1,440 1,920 Fixed Assets 3,840 4,560
Capital Reserve ---- 48 Less : Depreciation 1,104 1,392
General Reserve 816 960 Net Block 2,736 3,168
P & L A/c 288 360 Investments 480 384
9% Debentures 960 672 Cash 210 312
Current Liabilities 576 624 Other Current Assets
Proposed Dividend 144 174 (including Stock) 1,134 1,272
Provision for Tax 432 408 Preliminary Expenses 96 48
Unpaid Dividend ---- 18
Total 4,656 5,184 Total 4,656 5,184
Q. 3. Prepare a Cash Flow Statement as per AS 3 (Revised) from the following information -
(Direct & Indirect Method)
Summarized Balance Sheet of XYZ Ltd. as on 31st March, 2013 and 2014. (` in 000')
Profit and Loss Account for the year ended 31st March, 2014
Particulars ` 000s Particulars ` 000s
To Opening Stock 806 By Sales 6,331
To Purchases 2,080 By Closing Stock 1,105
To Wages 650
To Gross Profit c/d 3,900
Total 7,436 Total 7,436
: 28 : CASH FLOW STATEMENT
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Q. 4. Balance Sheet of a Company as on 31st March, 20X1 and 20X2 were as follows :
Additional Information :
1. Investments were sold during the year at a profit of ` 15,000.
2. During the year, an old machine costing ` 80,000 was sold for ` 36,000. Its
WDV was ` 45,000.
3. Depreciation charged on Plant and Machinery at 20% on the Opening Balance.
4. There was no purchase or sale of Land and Building.
5. Provision for tax made during the year was ` 96,000.
6. Preference Shares were issued for consideration of cash during the year.
From the above, prepare -
(a) Cash Flow Statement as per AS - 3
(b) Schedule of Changes in Working Capital.
`
The Company made the following estimates for the financial year :
1. The Company will pay a free of tax dividend of 10% of rate of tax being 25%.
2. The Company will acquire Fixed Assets costing ` 1,90,000 after selling one
machine for ` 38,000 costing ` 95,000 and on which depreciation provided
amounted to ` 66,500.
3. Stocks and Debtors, Creditors and Bills Payable at the end of financial year
are expected to be ` 5,60,500, ` 1,48,200 and ` 98,800 respectively.
4. The Profit would be ` 1,04,500 after depreciation of ` 1,14,000.
Prepare Projected Cash Flow Statement & ascertain the Bank Balances of X Ltd.
at the end of the financial year.
CHAPTER - 11
CASH BUDGETS
Q. 1. Prepare monthly cash forecast for the company XYZ Ltd. for the quarter ending
31st March, from the following details :
(i) Opening balance as on 1st January is ` 22,000.
(ii) Its estimated sale for the month of January and February ` 1,00,000 each
and for the month of March is ` 1,20,000. The sale for November and
December of the previous year have been ` 1,00,000 each.
(iii) Cash and credit sales are estimated 20% and 80% respectively.
(iv) The receivables from credit sales are expected to be collected as follows :
50% of the receivable on an average of one month from the date of sales ;
and balance 50% after the two months from the date of sale. No bad debts
on the realization of sales.
(v) Other anticipated receipt is ` 5,000 from the sale of machine in March.
The forecast of payment is as follows :
(a) The purchase of materials worth ` 40,000 in January and February and
materials worth ` 48,000 in March.
(b) The payments for these purchases are made approximately a month after the
purchase. The purchase for December of the previous year have been
` 40,000 for which the payment will be made in January.
(c) Miscelleneous cash purchase of ` 2,000 per month.
(d) The wages payments are expected to be ` 1,500 per month.
(e) Manufacturing expenses are expected to be ` 20,000 per month.
(f) General selling expenses are expected to be ` 10,000 per month.
(g) A machine worth ` 50,000 is proposed to be purchased on cash in March.
Q. 2. Lal & Co. has given the forecast sales for January 2014 to July 2014 and actual
sales for November and December 2013 as under. With the other particulars given,
prepare a Cash Budget for the months i.e. from January to May 2014.
(i) Sales
November ` 1,60,000
December ` 1,40,000
January ` 1,60,000
February ` 2,00,000
March ` 1,60,000
April ` 2,00,000
May ` 1,80,000
June ` 2,40,000
July ` 2,00,000
: 31 : CASH BUDGETS
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
(ii) Sales 20% cash, and 80% credit, credit period two months.
(iii) Variable expenses 5% on turnover, time lag of half month.
(iv) Commission 5% on credit sale payable in two months.
(v) Purchases are 60% of the sales. Payment will be made in 3rd month of purchases.
(vi) Rent ` 6,000 paid every month.
(vii) Other payments : Fixed assets purchases - February ` 36,000 and March
` 1,00,000 ; Taxes - April 40,000.
(viii) Opening cash balance ` 50,000.
Q. 3. Vivek & Co. are manufacturers of check valves which are sold at ` 50 each. The
cost data are :
(a) Variable manufacturing cost : ` 25 per unit.
(b) Variable selling expenses : ` 5 per unit.
(c) Fixed manufacturing cost paid in cash : ` 1.5 lacs.
Fixed selling expenses : ` 1 lac payable in cash each month.
(d) Depreciation : ` 30,000 per month.
Other Information :
(i) The company's policy is to hold at the end of each month an inventory of
finished goods representing targeted production for next two months. Opening
inventory on 1st January was 30,000 units.
(ii) The raw material required each month is purchased in cash which is included
in Variable manufacturing cost of ` 25. No inventory of raw material is held.
(iii) All sales are on credit. Collection is 50% in the same month and the balance
in the following month. The debtors balance was ` 4 lacs on 1st Janaury.
(iv) All manufacturing costs are paid in cash in the month of production.
(v) The company pays 80% of its Variable selling expenses in the month of sale
and the balance in the following month. On 1st January, the company owed
` 25,000 for December expenses.
(vi) The minimum desired cash balance is ` 50,000 which is held on 1st January.
(vii) The company borrows at the beginning of the month and repays at the end,
amount available in excess of ` 50,000.
Ignore interest.
(viii) The sales budget is :
Month Units Month Units
January 15,000 February 20,000
March 25,000 April 27,000
May 30,000 June 30,000
Prepare cash budget of the company (i) for January, February and March ; and
(ii) in total.
: 32 : CASH BUDGETS
SOLUTIONS
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
ACCOUNTING RATIOS
Stock + QA : CL
0.5 + 1 1
p p p
3,75,000 (?) (?)
= 7,50,000 7,50,000
26,25,000 26,25,000
Working notes:
(a) G.P. Ratio = 25%
Sales = COGS+ GP
100 = 75 25
30,00,000 (?)
= 22,50,000
:2 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
(d) Fixed Assets : Net worth
1.2 : 1
p p
(?) 12,50,000
= 15,00,000
? F = 3,35,000
:3 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
? Opg stock = 3,35,000
= 1
x 365 = 36.5 days
10
1
= x 365 = 45.625
8
(vii) Current Assets & Current Liabilities
CR = 2.4 :1
W.C = CA (-) CL
p p p
1.4 2.4 1
p p p
2,80,000 (?) (?)
= 4,80,000 2,00,000
? CA = 4,80,000
CL = 2,00,000
:4 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Ans. 4. (i) Quick Ratio
Q.A = Cash + Debtors + Short term Invetsments
=
Q.L C.L.
Equity = 8,70,000
PAT 2,62,500
(-) P.D. (18,000)
Earnings for E.S.H.S 2,44,500
yno. of equity shares 60,000
EPS 4.075
Ans. 6. (i) Average stock = Opg stk+ Clg Stock = ( 2407 + 2867)
2 2
= 2637
34 x 100 = 1.77 %
=
1472 +2377
2
= 22 days
:7 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Ans. 7. (a) Calculation of operating expenses.
Sales 6,00,000
Less: COGS 18,00,000
G.P. 42,00,000
Less: Operating Exp. 33,90,000
EBIT 8,10,000
Less: Interest on Debentures 60,000
EBT 7,50,000
Less: Tax @ 50% 3,75,000
EAT @ 6.25% 3,75,000
Balance Sheet as at 31st March
Liabilities ` Assets `
Share capital 10,50,000 Fixed Assets 17,00,000
Reserves & Surplus 4,50,000 Stock 1,50,000
15% Debentures 4,00,000 Debtors 2,00,000
Sundary creditors 2,00,000 Cash 50,000
21,00,000 21,00,000
Stock T/O = COGS
Clg stk
12 = 18,00,000 ?closing stock = 1,50,000
Closing stock
CR = CA = 2
CL
2 = CA ? CA = 4,00,000
2,00,000
25 = 3,75,000 x 100
equity
? Equity = 2,50,000
7:3
Share capital R&S
= 10,50,000 4,50,000
:8 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
LEVERAGES
Ans. 1. Income Statement
` `
` ` ` `
`
EBIT
` `
` `
Ans. 3. Contribution:
C = S - V and
EBIT = C- F
10,00,000 = C - 20,00,000
?C
? = 30,00,000
Operating leverage = C / EBIT = 30,00,000/10,00,000 = 3 times
Financial leverage - EBIT/EBT = 10,00,000/8,00,000 = 1.25 times
Combined leverage = OL x FL = 3 x 1.25 = 3.75 times
: 10 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Where, C = Contribution
S = Sales
V = variable cost
Ans. 5. `
Sales 24,00,000
Less: Variable cost (12,00,000)
Contribution 12,00,000
Less: Fixed cost (10,00,000)
EBIT 2,00,000
Less: Interest (1,00,000)
EBT 1,00,000
Less: Tax (50%) (50,000)
EAT 50,000
No. of equity shares 10,000
EPS 5
: 11 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
(a) Operating Leverage = 12,00,000 = 6 times
2,00,000
(b) Financial Leverage = 2,00,000 = 2 times
1,00,000
(c) Combined Leverage = DOL x DFL - 6 x 2 = 12 times.
(d) R.O.E. = 50,000 x 100 = 5%
10,00,000
(e) Operating Leverage = 6
% age change in EBIT %
6 =
% age change in Sales
Ans. 6.(a) Calculation of Degree of Operating (DOL), Financial (DFL) and Combined
leverages(DCL).
` 3,40,000 - ` 60,000
DOL = = 1.27
` 2,20,000
DFL = 2,20,000
1,60,000
DCL = DOL x DFL = 1.27 x 1.37 = 1.75
(b) Earnings per share at the new sales level
: 12 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
CAPITAL STRUCTURE
Ans. 1. Calculation of Earning Per share under the three options:
P articulars Option I Option II Option III
(Equity Only) (Debenturesonly) (Equity & Debentures)
Number of Equity shares (lakhs):
Existing 10 10 10.00
New issued 2 - 0.50
50L 25L
25 50
Total 12 10 10.50
1 6% debentures NIL 50 25
Estimated total Income:
From current Operations 60 60 60
From new projects 40 40 40
EBIT 100 100 100
Less: Interest on 16% debentures ---- 8 4
Profit before tax 100 92 96
Less: Tax at 50% (50) (46) (48)
Profit after tax 50 46 48
EPS ` 4.17 ` 4.60 ` 4.57
Advise : Option II i.e., issue of 16% debentures is most suiatable to maximise the
earning per share.
: 13 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Statement showing computation of EPS and Financial Leverage (Amount in `)
Particulars Plan I Plan II Plan III PlanIV
EBIT 4,00,000 4,00,000 4,00,000 4,00,000
Less: Interest on 12% loan - (24,000) - -
Less: Interest on 9% Debentures - - (27,000) -
EBT 4,00,000 3,76,000 3,73,000 4,00,000
Less : Tax (40%) (1,60,000) (1,50,400) (1,49,200) (1,60,000)
EAT 2,40,000 2,25,600 2,23,800 2,22,000
Less: Preference Dividends@ 6% - - - (18,000)
Earnings available for equity shareholders (A) 2,40,000 2,25,600 2,23,800 2,22,000
No. of Equity shares (B) 1,60,000 1,40,000 1,30,000 1,30,000
(i) EPS (A) 1.50 1.61 1.72 1.71
(B)
(ii) Degree of financial Leverage (DFL) 4,00,000 4,00,000 4,00,000 4,00,000
EBIT 4,00,000 4,00,000 4,00,000 4,00,000-18,000
EBI- Preference Div (1-0.40)
(1-t) = 1.00 = 1.06 = 1.07 = 1.08
Ans. 4. If financing agencies insist 2 : 1 Debt Equity ratio then company has two options;
(i) To arrange whole amount the company as issue equity shares.
(ii) Company should arrange 3 crores by 12% term loan and 1.50 crore through
equity share so that 2:1 Debt-equity ratio can be maintained.
In first option interest will be Zero and in second option the interest will be
` 36,00,000 Let EBIT be x
(X-I1) (1-T) = (X-I2) (1-T)
N1 N2
Or (X-0) (1- 0.5) = (X- 36 Lakhs) (1-0.5)
45 Lakhs 15Lakhs
Or 0.5x = 0.5x18
45 15
Or 7.5x = 22.5x - 810
Or 810 = 22.5x - 7.5x
Or 810 = 15x
810 = 54 Lakhs
X=
15
EBIT at point of indifference will be ` 54 Lakhs.
: 14 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Ans. 5. In order to determinne the indifference level of EBIT, the EPS under the alternative
plan should be equated as follows:
(EBIT -0.12 x ` 4,00,000) ( 1- 0.35)= (EBIT - 0.12 x ` 4,00,000) (1-0.35)- (0.14 x ` 2,00,000)
60,000 40,000
or (0.65 EBIT - ` 31,200) (0.65 EBIT - ` 31,200) = (0.65 EBIT - ` 56,200)
3 2
or 1.30 EBIT - ` 62,4000 = 1.95 EBIT - ` 1,77,600
or (1.95-1.30) EBIT = ` 1,77,600 - ` 62,400
or EBIT = ` 1,15,200
0.65
or EBIT = 1,77,231
Ans. 7.1. Calculation of EPS ( When only equity shares are issued)
I II III
EBIT 40,00,000 80,00,000 1,00,00,000
Less: Interest on 12% Debt (3,00,000) (3,00,000) (3,00,000)
EBT 37,00,000 77,00,000 97,00,000
Less : Tax @ 50% (18,50,000) ( 38,50,000) (48,50,000)
EAT 18,50,000 38,50,000 48,50,000
No. of equity shares 18,00,000 18,00,000 18,00,000
10 lakhs + 1Cr
12.5
EPS ` 1.03 ` 2.14 ` 2.69
P/E ratio 5 5 5
MPS 5.15 10.70 13.45
2. Calculation of EPS (When only 14% debts are issued)
Particulars I II III
EBIT 40,00,000 80,00,000 ,00,00,000
Less: Interest
- on 12% debt (3,00,000) (3,00,000) (3,00,000)
- on 14% debt (14,00,000) (14,00,000) (14,00,000)
EBT 23,00,000 63,00,000 3,00,000
Less Tax @ 50% 11,50,000) (3150000) (41,50,000)
EAT = EAE 11,50,000 31,50,000 41,50,000
No. of equity 1,00,000 10,00,000 10,00,000
EPS 1.15 3.15 4.15
P/E 4 4 4
MPS ` 4.60 ` 12.60 ` 16.60
: 16 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
3. Calculation of Indiffrence point
Plan A (Equity) Plan B (Debt)
= (EBIT - interest) (1-t) = (EBIT - interest) (1-t)
NA NB
= (EBIT - 30000) (1-0.5) = (EBIT - 1700000) (1-0.5)
1800000 1000000
= 10 EBIT - 30,00,000 = 18 EBIT - 3,06,00,000
8 EBIT = ` 2,76,00,000
EBIT = ` 34,50,000
: 17 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
COST OF CAPITAL
Ans.1. (i) 7.68% (ii) 9.52% (iii) 13% (iv)12%
(v) 10.75% and 11% and (vi) 19.18%
Ans.3. In order to calculate the WACC, the specific cost of equity capital and debt are to be
calculated as follows:
D1 ` 2 x 1.10
Ke= + g = + 0.10 = 18%
P0 ` 27.50
The market value of equity is 80,000 x ` 27.50 = ` 22,00,000
I ` 12
Kd = = = 15%
B0 ` 80
Working Note:
The new weights of different sources have been calculated as follows:
Equity (5/10-1/6) = 1/3 = 5/15
Preference share (2/10-1/15) = 2/15
12% Debentures (3/10 -1/10) = 1/5 = 3/15
Loan (New) ( 1/10 + 1/15 + 1/6) = 5/15.
10
= + 0.06
100
= 0.11509 or 15.09%
(2) Revised cost of Eqiuty shares ( Ke)
12
Revised Ke = + 0.06
105
= 0.1742 or 17.42%
Shareholders Personal Tax Rate is not considered since Dividends are exepmt from
Tax in their hands.
: 20 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Ans.9. 1. Computation of cost of Additional Capital (Component wise)
Interest x (100% - Tax Rate) = 14 x (100% - 50%) = 6.63%(Note1)
1. (a) After Tax Cost of New Debt Kd =
Net Prodeeds of Issue 105.54
Preference Dividend ` 1.20
1.(b) After Tax Cost of new Preference share capital Kp = = = 12.24%
Net prodeeds of Issue ` 9.80
DPS
1.(c) After Tax Cost of ordinary Equity ke = + g ` 2.773 x 50% + 12% = 5% + 12% = 17.00% (Note 2)
MPS
Note 1: Since Current 13% Debentures is selling at ` 98 (` 100 presumed as par value), the
Company can sell 14% New Debentures at 14% x ` 98
= `105.54
13%
Note 2: For computing "g" i.e., Growth Rate under Realised yeild Method, the past average Growth
rate is taken at 12%, in the following manner-
Year 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
EPS (` `) 1.00 1.120 1.254 1.405 1.574 1.762 1.974 2.211 2.476 2.773
Additional EPS - 0.120 0.134 0.151 0.169 0.188 0.212 0.237 0.265 0.297
% increase in EPS - 12.00% 11.96% 12.04% 12.03% 11.94% 12.03% 12.01% 11.99% 12.00%
2. Marginal Cost of capital : Since the present Capital structure is optimum (Refer 1 st
sentence in the question), the additional funds will be raised in the same ratio in ored
to maintain the capital structure. Hence , the Marginal Cost of Capital is 15.20%,
computred as under:
Component ` % Individual Cost WACC
Debt 3,60,000 15% K d = 6.63% 0.99%
Preference Capital 1,20,000 5% Kp = 12.24% 0.61%
Equity Capital 19,20,000 80% Ke = 17.00% 0.13.60%
Total 24,00,000 100% WACC = Ko 15.20%
Note : When Kd is taken at 7.14% Ko will be 15.28%.
CAPITAL BUDGETING
Ans. 1. Calculation of NPV
Machine A Machine B
Year Cash flows PVF(7%n) PV (ìì ) Cash flows PVF (7%) PV ( `)
`
0 - ` 1,00,000 1.000 -1,00,000 - `
`60,000 1,000 -60,000
1 20,000 .935 .18,700 - ` 60,000 .935 -56,100
2 60,000 .873 52,380 60,000 .873 52,380
3 40,000 .816 32,640 60,000 .816 48,960
4 30,000 .763 22,980 80,000 .763 1,040
5 20,000 .713 14,260 ----- ---- ----
NPV 40,870 46,280
Machine B is having higher : NPV and may be selected.
Ans.2. Since there is no tax , the annual income befo re depreciation and after other changes
is equivalent to cash Flows (CF).
(a) Capital outlay of ` 2,00,000 is recovered in the first two years, ` 1,00,000
(year + 1) + `1,00,000 (year 2 ), therefore, the payback period is two years.
(b) Rate of return on original investment.
Year Income (`
`) Depreciation (`
`) Net Income (``)
1 1,00,000 40,000 60,000
2 1,00,000 40,000 60,000
3 80,000 40,000 40,000
4 80,000 40,000 40,000
5 40,000 40,000 -
2,00,000
Average Income = ` 2,00,000 / 5 = ` 40,000
Average income
Rate of Return = x 100
Original investment
= ` 40,000 x 100 = 20%
` 2,00,000
By interpolation between 13% and 14%, the IRR comes 13.56%. The results of the
above calculations may be summerized as follows:
Project X Project Y
NPV ` 16,130 ` 6,550
PI 1.161 1.065
IRR 14.71% 13.56%
: 23 :
J. K. SHAH CLASSES I .P. C. C. - FINANCIAL MANAGEMENT
Ans. 5. 1. Cash Outflows
Cost of new machine ` 20,00,000
- Scrap value of old 1,00,000 ` 19,00,000
2. Cash Inflow (Annual):
Net savings in variable costs ` 7,00,000
: 24 :
J. K. SHAH CLASSES I .P. C. C. - FINANCIAL MANAGEMENT
IRRB
Year Cash Flow 10% discount Present value 20% Present
(`
`) factor (`
`) discount value
factor (`
`)
0 (5,000) 1,000 (5,000) 1.000 (5,000)
1 700 0.909 636 0.833 583
2 800 0.826 661 0.694 555
3 900 0.751 676 0.579 521
4 1,000 0.683 683 0.482 482
5 1,100 0.621 683 0.402 442
6 1,200 0.564 677 0.335 402
7 1,300 0.513 667 0.279 363
8 1,400 0.467 654 0.233 326
9 1,500 0.424 636 0.194 291
10 1,600 0.386 618 0.162 259
1,591 (776)
Interpolating: IRR = 10 + 1,591 x10 = 10 + 6.72 = 16.72 per cent
: 25 :
J. K. SHAH CLASSES I .P. C. C. - FINANCIAL MANAGEMENT
Ans. 7(i) Expenditure at year zero (`
` in lakhs)
Particulars A B
Cost of machine 5.00 5.00
Cost of utilities 1.00 2.00
Salvage of Old Machine (1.00) (1.00)
Salvage of Old utilities - (0.20)
Total Expenditure (Net) 5.00
Ans.8.1. Given (a) Initial Investment = ` 80,000, (b) Project life = 8 years and (c) Cost of
capital = 10%
2. Depreciation p.a. (assuming SLM) = ` 80,000 - ` 6,000 = ` 9,250
8 years
3. Computation of Additional CFAT p.a from New Machine :
Particulars Computation `
Gross Revenue Given 40,000
Less: Operating Costs, i.e., Cash Expenses Given -7,500
Non- Cash, i.e. Depreciation WN 2 -9,250
EBT 23,250
Less: Tax Assumed 40% -9,300
EAT 13,950
Add: Depreciation WN 2 -9,250
CFAT (EAT + Depreciation) 23,200
Less: Post-Tax Commission Income from existing operation Given - 12,000
Additional CFAT p.a.by purchasing new
Diagnostic Machine 11,200
4. Computation of Discounted Cash Flows, NPV and PI
Year Cash Flow Disc. Factor at 10% DCFAT
1-8 Additional CFAT p.a= 11,200 (0.909 +0.826 +0.751 +0.683 +0.621+ 0.564+ 0.513 + 0.467) 59,741
8 Salvage Value of M/c = 6,000 0.467 2,802
Total DCFAT 62,543
Less: Initial Investment - 80,000
Net Present Value (17,457)
` 62,543
Probability Index 0.78
` 80,000
Conclusion:The purchase ofnew Diagnostic Machine is not worthwhile, since NPV is
negative, and PI is less than 1.
Ans. 9. 1. Computation of CFAT of the Drying Equipment
: 27 :
J. K. SHAH CLASSES I .P. C. C. - FINANCIAL MANAGEMENT
(?) 229109
Ans.10. 1. Computation of CFAT
Particulars Existing Machine New Machine
(a) Initial Investment (Old M/c already available ) Hence, Nil (see Note) = ` 8,00,000
(b) Life Balance 8 years 8 years
3,30,000 10,00,000 - ` 40,000
= ` 30,000 = 1,20,000
(c) Depreciation 11 years 8 years
(d) selling Price Less Materials Cost ` 15 - ` 4 = ` 11 p.u ` 15 - ` 4 = ` 11p.u.
(e) Quatity 30,000 units 75,000 units
(f) Total Contribution (d x e) ` 3,30,000 8,25,000
(g) Labour Cost 3,000 hrs at ` 40 ph = ` 1,20,000 3,000 hrs at 70Ph = ` 2,10,000
(h) indirect Cost ` 50,000 ` 65,000
(i) EBT (f- g- h-c) ` 1,30,000 ` 4,30,000
(j) Tax at 30% on EBT ` 39,000 ` 1,29,000
(k) EAT (i-j) ` 91,000 ` 3,01,000
(l) CFAT (k+ c) ` 1,21,000 ` 4,21,000
: 28 :
J. K. SHAH CLASSES I .P. C. C. - FINANCIAL MANAGEMENT
Conclusion:It is advisable to purchase the new machinery, since additional NPV is positive
: 29 :
J. K. SHAH CLASSES I.P.C.C. - FINANCIAL MANAGEMENT
Ans. 2. The comparative statement of working capital requirement may be prepared sa under:
Statement of working Capital Requirement
Current Year Next Year
Current Assets:
Raw Material (2,000 X6 X3) ` 36,000 (4,000 X 5.40 X 3) `64,800
Work in Progress:
Raw Material (2,000 x 6 X 1) 12,000 (2,000 X 5.40 x 1) 10,800
Wages - Variable (2,000 x 3 x 50%) 3,000 (2,000 X 3 X 50%) 3,000
- Fixed (4,000 x 50%) 2,000 (4,000 x 50%) 2,000
Finished goods (3,84,000 y24,000) x 4,500 72,000 (5,95,200 y 48,000)9,000 1,11,600
Debtors (3,84,000 y 12) x 3 96,000 (5,95,200 y12) x 3 1,48,800
2,21,100 3,41,000
Current Liabilities:
Creditors (2,000 x 2 x 6) 24,000 (4,000 x 2 x 5.40) 43,200
Wages (72,000 + 48,000) y 24 5,000 (1,44,000 + 48,000) y 24 8,000
Overheads (24,000 + 96,000) y 24 5,000 (48,000 + 96,000) y 24 6,000
34,000 57,200
Working Capital (CA - CL) 1,87,000 2,83,800
Assumptions:
(i) Debtors are taken at cost price
(ii) As work in progress is consisting of prime cost (i.e., Material + Labour), it is
Particulars Computation `
A. Current Assets
Raw material (bsed on RM Consumed) ` 6,00,000 x
Debtors (based on sales Less Profit & Deprn) ` 24,00,000 - ` 2,55,000 + ` 2,40,000 ) x 2
(` 3,17,500
: 32 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
RECEIVABLES MANGEMENT
Ans. 1. Statement showing Evaluation of the Proposed Credit Policies
(Amount ` in Lakhs)
Credit Policies
Proposed
Present I II III IV
Average Collection Period (20 days) (30 days) (40 days) (50 days) (60 days)
(days)
(70% sales)
360
Decision: The Company should be adopt the credit policy III (with collection period
of 50 days) as it yields a maximum profit to the company.
It is assumed that Debtors are valued on Total Coat.
Ans. 2.
Particulars Existing 1 mts Proposed 2 mts
Sales Qty 21,000 22,680
Sales in 8,40,000 9,07,200
(-) Variable cost (5,25,000) (5,67,000)
Contribution [A] 43,750 94,500
V.C * credit period
12
Interest lost @ 25% [B] 10,939 23,625
[A-B] 3,04,062 3,16,575
Company is advised to implement the proposed credit policy as it will increase the
profit.
: 33 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Ans. 3. Evaluation of Credit Policy
Working Notes:
(i) Calculation of Cash Discount
Cash Discount = Total credit sales x % opf customers who take up
discount x Rate
12,000 x 50 x.01
Present policy = = ` 6,000
100
Proposed Policy = 16,00,000 x 0.80 x 0.02 = ` 25,000
(ii) Opportunity cost of Investment in Receivables
Present Policy = 9,36,000 x (30/ 360) x 15% = 78,000 x 11,700
Proposed policy = 12,48,000 x (20/360) x 15% = ` 10,400
Statement Showing Evaluation Of Credit Policies
Particulars Present Policy Proposed policy
Credit sales [A] 12,00,000 16,00,000
Variables Cost @ 78% of sales [B] 9,36,000 12,48,000
Bad debts @ 1.5% and 2% [C] 18,000 32,000
Cash Discount [D] 6,000 25,600
Profit [A - B - C - D ] = [E] 2,40,000 2,94,400
Opportunity cost of Investment in Receivables [F] 11,700 10,400
Net Profit [E - F] 2,28,300 2,84,000
Advise: Proposed Policy should be adopted since the net benefit will increased by
(`
` 55,700 & post tax it will increase by 38,990,[55,700 x (1-0-3)]
Debtors are valued on Variable Cost
: 34 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Ans. 5 Annual Cost Under in-house management
Bad-debts 4,80,000
Administrative cost p.a. 5,00,000
Total 9,80,000
Assimption : Since cost of capital under in-house management is not given interest lost on
funds getting locked up under in-house management & factor reserve have been ignored.
Working notes
Amount receivable from factor for whole year 3,20,00,000
Net receivable from factor for whole year 3,13,60,000 360 days
78,40,000
: 35 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
(c) Depreciation of Buildings during the year= Closing Bal. less Opening bal.= ` 15,00,000-
` 14,00,000= ` 1,00,000
(d) Transfer to General Reserve out of current profit = ` 4,50,000 - ` 4,00,000- Invt transfer
` 17,000 = ` 33,000
(e) ` 10,00,000 - ` 8,00,000) +20% Premium =
Amount paid on redemption of debentures = (`
` 2,40,000 .
: 36 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
3.Computation of Funds from Operatios by preparing the Adjusted P& L Account-
Particulars ` Particulars `
To Loss on sale of Machinery 20,000 By balance b/d - Opening balance (given) 2,50,000
To Depereciation on Plan & Machinery 2,80,000
To Depreciation on Buildings 1,00,000
To premium on Redemption of Debentures 40,000
To Tranfer to General Reserve 33,000
To Proposed Dividend 3,60,000 By Funds from Operations (bal. fig) 9,43,000
To balance c/d - Closing balance (given) 3,60,000
Total 11,93,000 Total 11,93,000
(e) Gross Book Value of Asset Sold = Net Book Vlaue + Accum. Depreciation =
11,250 + 33,750 = 45,000.
(f) Fixed Assets purchased during the year = Closing Balance + Gross Book Value of asset
sold -Opening = ` 13,50,000 + ` 45,000 - ` 11,25,000 = ` 2,70,000.( Application of Fund )
(g) Depreciation Provided for the year = Closing Balance + Gross Book value of Asset Sold -
Opening balance = ` 2,81,250 + ` 33,750 - ` 2,25,000 = ` 90,000 (taken to Adjusted
P/L A/c).
(h) Misc. Exp. W/ off during the year = ` 16,875 - 11,250 = ` 5,625. (Taken to Adjusted
P & L A/c)
Particulars ` Particulars `
To Misc. Expenditure written off 5,625 By balance c/d (Opening Bal. in P&L A/c) 1,12,500
Sale of Invetsments (WN 2b) 1,01,250 Redemption of Debentures (WN 2c) 1,23,750
3. Proceeds from issue of shares = Difference between Closing & Opening Balance in share
capital & share Premium a/c = (1,67,50 - 1,50,000) + (3,35,000- 2,37,500) = ` 17,500 +
97,500 = 1,15,000
4. Proceeds from issue of Debentures = 2,40,000 - 75,000 for investment in A Ltd = 1,65,000
5. Trade Investment Sold = Opening Bal. Less closing Bal . Gain on sale = 1,05,000- 40,000
+ 6,400= ` 71,400
6. Amount received by Sale of Machinery = Book Value of M/c + Profit on sale = 9,150+1,850
= 11,000
7. Long Term Repaid = Opening Balance - Closing Balance = 50,000 - 40,000 = 10,000
8. Funds from Opertions = Operating + Depriciation = 91,050 + 6,600 + 11,400 = 1,09,050
Working Notes:
Fixed Assets Account
Particulars Amount Particulars Amount
To Balance b/d ` 2,40,070 By Depreciation A/c ` 4,800
To Adjusted P& L A/c 3,000 By Bank (sale) 250
To Sundry Debtors A/c 1,700 By Adjusted P & L A/c 950
To Bank ( Purchase) 14,960 By Balance c/d 2,53,730
2,59,730 2,59,730
: 41 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Working Note :
Calculation of Net profit before tax
P & L A/c at the beginning (6,000)
Add : Profit for the period [PAT] 92,500
Loss : Transfer to Reserves (30,000)
Add : Transfer from Reserves ----
Les : Proposed dividend (20,000) + (7,500)
P/L A/c at the ende 29,000
Particulars `
Less : Revaluation of opening stock will increase stock and reduce profits by
10
` 2,59,200 x
90 (28,800)
` 2,59,200
Note: Corrected Value Opening will be = ` 2,88,000
90%
Note: Other Current Assets are taken as per Balancesheet, Which includes the uncorrected
amount of stock as on 31st March of Year 1 . Hence, the uncorrected stock amount is
reduced threrfrom, to determine the Other Current Assets.
: 44 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
9. Cash Flow statement for the year ended 31st March of year 2
Particulars ` `
` 6,24,000 - ` 5,76,000)
Adjustment for : Increase in Current Liabilities (` 48,000
` 19,20,000 - ` 14,40,000)
Proceeds from issuance of share capital (` 4,80,000
E. Cash and Cash equivalents at the begainjing of the year (given) 2,10,000
F. Cash And Cash Equivalents at the end of the year (given) 3,12,000
: 45 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
Ans. 3. Cash Flow statement for the year ended 31st March 2014. [Indirect Method]
Particulars ` 000s ` 000s
A. Cash Flow from Operating Activities
Net Profit after Taxation 1,560
Add back:Provision for Taxation 1,040
Depreciation 390
Less: Divided Income (taken in investing Activities (260)
Operating profit before working capital changes 2,730
Adjustment for: Increase in stock ( 676 - 975) (299)
Increase in Debtors (728- 1,131) (403)
Increase in Prepaid selling Expenses(26-52) (26)
Increase in Creaditors (1,222 - 936) 286
Increase in outsting Rent (65- 52) 13
Cash generated from operations 2,301
Less: Income Tax Paid (OB + Provn - CB) = (520+1040 -195) (1,365)
Net Cash Flow from / (used in ) Operating Activities 936
B. CASH FLOW FROM INVESTING ACTIVITIES:
Purchase of plant and M/c (CB + Deprn- OB) = 5,525 + 390 - 3,978) (1, 937)
Dividend Income Received 250
Net Cash Flow / (used in) Investing Activities (1,677)
C. CASH FLOW FROM FINANCING ACTIVITIES
Proceeds from issue of Equity Shares (5,200 - 3,900) 1,300
Proceeds from issue of 12% Debentures (1,300 - Nil) 1,300
Dividend paid (as per P & L A/c) (650)
Net Cash Flow from / (used in) Financing Activities 1,950
D. Net Incease / (Decrease) in cash Acsh equivalents (A+ B+C) 1,209
E. Cash and cash Equivalents at the begaining of the year (494 + 26) 520
F. Cash and Cash Equivalents at the end of the year (1,677 + 52) 1,729
2. Investment Account
Particulars ` Particulars `
To Balance b/d 2,40,000 By Bank A/c (Bal. fig invts sold ) 35,000
To Profit on sale of invts (given) 15,000 By balance c/d 2,20,000
Total 2,55,000 Total 2,55,000
3. Cash Flow statement for the year ended 31st March 20x2
Particulars ` `
Particulars ` `
D. Net increase / (Decrease) in Cash & Bank Balances during the year (A +B+C) (47,500)
E. Cash & Bank Balances at the begainig of the year (Given) 66,500
( ` ` `
` `
`
` `
` ` ` `
` `
` ` `
` ` `
` ` `
` `
` `
` `
: 49 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
2. Projected Profit & Loss Statemnet of X Limited for the ended 31.3.2011
Particulars Computation `
Sale (WN 1b) 1,37,50,000
Less: Material Cost 40 % of ` 1,37,50,000 55,00,000
Labour & other production cost 45% of ` 1,37,50,000 61,87,500
Depreciation 5% of ` 1,37,50,000 6,87,500
EBIT 10% of 1,37,50,000 13,75,000
Less: Interest on Debentures (WN 1) 2,55,500
EBT 11,19,500
Less: Taxation 30% of EBT 3,35,850
EAT 7,83,650
Less: Preference Dividend 8% x ` 32,50,000 2,60,000
Residual Earnings available for Equity Shareholder 5,23,650
Less: Equity Dividend 7 % X ` 60,00,000 4,20,000
Balance carried to Balance Sheet 1,03,650
4. Projected Cash Flow Statement for the period eneded 31 st March 2011 (Indirect Method)
Particulars ` `
A. Cash Flows from Operating activities:
Net Profit before Tax and extra ordinary items 11,19,500
Adjustment for : Depreciation 6,87,500
Debenture Interest 2,55,500
Operating Profit before working Capital changes 20,62,500
Adjustyment for: Increase in Stock ` 21,75,000 - 19,50,000)
(` (2,25,000)
Decrease in Creditors ` 32,50,000 -13,75,000)
(` (18,75,000)
Decrease in Debtors ` 26,00,000 - ` 13,75,000)
(` 12,25,000
Net cash Flow From / (used in) Operating Activities 11,87,500
B. Cash Flow From Investing Activities : Purchase of fixed assets (30,00,000)
C. Cash Flow from financing activities:
Dividend on prefrence & Equity Capital ( 6,80,000)
Interest paid on Debentures (2,55,500)
Issue of 11% Debentures 5,50,000
Issue of Equity shares 30,00,000
Net Cash Flow / (used in ) Financing Activities 26,14,500
D. Net Increase/ (Decrease) in Cash & Bank during the year (A + B+ C) 8,02,000
E. Cash & Bank Balances at the begining of the year (Given) 2,50,000
F. Estimated Closing Balance of Cash & Bank (D+E) 10,52,000
: 50 :
J. K. SHAH CLASSES I. P. C. C. - FINANCIAL MANAGEMENT
CASH BUDGET
CASH BUDGET
(`in lacs)
January February March Total
Cash Balance (opening) 0.50 0.50 0.50 0.50
A. Cash Inflows from
Debtors:
Current Month @ 50% 3.75 5.00 6.25 15.00
Previous month 4.00 3.75 5.00 12.75
Total 8.25 9.25 11.75 28.25
B. Cash Outflows:
Varible Manufacturing
Costs@ 25each 7.50 6.75 7.50 21.75
Fixed Manufacturing cost 1.50 1.50 1.50 4.50
Fixed selling Expenses
Variable selling Expenses
Current month (80%) 0.60 0.80 1.00 2.40
Next month (20%) 0.25 0.15 0.20 0.60
Total 10.85 10.20 11.20 32.25
Balance -2.60 -0.95 +0.55 -4.00
Desired minimum cash
Balance +0.50 +0.50 +0.50 +0.50
Loan required 3.10 1.45 - 4.50
Repayment - - 0.05 -
Closing Balance 0.50 0.50 0.50 0.50
: 52 :