Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Profit Loss ASX Code Company Name Item 06/15 06/16 06/17 06/18 06/19 CBA Commonwealth Bank of Australia Interest...

1 answer below »
Profit Loss
    ASX Code    Company Name    Item    06/15    06/16    06/17    06/18    06/19
    CBA    Commonwealth Bank of Australia    Interest Income    34,100,000,000.00    33,817,000,000.00    33,293,000,000.00    34,543,000,000.00    34,588,000,000.00
    CBA    Commonwealth Bank of Australia    Interest Expense    -18,305,000,000.00    -16,882,000,000.00    -15,693,000,000.00    -16,202,000,000.00    -16,468,000,000.00
    CBA    Commonwealth Bank of Australia    Net Interest Income    15,795,000,000.00    16,935,000,000.00    17,600,000,000.00    18,341,000,000.00    18,120,000,000.00
    CBA    Commonwealth Bank of Australia    Prov. For Doubtful Debts    -988,000,000.00    -1,256,000,000.00    -1,095,000,000.00    -1,079,000,000.00    -1,201,000,000.00
    CBA    Commonwealth Bank of Australia    Net Int. Income Less Prov    14,807,000,000.00    15,679,000,000.00    16,505,000,000.00    17,262,000,000.00    16,919,000,000.00
    CBA    Commonwealth Bank of Australia    Non Interest Income    11,210,000,000.00    10,562,000,000.00    10,850,000,000.00    7,865,000,000.00    6,217,000,000.00
    CBA    Commonwealth Bank of Australia    Total Operating Income    26,017,000,000.00    26,241,000,000.00    27,355,000,000.00    25,127,000,000.00    23,136,000,000.00
    CBA    Commonwealth Bank of Australia    Non Interest Expense    -13,321,000,000.00    -13,078,000,000.00    -13,491,000,000.00    -10,836,000,000.00    -10,731,000,000.00
    CBA    Commonwealth Bank of Australia    PreTax Profit    12,696,000,000.00    13,163,000,000.00    13,864,000,000.00    14,291,000,000.00    12,405,000,000.00
    CBA    Commonwealth Bank of Australia    Tax Expense    -3,538,000,000.00    -3,693,000,000.00    -3,959,000,000.00    -4,026,000,000.00    -3,391,000,000.00
    CBA    Commonwealth Bank of Australia    Net Profit after Tax Before Abnormals    9,158,000,000.00    9,470,000,000.00    9,905,000,000.00    10,265,000,000.00    9,014,000,000.00
    CBA    Commonwealth Bank of Australia    Abnormals    -84,000,000.00    -309,000,000.00    80,000,000.00    -871,000,000.00    -642,000,000.00
    CBA    Commonwealth Bank of Australia    Abnormals Tax    10,000,000.00    86,000,000.00    -33,000,000.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Net Abnormals    -74,000,000.00    -223,000,000.00    47,000,000.00    -871,000,000.00    -642,000,000.00
    CBA    Commonwealth Bank of Australia    Reported NPAT After Abnormals    9,084,000,000.00    9,247,000,000.00    9,952,000,000.00    9,348,000,000.00    8,590,000,000.00
    CBA    Commonwealth Bank of Australia    Outside Equity Interests    -21,000,000.00    -20,000,000.00    -24,000,000.00    -19,000,000.00    -19,000,000.00
    CBA    Commonwealth Bank of Australia    Shares Outstanding at Period End    1,622,938,436.00    1,711,061,742.00    1,726,013,398.00    1,756,617,620.00    1,770,239,507.00
    CBA    Commonwealth Bank of Australia    Weighted Average Number of Shares    1,618,000,000.00    1,692,000,000.00    1,719,000,000.00    1,746,000,000.00    1,765,000,000.00
    CBA    Commonwealth Bank of Australia    EPS Adjusted (cents/share)    535.94    542.30    556.45    568.59    491.78
    CBA    Commonwealth Bank of Australia    EPS After Abnormals (cents/share)    531.60    529.50    559.10    517.70    468.60
