1 Financial Detective Berau Final
1 Financial Detective Berau Final
1 Financial Detective Berau Final
Member:
29118302 - Arif Widya S
29118343 - Fandy Alim
29118350 - Dwi Al Aji Suseno
29118370 - Idam Faisal Rahman
Beer
Company D's ROE (21.9%) is higher than Company C (19.7%) due to Company D's assets
turnover of 1.5%, where Company D is the largest craft brewers in the US and builds high
quality beer with premium prices. Company C has high a Long Term Debt because they need
money to acquire several large brewers over 12 years. Company D's Current Ratio is higher by
25.3%, where Company D's current assets are high because they have the largest craft brewers
and Company D's current liabilities are low because the company is financially conservative.
Computers
From common-size financial data and ratios :
Company E sells personal computers as well as handheld devices and software. the firm has
been able to differentiate itself by using its own operating system for its computers and by
creating new and innovative designs for all its products. these products carry premium prices
domestically and globally. It represents from financial data :
● Inventory Turnover (62,8) : higher than company F because of selling to personal (B2C)
rather than Business to Business
● COGS (60) : because of selling B2C equipments
● NPM (22,8) higher than Company F. as impact of lower COGS
Hospitality
From common-size financial data and ratios :
Company G maintains market presence by owning all of its properties, which contributes to the
high recognition of its industry-leading brands. It represents from financial data :
● Net Property, Plant & Equipment (53), higher than company H
● Current Ratio (1.02) and Quick Ratio (0,72)
● COGS is higher than company H (63)
● NPM (4,9)
Company H operates hotels and residential complexes. Rather than owning the hotels, this firm
chooses to manage or franchise its hotels. The company recieves its revenues each month
based on long-term contract with the hotels owners. It represents from financial data :
● Net Property, Plant & Equipment (17), lower than company G
● Current Ratio (0.43) and Quick Ratio (0,37)
● COGS is lower (26)
● NPM (30,1)
Newspapers (I and J)
● Based on the product of these companies, we can see the COGS has significantly
different because Company I is going to prepare print to digital newspaper and Company
J is still do both product (print and digital newspapers).
Data: COGS (Company I: 39) and COGS (Company J: 101)
● Focus on marketing to prepare transformation from print to digital, company I has higher
cost for SG&A Expense than company J.
Data: SG&A Expense (Company I: 45) and SG&A Expense (Company J: 0)
● The effect of company I that has introduced cost controls to address cost-structures
issues. We can see on Gross Profit of company between I and J.
Data: Gross Profit (Company I: 61) and Gross Profit (Company J: -1)
Pharmaceuticals (K and L)
● Because of the different strategies on company K and L focuses, K is focus on proven
drugs and L focuses on sustainability to fulfill customer needs by RnD to discover new
drugs. So we can see on RnD Expenses. L has more value than K to enhance the
Research and Development to discover new drugs.
Data: RnD Expenses (Company K: -3) and Long-Term Debt (Company L: -24)
● Because the company K focuses on proven drugs than gambling to discover new drug in
the future. Net income of this company is less than company L which focus on RnD. This
is caused by company K has more other cost.
Data: Net Income (Company K: -3) and Net Income (Company L: 12)
Coal powered electric power plant are high asset compared to the Solar power. The difference
in fixed asset M (62%) vs N (19%) since the coal powered electric power has a large size of
power plant which means high asset.
Coal powered electric power plant has higher long term debt compared to the solar power plant
the difference in fixed asset M (50%) vs N (4%) it is because the size they have is much
different..
Since the long term debt of coal powered electric power plant is higher, the equity structure is
higher than coal powered electric power plant M (17%) vs N (76%). Based on explanation
above debt management also has a significant difference.
Retail
Leading e-commerce (O) compared to leading retailer in apparel and fashion (P):
Leading e-commerce has lower inventory (O 16% vs P 25%), and has higher AP (O 31% vs P
17%) and higher receivable (O 10% vs P 13%) since the typical of e commerce that the stock is
arranged by supplier and in leading retailer, it arrange stock/inventory by itself. Leading e-
commerce has lower long term debt (O 13% vs P 36%) because leading retailer need more
money to invest in fixed asset (O 33% vs P 49%)
Leading e-commerce has R&D Cost (O 12% vs P 0%) since the innovation is a must, it
competes with another high tech e-commerce company. The leading retailer doesn’t need R&D
but higher SG&A expense (O 19% vs 28%) to cover it sales and general expense.