Profit Loss ASX CodeCompany NameItem06/1506/1606/1706/1806/19 CBACommonwealth Bank of AustraliaInterest...

1 answer below ยป
The assignment task sheet attached is called FINM Assignment. The CBA Final Data file is the data for CBA that needs to be used for the year 2015 to 2019. The An example of Halfords excel calculations file is just a template for how the CBA excel analysis should look like. The data in An example of Halfords excel calculations is not to be used as it is only a suggestive template. The data in An example of Halfords excel calculations is not to be used.


Profit Loss ASX CodeCompany NameItem06/1506/1606/1706/1806/19 CBACommonwealth Bank of AustraliaInterest Income34,100,000,000.0033,817,000,000.0033,293,000,000.0034,543,000,000.0034,588,000,000.00 CBACommonwealth Bank of AustraliaInterest 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 CBACommonwealth Bank of AustraliaNet Interest Income15,795,000,000.0016,935,000,000.0017,600,000,000.0018,341,000,000.0018,120,000,000.00 CBACommonwealth Bank of AustraliaProv. 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 CBACommonwealth Bank of AustraliaNet Int. Income Less Prov14,807,000,000.0015,679,000,000.0016,505,000,000.0017,262,000,000.0016,919,000,000.00 CBACommonwealth Bank of AustraliaNon Interest Income11,210,000,000.0010,562,000,000.0010,850,000,000.007,865,000,000.006,217,000,000.00 CBACommonwealth Bank of AustraliaTotal Operating Income26,017,000,000.0026,241,000,000.0027,355,000,000.0025,127,000,000.0023,136,000,000.00 CBACommonwealth Bank of AustraliaNon 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 CBACommonwealth Bank of AustraliaPreTax Profit12,696,000,000.0013,163,000,000.0013,864,000,000.0014,291,000,000.0012,405,000,000.00 CBACommonwealth Bank of AustraliaTax 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 CBACommonwealth Bank of AustraliaNet Profit after Tax Before Abnormals9,158,000,000.009,470,000,000.009,905,000,000.0010,265,000,000.009,014,000,000.00 CBACommonwealth Bank of AustraliaAbnormals-84,000,000.00-309,000,000.0080,000,000.00-871,000,000.00-642,000,000.00 CBACommonwealth Bank of AustraliaAbnormals Tax10,000,000.0086,000,000.00-33,000,000.000.000.00 CBACommonwealth Bank of AustraliaNet Abnormals-74,000,000.00-223,000,000.0047,000,000.00-871,000,000.00-642,000,000.00 CBACommonwealth Bank of AustraliaReported NPAT After Abnormals9,084,000,000.009,247,000,000.009,952,000,000.009,348,000,000.008,590,000,000.00 CBACommonwealth Bank of AustraliaOutside Equity Interests-21,000,000.00-20,000,000.00-24,000,000.00-19,000,000.00-19,000,000.00 CBACommonwealth Bank of AustraliaShares Outstanding at Period End1,622,938,436.001,711,061,742.001,726,013,398.001,756,617,620.001,770,239,507.00 CBACommonwealth Bank of AustraliaWeighted Average Number of Shares1,618,000,000.001,692,000,000.001,719,000,000.001,746,000,000.001,765,000,000.00 CBACommonwealth Bank of AustraliaEPS Adjusted (cents/share)535.94542.30556.45568.59491.78 CBACommonwealth Bank of AustraliaEPS After Abnormals (cents/share)531.60529.50559.10517.70468.60 Balance Sheet ASX CodeCompany NameItem06/1506/1606/1706/1806/19 CBACommonwealth Bank of AustraliaShort Term Money33,116,000,000.0023,372,000,000.0045,850,000,000.0022,897,000,000.0016,655,000,000.00 CBACommonwealth Bank of AustraliaInvestment Securities119,111,000,000.00119,221,000,000.00120,128,000,000.00131,114,000,000.00135,677,000,000.00 CBACommonwealth Bank of AustraliaDue From Banks0.000.000.000.008,093,000,000.00 CBACommonwealth Bank of AustraliaLoans639,262,000,000.00695,398,000,000.00731,762,000,000.00743,365,000,000.00755,141,000,000.00 CBACommonwealth Bank of AustraliaTotal Earning Assets791,489,000,000.00837,991,000,000.00897,740,000,000.00897,376,000,000.00915,566,000,000.00 CBACommonwealth Bank of AustraliaCustomer Acceptances1,944,000,000.001,431,000,000.00463,000,000.00379,000,000.0032,000,000.00 CBACommonwealth Bank of AustraliaFixed Assets2,833,000,000.003,940,000,000.003,873,000,000.002,576,000,000.002,383,000,000.00 CBACommonwealth Bank of AustraliaOther77,180,000,000.0089,716,000,000.0074,298,000,000.0074,834,000,000.0058,521,000,000.00 CBACommonwealth Bank of AustraliaTotal Non-Earning Assets81,957,000,000.0095,087,000,000.0078,634,000,000.0077,789,000,000.0060,936,000,000.00 CBACommonwealth Bank of AustraliaTotal Assets873,446,000,000.00933,078,000,000.00976,374,000,000.00975,165,000,000.00976,502,000,000.00 CBACommonwealth Bank of AustraliaDue to Banks36,416,000,000.0028,771,000,000.0028,432,000,000.0020,899,000,000.0023,370,000,000.00 CBACommonwealth Bank of AustraliaBank Acceptances1,944,000,000.001,431,000,000.00463,000,000.00379,000,000.0032,000,000.00 CBACommonwealth Bank of AustraliaDeposits543,231,000,000.00588,045,000,000.00626,655,000,000.00630,358,000,000.00623,158,000,000.00 CBACommonwealth Bank of AustraliaProvisions2,738,000,000.003,018,000,000.003,562,000,000.002,841,000,000.003,077,000,000.00 CBACommonwealth Bank of AustraliaBonds154,429,000,000.00161,284,000,000.00167,571,000,000.00172,693,000,000.00197,117,000,000.00 CBACommonwealth Bank of AustraliaOther81,695,000,000.0089,773,000,000.0085,975,000,000.0080,135,000,000.0060,099,000,000.00 CBACommonwealth Bank of AustraliaTotal Liabilities820,453,000,000.00872,322,000,000.00912,658,000,000.00907,305,000,000.00906,853,000,000.00 CBACommonwealth Bank of AustraliaShare Capital28,558,000,000.0033,845,000,000.0034,971,000,000.0037,270,000,000.0038,020,000,000.00 CBACommonwealth Bank of AustraliaReserves2,345,000,000.002,734,000,000.001,869,000,000.001,676,000,000.003,092,000,000.00 CBACommonwealth Bank of AustraliaRetained Earnings21,528,000,000.0023,627,000,000.0026,330,000,000.0028,360,000,000.0028,482,000,000.00 CBACommonwealth Bank of AustraliaOther Equity0.000.000.000.000.00 CBACommonwealth Bank of AustraliaConvertible Equity0.000.000.000.000.00 CBACommonwealth Bank of AustraliaSE Held Sale0.000.000.000.000.00 CBACommonwealth Bank of AustraliaOutside Equity562,000,000.00550,000,000.00546,000,000.00554,000,000.0055,000,000.00 CBACommonwealth Bank of AustraliaTotal Equity52,993,000,000.0060,756,000,000.0063,716,000,000.0067,860,000,000.0069,649,000,000.00 Cash Flow ASX CodeCompany NameItem06/1506/1606/1706/1806/19 CBACommonwealth Bank of AustraliaInterest Received34,067,000,000.0034,047,000,000.0033,536,000,000.0035,801,000,000.0034,757,000,000.00 CBACommonwealth Bank of AustraliaInterest 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 CBACommonwealth Bank of AustraliaDivideds Received0.000.000.000.000.00 CBACommonwealth Bank of AustraliaTax 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 CBACommonwealth Bank of AustraliaOther Operating Cashflows-6,015,000,000.00-19,252,000,000.00-15,361,000,000.00-14,545,000,000.003,902,000,000.00 CBACommonwealth Bank of AustraliaNet Operating Cashflows7,183,000,000.00-4,561,000,000.00-807,000,000.001,109,000,000.0018,086,000,000.00 CBACommonwealth Bank of AustraliaPayment 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 CBACommonwealth Bank of AustraliaProceeds From Sale of PPE69,000,000.00405,000,000.00381,000,000.00155,000,000.00151,000,000.00 CBACommonwealth Bank of AustraliaInvestments Purchased-270,000,000.000.000.00-271,000,000.0072,000,000.00 CBACommonwealth Bank of AustraliaProceeds From Sale of Investments0.000.000.000.000.00 CBACommonwealth Bank of AustraliaPayments for Purchase of Subsidiaries-29,000,000.00-857,000,000.00-31,000,000.0026,000,000.000.00 CBACommonwealth Bank of AustraliaProceeds from Sale of Subsidiaries72,000,000.00110,000,000.001,000,000.000.001,259,000,000.00 CBACommonwealth Bank of AustraliaLoans Granted0.000.000.000.000.00 CBACommonwealth Bank of AustraliaLoans Repaid0.000.000.000.000.00 CBACommonwealth Bank of AustraliaOther Investing Cashflows71,000,000.0078,000,000.0069,000,000.0068,000,000.00141,000,000.00 CBACommonwealth Bank of AustraliaNet Investing Cashflows-1,215,000,000.00-2,032,000,000.00-677,000,000.00-1,002,000,000.00983,000,000.00 CBACommonwealth Bank of AustraliaProceeds from Issues0.005,022,000,000.0028,000,000.000.000.00 CBACommonwealth Bank of AustraliaProceeds from Borrowings6,184,000,000.003,949,000,000.0098,317,000,000.0072,718,000,000.0058,027,000,000.00 CBACommonwealth Bank of AustraliaRepayment of Borrowings-7,693,000,000.00-460,000,000.00-81,758,000,000.00-68,273,000,000.00-76,384,000,000.00 CBACommonwealth Bank of AustraliaDividends 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 CBACommonwealth Bank of AustraliaOther Financing Cashflows-166,000,000.00-1,064,000,000.00-31,000,000.00-13,000,000.00-529,000,000.00 CBACommonwealth Bank of AustraliaNet Financing Cashflows-7,875,000,000.001,620,000,000.0010,472,000,000.00-934,000,000.00-25,739,000,000.00 CBACommonwealth Bank of AustraliaNet Increase in Cash-1,907,000,000.00-4,973,000,000.008,988,000,000.00-827,000,000.00-6,670,000,000.00 CBACommonwealth Bank of AustraliaCash at Beginning of Period19,128,000,000.0019,270,000,000.0014,447,000,000.0023,117,000,000.0023,005,000,000.00 CBACommonwealth Bank of AustraliaExchange Rate Adj2,049,000,000.00150,000,000.00-318,000,000.00715,000,000.00675,000,000.00 CBACommonwealth Bank of AustraliaOther Cash Adjustments0.000.000.000.000.00 CBACommonwealth Bank of AustraliaCash at End of Period19,270,000,000.0014,447,000,000.0023,117,000,000.0023,005,000,000.0017,010,000,000.00 Per Share Statisticts ASX CodeCompany NameItem06/1506/1606/1706/1806/19 CBACommonwealth Bank of AustraliaShares Outstand. (EOP)1,622,938,436.001,711,061,742.001,726,013,398.001,756,617,620.001,770,239,507.00 CBACommonwealth Bank of AustraliaWeighted Avg. Shares1,618,000,000.001,692,000,000.001,719,000,000.001,746,000,000.001,765,000,000.00 CBACommonwealth Bank of AustraliaEPS Bef. Abs560.14545.33577.55534.31485.61 CBACommonwealth Bank of AustraliaEPS Aft. Abs.531.60529.50559.10517.70468.60 CBACommonwealth Bank of AustraliaDilution Factor--0.99------ CBACommonwealth Bank of AustraliaCumulative0.991.001.001.001.00 CBACommonwealth Bank of AustraliaReportd EPS Bef. Abs.Adj533.05542.30556.45568.59491.78 CBACommonwealth Bank of AustraliaDPS - Adj Ex. Special417.73420.00429.00431.00431.00 CBACommonwealth Bank of AustraliaDPS - Adj.417.73420.00429.00431.00431.00 CBACommonwealth Bank of AustraliaInterim Div - Ordinary198.00198.00199.00200.00200.00 CBACommonwealth Bank of AustraliaInterim Franking - Ord (%)100.00100.00100.00100.00100.00 CBACommonwealth Bank of AustraliaGross Interim Div - Ord282.86282.86284.29285.71285.71 CBACommonwealth Bank of AustraliaFinal Dividend - Ordinary222.00222.00230.00231.00231.00 CBACommonwealth Bank of AustraliaFinal Franking - Ordinary (%)100.00100.00100.00100.00100.00 CBACommonwealth Bank of AustraliaGross Final Div - Ord317.14317.14328.57330.00330.00 CBACommonwealth Bank of AustraliaSpecial Dividend - Ord0.000.000.000.000.00 CBACommonwealth Bank of AustraliaSpecial Franking - Ord (%)---------- CBACommonwealth Bank of AustraliaGross Special Div - Ord0.000.000.000.000.00 CBACommonwealth Bank of AustraliaTotal Div - Ex. Special420.00420.00429.00431.00431.00 CBACommonwealth Bank of AustraliaTotal Div - Inc. Special420.00420.00429.00431.00431.00 CBACommonwealth Bank of AustraliaTotal Franking - Ex. Spec100.00100.00100.00100.00100.00 CBACommonwealth Bank of AustraliaTotal Franking - Inc. Spec (%)100.00100.00100.00100.00100.00 CBACommonwealth Bank of AustraliaTotal Gross Div- Ex.Spec600.00600.00612.86615.71615.71 CBACommonwealth Bank of AustraliaTotal Gross Div- Inc.Spec600.00600.00612.86615.71615.71 CBACommonwealth Bank of AustraliaTax Rate (%)27.8728.0628.5628.1727.34 CBACommonwealth Bank of AustraliaCorporate Tax Rate (%)30.0030.0030.0030.0030.00 CBACommonwealth Bank of AustraliaPayout Ratio Ex. Special (%)78.3777.4577.1075.8087.64 CBACommonwealth Bank of AustraliaPayout Ratio (%)78.3777.4577.1075.8087.64 CBACommonwealth Bank
finm-assignment-hcxtkncg.docx cba-final-data-21pdhz0l.xlsx an-example-of-halfords-excel-calculations-prrktkfo.xlsx
Answered Same DaySep 29, 2021

Answer To: Profit Loss ASX CodeCompany NameItem06/1506/1606/1706/1806/19 CBACommonwealth Bank of...

Tanmoy answered on Oct 02 2021
150 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 Borrowings    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
Have files?