As a member of the elite team of management consultants, you are invited by the Board of Governors to review and advise on the financial management practices of CVS Health Corp (CVS). Part I: Review...

1 answer below »

As a member of the elite team of management consultants, you are invited by the Board of Governors toreviewandadviseon the financial management practices of CVS Health Corp (CVS).




Part I: Review.Part I of the project report should include, but not limited to:


a.A brief overview of the company’s business and profitability.Reading through one of the company’s quarterly or annual reports will help tremendously on understanding the company and the rest of the project.


b.You are given the basic financial data from the company’s filings for the past few years.You are free to collect additional data that you think may help your analysis, for example, CVS’s equity trading data (price, volume, beta, etc), debt rating data, etc.You should use Excel to store and process your data.Please avoid including entire spreadsheets in the project report.Exhibits in the project report should be tables, charts, or graphs that illustrate specific points.The Excel file you use should be submitted as an attachment separately from the project report.


c.Review the company’s capital structure (leverage), calculating appropriate ratios, tracking changes through the year, tax savings from interest (if any), indications of potential financial distress (if any), etc.


d.Review the company’s retain/payout, dividend/repurchase practices.


e.Review the company’s short-term financial management practice, including, but not limited to, firm’s operating and cash cycle, accounting liquidity, short-term borrowings, and short-term investments in marketable securities.



Part II: Comparables, Special topic, Final Evaluation and Recommendation.Part II of the project report should include, but not limited to:


a.You are given the data ofonecomparable company to analyze. Matching on sales and within Dow Jones Industry Classification of Pharmacies/Drug Stores, we chose Walgreens Boots Alliance Inc.(WBA).


b.Chooseat least oneaspect from 1) capital structure, 2) payout/dividend policy, 3) short-term financial management on which to compare the company of interest and its comparables.


c.ChooseONEfrom the following topics of corporate finance on which to review the practice of the company of interest: 1) International operations, 2) Enterprise risk management, 3) use of Options, 4) past and potential Mergers and Acquisitions, 5) Leasing.


d.Please make sure to include any assumptions you made in your analysis.


e.Your report should explain your findings and recommendations to the Board.In the concluding section you should give your evaluations (seals of approval) or recommendations separately on each aspect of financial management that you analyze.

Answered Same DayMay 10, 2021

Answer To: As a member of the elite team of management consultants, you are invited by the Board of Governors...

Neenisha answered on May 16 2021
148 Votes
CVS_Health_Corp_Annual_BalanceS
    Period End Date    31-Dec-19    31-Dec-18    31-Dec-17    31-Dec-16    31-Dec-15
    Update Type/Date    Normal    Normal    Restated    Normal    Restated
    Auditor/Accountant    Ernst & Young
    Accounting Standard    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)
    Annual Balance Sheet: (USD)
    Cash and Short Term Investments    8056000000    6587000000    1821000000    3458000000    2547000000
    Cash    5683000000    4065000000    1710000000    3371000000    2459000000
    Short Term Investments    2373000000    2522000000    111000000    87000000    88000000
    Total Receivables Net    19617000000    17631000000    13181000000    12164000000    11888000000
    Net Receivables    17236000000    16810000000    13035000000    12164000000    11888000000
    Accounts Receivable Gross    17555000000    17303000000    13342000000    12450000000    12049000000
    Provision for Bad Debt    -319000000    -493000000    -307000000    -286000000    -161000000
    Other Receivables    2381000000    821000000    146000000         
    Total Inventories    17516000000    16450000000    15296000000    14760000000    14001000000
    Finished Goods    17516000000    16450000000    15296000000    14760000000    14001000000
    Other Current Assets    5113000000    4575000000    931000000    660000000    722000000
    Miscellaneous Current Assets    5113000000    4575000000    931000000    660000000    722000000
    Total Current Assets    50302000000    45243000000    31229000000    31042000000    29158000000
    Net Property, Plant and Equipment    32904000000    11349000000    10292000000    10175000000    9855000000
    Property, Plant a