Balance Sheet
    ASX Code    Company Name    Item    06/15    06/16    06/17    06/18    06/19
    CBA    Commonwealth Bank of Australia    Short Term Money    33,116,000,000.00    23,372,000,000.00    45,850,000,000.00    22,897,000,000.00    16,655,000,000.00
    CBA    Commonwealth Bank of Australia    Investment Securities    119,111,000,000.00    119,221,000,000.00    120,128,000,000.00    131,114,000,000.00    135,677,000,000.00
    CBA    Commonwealth Bank of Australia    Due From Banks    0.00    0.00    0.00    0.00    8,093,000,000.00
    CBA    Commonwealth Bank of Australia    Loans    639,262,000,000.00    695,398,000,000.00    731,762,000,000.00    743,365,000,000.00    755,141,000,000.00
    CBA    Commonwealth Bank of Australia    Total Earning Assets    791,489,000,000.00    837,991,000,000.00    897,740,000,000.00    897,376,000,000.00    915,566,000,000.00
    CBA    Commonwealth Bank of Australia    Customer Acceptances    1,944,000,000.00    1,431,000,000.00    463,000,000.00    379,000,000.00    32,000,000.00
    CBA    Commonwealth Bank of Australia    Fixed Assets    2,833,000,000.00    3,940,000,000.00    3,873,000,000.00    2,576,000,000.00    2,383,000,000.00
    CBA    Commonwealth Bank of Australia    Other    77,180,000,000.00    89,716,000,000.00    74,298,000,000.00    74,834,000,000.00    58,521,000,000.00
    CBA    Commonwealth Bank of Australia    Total Non-Earning Assets    81,957,000,000.00    95,087,000,000.00    78,634,000,000.00    77,789,000,000.00    60,936,000,000.00
    CBA    Commonwealth Bank of Australia    Total Assets    873,446,000,000.00    933,078,000,000.00    976,374,000,000.00    975,165,000,000.00    976,502,000,000.00
    CBA    Commonwealth Bank of Australia    Due to Banks    36,416,000,000.00    28,771,000,000.00    28,432,000,000.00    20,899,000,000.00    23,370,000,000.00
    CBA    Commonwealth Bank of Australia    Bank Acceptances    1,944,000,000.00    1,431,000,000.00    463,000,000.00    379,000,000.00    32,000,000.00
    CBA    Commonwealth Bank of Australia    Deposits    543,231,000,000.00    588,045,000,000.00    626,655,000,000.00    630,358,000,000.00    623,158,000,000.00
    CBA    Commonwealth Bank of Australia    Provisions    2,738,000,000.00    3,018,000,000.00    3,562,000,000.00    2,841,000,000.00    3,077,000,000.00
    CBA    Commonwealth Bank of Australia    Bonds    154,429,000,000.00    161,284,000,000.00    167,571,000,000.00    172,693,000,000.00    197,117,000,000.00
    CBA    Commonwealth Bank of Australia    Other    81,695,000,000.00    89,773,000,000.00    85,975,000,000.00    80,135,000,000.00    60,099,000,000.00
    CBA    Commonwealth Bank of Australia    Total Liabilities    820,453,000,000.00    872,322,000,000.00    912,658,000,000.00    907,305,000,000.00    906,853,000,000.00
    CBA    Commonwealth Bank of Australia    Share Capital    28,558,000,000.00    33,845,000,000.00    34,971,000,000.00    37,270,000,000.00    38,020,000,000.00
    CBA    Commonwealth Bank of Australia    Reserves    2,345,000,000.00    2,734,000,000.00    1,869,000,000.00    1,676,000,000.00    3,092,000,000.00
    CBA    Commonwealth Bank of Australia    Retained Earnings    21,528,000,000.00    23,627,000,000.00    26,330,000,000.00    28,360,000,000.00    28,482,000,000.00
    CBA    Commonwealth Bank of Australia    Other Equity    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Convertible Equity    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    SE Held Sale    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Outside Equity    562,000,000.00    550,000,000.00    546,000,000.00    554,000,000.00    55,000,000.00
    CBA    Commonwealth Bank of Australia    Total Equity    52,993,000,000.00    60,756,000,000.00    63,716,000,000.00    67,860,000,000.00    69,649,000,000.00
