Scribd Logo
Upload

Welcome to Scribd!

  • 58 views

    RAK Ceramics: Balance Sheet

    Uploaded by

    Md Borhan Uddin 2035097660
    The documents provide balance sheet and income statement information for RAK Ceramics and Shinepukur Ceramics for the years 2020 and 2019. Key assets for both companies include property, plant and equipment, while liabilities are made up of both current and non-current obligations. For 2020, RAK Ceramics reported a net profit of $329 million on revenues of $5.2 billion, while Shinepukur reported a net profit of $49 million on revenues of $1.2 billion. Short term liquidity, leverage, and activity ratios are also presented for comparative analysis between the two years.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    RAK Ceramics: Balance Sheet

    Uploaded by

    Md Borhan Uddin 2035097660
    58 views16 pages
    The documents provide balance sheet and income statement information for RAK Ceramics and Shinepukur Ceramics for the years 2020 and 2019. Key assets for both companies include property, plant and equipment, while liabilities are made up of both current and non-current obligations. For 2020, RAK Ceramics reported a net profit of $329 million on revenues of $5.2 billion, while Shinepukur reported a net profit of $49 million on revenues of $1.2 billion. Short term liquidity, leverage, and activity ratios are also presented for comparative analysis between the two years.

    Original Title

    BUS505-EXCEL WORK

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The documents provide balance sheet and income statement information for RAK Ceramics and Shinepukur Ceramics for the years 2020 and 2019. Key assets for both companies include property, plant and equipment, while liabilities are made up of both current and non-current obligations. For 2020, RAK Ceramics reported a net profit of $329 million on revenues of $5.2 billion, while Shinepukur reported a net profit of $49 million on revenues of $1.2 billion. Short term liquidity, leverage, and activity ratios are also presented for comparative analysis between the two years.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    58 views16 pages

    RAK Ceramics: Balance Sheet

    Uploaded by

    Md Borhan Uddin 2035097660
    The documents provide balance sheet and income statement information for RAK Ceramics and Shinepukur Ceramics for the years 2020 and 2019. Key assets for both companies include property, plant and equipment, while liabilities are made up of both current and non-current obligations. For 2020, RAK Ceramics reported a net profit of $329 million on revenues of $5.2 billion, while Shinepukur reported a net profit of $49 million on revenues of $1.2 billion. Short term liquidity, leverage, and activity ratios are also presented for comparative analysis between the two years.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 16

    RAK Ceramics

    Balance Sheet

    Balance Sheet Items

    Assets
    Property, plant and equipment
    Investment property
    Intangible assets
    Capital work in progress
    Investment in subsidiaries
    Right of use assets
    Total non-current assets
    Inventories
    Trade and other receivables

    Advances, deposits and prepayments


    Advance income tax
    Cash and cash equivalents

    Total current assets


    Total assets
    Equity
    Share capital
    Share premium
    Retained earnings

    Total equity
    liabilities
    Lease liability
    Deferred tax liability
    Total non-current liabilities
    Borrowings
    Lease liability
    Trade and other payables
    Accrued expenses
    Provision for income tax

    Total current liabilities


    Total Liabilities
    Total equity and liabilities

    Income Statements

    Income Statement Items


    Revenue
    Cost of sales
    Gross profit
    Other income
    Administrative expenses
    Marketing and selling expenses
    Total Operating Expenses
    Profit from operating activities
    Finance income
    Finance expenses
    Net finance income

    Profit before contribution of worker


    Contribution to worker's profit participation
    Profit before income tax
    Income tax expense:
    Current tax
    Deferred tax
    Total Tax expenses
    Net profit after tax

    Total comprehensive income for the year


    EPS

    Dividend Paid

    Book vale per share


    Shares outstanding
    Market price per share
    RAK Ceramics
    Balance Sheet

    2020 2019

    2956685158 2857158157
    503,456,083 681,433,368
    3,132,358 6,495,047
    3,777,569 177,641,997
    360,379,950 360,379,950
    21183255 44,970,798
    3848614373 4128079317
    1964552190 2,716,061,804
    988855261 837944361

    229920846 236462896
    3241709306 3106581019
    1904369238 1,427,796,668

    8329406841 8324846748
    12178021214 12452926065

    4,279,687,010 4,279,687,010
    1,473,647,979 1,473,647,979
    1,324,462,127 1,636,929,820

    7077797116 7390264809

    9291390 29,374,867
    166,403,706 161,871,924
    175695096 191246791
    119,940,905 89,232,918
    4,505,188 9098137
    690564553 754014087
    490310554 522177830
    3619207802 3496891493

    4924529002 4871414465
    5100224098 5062661256
    12178021214 12452926065

    Income Statements

    2020 2019
    5,233,144,472 6,408,004,827
    -4,119,245,478 -4,608,074,082
    1,113,898,994 1,799,930,745
    62,605,952 144,138,331
    -316,798,031 -377,202,064
    -411,763,094 -458,135,624
    -665,955,173 -691,199,357
    447,943,821 1,108,731,388
    49,393,745 30,596,482
    -18,187,444 -27,060,159
    31,206,301 3,536,323

    479,150,122 1,112,267,711
    -22,816,672 -52,965,129
    456,333,450 1,059,302,582

    -122,316,309 -269,804,714
    -4,531,782 4,152,154
    -126,848,091 -265,652,560
    329,485,359 793,650,022

    329,485,359 793,650,022
    0.21 0.43

    634,047,427 386,966,131

    21.0116796136671 17.2682366531285
    336,850,611 427,968,701
    33 28.7
    Shinepukur Ceramics
    Balance Sheet

    Balance Sheet Items

    Assets
    Non-Current Assts
    Property, plant and equipment
    Investments in shares
    Capital work in progress

    Total non-current assets


    Current Asset
    Inventories
    Accounts and other receivables
    Advances, deposits and prepayments
    Cash and cash equivalents
    Total current assets
    Total assets
    Equity
    Share capital
    Retained earnings
    Revaluation Surplus
    Fair Value loss on Investment
    Total equity
    liabilities
    Long term loan- Net off Current matuirity (secured)
    Deferred tax liability
    Gratuity Payable
    Total non-current liabilities
    Short term loan from banks (secured)
    Long term Loan current matuirity (Secured)
    Creditors, Accruals and other payables
    Total current liabilities

    Total Liabilities
    Total equity and liabilities

    Income Statement

    Income Statements Items


    Sales
    Cost of sales
    Gross profit
    Other income
    Administrative expenses
    Selling and distribution expenses
    Total Operating Expenses
    Profit from operating activities
    Finance cost
    Profit before contribution of worker
    Contribution to worker's profit participation
    Profit before income tax
    Income tax expense:
    Total Tax expenses
    Net Profit after tax
    Fair value loss on investment in shares
    Total comprehensive income for the year

    EPS

    Dividend Paid

    Book vale per share


    Shares outstanding
    Market price per share
    kur Ceramics
    nce Sheet

    2020 2019

    5,145,934,995 5,269,337,376
    34,148,868 58,470,185

    5,180,083,863 5,327,807,561

    902,826,025 866,347,612
    178,701,696 272,949,292
    146,682,551 130,348,652
    7,803,877 25,509,152
    1,236,014,149 1,295,154,708
    6,416,098,012 6,622,962,269

    1,469,660,550 1,469,660,550
    30,330,522 (61,923,172)
    2,966,690,015 2,966,690,015
    (130,821,746) (106,500,419)
    4,275,198,297 4,267,926,974

    291,263,805 313,768,701
    81,472,077 81,472,077
    133,421,835 131,536,452
    506,157,717 526,777,230
    766,336,816 863,635,578
    155,094,538 187,071,590
    713,310,644 777,550,897
    1,634,741,998 1,828,258,065

    2,140,899,715 2,355,035,295
    6,416,098,012 6,622,962,269

    e Statement

    2020 2019
    1,205,076,326 1,533,121,181
    -1019217711 -1192696859
    185,858,615 340,424,322
    5817591 9732635
    -49,424,525 -63,250,534
    -49196870 -55876266
    -98,621,395 -119,126,800
    93,054,811 231,030,157
    -81193722 -133928558
    11,861,089 97,101,599
    -564814 -4623886
    11,296,275 92,477,713

    20296375 -29766002
    31,592,650 62,711,711
    17761266 -16189636
    49,353,916 46,522,075

    0.21 0.43

    0 0

    29.09 29.04
    146966055 146966055
    26.8 10.8
    Short term solvency ratio

    Current Ratio
    2020 2019
    RAK 1.6914118766723 1.708917770765
    Shinepukur 0.75609126731447 0.7084091315085

    Quick Ratio
    2020 2019
    RAK 1.29247987947985 1.1513668123084
    Shinepukur 0.20381694751076 0.234544074608

    CASH RATIO
    2020 2019
    RAK 0.38671093971151 0.2930969389401
    Shinepukur 0.00477376675313 0.0139527085855

    NWC to Total Asset


    2020 2019
    RAK 27.96% 27.73%
    Shinepukur -6.21% -8.05%

    Interval measure
    2020 2019
    RAK 635.340860017993 573.39352233792
    Shinepukur 403.586850704613 360.3620541349

    Long term solvency ratio

    Total debt ratio


    2020 2019
    RAK 0.41880565063696 0.4065439102083
    Shinepukur 0.33367627972576 0.3555863976492

    Debt to Equity
    2020 2019
    RAK 0.7205948424928 0.6850446346435
    Shinepukur 0.50077202652853 0.5517984045526
    Equity multiplier
    2020 2019
    RAK 1.7205948424928 1.6850446346435
    Shinepukur 1.50077202652853 1.5517984045526

    Long term debt ratio


    2020 2019
    RAK 0.02422213891804 0.0252254169208
    Shinepukur 0.10586070468669 0.1098664709203

    Activity ratio

    Inventory turnover
    2020 2019
    RAK 2.09678597441588 1.6966013347758
    Shinepukur 1.13 1.38

    Day's sales in inventory


    2020 2019
    RAK 174.075945019463 215.1359854071
    Shinepukur 323.31806597207 265.12761897028

    Accounts receivable turnover


    2020 2019
    RAK 5.2921238106251 7.6472915449335
    Shinepukur 6.74350805266 5.6168717997627

    Average collection period


    2020 2019
    RAK 68.9704196389325 47.729316694068
    Shinepukur 54.1261309617662 64.982789889458

    Net working capital turnover


    2020 2019
    RAK 1.5369551330326 1.8555466856971
    Shinepukur -3.02230287907479 -2.8758422937487

    Fixed asset turnover


    2020 2019
    RAK 1.35974768184446 1.552296924289
    Shinepukur 0.23263645104427 0.2877583627875
    Total asset turnover
    2020 2019
    RAK 0.42972042666373 0.5145782439848
    Shinepukur 0.18782074771086 0.2314857187359

    Profitability ratio

    Profit margin
    2020 2019
    RAK 6.30% 12.39%
    Shinepukur 4.10% 3.03%

    ROA
    2020 2019
    RAK 2.71% 6.37%
    Shinepukur 0.77% 0.70%

    ROE
    2020 2019
    RAK 4.66% 10.74%
    Shinepukur 1.15% 1.09%

    Market value ratio

    P/E ratio
    2020 2019
    RAK 157.142857142857 66.744186046512
    Shinepukur 127.619047619048 25.116279069768

    Market to book ratio


    2020 2019
    RAK 1.57055507254808 1.662011042384
    Shinepukur 0.92128832404426 0.3718979738101
    RAK- DuPont Analysis
    2020 2019
    Net Profit 329485359 793650022
    Revenue 5233144472 6408004827
    Total Assets 12178021214 12452926065
    Equity 7077797116 7390264809

    Margin 6% 12%
    Asset turnover 0.4 0.5
    Leverage 1.7 1.7
    Return on equity 5% 11%
    Shinepukur- DuPont Analysis
    2020 2019
    Net Profit 49353916 46522075
    Revenue 1205076326 1533121181
    Total Assets 6416098012 6622962269
    Equity 4275198297 4267926974

    Margin 4% 3%
    Asset turnover 0.2 0.2
    Leverage 1.5 1.6
    Return on 1% 1%
    equity
    RAK 2020 2019
    Asets 12178021214 12452926065
    Liabilities 5100224098 5062661256
    Shares outstanding 336,850,611 427,968,701
    Net Asset Value is calculated using the formula given below
    Net Asset Value = ( Assets - Liabilities) / Total number of Outstanding Shares
    RAK 2020 2019
    Net Asset Value Of RAK 21.0116796136671 17.2682366531285

    Shinepukur 2020 2019


    Assets 6416098012 6622962269
    Liabilities 2140899715 2355035295
    Shares outstanding 146966055 146966055

    Shinepukur 2020 2019


    Net Asset Value Of Shinepukur 29.0896989580349 29.040222750757

    You might also like