Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am having trouble with calculating those things. please do not just merely put answers below the questions. i need to know how that amount

image text in transcribed

I am having trouble with calculating those things. please do not just merely put answers below the questions. i need to know how that amount came. so please write whole calculation process. thanks !!

image text in transcribed 1. 4. On the following pages are the annual financial statements of Target. Please utilize the financial statements to calculate the following: (16 points) DO SELF WRITE IN 1234 a) EBITDA (Depreciation and Amortization are on the cash flow statement) for 2011 b) Current Ratio for 2011 c) Gross margin as a % of sales for 2011 d) Interest Coverage ratio for 2011 e) Debt to equity ratio for 2011 f) In dollar what was the dollar amount of common stock repurchased in 2010? g) What is the net margin of the credit card business including nonrecourse debt collateralized by credit card receivables? h) How much longterm debt was repaid in 2011? Consolidated Statements of Operations (millions, except per share data) Sales Credit card revenues Total revenues Cost of sales Selling, general and administrative expenses Credit card expenses Depreciation and amortization Earnings before interest expense and income taxes Net interest expense Nonrecourse debt collateralized 2010 2011 2009 $ $ $ 65,786 63,435 68,466 1,39 1,60 1,92 4 2 9 67,39 65,35 69,86 0 7 5 45,72 44,06 47,86 5 2 0 13,46 13,07 14,10 9 8 6 86 1,52 44 0 1 6 2,13 2,08 2,02 4 3 1 5,32 5,25 4,67 2 2 3 by credit card receivables Other interest expense Interest income Net interest expense Earnings before income taxes Provision for income taxes Net earnings Basic earnings per share Diluted earnings per share Weighted average common shares outstanding Basic 72 79 7 (3) 86 6 4,45 6 1,52 7 $ 2,929 $ 4.31 $ 4.28 8 3 67 7 (3) 75 7 4,49 5 1,57 5 $ 2,920 $ 4.03 $ 4.00 9 7 70 7 (3) 80 1 3,87 2 1,38 4 $ 2,488 $ 3.31 $ 3.30 Diluted 679.1 683.9 723.6 729.4 752.0 754.8 Consolidated Statements of Financial Position Balance Sheet January 28, 2012 (millions, except footnotes) Assets $ Cash and cash equivalents, including marketable securities of $194 and 794 $1,129 Credit card receivables, net of allowance of $430 and $690 5,927 7,918 Inventory Other current assets 1,810 16,449 Total current assets Property and equipment 6,122 Land 26,837 Buildings and improvements Fixtures and equipment January 29, 2011 $ 1,712 6,153 7,596 1,752 17,213 5,928 23,081 Computer hardware and software Constructioninprogress Accumulated depreciation Property and equipment, net Other noncurrent assets Total assets Liabilities and shareholders' investment Accounts payable Accrued and other current liabilities Unsecured debt and other borrowings Nonrecourse debt collateralized by credit card receivables Total current liabilities Unsecured debt and other borrowings Nonrecourse debt collateralized by credit card receivables Deferred income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders' investment Common stock Additional paidin capital Retained earnings Accumulated other comprehensive loss Total shareholders' investment Total liabilities and shareholders' investment 5,141 2,468 963 (12,382) 29,149 1,032 $ 46,630 4,939 2,533 567 (11,555) 25,493 999 $ 43,705 $ 6,857 3,644 3,036 750 14,287 13,447 250 1,191 1,634 16,522 $ 6,625 3,326 119 10,070 11,653 3,954 934 1,607 18,148 56 3,487 12,959 (681) 15,821 $ 59 3,311 12,698 (581) 15,487 $ 46,630 43,705 Common Stock Authorized 6,000,000,000 shares, $0.0833 par value; 669,292,929 shares issued and outstanding at January 28, 2012; 704,038,218 shares issued and outstanding at January 29, 2011. Preferred Stock Authorized 5,000,000 shares, $0.01 par value; no shares were issued or outstanding at January 28, 2012 or January 29, 2011. a) EBITDA (Depreciation and Amortization are on the cash flow statement) for 2011 EBITDA = earnings before interest, taxes, depreciation, and amortization (decrease in value of an intangible asset or assets over time) REPEAT 1234 b) Current Ratio for 2011 REPEAT 1234 Current Ratio = measures a company's ability to meet its shortterm obligations c) Gross margin as a % of sales for 2011 REPEAT 1234 Gross Margin = proportion of each dollar of revenue that the company banks as gross profit (Total Revenue - COGS) d) Interest Coverage ratio for 2011 REPEAT 1234 Interest Coverage Ratio = ratio used to determine how easily a company can pay interest on outstanding debt e) Debt to equity ratio for 2011 REPEAT 1234 Debt to Equity Ratio = measure of a company's financial leverage and indicates what proportion of equity and debt the company is using to finance its assets f) In dollar what was the dollar amount of common stock repurchased in 2010? g) What is the net margin (borrowed money that is used to pay securities) of the credit card business including nonrecourse (secured loan/debt that is secured by a pledge of collateral but for which the borrower is not personally liable) debt collateralized by credit card receivables (interest payments they will receive on credit cards)? h) How much longterm debt was repaid in 2011? Discounted cash flow (DCF) valuation Calculating the present value of a future cash flow to determine tis value today FV = $1,000 I = 15% N = 3 years PV = $657.5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Derivatives Markets

Authors: Robert L. McDonald

2nd Edition

032128030X, 978-0321280305

More Books

Students also viewed these Finance questions