Cash Flow
    ASX Code    Company Name    Item    06/15    06/16    06/17    06/18    06/19
    CBA    Commonwealth Bank of Australia    Interest Received    34,067,000,000.00    34,047,000,000.00    33,536,000,000.00    35,801,000,000.00    34,757,000,000.00
    CBA    Commonwealth Bank of Australia    Interest Paid    -17,425,000,000.00    -16,285,000,000.00    -15,006,000,000.00    -15,356,000,000.00    -15,695,000,000.00
    CBA    Commonwealth Bank of Australia    Divideds Received    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Tax Paid    -3,444,000,000.00    -3,071,000,000.00    -3,976,000,000.00    -4,791,000,000.00    -4,878,000,000.00
    CBA    Commonwealth Bank of Australia    Other Operating Cashflows    -6,015,000,000.00    -19,252,000,000.00    -15,361,000,000.00    -14,545,000,000.00    3,902,000,000.00
    CBA    Commonwealth Bank of Australia    Net Operating Cashflows    7,183,000,000.00    -4,561,000,000.00    -807,000,000.00    1,109,000,000.00    18,086,000,000.00
    CBA    Commonwealth Bank of Australia    Payment for Purchase of PPE    -1,128,000,000.00    -1,768,000,000.00    -1,097,000,000.00    -980,000,000.00    -640,000,000.00
    CBA    Commonwealth Bank of Australia    Proceeds From Sale of PPE    69,000,000.00    405,000,000.00    381,000,000.00    155,000,000.00    151,000,000.00
    CBA    Commonwealth Bank of Australia    Investments Purchased    -270,000,000.00    0.00    0.00    -271,000,000.00    72,000,000.00
    CBA    Commonwealth Bank of Australia    Proceeds From Sale of Investments    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Payments for Purchase of Subsidiaries    -29,000,000.00    -857,000,000.00    -31,000,000.00    26,000,000.00    0.00
    CBA    Commonwealth Bank of Australia    Proceeds from Sale of Subsidiaries    72,000,000.00    110,000,000.00    1,000,000.00    0.00    1,259,000,000.00
    CBA    Commonwealth Bank of Australia    Loans Granted    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Loans Repaid    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Other Investing Cashflows    71,000,000.00    78,000,000.00    69,000,000.00    68,000,000.00    141,000,000.00
    CBA    Commonwealth Bank of Australia    Net Investing Cashflows    -1,215,000,000.00    -2,032,000,000.00    -677,000,000.00    -1,002,000,000.00    983,000,000.00
    CBA    Commonwealth Bank of Australia    Proceeds from Issues    0.00    5,022,000,000.00    28,000,000.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Proceeds from Bo
owings    6,184,000,000.00    3,949,000,000.00    98,317,000,000.00    72,718,000,000.00    58,027,000,000.00
    CBA    Commonwealth Bank of Australia    Repayment of Bo
