FM Formulas
FM Formulas
𝑂𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑃𝑟𝑜𝑓𝑖𝑡
ii. Operating Profit Ratio= 𝑁𝑒𝑡 𝑆𝑎𝑙𝑒𝑠
(In %)
𝑁𝑒𝑡 𝑃𝑟𝑜𝑓𝑖𝑡
iii. Net Profit Ratio= 𝑁𝑒𝑡 𝑆𝑎𝑙𝑒𝑠
(In %)
Net Profit = Net profit as per P & L A/c (either before tax or after tax, depending upon data).
iv. Contribution Sales Ratio [or] Profit Volume Ratio= Contribution/ Sales
𝐸𝑎𝑟𝑛𝑖𝑛𝑔𝑠 𝑓𝑜𝑟 𝐷𝑒𝑏𝑡 𝑆𝑒𝑟𝑣𝑖𝑐𝑒 𝑃𝐴𝑇+𝐼𝑛𝑡𝑒𝑟𝑒𝑠𝑡+𝑁𝑜𝑛 𝑐𝑎𝑠ℎ (𝑜𝑟 𝑛𝑜𝑛 𝑜𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔) 𝑒𝑥𝑝𝑒𝑛𝑠𝑒𝑠
i. Debt Service Coverage Ratio= (𝐼𝑛𝑡𝑒𝑟𝑒𝑠𝑡 + 𝐼𝑛𝑠𝑡𝑎𝑙𝑚𝑒𝑛𝑡)
= (𝐼𝑛𝑡𝑒𝑟𝑒𝑠𝑡 + 𝐼𝑛𝑠𝑡𝑎𝑙𝑚𝑒𝑛𝑡)
(In Times)
𝐸𝐴𝑇
iii. Preference Dividend Coverage Ratio= 𝑃𝑟𝑒𝑓𝑒𝑟𝑒𝑛𝑐𝑒 𝐷𝑖𝑣𝑖𝑑𝑒𝑛𝑑 (In Times)
𝐸𝐴𝐸𝑆
iv. Equity Dividend Coverage Ratio= 𝐸𝑞𝑢𝑖𝑡𝑦 𝐷𝑖𝑣𝑖𝑑𝑒𝑛𝑑
(In Times)
𝐸𝐴𝑇
v. Dividend Coverage Ratio = 𝐸𝑞𝑢𝑖𝑡𝑦 𝐷𝑖𝑣𝑖𝑑𝑒𝑛𝑑 +𝑃𝑟𝑒𝑓 𝐷𝑖𝑣𝑖𝑑𝑒𝑛𝑑
(In Times)
𝐹𝑎𝑐𝑡𝑜𝑟𝑦 𝑐𝑜𝑠𝑡
ii. WIP Turnover Ratio= 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑆𝑡𝑜𝑐𝑘 𝑜𝑓 𝑊𝐼𝑃 (In Times)
Cost of Goods Sold = For Manufacturers: OpeningStock of FG (+)Cost of Production (-) Closing Stock of FG.
For Traders: Opening Stock of FG + Cost of Goods Purchased (-) Closing Stock of FG.
(𝑂𝑝𝑒𝑛𝑖𝑛𝑔 𝐹𝐺 𝑆𝑡𝑜𝑐𝑘 + 𝐶𝑙𝑜𝑠𝑖𝑛𝑔 𝐹𝐺 𝑆𝑡𝑜𝑐𝑘)
Average Stock of Finished Goods = 2
𝐶𝑟𝑒𝑑𝑖𝑡 𝑆𝑎𝑙𝑒𝑠
iv. Debtors Turnover Ratio= 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝐴𝑐𝑐𝑜𝑢𝑛𝑡 𝑅𝑒𝑐𝑒𝑖𝑣𝑎𝑏𝑙𝑒 (In Times)
𝐶𝑟𝑒𝑑𝑖𝑡 𝑃𝑢𝑟𝑐ℎ𝑎𝑠𝑒𝑠
v. Creditors Turnover Ratio= 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝐴𝑐𝑐𝑜𝑢𝑛𝑡𝑠 𝑃𝑎𝑦𝑎𝑏𝑙𝑒
(In Times)
𝑇𝑢𝑟𝑛𝑜𝑣𝑒𝑟
vii. Fixed Assets Turnover Ratio= 𝑁𝑒𝑡 𝐹𝑖𝑥𝑒𝑑 𝐴𝑠𝑠𝑒𝑡𝑠 (In Times)
Net Fixed Assets = Net Fixed Assets (Average of Opening and Closing balances may be taken)
𝑇𝑢𝑟𝑛𝑜𝑣𝑒𝑟
[Link] Turnover Ratio = 𝐶𝑎𝑝𝑖𝑡𝑎𝑙 𝐸𝑚𝑝𝑙𝑜𝑦𝑒𝑑
(In Times)
Capital Employed = (Average of Opening and Closing balances may be taken)
𝑇𝑜𝑡𝑎𝑙 𝐷𝑒𝑏𝑡
i. Debt to Total Assets Ratio = 𝑇𝑜𝑡𝑎𝑙 𝐴𝑠𝑠𝑒𝑡𝑠
𝑇𝑜𝑡𝑎𝑙 𝐷𝑒𝑏𝑡
ii. Debt Ratio = 𝑁𝑒𝑡 𝐴𝑠𝑠𝑒𝑡𝑠
𝐸𝑞𝑢𝑖𝑡𝑦
iii. Equity to Total Funds Ratio = 𝑇𝑜𝑡𝑎𝑙 𝐹𝑢𝑛𝑑𝑠
𝑆ℎ𝑎𝑟𝑒ℎ𝑜𝑙𝑑𝑒𝑟𝑠 𝐸𝑞𝑢𝑖𝑡𝑦
iv. Equity Ratio = 𝑁𝑒𝑡 𝐴𝑠𝑠𝑒𝑡𝑠
𝑃𝑟𝑜𝑝𝑟𝑖𝑒𝑡𝑎𝑟𝑦 𝐹𝑢𝑛𝑑𝑠
vii. Proprietary Ratio = 𝑇𝑜𝑡𝑎𝑙 𝐴𝑠𝑠𝑒𝑡𝑠
Proprietary Funds = Net Worth (or) Shareholders’ Funds (or) Proprietors’ Funds (or) Owners’ Funds (or) Own
Funds
= Equity Share Capital + Preference Share Capital + Reserves & Surplus Less: Miscellaneous Expenditure (as
per Balance Sheet) and Accumulated Losses.
𝐹𝑖𝑥𝑒𝑑 𝐴𝑠𝑠𝑒𝑡𝑠
viii. Fixed Asset to Long Term Fund Ratio = 𝐿𝑜𝑛𝑔 𝑇𝑒𝑟𝑚 𝐹𝑢𝑛𝑑𝑠
V. LIQUIDITY RATIO
These ratios show a company's ability to meet its short term financial obligation like current ratio and quick
ratio.
𝐶𝑢𝑟𝑟𝑒𝑛𝑡 𝐴𝑠𝑠𝑒𝑡𝑠
i. Current Ratio= 𝐶𝑢𝑟𝑟𝑒𝑛𝑡 𝐿𝑖𝑎𝑏𝑖𝑙𝑖𝑡𝑖𝑒𝑠
𝑄𝑢𝑖𝑐𝑘 𝐴𝑠𝑠𝑒𝑡𝑠
iv. Basic Defence Interval Measure= 𝐶𝑎𝑠ℎ 𝐸𝑥𝑝𝑒𝑛𝑠𝑒𝑠 𝑝𝑒𝑟 𝑑𝑎𝑦
(In days)
𝐸𝐵𝐼𝑇
Pre-tax ROCE: = 𝐶𝑎𝑝𝑖𝑡𝑎𝑙 𝐸𝑚𝑝𝑙𝑜𝑦𝑒𝑑
𝐸𝑎𝑡 +𝐼𝑛𝑡𝑒𝑟𝑒𝑠𝑡 𝐸𝐵𝐼𝑇(1−𝑡)
Post-tax ROCE: = 𝐶𝑎𝑝𝑖𝑡𝑎𝑙 𝐸𝑚𝑝𝑙𝑜𝑦𝑒𝑑
= 𝐶𝑎𝑝𝑖𝑡𝑎𝑙 𝐸𝑚𝑝𝑙𝑜𝑦𝑒𝑑
(least preferred method)
𝐸𝐴𝑇
RONW: = 𝐸𝑆𝐻𝐹 + 𝑃𝑆𝐶
Equity (or) Net Worth (or) Shareholders’ Funds (or) Proprietors’ Funds (or) Owners’ Funds (or)Own Funds
𝐸𝐵𝐼𝑇
Pre-tax ROA: = 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑇𝑜𝑡𝑎𝑙 𝐴𝑠𝑠𝑒𝑡𝑠
𝐸𝐴𝑇 + 𝐼𝑛𝑡𝑒𝑟𝑒𝑠𝑡 𝐸𝐵𝑇(1−𝑇)
Post-tax ROA: = 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑇𝑜𝑡𝑎𝑙 𝐴𝑠𝑠𝑒𝑡𝑠 or 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑇𝑜𝑡𝑎𝑙 𝐴𝑠𝑠𝑒𝑡𝑠
𝑅𝑒𝑠𝑖𝑑𝑢𝑎𝑙 𝐸𝑎𝑟𝑛𝑖𝑛𝑔𝑠
iv. Earnings per Share (EPS)= 𝑁𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝐸𝑞𝑢𝑖𝑡𝑦 𝑆ℎ𝑎𝑟𝑒𝑠
𝐸𝑞𝑢𝑖𝑡𝑦 𝐶𝑎𝑝𝑖𝑡𝑎𝑙
Number of Equity Shares outstanding = 𝐹𝑎𝑐𝑒 𝑉𝑎𝑙𝑢𝑒 𝑝𝑒𝑟 𝑆ℎ𝑎𝑟𝑒
𝐷𝑖𝑣𝑖𝑑𝑒𝑛𝑑
vii. Dividend Yield (%)= 𝑀𝑎𝑟𝑘𝑒𝑡 𝑝𝑟𝑖𝑐𝑒 𝑝𝑒𝑟 𝑠ℎ𝑎𝑟𝑒
𝐸𝑆𝐻𝐹
viii. Book Value per Share= 𝑁𝑢𝑚𝑏𝑒𝑟 𝑜𝑓 𝐸𝑞𝑢𝑖𝑡𝑦 𝑆ℎ𝑎𝑟𝑒𝑠
𝐸𝑞𝑢𝑖𝑡𝑦 𝐶𝑎𝑝𝑖𝑡𝑎𝑙
Number of Equity Shares outstanding = 𝐹𝑎𝑐𝑒 𝑣𝑎𝑙𝑢𝑒 𝑝𝑒𝑟 𝑠ℎ𝑎𝑟𝑒
Du Pont Models
[Link] on Equity = Net Profit Margin × Asset Turnover Ratio × Equity Multiplier
Important Notes
1. We prefer to use averages in denominator if it can be consistently applied, otherwise we have to use
closing values to maintain consistency.
2. Compare Operating expenses/ operating cost / operating profit ratio
Cost of Capital
Concept 1 - Cost of Debt (Bonds/Debentures/Bank loans - LongTerm etc)
Method 1: Irredeemable Debt (approximation method)
Method 2: Redeemable Debt (approximation method)
Method 3: Yield to Maturity Method (YTM)
𝐼 (1−𝑡) 𝐼 (1−𝑡)
Kd = 𝑁𝑒𝑡 𝑃𝑟𝑜𝑐𝑒𝑒𝑑𝑠
or 𝑀𝑎𝑟𝑘𝑒𝑡 𝑃𝑟𝑖𝑐𝑒 (𝑤ℎ𝑒𝑛 𝑖𝑠𝑠𝑢𝑒 𝑝𝑟𝑖𝑐𝑒 𝑖𝑠 𝑛𝑜𝑡 𝑔𝑖𝑣𝑒𝑛)
● Net Proceeds = (𝐹𝑎𝑐𝑒 𝑣𝑎𝑙𝑢𝑒 + 𝑃𝑟𝑒𝑚𝑖𝑢𝑚 − 𝐷𝑖𝑠𝑐𝑜𝑢𝑛𝑡) 𝑜𝑟 (𝐼𝑠𝑠𝑢𝑒 𝑃𝑟𝑖𝑐𝑒) - Expenses on issue (Flotation
cost, Brokerage, Commission, Management exp etc)
● Current Market Price may be used in place of issue cost
Note: If we calculate kd for one Debenture or All Debentures, the answer will be the same. So, better to
calculate for one Debenture.
𝑅𝑉 − 𝑁𝑃
𝐼 (1−𝑡) + ( )
Kd = 𝑅𝑉 + 𝑁𝑃
𝑛
( 2
)
RV = Redemption value
NP = Net Proceeds = Issue Price - Floatation Cost
n = Number of years left for Maturity
𝐸𝑃𝑆1 𝐸𝑃𝑆𝑜(1+𝑔)
Ke = 𝑃0
+ g or 𝑃0
+g
Ke = 𝑅𝑓 + β (𝐸𝑅𝑚 – 𝑅𝑓)
𝐷1 𝐷1
Kre = 𝑀𝑃𝑆
+ g (for old shares) (New shares) Ke = 𝑁𝑃
+g
Ko/WACC
Shortcut method
𝐸 𝑃 𝐷
Ko (WACC) = Ke X 𝐸+𝑃+𝐷
+ Kp X 𝐸+𝑃+𝐷
+ Kd X 𝐸+𝑃+𝐷
Ko = Ke X We + Kp X Wp + Kd X Wd
Concept 10 - Additional Marginal Cost of Capital Weighted Marginal Cost of Capital (WMCC)
● The average cost of additional fund used (when we calculate weighted average cost only for new funds
which are raised)
Capital Structure
Capital Structure:
When a company decides the ratio in which it will raise finance from different sources.
Note 1
𝑀𝑃𝑆
P/E Ratio = Price Earning Ratio = 𝐸𝑃𝑆
P/E Ratio×EPS =MPS
Concept 6 — Arbitrage
The process of earning riskless profit by buying securities of higher Roi companies & selling securities in lower
Roi companies.
Arbitrage can be done in two ways:
1. Invest all money and earn more.
2. Invest less money and earn the same amount as before.
Assumptions
1. If you disinvest from a levered company then you can borrow proportional debt also.
(Yani agar aap levered Co se apni investment nikal rahe hai toh aap sirf equity ka paise hi nahi jabki
proportional debt bhi raise karke money le jayenge.)
2. If you invest in a levered company then you will invest in equity and also in proportional debt.
(Yani agar aap levered company me invest karne jaa rahe ho toh aap sirf equity mei invest nahi karoge
jabki proportional debt mei bhi invest karoge.)
3. We always move investment from lower Roi to higher Roi companies.
Leverages Notes
Concept 1: Income Statement
Sales XXX
(-) Variable Cost - XXX
Contribution XXX
(-) Fixed Cost - XXX
Earnings Before Interest & Tax (EBIT) Operating Profit
(-) Interest XXX
Earnings Before Tax (EBT) -XXX
(-) Tax (e.g., 30%) XXX
Earnings After Tax (EAT) XXX
(-) Preference Dividend -XXX
Earnings Available to Equity Shareholders (EAES) XXX
No. of Shares XXX
Earnings Per Share (EPS) EAES / No. of Shares
Dividend Distributed -XXX
Retained Earnings XXX
{Change in Value /Original Value} ×100 Used to calculate the percentage change in Sales,
Contribution, EBIT, or EPS
P/V Ratio + Variable Cost Ratio = 100% The sum of P/V Ratio & Variable Cost Ratio is
always 100%.
Concept 7: Asset Turnover Ratio
Formula Interpretation
Asset Turnover Ratio = Sales / Total Assets Higher Asset Turnover indicates better
asset utilization.
General Note -
Indian System Western System
Thousand 1,000 Thousand 1,000
Lakh 1,00,000 Million 1000,000
Crore 1,00,00,000 Billion 1,000,000,000
ROE = E/E (ROI × (1 - Tax Rate)) + P/E (ROI × (1 - Tax Rate) - PD) + D/E (ROI - Interest) (1 - Tax Rate)
Dividend Decisions
I. Dividend is that part of profit which the company pays out (gives) to shareholders.
II.
Theories of Dividend
Relevance of Dividend Irrelevance of Dividend
The company's value will be impacted by dividend The company's value is not impacted by dividend
decisions. decisions.
1. Walter Model 1. M M Approach
2. Gordon Model
III. Traditional Models:
● Graham Dodd Model
● Linter’s Model
P = Price of share
D = Dividend per share
E = Earning per share
r = rate of return
Ke = Cost of equity
(E - D) = Retained Earning per share.
➔ It means if a company earns less than shareholders expectation, then the company should distribute all
earnings as dividend.
Concept 6: M M Approach
(Dividend Irrelevance Theory)
⇒ The value of a firm is not dependent on dividend decisions.
Step 1:
Price today of share = PV of (Price & Dividend)
(
𝑃1+𝐷1
Po = (1+𝐾𝑒) )
Step 3: To Verify
Value of firm Today = PV of (Value of firm at end year 1)
(𝑛+∆𝑛)×𝑃1 + 𝐸𝑎𝑟𝑛𝑖𝑛𝑔𝑠 − 𝐼𝑛𝑣𝑒𝑠𝑡𝑚𝑒𝑛𝑡 𝑒𝑥𝑝.
n × Po = 1
(1+𝐾𝑒)
Investment Decision
𝐼𝑛𝑖𝑡𝑖𝑎𝑙 𝐼𝑛𝑣𝑒𝑠𝑡𝑚𝑒𝑛𝑡 + 𝑇𝑉 10 + 2
Average Investment = 2
= 2
= 6,00,000
𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑃𝐴𝑇
Type 1 ARR = 𝐼𝑛𝑖𝑡𝑖𝑎𝑙 𝐼𝑛𝑣𝑒𝑠𝑡𝑚𝑒𝑛𝑡
𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝑃𝐴𝑇
Type 2 ARR = 𝐴𝑣𝑒𝑟𝑎𝑔𝑒 𝐼𝑛𝑣𝑒𝑠𝑡𝑚𝑒𝑛𝑡
Example:
Initial Investment = ₹ 10,00,000
Year 1 2 3 4 5 6
CFAT 4,00,000 3,00,000 2,00,000 4,00,000 6,00,000 4,00,000
Solution :
Initial Investment = ₹ 10,00,000
Year Cash Flow Cumulative CF
1 4,00,000 4,00,000
2 3,00,000 7,00,000
3 2,00,000 9,00,000
4 4,00,000 13,00,000
5 6,00,000
6 4,00,000
(10,00,000 − 9,00,000)
PBP = 3 + 4,00,000
x 1 or 12 months
= 3.25 years or 3 years 3 months
Solution
(i) Initial Investment = ₹ 10,00,000
Year Cash Flow (A) PV Factor 10% (B) PV (A X B) Cumulative CF
1 4,00,000 0.909 363600 363600
2 3,00,000 0.826 247800 611400
3 2,00,000 0.751 150200 761600
4 4,00,000 0.683 293200 10,34,800
5 6,00,000 0.621
6 4,00,000 0.564
(10,00,000 − 761600)
Discounted PBP = 3 + 293200
x 1 = 3.873 years
Payback Period < Discounted PBP
● Ignore Irrelevant Cost - A cost which will not change in different situation whether we accept
Proposal or not.
● Ignore Apportionable Expenses - Headoffice expenses are anyhow going to be incurred. So if these
expenses are apportioned on proposes they should be ignored
Ex- General O/H apportioned on Project (should be ignored)
Decision Rule
1. Single Project Question
If NPV ≥ 0 , Accept Proposal
If NPV< 0 , Reject Proposal
6. Working Capital
We assume that working capital is recovered back at end of life of project.
7. Basic Notes:
When we buy new asset, we reduce its cost by sale of old asset and subsidies recovered.
8. Golden Rules:
a. Money saved is money earned.
b. Money forgone is money expensed.
Decision Rule :
1. Single Project
If PI ≥ 1 , Accept Proposal
If PI < 1 , Reject Proposal
2. Multi Project
Select Project with higher PI
NPV Index = PI - 1
+100 -60
𝐷𝑖𝑓𝑓𝑒𝑟𝑒𝑛𝑐𝑒 𝑜𝑓 𝑟𝑎𝑡𝑒𝑠
IRR = Lower rate + Lower rate NPV × 𝐷𝑖𝑓𝑓𝑒𝑟𝑒𝑛𝑐𝑒 𝑜𝑓 𝑁𝑃𝑉
★ If first rate has (+) NPV, then increase rate to find (-)NPV.
★ If first rate has (-) NPV, then decrease rate to find (+) NPV.
NPV vs IRR conflict arises when one project has higher NPV but other project has higher IRR.
Concept : Tax exp or saving on sale of asset at end. Or capital gain or capital loss.
ex : Purchase = 1,00,000 Life of Asset = 5 Yrs
+Installation cost = 50,000 Scrap Value = 50,000
Alternative way:
Sale of Asset at end xxx
- Tax amount on capital gains (-)
Or
+ Tax saving on capital loss (+)
Net cash Inflow from sale of asset *
Concept :
Independent Proposal Mutually Exclusive Proposals
If one event’s occurance doesn’t influence other event, If one event occurs, the other event cannot occur.
then they are called Independent proposals.
Ex: If you select project A, then you cannot select
Select Proposal having higher (+) NPV. project B at same time.
Terminal Value:
4
1 = CFAT1(1 + 𝑟)
3
2 = CFAT2(1 + 𝑟)
2
3 = CFAT3(1 + 𝑟)
1
4 = CFAT4(1 + 𝑟)
0
5 = CFAT5(1 + 𝑟)
1
Initial Investment = Terminal Value × 5
(1+𝑀𝐼𝑅𝑅)
Step 1: We will reinvest all cash flows (during the life) to terminal date.
𝑅𝑒𝑚𝑎𝑖𝑛𝑖𝑛𝑔 𝑙𝑖𝑓𝑒
CFAT1 , (1 + 𝑟) = *
𝑅𝑒𝑚𝑎𝑖𝑛𝑖𝑛𝑔 𝑙𝑖𝑓𝑒
+ CFAT2 , (1 + 𝑟) = *
+ = *
+ = *
Terminal Value
Step 2: MIRR is that discounting rate, at which Terminal Value discounted = Initial Investment
1
Initial Investment = Terminal Value × 𝑛
(1+𝑀𝐼𝑅𝑅)
We have limited funds, so we cannot invest in all proposals , therefore we have to choose best earning
projects.
Type of Questions
Divisible Projects Indivisible Projects
Step 1. Calculate NPV Step 1. Calculate NPV
Step 2. Calculate PI and ranking as per PI (or NPV Index) Step 2. Calculate PI and rank as per PI (or NPV Index)
Step 3. Start investing funds from rank 1, onwards. Step 3. Make Various Combinations.
Step 4. If at end a proposal cannot be purchased full, (try to use high rank projects)
then we will invest our remaining capital in it and (try to maintain high NPV and use maximum
earn proportioned NPV. funds.)
𝐴𝑚𝑜𝑢𝑛𝑡 𝑖𝑛𝑣𝑒𝑠𝑡𝑒𝑑 𝑏𝑦 𝑢𝑠
Total NPV of that project× 𝑇𝑜𝑡𝑎𝑙 𝑖𝑛𝑣𝑒𝑠𝑡𝑚𝑒𝑛𝑡 𝑟𝑒𝑞𝑢𝑖𝑟𝑒𝑑 Step 4. Select Highest NPV option combination.
Concept 2:
365
1. Number of operating cycles in a year (or Cash Cycle Turnover) = 𝑂𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝐶𝑦𝑐𝑙𝑒 𝑃𝑒𝑟𝑖𝑜𝑑
Times
𝐶𝑎𝑠ℎ 𝑜𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑒𝑥𝑝 𝑖𝑛 𝑎 𝑦𝑒𝑎𝑟
2. Working Capital estimation = 365
× 𝑂𝑝𝑒𝑟𝑎𝑡𝑖𝑛𝑔 𝑐𝑦𝑐𝑙𝑒 𝑝𝑒𝑟𝑖𝑜𝑑
Total Operating Expenses xxx
- Depreciation / Amortization (Non Cash Exp) xxx
Cash Operating Expenses xxx
Cost of Production *
+ Opening FG
- Closing FG
COGS *
+ Selling & Distribution O/H
+ Admin (General)
Cost of Sales
+ Profit
Sales **
Used in case of new company question. [Opening stock will be Zero, closing stocks will not be Zero]
Note -
Old Company New Company
Short Cost Sheet Long Cost Sheet
Op Stock = Cl Stock Op Stock ≠ Cl Stock
Op Stock = 0
Cl Stock ≠ 0
RM Consumed = RM Purchased RM Consumed ≠ RM Purchased
Estimation of WC
Particulars Amount (₹)
Current Assets
𝑛
● Raw Material = RM Consumed × 12/52/365
𝑛 𝑛
● WIP = (RM×100% + Labour & OH × 50%) × 12/52/365
OR (Factory Cost)× 12/52/365
𝑛
● FG Stock = cost of production× 12/52/365
𝑛
● Debtors = (Total Basis Question) = Credit Sales× 12/52/365
𝑛
(Cash Cost Basis Question) = Cash cost of Sales × 12/52/365
● Advance to Suppliers
● Cash / Bank Balance (Mentioned in question)
Total Current Asset (A) (A)
Current Liabilities
𝑛
● Creditors = RM Purchased × 12/52/365
𝑛
● O/S Wages = Annual Wages × 12/52/365
𝑛
● O/S Expenses = Cash Expenses × 12/52/365
Total Current Liabilities (B) (B)
Excess of CA over CL (A-B)
[Link] Approach
Statement for evaluation of Credit Policy
Particulars Present Proposal (I) Proposal (II)
30 days 60 days 90 days
Credit Sales
Less Variable Cost
Less Fixed Cost
Less Bad Debt
Less Collection Cost
Less Discount (Cash)
Estimated PBT
- Tax (if given)
(A)Estimated Profit (PAT)
(B)
Opportunity cost of investment in
Debtors (Int on Debtors Cost)
Net Benefit (A - B)
Advice: Select highest Net Benefit Option.
Note :
𝐴𝐶𝑃
1.(B) Int on Debtors Cost =(VC +FC)Cost of Sales × 12/52/365
× 𝐼𝑛𝑡 𝑅𝑎𝑡𝑒
2. If FC is not given, we can calculate Interest only on VC.
3. If Tax rate is given
➔ Profit should be Profit after Tax
➔ Int rate should be after Tax [I(1-t)]
[Link] Approach.
Ex: Present Policy A(30 days) Proposal (I) Policy (B)(60 days) Proposal (II) Policy (c)(90 days)
Total Amount (A) (B) (C)
Incremental Amount - (B - A) (C - A)
(We will have to calculate incremental value for each item.)
Cash Budget
Particulars Jan Feb March
Opening Balance xxx 20,000 20,000
Receipts
● Cash sales xxx xxx xxx
● Collection from debtors xxx xxx xxx
● Sale of asset xxx
● Issue of share / Debenture xxx
● Income Tax refund xxx
● Miscellaneous receipts xxx xxx
Total Cash Available (A)
Payments
● Cash Purchases
● Payment to Creditors
● Purchase of Asset
● Redemption of Debentures
● Dividend paid
● Income Tax Paid
● Miscellaneous Payment
Total Payments (B)
Closing Cash (A) - (B) 28,000 15,000 13,000
Less: Investment in short term securities - 8,000
Add : Sell short term securities + 5,000 + 3,000
Add : Short term borrowing + 4,000
Net Closing Cash 20,000 20,000 20,000
Topic 6: Financing of WC
Concept 1: Factoring
Factor
➔ May collect amount from debtors
➔ May perform invoicing for client
➔ Non recourse factors bear bad debt losses also.
Factor
Recourse Non Recourse
● Factor will not bear bad debt. ● Factor will bear bad debt.
Decision Making :
Case 1: If we have Net Benefit (X - Y)(+) : Accept Factoring
Case 2: If we have Net Cost (Y - X), then calculate effective Interest on advance(effective factoring rate)
𝑁𝑒𝑡 𝐶𝑜𝑠𝑡 𝑜𝑓 𝑓𝑎𝑐𝑡𝑜𝑟𝑖𝑛𝑔 𝑁𝑒𝑡 𝐶𝑜𝑠𝑡 𝑜𝑓 𝐹𝑎𝑐𝑡𝑜𝑟𝑖𝑛𝑔
Effective Rate = 𝑁𝑒𝑡 𝐴𝑑𝑣𝑎𝑛𝑐𝑒 𝐴𝑚𝑜𝑢𝑛𝑡 or 𝐴𝑚𝑜𝑢𝑛𝑡 𝑎𝑣𝑎𝑖𝑙𝑎𝑏𝑙𝑒 𝑓𝑜𝑟 𝐴𝑑𝑣𝑎𝑛𝑐𝑒
𝑌 −𝑋 𝑌−𝑋
= (𝐺)
or (𝐹)
=x%
If X% > Market Int Rate, Reject Factoring , If X% < Market Int Rate, Accept Factoring.