Explore BrainMass
Share

Explore BrainMass

    Financial analysis of Wal-Mart compared to Target

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Prepare a report on the financial analysis of these two companies. Perform the structured analysis steps 1-4 as laid out in Chapter 2 Data Case, on pages 45-46 in the textbook.

    Analyze the performance of the stocks of the two case companies relative to the price/earnings ratios. Calculate these ratios for the past three years and tell why you think these differences have occurred, supporting your reasoning.
    Data Case from 45-46 states:

    1. Download the annual income statements, balance sheets, and cash flow statements for the four years from MarketWatch.com.

    2. Find historical stock prices for each firm from Yahoo! Finance. Use the closing stock; calculate the firm's market capitalization for each date to cover the last day of the month by the firm's historic stock price.

    3. For each of the four years statements compute:
    a. Valuation Ratios
    i. Price-earnings
    ii. Market to Book Ratio
    iii. Enterprise
    b. Profitability Ratios
    i. Operating Margin
    ii. Net Profit
    iii. Return on Equity
    c. Financial Strength Ratios
    i. Current Ratio
    ii. Book Debt- Equity Ratio
    iii. Market Debt- Equity Ratio
    iv. Interest Coverage Ratio ( EBIT Divided by interest expense)

    4. Obtain industry averages for each from firm from Reuters.com and co

    © BrainMass Inc. brainmass.com October 9, 2019, 11:37 pm ad1c9bdddf
    https://brainmass.com/business/financial-statements/financial-analysis-of-wal-mart-compared-to-target-262398

    Attachments

    Solution Preview

    Data Case from 45-46 states:

    1. Download the annual income statements, balance sheets, and cash flow statements for the four years from MarketWatch.com.
    Attached in the excel file
    2. Find historical stock prices for each firm from Yahoo! Finance. Use the closing stock; calculate the firm's market capitalization for each date to cover the last day of the month by the firm's historic stock price.
    Price to earning ratio is taken from the source www.moneycentral.com

    3. For each of the four years statements compute:
    a. Valuation Ratios
    i. Price-earnings
    ii. Market to Book Ratio
    iii. Enterprise
    b. Profitability Ratios
    i. Operating Margin
    ii. Net Profit
    iii. Return on Equity
    c. Financial Strength Ratios
    i. Current Ratio
    ii. Book Debt- Equity Ratio
    iii. Market Debt- Equity Ratio
    iv. Interest Coverage Ratio ( EBIT Divided by interest expense)

    4. Attached in the excel file

    4. Obtain industry averages for each from firm from Reuters.com and ...

    Solution Summary

    Response provide the steps to compute the financial analysis of Wal-Mart compared to Target

    $2.19