owings    -7,693,000,000.00    -460,000,000.00    -81,758,000,000.00    -68,273,000,000.00    -76,384,000,000.00
    CBA    Commonwealth Bank of Australia    Dividends Paid    -6,200,000,000.00    -5,827,000,000.00    -6,084,000,000.00    -5,366,000,000.00    -6,853,000,000.00
    CBA    Commonwealth Bank of Australia    Other Financing Cashflows    -166,000,000.00    -1,064,000,000.00    -31,000,000.00    -13,000,000.00    -529,000,000.00
    CBA    Commonwealth Bank of Australia    Net Financing Cashflows    -7,875,000,000.00    1,620,000,000.00    10,472,000,000.00    -934,000,000.00    -25,739,000,000.00
    CBA    Commonwealth Bank of Australia    Net Increase in Cash    -1,907,000,000.00    -4,973,000,000.00    8,988,000,000.00    -827,000,000.00    -6,670,000,000.00
    CBA    Commonwealth Bank of Australia    Cash at Beginning of Period    19,128,000,000.00    19,270,000,000.00    14,447,000,000.00    23,117,000,000.00    23,005,000,000.00
    CBA    Commonwealth Bank of Australia    Exchange Rate Adj    2,049,000,000.00    150,000,000.00    -318,000,000.00    715,000,000.00    675,000,000.00
    CBA    Commonwealth Bank of Australia    Other Cash Adjustments    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Cash at End of Period    19,270,000,000.00    14,447,000,000.00    23,117,000,000.00    23,005,000,000.00    17,010,000,000.00
Per Share Statisticts
    ASX Code    Company Name    Item    06/15    06/16    06/17    06/18    06/19
    CBA    Commonwealth Bank of Australia    Shares Outstand. (EOP)    1,622,938,436.00    1,711,061,742.00    1,726,013,398.00    1,756,617,620.00    1,770,239,507.00
    CBA    Commonwealth Bank of Australia    Weighted Avg. Shares    1,618,000,000.00    1,692,000,000.00    1,719,000,000.00    1,746,000,000.00    1,765,000,000.00
    CBA    Commonwealth Bank of Australia    EPS Bef. Abs    560.14    545.33    577.55    534.31    485.61
    CBA    Commonwealth Bank of Australia    EPS Aft. Abs.    531.60    529.50    559.10    517.70    468.60
    CBA    Commonwealth Bank of Australia    Dilution Factor    --    0.99    --    --    --
    CBA    Commonwealth Bank of Australia    Cumulative    0.99    1.00    1.00    1.00    1.00
    CBA    Commonwealth Bank of Australia    Reportd EPS Bef. Abs.Adj    533.05    542.30    556.45    568.59    491.78
    CBA    Commonwealth Bank of Australia    DPS - Adj Ex. Special    417.73    420.00    429.00    431.00    431.00
    CBA    Commonwealth Bank of Australia    DPS - Adj.    417.73    420.00    429.00    431.00    431.00
    CBA    Commonwealth Bank of Australia    Interim Div - Ordinary    198.00    198.00    199.00    200.00    200.00
    CBA    Commonwealth Bank of Australia    Interim Franking - Ord (%)    100.00    100.00    100.00    100.00    100.00
    CBA    Commonwealth Bank of Australia    Gross Interim Div - Ord    282.86    282.86    284.29    285.71    285.71
    CBA    Commonwealth Bank of Australia    Final Dividend - Ordinary    222.00    222.00    230.00    231.00    231.00
    CBA    Commonwealth Bank of Australia    Final Franking - Ordinary (%)    100.00    100.00    100.00    100.00    100.00
    CBA    Commonwealth Bank of Australia    Gross Final Div - Ord    317.14    317.14    328.57    330.00    330.00
    CBA    Commonwealth Bank of Australia    Special Dividend - Ord    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Special Franking - Ord (%)    --    --    --    --    --
    CBA    Commonwealth Bank of Australia    Gross Special Div - Ord    0.00    0.00    0.00    0.00    0.00
    CBA    Commonwealth Bank of Australia    Total Div - Ex. Special    420.00    420.00    429.00    431.00    431.00
    CBA    Commonwealth Bank of Australia    Total Div - Inc. Special    420.00    420.00    429.00    431.00    431.00
    CBA    Commonwealth Bank of Australia    Total Franking - Ex. Spec    100.00    100.00    100.00    100.00    100.00
    CBA    Commonwealth Bank of Australia    Total Franking - Inc. Spec (%)    100.00    100.00    100.00    100.00    100.00
    CBA    Commonwealth Bank of Australia    Total Gross Div- Ex.Spec    600.00    600.00    612.86    615.71    615.71
    CBA    Commonwealth Bank of Australia    Total Gross Div- Inc.Spec    600.00    600.00    612.86    615.71    615.71
    CBA    Commonwealth Bank of Australia    Tax Rate (%)    27.87    28.06    28.56    28.17    27.34
    CBA    Commonwealth Bank of Australia    Corporate Tax Rate (%)    30.00    30.00    30.00    30.00    30.00
    CBA    Commonwealth Bank of Australia    Payout Ratio Ex. Special (%)    78.37    77.45    77.10    75.80    87.64
    CBA    Commonwealth Bank of Australia    Payout Ratio (%)    78.37    77.45    77.10    75.80    87.64
    CBA    Commonwealth Bank