nd Equipment - Gross    49794000000    26869000000    24290000000    22802000000    21036000000
    Buildings    4068000000    3785000000    3343000000    3226000000    3168000000
    Land    1981000000    1872000000    1707000000    1734000000    1635000000
    Machinery/Equipment    13807000000    13028000000    11963000000    10956000000    10001000000
    Computer Software and Equipment    3467000000    2800000000    2484000000    2392000000    2217000000
    Other Property/Plant/Equipment    5611000000    5384000000    4793000000    4494000000    4015000000
    Accumulated Depreciation    16890000000    15520000000    13998000000    12627000000    11181000000
    Total Investments and Advances    17585000000    15962000000    302000000         
    Long Term Investments    17585000000    15962000000    302000000         
    Intangible Assets    1.13E+11    1.15E+11    52081000000    51760000000    51984000000
    Goodwill- Net    79749000000    78678000000    38451000000    38249000000    38106000000
    Other Intangible Assets    33121000000    36524000000    13630000000    13511000000    13878000000
    Deferred Tax Assets    1845000000    1754000000    930000000         
    Other Assets    8788000000    8700000000    1227000000    1485000000    1440000000
    Deferred Charges    494000000    147000000              
    Other Tangible Assets    8294000000    8553000000    1227000000    1485000000    1440000000
    Total Assets    2.24E+11    1.98E+11    96061000000    94462000000    92437000000
    ST Debt and Curr Portion LT Debt    5377000000    1985000000    4821000000    1916000000    1197000000
    Short Term Debt    1596000000    720000000    1276000000    1874000000    
    Current Portion of Long Term Debt/Capital Leases    3781000000    1265000000    3545000000    42000000    1197000000
    Accounts Payable    30972000000    26437000000    19223000000    17397000000    15143000000
    Other Current Liabilities    16954000000    15587000000    6604000000    6937000000    6829000000
    Accrued Payroll    25000000    25000000    21000000         
    Miscellaneous Current Liabilities    16929000000    15562000000    6583000000    6937000000    6829000000
    Total Current Liabilities    53303000000    44009000000    30648000000    26250000000    23169000000
    Long-Term Debt    83625000000    71444000000    22181000000    25615000000    26267000000
    Long Term Debt excluding Capitalized Leases    63918000000    70876000000    21511000000    25615000000    26267000000
    Non-Convertible Debt    63918000000    70876000000    21511000000    25615000000    26267000000
    Captilized Lease Obligations    781000000    568000000    670000000         
    Provision for Risks and Charges    313000000    300000000    110000000         
    Deferred Tax Liabilities    9139000000    9431000000    3926000000    4214000000    4217000000
    Other Liabilities    13744000000    14483000000    1501000000    1549000000    1542000000
    Other Liabilities (excl. Deferred Income)    13744000000    14483000000    1501000000    1549000000    1542000000
    Total Liabilities    1.60E+11    1.40E+11    58366000000    57628000000    55195000000
    Common Equity    63864000000    58225000000    37691000000    36830000000    37196000000
    Common Stock    45972000000    17000000    17000000    17000000    17000000
    Capital Surplus         45423000000    32079000000    31618000000    30948000000
    Retained Earnings    45108000000    40911000000    43556000000    38983000000    35506000000
    Unrealized Foreign Exchange Gain/Loss    4000000    -158000000    -129000000    -127000000    -165000000
    Unrealized Gain/Loss Marketable Securities    774000000    97000000              
    Other Appropriated Reserves    241000000    163000000    -36000000    -178000000    -193000000
    Treasury Stock    -28235000000    -28228000000    -37796000000    -33483000000    -28917000000
    Total Shareholders Equity    63864000000    58225000000    37691000000    36830000000    37196000000
    Accumulated Minority Interest    306000000    318000000    4000000    4000000    46000000
    Total Stockholders' Equity    64170000000    58543000000    37695000000    36834000000    37242000000
    Total Liabilities and Shareholders Equity    2.24E+11    1.98E+11    96061000000    94462000000    92437000000
    Cash    8056000000    6587000000    1821000000    3458000000    2547000000
    Total Short Term Investments    2373000000    2522000000    111000000    87000000    88000000
    Other Investments    17585000000    15962000000    302000000         
    Goodwill, Gross    79749000000    78678000000    38451000000    38249000000    38106000000
    Other Intangible Assets Gross    1.22E+11    1.22E+11    58380000000    57255000000    56693000000
    Amortization of Intangible Assets    9038000000    7214000000    6299000000    5495000000    4709000000
    Total Debt    89002000000    73429000000    27002000000    27531000000    27464000000
    Accrued Expenses    12060000000    10711000000    6581000000    6937000000    6829000000
    Comprehensive Income- Hedging Gain or Loss    279000000    312000000    -15000000    -5000000    -7000000
    Other Accrued Expenses    12035000000    10686000000    6560000000    6937000000    6829000000
    Par Value    0.01    0.01    0.01    0.01    0.01
    Working Capital- Total    -3001    1234    581    4792    5989
    Invested Capital - Total    1.47E+11    1.30E+11    59872000000    62445000000    63463000000
    Total Capital    152866    131654    64693    64361    64660
    Common Shares Outstanding    1302000000    1295000000    1014000000    1061000000    1101000000
    Treasury Shares    425    426    699    644    597
    Investments and Long Term Receivables    17585000000    15962000000    302000000         
    Deferred Taxes and Investment Tax Credit    7294000000    7677000000    2996000000    4214000000    4217000000
    Lease Commitments Over 5 Years    15654000000    16004000000         16368000000    
    Lease Commitments- Year 1    2699000000    2690000000         2458000000    
    Lease Commitments- Year 2    2598000000    2544000000         2361000000    
    Lease Commitments- Year 3    2444000000    2399000000         2209000000    
    Lease Commitments- Year 4    2335000000    2233000000         2040000000    
    Lease    2103000000    2110000000         1910000000    
