1> for fiscal year 2013, rank the following assets in terms of which was the largest as a % of. 2> for fiscal year 2013, rank the following items in terms of which was the largest as a. 1> rank the following items in terms of which had the largest % increase from fiscal 2012 to. 2> rank the following items in terms of which had the largest dollar increase from fiscal 2012 to. Place a 1 in the box of the largest, a 2 in the box of the second largest, etc. Dupont analysis -- return on assets ratio (pg. 1> which fiscal year, 2013 or 2012, had higher profitability based on gross profit margin %, operating profit.

Related Questions

BradburnCorporation was formed 5 years ago through a public subscription ofcommon stock. Daniel Brown,

who owns

15%

owns 15% of the common stock, was one of theorganizers of Bradburn and is its

current president. The companyhas been successful, but it currently is experiencing a shortage offunds. On

June 10, Daniel Brownapproached the Topeka National Bank, asking for a 24-monthextension on two

$35,000

notes, which are due on June30, 2013, and September 30, 2013. Another note of

$6,000

is due

on March 31, 2014, but heexpects no difficulty in paying this note on its due date. Brownexplained that

Bradburnâs cash flow problemsare due primarily to the companyâs desire to finance a

$300,000

plant

expansion over the next 2fiscal years through internally generated funds.

The commercialloan officer of Topeka National Bank requested financial reportsfor the last 2 fiscal years.

BRADBURN CORPORATION

Statement of FinancialPosition

Accounts receivable (net)

131,800

125,500

Inventories (at cost)

105,000

50,000

Plant & equipment (net ofdepreciation)

Liabilities and Owners'Equity

Common stock (130,000 shares,$10 par)

Total liabilities and owners'equity

$1,852,000

$1,740,500

^aCash dividends were paid at the rate of $1.00 per sharein fiscal year 2012
and $2.00 per share in fiscal year 2013.

SANDBURG CORPORATION

Income Statement

For The Fiscal Year EndedMarch 31

Income before incometaxes

Net income after incometaxes

$366,000

$297,000

Depreciation charges on theplant and equipment of

$100,000

and

$102,500

for the fiscal years endedMarch 31, 2012 and 2013, respectively, are included in cost ofgoods sold.

Instructions:

Fill in the provided matrixand utilize it as the matrix for "VLOOKUP" formulas within thecells below.

Average inventory - 2011

Total Assets = Mar 31, 2009

1,688,500

Total Assets = Mar 31, 2010

1,740,500

Total Assets = Mar 31, 2011

Inventories = EOY 2010

Amount

Inventories = EOY 2011

Amount

Net income after taxes

(a) Compute the followingitems for Bradburn Corporation:

(1) Current ratio for fiscalyears 2012 and 2013.

Note: The formulas in somecell formulas are "live" and need values placed in their sourcecells.

2012 Current ratio =

Currentassets
----------------------- =
Current liabilities

Currentassets
----------------------- =
Current liabilities

(2) Acid-test (quick) ratiofor fiscal years 2012 and 2013.

2012 Quick ratio =

Current assets -Inventories
----------------------- =
Current liabilities

Current assets -Inventories
----------------------- =
Current liabilities

(3) Inventory turnover forfiscal year 2013.

2013 Inventory Turnover =

Cost of goodssold
------------------------------------ =
Average inventory

(4) Return on assets forfiscal years 2012 and 2013. (Assume total assets were

$1,688,500

at March 31, 2011.)

2012 Return on assets =

Net income
----------------------- =
Average total assets

Formula

---------------- =

Formula

2013 Return on assets =

Net income
----------------------- =
Average total assets

Formula

---------------- =

Formula

(5)Percentage change in sales, cost of goods sold, gross margin, andnet income after taxes from fiscal year
2012 to 2013. Omit "000" from thevalues.

Net income after taxes

#VALUE!

Formula

Note: The formulas in somecell formulas are "live" and need values placed in their sourcecells.

(b)Identify and explain what other financial reports and/or financialanalyses might be helpful to the
commercial loan officer of Topeka NationalBank in evaluating Daniel Brownâs request for a timeextension
on Bradburnâs notes.

Otherfinancial reports and financial analyses which might be helpful tothe commercial loan officer of Spokane National Bank include:

Enter text answeras appropriate.

(c)Assume that the percentage changes experienced in fiscal year 2013as compared with fiscal year 2012
for sales and cost of goods sold will berepeated in each of the next 2 years. Is Bradburnâs desire to
finance the plant expansion frominternally generated funds realistic? Discuss.

Entertext answer as appropriate.

Funds available for plant expansion

Assumptions: Complete as appropriate.

Sales increase at a rate of

Cost of goods sold increases at rate of

despite depreciation remaining constant.

Other operating expenses increase at the same rateexperienced from 2012 to 2013;

i.e., at

Depreciation remains constant at

Dividends remain at

per share.

Plant expansion is financed equally over the twoyears(

each year).

Loan extension is granted.

(d)Should Topeka National Bank grant the extension on Bradburnâs notesconsidering Daniel Brownâs statement
about financing the plant expansionthrough internally generated funds? Discuss.

Enter text answer as appropriate.

ochreoyster815

Case 2.3 Walgreens Co. and Subsidiaries

The following excerpts are from the 2013 Walgreen Co. Form 10-K:

CONSOLIDATED BALANCE SHEETS

Walgreens Co. and Subsidiaries at August 31,2013 and 2012

(in millions, except shares and per share amounts)

Cash and cash equivalents

Property & equipment, at cost,less accumulated deprec & amortization

$12,138

$12,038

Equity investment in Alliance Boots

$2,410

$2,161

Alliance Boots call option

Other noncurrent assets

Liabilities and Shareholders' Equity

Current Liabilities

Short-term borrowings

$570

$1,319

Trade accounts payable

$4,635

$4,384

Accrued expenses and other liabilities

Total Current Liabilites

$8,883

$8,722

Noncurrent liabilites

Long-term debt

$4,477

$4,073

Deferred income taxes

$600

$545

Other noncurrent liabilities

$2,067

$1,866

Total noncurrent liabilites

$7,144

$6,504

Commitments and contingencies(see note)

Shareholders' Equity

Preferred stock, $.0625 per value; authorized 32 million shares;

issued 1,028,180,150 shares in 2013 and 2012

Employee stock loan recievable

Accumulated other comprehensive (loss) income

($98)

$68

Treasury Stock at cost, 81,584,572 shares in 2013 and

84,124,816 shares in 2012

($3,114)

($2,985)

Total Shareholders' Equity

$19,454

$18,236

Total Liabilites and Shareholder's Equity

$35,481

$33,462

The accompanying Notes to Consolidated Financial Statements are integral parts of these statments.

Notes to Consolidated financial Statements

1.Summary of Major Accounting Policies

Description of Business

The company is principally in the retail drugstore business and its operations are within one reportable segment. At August 31,2013 there was 8,582 drugstore and other locations in 50 states, the District of Columbia, Guam, and Puerto Rico. Prescription sales were 62.9% of total sales for fiscal 2013 compared to 63.2% in 2012 and 64.7% in 2011.

Allowance for Doubtful Accounts

The provision for bad debt is based on both historical write-off percentages and specifically identified receivables. Activity in the allowance for doubtful accounts was as follows (In millions):

	2013	2012	2011
Balance at beginning of year	$99	$101	$104
Bad debt provision	$124	$107	$88
Write-offs	($69)	($109)	($91)
Balance at end of year	$154	$99	$101

Inventories

Inventories are valued on a lower of last-in, first-out (LIFO) cost or market basis. At August 31, 2013 and 2012, inventories would have been greater by $2.1 billion and $1.9 billion, respectively, if they had been valued on a lower of first-in, first-out (FIFO) cost or market basis. As a result of declining inventory levels, the fiscal 2013 and 2012 LIFO provisions were reduced by $194 million and $268 million of LIFO liquidation, respectively. Inventory includes product costs, inbound freight, warehousing costs, and vendor allowances not classified as a reduction of advertising expense.

3.Leases

The company owns 20.2% of its operating locations; the remaining locations are leased premises. Initial terms are typically 20 to 25 years, followed by additional terms containing renewal options at five-year intervals, and may include rent escalation clauses. The commencement date of all lease terms is the earlier of the date the company becomes legally obligated to make rent payments or the date the Company has to right to control the property. The Company recognizes rent expense on a straight-line basis over the term of the lease. In addition to minimum fixed rentals, some leases provide for contingent rentals based upon a portion of sales.

Minimum rental commitments at August 31, 2013, under all leases having an initial or remaining non-cancelable term of more than one year are shown below (in Millions):

	Capital Lease	Operatin Lease
2014	$19	$2,536
2015	$19	$2,514
2016	$18	$2,464
2017	$17	$2,389
2018	$15	$2,292
Later	$270	$23,507
Total Minimum lease Payments	$358	$35,702

The capital lease amoutn includes $155 million of imputed interest and executory costs. Total minimum lease payments have not been reduced by minimum sublease rentals of approximately $140 million on leases due in the future under non-cancelable subleases.

The Company remains secondarily liable on 26 assigned leases. The maiximum potential undiscounted future payments are $18 million at August 31, 2013. Lease option dates vary, with some extending to 2041.

WALGREEN CO. INFORMATION FROM CONSOLIDATED
STATEMENTS OF COMPREHENSIVE INCOME
For the Years Ended August 31,2013 and 2012 (in millions)
	2013	2012
Sales	$72,217	$71,633
Net Income	$2,450	$2,127

Required:

a. Using the consolidated balance sheets for Walgreen Co. for August 31,2013 and 2012, prepare a common-size balance sheet.

b. Which current asset is the most significant? Which noncurrent asset is the most significant? Are the relative proportions of current and noncurrent assets what you would expect for a drug store?

c. Analyze accounts recievable and allowance for doubtful accounts.

d. What inventory is used to value inventories? Has Walgreen experienced inflation or deflation? Explain your answer. Explain the reference in the inventory note to the LIFO liquidation and what this means with regard to net income reported.

e. Assess the level of debt and risk that Walgreen has by looking only at the balnce sheet.

f. Estimate the dollar amount of dividends Walgreens paid in 2013.

g. Does Walgreen use off-balance sheet fiancing? Explain your answer.

h. Evaluate the creidtworthiness of Walgreen based on the Balance sheet and the excerpts from the notes.

coralhyena380

just need help with 3 & 4

LINKS ARE PROVIDED YOU JUST HAVE TO COPY AND PASTE ON YOUR SEARCH BAR

10-K reports (fiscal year 2015) for Williams-Sonoma, Inc.

LINK 1

https://www.sec.gov/Archives/edgar/data/719955/000119312517104341/d265187d10k.htm

10-K reports (fiscal year 2015) for Williams-Sonoma, Inc.

LINK 2

https://www.sec.gov/Archives/edgar/data/719955/000119312516525847/d120289d10k.htm

10-K reports (fiscal year 2014) for Williams-Sonoma, Inc.

LINK 3

https://www.sec.gov/Archives/edgar/data/719955/000119312515118009/d851953d10k.htm#tx851953_13

10-K reports (fiscal year 2016) for Pier 1 Imports, Inc.

LINK 4

https://www.sec.gov/Archives/edgar/data/278130/000119312517136345/d343458d10k.htm

10-K reports (fiscal year 2015) for Pier 1 Imports, Inc.

LINK 5

https://www.sec.gov/Archives/edgar/data/278130/000119312516556025/d133529d10k.htm

10-K reports (fiscal year 2014) for Pier 1 Imports, Inc.

LINK 6

https://www.sec.gov/Archives/edgar/data/278130/000119312515153179/d881010d10k.htm#toc881010_13

(3) Prepare ratio analyses (for the same THREE year time period) for both companies. At least, you should include the following ratios in your computations: (1) current ratio, (2) acid-test ratio, (3) receivables turnover, (4) inventory turnover, (5) asset turnover, (6) profit margin on sales, (7) rate of return on assets, (8) rate of return on common stock equity, (9) earnings per share, (10) payout ratio, (11) debt to total assets ratio, (12) times interest earned, (13) cash debt coverage ratio, and (14) book value per share.

(4) Comment on the analytical results of the two companies. Your comments should concentrate on the trends across the companies. In addition to contrasting the ratios between the companies, you should interpret the numbers and make suggestions as to why the ratio of one company might be higher/lower than the other.

Table 1. Williams-Sonoma, Inc ----Balance Sheet

Williams-Sonoma, Inc.
BALANCE SHEET
Fiscal Years 2016, 2015, 2014, 2013
(In thousands)	FY 2016	FY 2015	FY 2014	FY 2013
ASSETS
Current assets
Cash and cash equivalents	$ 213,713	$ 193,647	$ 222,927	330121
Restricted cash	â	â	â	14289
Accounts receivable, net	88,803	79,304	67,465	60,330
Merchandise inventories, net	977,505	978,138	887,701	813,160
Prepaid catalog expenses	23,625	28,919	33,942	33,556
Prepaid expenses	52,882	44,654	36,265	35,309
Deferred income taxes, net	â	â	130,618	121,486
Other assets	10,652	11,438	13,005	10,852
Total current assets	1,367,180	1,336,100	1,391,923	1,419,103
Property and equipment, net	923,283	886,813	883,012	849,293
Deferred income taxes, net	135,238	141,784	4,265	13,824
Other assets, net	51,178	52,730	51,077	54,514
Total assets	$ 2,476,879	$ 2,417,427	$ 2,330,277	2,336,734
LIABILITIES AND STOCKHOLDERSâ EQUITY
Current liabilities
Accounts payable	$ 453,710	$ 447,412	$ 397,037	404791
Accrued salaries, benefits and other liabilities	130,187	127,122	136,012	138,181
Customer deposits	294,276	296,827	261,679	228,193
Income taxes payable	23,245	67,052	32,488	49,365
Current portion of long-term debt	â	â	1,968	1,785
Other liabilities	59,838	58,014	46,764	38,781
Total current liabilities	961,256	996,427	875,948	861,096
Deferred rent and lease incentives	196,188	173,061	166,925	157,856
Long-term debt				1,968
Other long-term obligations	71,215	49,713	62,698	59,812
Total liabilities	1,228,659	1,219,201	1,105,571	1,080,732
Stockholdersâ equity
Preferred stock: $.01 par value; 7,500 shares authorized; none issued	â	â	â	0
Common stock: $.01 par value; 253,125 shares authorized;
87,325 and 89,563 shares issued and outstanding at	873	896	919	941
January 29, 2017 and January 31, 2016, respectively	873	896	919	941
Additional paid-in capital	556,928	541,307	527,261	522,595
Retained earnings	701,702	668,545	701,214	729,043
Accumulated other comprehensive loss	(9,903)	(10,616)	(2,548)	6524
Treasury stock â at cost: 20 and 29 shares as of January 29, 2017 and January 31, 2016, respectively	(1,380)	(1,906)	(2,140)	(3,101)
Total stockholdersâ equity	1,248,220	1,198,226	1,224,706	1,256,002
Total liabilities and stockholdersâ equity	$ 2,476,879	$ 2,417,427	$ 2,330,277	2,336,734

Table 2. Williams-Sonoma, Inc --- Statement of Income

Williams-Sonoma, Inc.
STATEMENT OF INCOME
Fiscal Years 2016, 2015, 2014,2013
(In thousands)	FY 2016	FY 2015	FY 2014	FY 2013
E-commerce net revenues	$ 2,633,602	$ 2,522,580	$ 2,370,694	$ 2,115,022
Retail net revenues	2,450,210	2,453,510	2,328,025	2,272,867
Net revenues	5,083,812	4,976,090	4,698,719	4,387,889
Cost of goods sold	3,200,502	3,131,876	2,898,215	2,683,673
Gross profit	1,883,310	1,844,214	1,800,504	1,704,216
Selling, general and administrative expenses	1,410,711	1,355,580	1,298,239	1,252,118
Operating income	472,599	488,634	502,265	452,098
Interest (income) expense, net	688	627	62	(584)
Earnings before income taxes	471,911	488,007	502,203	452,682
Income taxes	166,524	177,939	193,349	173,780
Net earnings	$ 305,387	$ 310,068	$ 308,854	$ 278,902

ivorybeetle173

ACC 221 Chapter Notes -Retained Earnings

ACC 221 Full Course Notes

Document Summary

Get access

Related Documents

ACC 221 Chapter Notes -Income Statement

ACC 221 Chapter Notes -Financial Statement, Retained Earnings

ACC 221 Chapter : ShindlerEmily-ARP Pg15.pdf

Related Questions