Please Calculate the following ratios for fiscal year 2008: a. Current Ratio b.A
ID: 2640313 • Letter: P
Question
Please Calculate the following ratios for fiscal year 2008:
a. Current Ratio
b.Acid-test ratio
c.Inventory turnover
d.Days' sales in receivables
e.Debt Ratio
f.Times-Intrest-earned ratioi
g.Rate of return on net sales
h.Rate of return on total assets
i.Rate of return on common stockholders' equity
j.Earnings per share of common stockholders' equity
k.Price/earnings ratio
l. Dividend yield
m. Book value per share of common stock
Target Corporation income statment is presented below
Target Corporation
Income Statment (Adapted)
For the Fiscal Year 2008 and 2007
(Dollars in Million) 2008 2007
Sales Revenue** $63,339 $62,530
Cost of Goods Sold 44,157 42,929
Gross Profit 19,182 19,601
Operating Expenses: 12,954 12,670
Selling,general,and Administrative 1,826 1,659
Depreciation 4,402 5,272
Operating income 866 647
Intrest expense,net 1,322 1,776
Income tax expense $2,214 $2,489
Net income
Also, the company's balance sheet (adaptes), at the end of fiscal year 2008 and 2007 provided.
Target Corporation
Balance Sheet (Adapted)
End of Fiscal Year*
(Dollars In Millions) 2008 2007
Current assets $864 $2,450
Cash and Cash equivalents 8,084 8,054
Credit Card receivables, net of allowance 6,705 6,780
Other Current Assets 1,835 1,622
Total Current Assets 17,488 18,906
Property,plant,and equitment net 25,756 24,095
Other noncurrent assets 862 1,559
Total Assets $44,106 $44,560
Current Liablilites
Accounts Payable $6,337 $$6,721
Other Current Liabilites 4,175 5,061
Total current liabilites 10,512 11,782
Long-term liabilites 19,882 17,471
Total Liabilites 30,394 29,253
Common stock and Additional paid in capital 2,825 2,724
Retained earnings* 10,887 12,583
Total stockholders' equity 13,712 15,307
Total liabilites and equity $44,106 $44,560
* January 31 2009 ( fiscal year 2008) and Febuary 2,2008 ( Fiscal year 2007)
Other Company Information is as follows:
Target has no prefeered stock issued or outstanding
There were 752,712,464 common shares issued and outsanding at the end of fiscal year 2008
Cash dividends of $0.62 per share were declared during fiscal year 2008
The closing marker price per share was $31.20 on Friday,January 30,2009 ( the end of fiscal year 2008) and $57.05 on Friday,Febuary 1,2008 (the end of fiscal year 2007)
Explanation / Answer
Current Ratio = Current Assets/Current Liabilities
17488/10512 = 1.664
Acid Test Ratio =
Cash Equivalents + Marketable Securities + Net Receivables/Current Liabilities
15653/10512 = 1.4890
Inventory Turnover Ratio = Turnover/Inventory (Here, other current Assets assumed as Inventory as no other info available)
=63339/1835 = 34.517
Days' sales in receivables = (Inventory/Cost of sales) * 365
=(1835/44157)*365 = 15.1680
Debt Ratio = Total Liabilities/Total Assets
= 30394/44106 = 0.689
Times Interest Earned Ratio = Income before Interest and Taxes (EBIT)/Interest cost
=(19182(Gross profit)-1826(Selling Exps)-4402(Depreciation)+866(Operating Income)/1322(Interest cost) =10.4539
Rate of return on net sales = Net Income(Before Interest and Tax)/Sales
= 13820(As clculated above)/63339 =0.21819
Rate of return on total assets = Net Income(Before Interest and Tax) / Total Assets
=13820(As clculated above)/44106 = 0.31333
Rate of return on common stockholders' equity = net income - preferred dividends / Average common equity
= 13820(As clculated above) -1322(interest) - 2214(Tax) /2774.5 = 3.7066
Average Equity = (Opening Equity + Closing Equity)/2 = (2825+2724)/2 = 2774.5
Earnings per share of common stockholders' equity = Net Income/Weighted avg no. of shares outstanding
= 10284/752712464 = 0.00001366 (In Million Dollars)
Price/earnings ratio = Market Value per Share / Earnings per Share (EPS)
= (752712464*31.20)/13.66 = 1719226126 or 171.9226(In Milion Dollars)
Dividend yield = Annual Dividends per share / Price per share
= 0.62/31.20 = 0.01987
Book value per share of common stock = Total shareholders equity/No. of shares
=(13712*1000000)/752712464 = 18.216
Cash Equivalents + Marketable Securities + Net Receivables/Current Liabilities