Explore BrainMass

Explore BrainMass

    Target Corporation - Financial Ratios

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

    I need the following ratios solved on Target Corporation assuming that their is a 15% increase from last years annual report. I have attached a worksheet to use as the template(these figures are before the 15 % increase). However, it does show figures for Walmart as well. I don't need Walmart figures, just target. Here are the ratios i need:

    current ratio
    quick ratio
    debt to equity ratio
    net profit margin
    return on equity
    total assets turnover
    return on assets
    price earnings ratio
    the link for the annual report is:

    © BrainMass Inc. brainmass.com June 3, 2020, 8:07 pm ad1c9bdddf


    Solution Preview

    Please see the attached file.

    I use 15% increase from Target last year's annual report, that is from the year 2006.

    For average inventory, I increase it by 15% and add with the amount from the year 2006 and ...

    Solution Summary

    This solution is comprised of a detailed calculation and explanation to find the financial ratios for Target Corporation.