Quarterly_BalanceSheet
    Period End Date    31-Dec-19    30-Sep-19    30-Jun-19    31-Mar-19    31-Dec-18
    Update Type/Date    Normal    Normal    Normal    Normal    Normal
    Auditor/Accountant    Ernst & Young
    Accounting Standard    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)
    Interim Balance Sheet: (USD)
    Cash and Short Term Investments    8056000000    7533000000    8531000000    8328000000    6587000000
    Cash    5683000000    5199000000    6069000000    5902000000    4065000000
    Total Receivables Net    19617000000    19789000000    18174000000    19509000000    17631000000
    Net Receivables    17236000000    17782000000    17422000000    18641000000    16810000000
    Accounts Receivable Gross    17555000000    17782000000    17422000000    18641000000    17303000000
    Provision for Bad Debt    -319000000                   -493000000
    Other Receivables    2381000000    2007000000    752000000    868000000    821000000
    Total Inventories    17516000000    16028000000    15511000000    15448000000    16450000000
    Finished Goods    17516000000    16028000000    15511000000    15448000000    16450000000
    Other Current Assets    5113000000    4835000000    4685000000    4572000000    4575000000
    Miscellaneous Current Assets    5113000000    4835000000    4685000000    4572000000    4575000000
    Total Current Assets    50302000000    48185000000    46901000000    47857000000    45243000000
    Net Property, Plant and Equipment    32904000000    32408000000    32348000000    32340000000    11349000000
    Property, Plant and Equipment - Gross    49794000000                   26869000000
    Computer Software and Equipment    3467000000                   2800000000
    Accumulated Depreciation    16890000000                   15520000000
    Total Investments and Advances    17585000000    17612000000    17242000000    16676000000    15962000000
    Long Term Investments    17585000000    17612000000    17242000000    16676000000    15962000000
    Intangible Assets    112870000000    113203000000    113648000000    114222000000    115202000000
    Goodwill- Net    79749000000    79548000000    79485000000    79075000000    78678000000
    Other Intangible Assets    33121000000    33655000000    34163000000    35147000000    36524000000
    Deferred Tax Assets    1845000000                   1754000000
    Other Assets    8788000000    8705000000    8765000000    8673000000    8700000000
    Deferred Charges    494000000                   147000000
    Other Tangible Assets    8294000000    8705000000    8765000000    8673000000    8553000000
    Total Assets    224294000000    220113000000    218904000000    219768000000    198210000000
    ST Debt and Curr Portion LT Debt    5377000000    6646000000    6133000000    8701000000    1985000000
    Short Term Debt    1596000000    2868000000    2239000000    4808000000    720000000
    Current Portion of Long Term Debt/Capital Leases    3781000000    3778000000    3894000000    3893000000    1265000000
    Accounts Payable    30972000000    29555000000    27986000000    26818000000    26437000000
    Other Current Liabilities    16954000000    16343000000    15257000000    15112000000    15587000000
    Accrued Payroll    25000000                   25000000
    Miscellaneous Current Liabilities    16929000000    16343000000    15257000000    15112000000    15562000000
    Total Current Liabilities    53303000000    52544000000    49376000000    50631000000    44009000000
    Long-Term Debt    83625000000    83032000000    85790000000    86849000000    71444000000
    Long Term Debt excluding Capitalized Leases    63918000000    63615000000    66382000000    67353000000    70876000000
    Captilized Lease Obligations    781000000    591000000    559000000    535000000    568000000
    Provision for Risks and Charges    313000000                   300000000
    Deferred Tax Liabilities    9139000000    7279000000    7375000000    7540000000    9431000000
    Other Liabilities    13744000000    14325000000    14764000000    14742000000    14483000000
    Other Liabilities (excl. Deferred Income)    13744000000    14325000000    14764000000    14742000000    14483000000
    Total Liabilities    160124000000    157180000000    157305000000    159762000000    139667000000
    Common Equity    63864000000    62614000000    61282000000    59686000000    58225000000
    Common Stock    45972000000    17000000    17000000    17000000    17000000
    Capital Surplus         45837000000    45702000000    45598000000    45423000000
    Retained Earnings    45108000000    44017000000    43136000000    41859000000    40911000000
    Unrealized Foreign Exchange Gain/Loss    4000000    -1000000    -154000000    -157000000    -158000000
    Unrealized Gain/Loss Marketable Securities    774000000    818000000    682000000    431000000    97000000
    Other Appropriated Reserves    241000000    133000000    156000000    159000000    163000000
    Treasury Stock    -28235000000    -28207000000    -28257000000    -28221000000    -28228000000
    Total Shareholders Equity    63864000000    62614000000    61282000000    59686000000    58225000000
    Accumulated Minority Interest    306000000    319000000    317000000    320000000    318000000
    Total Stockholders' Equity    64170000000    62933000000    61599000000    60006000000    58543000000
    Total Liabilities and Shareholders Equity    224294000000    220113000000    218904000000    219768000000    198210000000
    Cash    8056000000    7533000000    8531000000    8328000000    6587000000
    Total Short Term Investments    2373000000    2334000000    2462000000    2426000000    2522000000
    Other Investments    17585000000    17612000000    17242000000    16676000000    15962000000
    Other Intangible Assets Gross    121908000000                   122416000000
    Amortization of Intangible Assets    9038000000                   7214000000
    Total Debt    89002000000    89678000000    91923000000    95550000000    73429000000
    Comprehensive Income- Hedging Gain or Loss    279000000    282000000    305000000    308000000    312000000
    Other Accrued Expenses    12035000000    11615000000    10562000000    10443000000    10686000000
    Par Value    0.01    0.01    0.01    0.01    0.01
    Working Capital- Total    -3001    -4359    -2475    -2774    1234
    Invested Capital - Total    147489000000    145646000000    147072000000    146535000000    129669000000
    Total Capital    152866    152292    153205    155236    131654
    Common Shares Outstanding    1302000000    1301000000    1299000000    1298000000    1295000000
    Treasury Shares    425    424    425    424    426
    Investments and Long Term Receivables    17585000000    17612000000    17242000000    16676000000    15962000000
    Deferred Taxes and Investment Tax Credit    7294000000    7279000000    7375000000    7540000000    7677000000
