Profitability Ratios: Case Study - PACKMISR
Profitability Ratios: Case Study - PACKMISR
Profitability Ratios: Case Study - PACKMISR
This ratio measures the relationship between COGS and Sales, its measures the
➢Case Study - PACKMISR profitability, and recorded 80.33%, 77.46%. And 79.12% during understudy
COGS/Sales
period respectively,
➢Profitability Ratios this ratio is better in Y2009, due to controlling in the Direct Cost.
This ratio measures the relationship between Gross Profit and Sales, how much
Gross Profit bounds of sales generate how much bound of gross profit , and recorded
Margin 15.61%,17.96%,16.25% , and the better also in 2009, due to decreasing
COGS/Sales and enhancing the ratio in 2009.
This ratio measures the relationship between SG&A and Sales, how much bounds
SG&A / Sales of sales generate how much bound of SG&A, and recorded, and the better also in
2009, due to decreasing COGS/Sales and SG&A .
NOP Margin
NPBT Margin the better also in 2009 for the same reasons.
NPAT Margin
ROE
the better also in 2009 for the same reasons.
ROA
Sales decreased in 2009 but the company generated Good Profitability ratios,
Sales Growth despite 2010, which the sales increased but the profitability ratio is decreased
due to increasing in Financial Payments and Taxes charges .
Lecture #6 05-11-2021
Instructor/ Dr. Mohamed Samir Prepared by : Ahmed Salem 1
The ratio increased from 2008 to 2009 due to increasing WI due to increasing in
بسبب االزمة االقتصادية العالمية A/R and Inventory, and decreasing in Sales
➢Efficiency Ratios 1st Topic
In 2010 the ratio decreased from 32% and 24% due to increasing in sales and
decreasing in Trading Assets
WI / Sales وده معناه ان االزمة خلصت ،والدورة رجعت زي زمان
الن ارتفع نتيجة االزمة وعدم القدرة على البيع WI in 2009 is fake
والزم تدخل بتعمق علشان تعرف انها عليت ليه وا انخفضت ليه وده شيء جيد وال أل ،فمش هتقدر تقول ان
االرتفاع او االنخفاض دا شيء جيد غير لما تعرف األسباب بعمق .
2nd Topic وده معناه ان الشركة تعرضت الزمة We note that the higher DOH in 2009, and this is fake
➔ A/R DOH اقتصادية طاحنة والفجوة التمويلية زادت زيادة وهمية لعدم القدرة على التحصيل من العمالء ،وأيضا عدم
➔ Inv. DOH القدرة على تصريف المخزون وبيعه.
➔ A/P DOH الن اشركة استغلت االزمة في انها تزود تسهيالت السداد للموردين Increased in 2009,
= ➔ ACC
Operating Cycle اعلى ما يمكن في عام االزمة ،ولنفس األسباب اللي قلناها قبل كدة ،وطبعا هي زيادة وهمية
➔ CCC
1- measures the relationship between Gross PP&E and Sales.
3rd Topic
2- measures the relationship between net PP&E and Sales.
1- Gross Plant TO
3- measures the relationship between total Assets and Sales
2- net Plant TO
والمؤشرات دي عالية في ، 2008الحقيقة النها نتيجة انخفاض المبيعات ( المقام يعني )
3- Total Assets
وبرضه على الرغم من المبيعات في 2010زادت ، %18ولكن المؤشرات لما تتحسن وده الن كان فيه
TO
مشروعات تحت التنفيذ وما دخلتش الخدمة واإلنتاج والشركة ما لحقتش تستخدمها.
4th Topic
1- Plant life.
وده اللي خلى The better ratios in 2010 due to expansions and purchasing new capex
2-Plant Age
المؤشرات دي ارتفعت.
3- Plant Life
remaining
Instructor/ Dr. Mohamed Samir Prepared by : Ahmed Salem 2
➢Liquidity Ratios
Current Ratio All ratios are Misleading due to increasing in A/R and Inventory نتيجة االزمة االقتصادية وعدم القدرة على التحصيل وعدم القدرة على التصرف في
Quick Ratio المخزون
Cash Ratio Increased in 2009 due to Purchasing Marketable Securities علشان تهرب من النشاط بتاعها وبدأت تتجه لشراء اذون خزانة مضمونة من الدولة
Defensive Interval Increased as a fake ratio due to fake increasing in A/R and Inventory.
Net WC +++high Positive due to increasing A/R and Inv. ( but we can’t determine that is enough to absorb the shrinkage or not )
It’s high in 2009 due to the Profit is High, and the ability of the Co. to serve FP about 120 time in 2009, and about 10 times in
Interest Coverage
2010 due to increasing FP due to new Debts, moreover the Profitability ratios in 2010 is less than Profitability ratios in 2009
Total Debt / Total Assets The high ratio in 2010 due to granting new Loans from banks.
the ratio decreased in 2010 from 89% to 81% due to the company depended on Liability more than Equity and it’s high
Net Worth / Total Assets
risky but high return.
Dividends Payout وده بسبب االزمة االقتصادية The less % in 2009 which represented 42% ،
Retained Rate و ده اللي خلى نسبة األرباح المحتجزة ولم توزع عاليه ووصلت لـ %58
)Earnings Per Share (EPS مع ثبات عدد األسهم المصدرة the high in 2009, due to generate a high Profit
الن االزمة االقتصادية خلت البورصة وسعر السهم يقع It’s decreased in 2009
)Price Earning ratio ( P/E
فلما تيجي تقارن سعر السهم بالبورصة بربحيته تالقيها ضعيفة،
Dividends Yield النخفاص توزيعات األرباح مقارنة بالسعر It’s decreased in 2009,
ما العوامل التي تتحكم في ربحية المساهمين /المالك ،بالزيادة او االنخفاض ؟ ROE )(1
ما العوامل التي تتحكم في ربحية األصول بالزيادة او االنخفاض ؟ ROA )(2
ما العوامل التي تتحكم في ربحية المبيعات بالزيادة او االنخفاض ؟ ROS )(3
و كلما اجتهنا يف التبويب لألصول املتداولة – املخزون – مؤشرات الشركة تتحسن نتيجة حتسن رأس املال العامل ببنوده ( السيولة – ، ) Tenor Miss matching – WI - WCوالعكس صحيح يف حالة اجتاه التبويب لألصول طويلة
األجل.
-4المستحق من شركات شقيقة -:Due from Affiliatesليا فلوس عند الشركات الشقيقة ،فما هي احتماالت التبويب
،Due From Affiliatesيتم تبويبه كاالتي /
-1عمالء -: A/Rلو فيه معامالت جتارية بينهم ،الن الشركة بتاعيت بتبيع بضاعة للشركة الشقيقة.
-2أصول متداولة أخرى -:لو ليا فلوس عند الشركة شقيقة والفلوس دي بتقل من سنة للتانية النه بيديين اإلحياء انه قصري االجل ،
-3أصول طويلة األجل -:لو ليا فلوس عند الشركة شقيقة والفلوس دي بتزيد من سنة للتانية النه بيديين اإلحياء انه طويل االجل ،
و كلما اجتهنا يف التبويب لألصول املتداولة – العمالء – مؤشرات الشركة تتحسن نتيجة حتسن رأس املال العامل ببنوده ( السيولة – ، ) Tenor Miss matching – WI - WCوالعكس صحيح يف حالة اجتاه التبويب لألصول طويلة
األجل.
1- In profitability analysis, when the CGS/Sales ratio is declining from period to period
a) The company is exhibiting sound control of costs قادرة على التحكم في التكاليف
b) The company’s management of costs is spiraling out of control الشركة لم تقدر على التحكم في التكاليف
c) The company is not properly managing the costs of supplies and raw materials الشركة لم تستطع إدارة تكاليف المواد الخام
d) The company is focusing on costs of goods sold and not focused on other costs (sales, marketing and promotion) الشركة ركزت على تكلفة البضاعة ولم تركز على
تكاليف البيع والتسويق
The CGS/Sales ratio shows the degree to which the company is managing costs related to supplies, raw material and other expenses tied directly to the asset-
conversation or operating cycle. When the ratio declines, the company is able to reduce operating costs or able to past cost increases to its customer base, in
order to improve gross operating profit margins.
A steady decline in the ratio implies the company consistently has control of cost management. It is not possible to determine solely from the CGS/Sales ratio
the level of costs related to sales, marketing and promotion
NPAT/Sales = ROS. If CGS/Sales and SGA/Sales decline, then ROS and NPAT/Sales will improve. NPAT/Sales, when it declines, the company is not managing costs as well as before or not managing
other expenses (e.g., taxes), as described in (a).
The company’s NPAT/Sales ratios can decline (profit margins declining), but still have substantial amount of liquidity (cash) on the balance sheet (as long as it is generating some profit).
If NPAT/Sales is declining and the company is becoming less profitable, it will likely be even more sensitive to its ongoing debt obligations
6- As the company improves performance and earnings grow, if the company pays out a steady proportion in dividends and buys back shares, what
happens to the level of equity capital? وبعدين تعمل إعادة شراء من المالك تاني، لو الشركة بتوزع أرباح
a) Equity capital will grow at the same amount of earnings reported
b) The growth of equity capital will be restricted, or equity remain the same or even decline
c) The equity capital account remains the same no matter dividend-payout policy
d) Equity capital will grow at the same amount of increases on the balance sheet
By accounting standards, earnings will contribute to increases in equity capital. Dividends and buy-backs, depending on the company’s capital-management strategy and shareholder
expectations, will subtract from that.
Hence, a company’s earnings may grow substantially year to year, but because of dividends and buy-backs the equity on the balance sheet may not grow at the same rate and can possibly
remain the same or even decline.
By definition, liquidity measures cash, cash-equivalents, and assets that can be turned to cash quickly. Liquidity also measures the extent to which cash and cash-equivalents can offset all
short-term obligations (over 30-days or up to a year).
By some measure, liquidity is an indication, also, to be able to raise cash from committed funding arrangements to add to current cash balances (to be able to handle other current liabilities).
Liquidity is unrelated to non-current assets on the balance sheet (unless they will be sold for cash in a very short term). Liquidity cannot be measured solely based on the amount of short-term
debt.
Debt/Ebitda helps measure debt leverage on the balance sheet based on an approximation of how long it would take operating cash flow to pay down all debt, even if the company will likely
refinance some of the debt.
It refers to the minimum amount of time (as in (a)) because it presumes that all net operating cash will be used to service debt.
Equity is not factored in assessing levels of debt based on the ratio. The length of the asset-conversion cycle and short-term debt are not factored into Debt/Ebitda.
12- Which ratio below best describes one version of the quick ratio?
a) Cash/Current Liabilities دي اقرب حاجة ليها الن مفيش حاجة فيها مخزون مستبعد هنا
b) Current Liabilities/Working Capital
c) Cash/Tax-payables
d) Accounts receivable/Accounts payable
The quick ratio, defined by credit analysts and depicted in (a), focuses on the cash on hand and the degree it can pay down all current liabilities, if the company wanted or needed to.
Such quick ratios measure cash and cash-equivalents and all significant short-term obligations. Cash/Tax-Payables in (c ) measures the company’s ability to meet only tax obligations. Quick
ratios typically include a broad range of current liabilities.
AR/AP does not address ability to handle other current liabilities, which is what the quick ratio attempts to do
Permanent growth implies the recent growth in company operations and sales are not seasonal or temporary.
Permanent growth also implies the company will likely have permanent growth in levels of inventory and receivables, which implies working investment (a function of inventory and
receivables) will rise to new permanent levels.
Permanent growth and its impact on working investment will not be influenced by the accounting method for inventory
14- If the measure of “Payables Days on Hand” decreases, this may imply (Red Flag)
a) Suppliers and vendors are granting more lenient terms
b) Suppliers and vendors have concerns about the company’s financial soundness and, therefore, are becoming stricter with terms
c) Suppliers and vendors are not sure about the health of the company—whether it’s improving or deteriorating
d) Customers of the company are indifferent to the company’s condition
A decline in “Payables days on hand” implies the company is paying down suppliers and vendors more quickly.
In some cases, the company may have opted to make payments more quickly, but a decline in this metric may also suggest that the suppliers, concerned about the company’s condition, are
reducing credit terms (described in answer (b)).
Payables days on hand does not address or assess the perception of the company by its customer base
16. In periods of downturn أوقات الكسادand a steady decline in revenues, a company with low fixed costs will be less vulnerable because
a) The company will be able to reduce quickly substantial variable costs
b) The company projects it will be able to negotiate away fixed costs
c) The company is confident it can sell the fixed assets related to fixed costs
d) The company expects variable costs to rise as revenues decline
Variable costs decline when revenues decline. So in a downturn, those costs can be reduced. A company with substantial fixed costs will be more vulnerable, as they
encounter costs that can’t be reduced.
In a downturn, the company may not be able to sell fixed assets related to fixed costs.
Variable costs, by definition, are costs the company won’t incur if product sales or business activity decreases.
Credit analysts measure total payments on debt instruments and debt exposures. That includes the sum of interest expenses on all debt and the required principal payments amortizing
debt outstanding (summarized in (d)). Debt instruments include loans and subordinated debt.
Debt-service payments are not applicable to non-debt instruments, including preferred stock and cash used to repurchase stock.
18- Which Debt/Net-operating-cash flow ratio below suggests the company is at risk of not being able to amortize debt as scheduled? balance sheet?
a) 0.7
b) 1.3
c) 12.4
d) 3.2
Debt/Net-operating-cash-flow measures approximately how long current cash flows (if sustained) will take to amortize all debt outstanding.
In many cases, the same debt may be refinanced. But credit analysts, for conservative scenarios, assume the company will not be able to refinance old debt.
The higher the ratio, the longer it takes for the company to pay down total debt. The longer it takes, then the more risk the company encounters. There is the risk the company will not be able
to sustain the same cash flows for an extended period.
A Debt/Net-op-cash-flow = 12.4 (in answer (c )) presumes it will take over 12 years to pay down existing debt and presumes the company will be able to maintain the same performance and
will not use cash flow to pay dividends or repurchase stock.
In the above, based on current accounting standards, goodwill from acquisitions (in answer (b)) is a specific balance-sheet asset.
The “likely” or “expected” portion of a settlement in litigation should be recognized as a balance-sheet liability. Contractual commitments to purchase are not balance-sheet items, although after
the purchase, the system will appear on the balance sheet.
A company’s pension fund does not appear on the company’s consolidated balance sheet, although annual pension expenses and related payables appear in financial statements. The fund may
have deficits that must be addressed by the company. The company may increase pension-related expenses to address the deficit.