finm-assignment-hcxtkncg.docx cba-final-data-21pdhz0l.xlsx an-example-of-halfords-excel-calculations-prrktkfo.xlsx
Answered Same Day Sep 29, 2021

Solution

Tanmoy answered on Oct 02 2021
153 Votes
IS(CBA)
            Item    Jun-15    Jun-16    Jun-17    Jun-18    Jun-19
            Interest Income    34,100,000,000    33,817,000,000    33,293,000,000    34,543,000,000    34,588,000,000
            Interest Expense    -18,305,000,000    -16,882,000,000    -15,693,000,000    -16,202,000,000    -16,468,000,000
            Net Interest Income    15,795,000,000    16,935,000,000    17,600,000,000    18,341,000,000    18,120,000,000
            Prov. For Doubtful Debts    -988,000,000    -1,256,000,000    -1,095,000,000    -1,079,000,000    -1,201,000,000
            Net Int. Income Less Prov    14,807,000,000    15,679,000,000    16,505,000,000    17,262,000,000    16,919,000,000
            Non Interest Income    11,210,000,000    10,562,000,000    10,850,000,000    7,865,000,000    6,217,000,000
            Total Operating Income    26,017,000,000    26,241,000,000    27,355,000,000    25,127,000,000    23,136,000,000
            Non Interest Expense    -13,321,000,000    -13,078,000,000    -13,491,000,000    -10,836,000,000    -10,731,000,000
            PreTax Profit    12,696,000,000    13,163,000,000    13,864,000,000    14,291,000,000    12,405,000,000
            Tax Expense    -3,538,000,000    -3,693,000,000    -3,959,000,000    -4,026,000,000    -3,391,000,000
            Net Profit after Tax Before Abnormals    9,158,000,000    9,470,000,000    9,905,000,000    10,265,000,000    9,014,000,000
            Abnormals    -84,000,000    -309,000,000    80,000,000    -871,000,000    -642,000,000
            Abnormals Tax    10,000,000    86,000,000    -33,000,000    0    0
            Net Abnormals    -74,000,000    -223,000,000    47,000,000    -871,000,000    -642,000,000
            Reported NPAT After Abnormals    9,084,000,000    9,247,000,000    9,952,000,000    9,348,000,000    8,590,000,000
            Outside Equity Interests    -21,000,000    -20,000,000    -24,000,000    -19,000,000    -19,000,000
            Shares Outstanding at Period End    1,622,938,436    1,711,061,742    1,726,013,398    1,756,617,620    1,770,239,507
            Weighted Average Number of Shares    1,618,000,000    1,692,000,000    1,719,000,000    1,746,000,000    1,765,000,000
            EPS Adjusted (cents/share)    535.94    542.3    556.45    568.59    491.78
            EPS After Abnormals (cents/share)    531.6    529.5    559.1    517.7    468.6
            Depreciation    803000000    749000000    1135000000    931000000    974000000
            Capital Expenditure    1,128,000,000    1,768,000,000    1,097,000,000    980,000,000    640,000,000