Annual_CashFlow
    Period End Date    31-Dec-19    31-Dec-18    31-Dec-17    31-Dec-16    31-Dec-15
    Update Type/Date    Normal    Normal    Restated    Normal    Restated
    Auditor/Accountant    Ernst & Young
    Accounting Standard    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)    U.S. standards (GAAP)
    Annual Cash Flow Statement: (USD)
    Net Income Or Starting Line    6631000000    -596000000    6623000000    5319000000    5239000000
    Depreciation, Depletion and Amortization    4371000000    2718000000    2479000000    2475000000    2092000000
    Accumulated Depreciation and Depletion    1900000000    1700000000    1700000000    1700000000    1500000000
    Amortization of Intangibles    2471000000    1018000000    779000000    775000000    592000000
    Deferred Taxes and Investment Tax Credit    -654000000    87000000    -1334000000         
    Deferred Taxes    -654000000    87000000    -1334000000         
    Total Other Cash Flow    1001000000    6768000000    655000000    1018000000    -36000000
    Funds from Operations    11349000000    8977000000    8423000000    8812000000    7295000000
    Changes in Working Capital    1499000000    -112000000    -416000000    1257000000    1117000000
    Decrease Or Increase In Receivables    -2158000000    -1139000000    -941000000    -243000000    -1594000000
    Decrease Or Increase In Inventories    -1075000000    -1153000000    -514000000    -742000000    -1141000000
    Increase/Decrease In Accounts Payable    3870000000    2018000000    1710000000    2189000000    2834000000
    Increase/Decrease In Other Accruals                   59000000    765000000
    Decrease Or Increase In Other Assets Or Liability    862000000    162000000    -671000000    -6000000    253000000
    Net Cash from Operating Activities    12848000000    8865000000    8007000000    10069000000    8412000000
    Capital Expenditures    -2457000000    -2037000000    -1918000000    -2224000000    -2367000000
    Capital Expenditures - Additions to Fixed Assets    -2457000000    -2037000000    -1918000000    -2224000000    -2367000000
    Net Assets From Acquisitions    -444000000    -42226000000    -1181000000    -578000000    -11475000000
    Disposal of Fixed Assets    5000000    832000000    265000000    267000000    446000000
    Purchase Or Sale Of Investments    -485000000    125000000    -76000000    26000000    -24000000
    Increase In Investments    7534000000    692000000    137000000    65000000    267000000
    Decrease In Investments    7049000000    817000000    61000000    91000000    243000000
    Other...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here