BS(CBA)
            Item    Jun-15    Jun-16    Jun-17    Jun-18    Jun-19
            Short Term Money    34,100,000,000    23,372,000,000    45,850,000,000    22,897,000,000    16,655,000,000
            Investment Securities    119,111,000,000    119,221,000,000    120,128,000,000    131,114,000,000    135,677,000,000
            Due From Banks    0    0    0    0    8,093,000,000
            Loans    639,262,000,000    695,398,000,000    731,762,000,000    743,365,000,000    755,141,000,000
            Total Earning Assets    791,489,000,000    837,991,000,000    897,740,000,000    897,376,000,000    915,566,000,000
            Customer Acceptances    1,944,000,000    1,431,000,000    463,000,000    379,000,000    32,000,000
            Fixed Assets    2,833,000,000    3,940,000,000    3,873,000,000    2,576,000,000    2,383,000,000
            Other    77,180,000,000    89,716,000,000    74,298,000,000    74,834,000,000    58,521,000,000
            Total Non-Earning Assets    81,957,000,000    95,087,000,000    78,634,000,000    77,789,000,000    60,936,000,000
            Total Assets    873,446,000,000    933,078,000,000    976,374,000,000    975,165,000,000    976,502,000,000
            Due to Banks    36,416,000,000    28,771,000,000    28,432,000,000    20,899,000,000    23,370,000,000
            Bank Acceptances    1,944,000,000    1,431,000,000    463,000,000    379,000,000    32,000,000
            Deposits    543,231,000,000    588,045,000,000    626,655,000,000    630,358,000,000    623,158,000,000
            Provisions    2,738,000,000    3,018,000,000    3,562,000,000    2,841,000,000    3,077,000,000
            Bonds    154,429,000,000    161,284,000,000    167,571,000,000    172,693,000,000    197,117,000,000
            Other    81,695,000,000    89,773,000,000    85,975,000,000    80,135,000,000    60,099,000,000
            Total Liabilities    820,453,000,000    872,322,000,000    912,658,000,000    907,305,000,000    906,853,000,000
            Share Capital    28,558,000,000    33,845,000,000    34,971,000,000    37,270,000,000    38,020,000,000
            Reserves    2,345,000,000    2,734,000,000    1,869,000,000    1,676,000,000    3,092,000,000
            Retained Earnings    21,528,000,000    23,627,000,000    26,330,000,000    28,360,000,000    28,482,000,000
            Other Equity    0    0    0    0    0
            Convertible Equity    0    0    0    0    0
            SE Held Sale    0    0    0    0    0
            Outside Equity    562,000,000    550,000,000    546,000,000    554,000,000    55,000,000
            Total Equity    52,993,000,000    60,756,000,000    63,716,000,000    67,860,000,000    69,649,000,000
            Total Liabilities and Equity    873,446,000,000    933,078,000,000    976,374,000,000    975,165,000,000    976,502,000,000
            Shares Outstand. (EOP)    1,622,938,436    1,711,061,742    1,726,013,398    1,756,617,620    1,770,239,507
            Weighted Avg. Shares    1,618,000,000    1,692,000,000    1,719,000,000    1,746,000,000    1,765,000,000
            Price per share    540    551    568    559    553
            Total Bo
owings    190,787,000,000    193,952,000,000    230,999,000,000    230,881,000,000    229,457,000,000
            EPS Aft. Abs.    532    530    559    518    469
            BV Per Share ($)    32    35    37    38    39
            Market Cap    138910867710    127251661752    142931169488    128004725969    146540426389
CF(CBA)
            Item    Jun-15    Jun-16    Jun-17    Jun-18    Jun-19    Jun-20    Jun-21    Jun-22    Jun-23    Jun-24    Jun-25    Jun-26    Jun-27    Jun-28    Jun-29    Jun-30
            Net Operating Cashflows    7,183,000,000    -4,561,000,000    -807,000,000    1,109,000,000    18,086,000,000
            Net Investing...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Attach File