AC 302 Chapter 24 Questions AND Problems

AC 302 Chapter 24 Questions AND Problems
Exercise 24 Question 2
Name				Date		
Instructor				Course		
Intermediate Accounting, 14th Edition by Kieso, Weygandt, and Warfield						
Primer on Using Excel in Accounting by Rex A Schildhouse						
						
E24-2 (Post-Balance-Sheet Events) For each of the following subsequent (post-balance-sheet) events, indicate whether a company should (a) adjust the financial statements, (b) disclose in notes to the financial statements, or (c) neither adjust nor disclose.						
						
						
	"1.   Settlement of federal tax case at a cost considerably in excess of the amount
      expected at year-end."					
						
	2.   Introduction of a new product line.					
	3.   Loss of assembly plant due to fire.					
	4.   Sale of a significant portion of the company's assets.					
	5.   Retirement of the company president.					
	6.   Issuance of a significant number of shares of common stock.					
	7.   Loss of a significant customer.					
	8.   Prolonged employee strike.					
	9.   Material loss on a year-end receivable because of customer's bankruptcy.					
	10. Hiring of a new president.					
	11. Settlement of prior year's litigation against the company.					
	12. Merger with another company of comparable size.					
						
	1	Enter letter		7	Enter letter	
	2	Enter letter		8	Enter letter	
	3	Enter letter		9	Enter letter	
	4	Enter letter		10	Enter letter	
	5	Enter letter		11	Enter letter	
	6	Enter letter		12	Enter letter	
						


Exercise 24-3
Name:				Date:		
Instructor:				Course:		
Intermediate Accounting, 14th Edition by Kieso, Weygandt, and Warfield						
Primer on Using Excel in Accounting by Rex A Schildhouse						
						
E24-3 (Segmented Reporting) LaGreca Company is involved in four separate industries. The following information is available for each of the four industries.						
						
	Operating Segment	Total Revenue	Operating Profit (Loss)	Identifiable Assets		
	W	$60,000 	$15,000 	$167,000 		
	X	10,000 	1,500 	83,000 		
	Y	23,000 	(2,000)	21,000 		
	Z	9,000 	1,000 	19,000 		
		$102,000 	$15,500 	$290,000 		
						
Instructions:						
Determine which of the operating segments are reportable based on the:						
						
(a) Revenue test.						
	Enter answer in this area					
	Enter answer in this area					
						
(b) Operating profit (loss) test.						
	Enter answer in this area					
	Enter answer in this area					
						
(c) Identifiable assets test.						
	Enter answer in this area					
	Enter answer in this area					
						
						
						
						
Problem 24-3
Name:				Date:			
Instructor:				Course:			
Intermediate Accounting, 14th Edition by Kieso, Weygandt, and Warfield							
Primer on Using Excel in Accounting by Rex A Schildhouse							
							
P24-3 (Ratio Computations and Additional Analysis) Bradburn Corporation was formed 5 years ago 							
through a public subscription of common stock. Daniel Brown, who owns						15%	of the 
common stock, was one of the organizers of Bradburn and is its current president. The company has been successful, but it currently is experiencing a shortage of funds. On June 10, Daniel Brown approached the 							
							
Topeka National Bank, asking for a 24-month extension on two					$35,000 	notes, which are due on 	
June 30, 2013, and September 30, 2013. Another note of				$6,000 	is due on March 31, 2014, but he 		
expects no difficulty in paying this note on its due date. Brown explained that Bradburn- cash flow problems 							
are due primarily to the company- desire to finance a				$300,000 	plant expansion over the next 		
2 fiscal years through internally generated funds.							
							
The commercial loan officer of Topeka National Bank requested financial reports for the last 2 fiscal years.							
							
BRADBURN CORPORATION							
Statement of Financial Position							
March 31							
Assets					2013	2012	
Cash					$18,200 	$12,500 	
Notes receivable					148,000 	132,000 	
Accounts receivable (net)					131,800 	125,500 	
Inventories (at cost)					105,000 	50,000 	
Plant & equipment (net of depreciation)					1,449,000 	1,420,500 	
Total assets					$1,852,000 	$1,740,500 	
							
Liabilities and Owners' Equity							
Accounts payable					$79,000 	$91,000 	
Notes payable					76,000 	61,500 	
Accrued liabilities					9,000 	6,000 	
Common stock (130,000 shares, $10 par)					1,300,000 	1,300,000 	
Retained earningsa					388,000 	282,000 	
Total liabilities and owners' equity					$1,852,000 	$1,740,500 	
aCash dividends were paid at the rate of $1.00 per share in fiscal year 2012 and $2.00 per share in fiscal year 2013.							
							
							
SANDBURG CORPORATION							
Income Statement							
For The Fiscal Year Ended March 31							
					2013	2012	
Sales					$3,000,000 	$2,700,000 	
Cost of goods sold					1,530,000 	1,425,000 	
Gross margin					1,470,000 	1,275,000 	
Operating expenses					860,000 	780,000 	
Income before income taxes					610,000 	495,000 	
Income taxes					244,000 	198,000 	
Net income after income taxes					$366,000 	$297,000 	
Depreciation charges on the plant and equipment of				$100,000 	and	$102,500 	
for the fiscal years ended March 31, 2012, and 2013, respectively, are included in cost of goods sold.							
							
Instructions:							
Fill in the provided matrix and utilize it as the matrix for "VLOOKUP" formulas within the cells below.							
							
				Column 4	Column 5		
				2013	2012		
	Average inventory - 2011			Formula			
	Average total assets			Formula	Formula		
	Total Assets = Mar 31, 2009			Formula			
	Total Assets = Mar 31, 2010			Formula			
	Total Assets = Mar 31, 2011			Amount			
	Cost of goods sold			Amount	Amount		
	Current assets			Amount	Amount		
	Current liabilities			Amount	Amount		
	Dividends			Amount	Amount		
	Depreciation			Amount	Amount		
	Gross margin			Amount	Amount		
	Income before taxes			Amount	Amount		
	Income taxes (40%)			Amount	Amount		
	Inventories = EOY 2010				Amount		
	Inventories = EOY 2011			Amount			
	Net income after taxes			Amount	Amount		
	Operating expenses			Amount	Amount		
	Sales			Amount	Amount		
							
(a) Compute the following items for Bradburn Corporation:							
(1) Current ratio for fiscal years 2012 and 2013.							
							
	2012 Current ratio = 		"Current assets
  ----------------------- =
Current liabilities"		Amount		
					---------------- =	Formula	to 1
					Amount		
							
	2013 Current ratio = 		"Current assets
  ----------------------- =
Current liabilities"		Formula		
					---------------- =	Formula	to 1
					Formula		
							
(2) Acid-test (quick) ratio for fiscal years 2012 and 2013.							
							
	2012 Quick ratio = 		"Current assets - Inventories
  ----------------------- =
Current liabilities"			Formula	
						---------------- =	Formula
						Formula	to 1
							
	2013 Quick ratio = 		"Current assets - Inventories
  ----------------------- =
Current liabilities"			Formula	
						---------------- =	Formula
						Formula	to 1
							
(3) Inventory turnover for fiscal year 2013.							
							
	2013 Inventory Turnover = 		"Cost of goods sold
  ------------------------------------ =
Average inventory"			Amount	
						---------------- =	Formula
						#N/A	to 1
							
(4) Return on assets for fiscal 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	
					Formula		
							
	2013 Return on assets  = 		"Current assets
  ----------------------- =
Current liabilities"		Formula		
					---------------- =	Formula	
					Formula		
							
"(5) Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal year
     2012 to 2013. Omit ""000"" from the values."							
							
							
		2012	2013	Change	Percent Change		
Sales		Formula	Formula	Formula	Formula		
Cost of goods sold		Formula	Formula	Formula	Formula		
Gross margin		Formula	Formula	Formula	Formula		
Net income after taxes		Formula	Formula	Formula	Formula		
Note: The formulas in some cell formulas are "live" and need values placed in their source cells.							
"(b) Identify and explain what other financial reports and/or financial analyses might be helpful to the
     commercial loan officer of Topeka National Bank in evaluating Daniel Brown- request for a time extension
     on Bradburn- notes."							
							
							
							
Other financial reports and financial analyses which might be helpful to the commercial loan officer of Spokane National Bank include:							
							
							
1	Enter text answer as appropriate.						
							
							
							
							
							
2	Enter text answer as appropriate.						
							
							
							
							
							
3	Enter text answer as appropriate.						
							
							
							
							
							
4	Enter text answer as appropriate.						
							
							
							
							
							
"(c) Assume that the percentage changes experienced in fiscal year 2013 as compared with fiscal year 2012
     for sales and cost of goods sold will be repeated in each of the next 2 years. Is Bradburn- desire to
     finance the plant expansion from internally generated funds realistic? Discuss."							
							
							
							
Enter text answer as appropriate.							
							
							
							
			2013	2014	2015		
	Sales		Formula	Formula	Formula		
	Title		Formula	Formula	Formula		
	Gross margin		Formula	Formula	Formula		
	Title		Formula	Formula	Formula		
	Income before taxes		Formula	Formula	Formula		
	Title		Formula	Formula	Formula		
	Net income		Formula	Formula	Formula		
							
	Add: Title			Amount	Amount		
	Deduct: Title			Amount	Amount		
	Note repayment			Amount			
	Funds available for plant expansion			Formula	Formula		
	Plant expansion			Amount	Amount		
	Excess funds			Formula	Formula		
							
	Assumptions:						
	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 rate experienced from 2010 to 2011; i.e., at						
							
	Depreciation remains constant at						
	Dividends remain at 			per share.			
	Plant expansion is financed equally over the two years(					 each year).	
	Loan extension is granted.						
							
"(d) Should Topeka National Bank grant the extension on Bradburn- notes considering Daniel Brown- statement
     about financing the plant expansion through internally generated funds? Discuss."							
							
							
Enter text answer here.							
							
							
							
							
							
							
							
Problem 24-4
Name:				Date:		
Instructor:				Course:		
Intermediate Accounting, 14th Edition by Kieso, Weygandt, and Warfield						
Primer on Using Excel in Accounting by Rex A Schildhouse						
						
P 24-4 (Horizontal and Vertical Analysis) Presented below are comparative balance sheets for the Gilmour Company.						
						
	GILMOUR COMPANY					
	Comparative Balance Sheet					
	December 31, 2013 and 2012					
				2013	2012	
	Assets					
	Cash			$180,000 	$275,000 	
	Accounts receivable (net)			220,000 	155,000 	
	Short-term investments			270,000 	150,000 	
	Inventories			1,060,000 	980,000 	
	Prepaid expense			25,000 	25,000 	
	Fixed assets			2,585,000 	1,950,000 	
	Accumulated depreciation			(1,000,000)	(750,000)	
				$3,340,000 	$2,785,000 	
						
	Liabilities and Stockholders' Equity					
	Accounts payable			$50,000 	$75,000 	
	Accrued expenses			170,000 	200,000 	
	Bonds payable			450,000 	190,000 	
	Capital stock			2,100,000 	1,770,000 	
	Retained earnings			570,000 	550,000 	
				$3,340,000 	$2,785,000 	
						
Instructions: (Round to two decimal places.)						
"(a) Prepare a comparative balance sheet of Gilmour Company showing the percent each item is of the
     total assets or total liabilities and stockholders' equity."						
						
						
GILMOUR COMPANY						
Comparative Balance Sheet						
December 31, 2013 and 2012						
		December 31				
		2013		2012		
Assets						
Cash		Amount	Formula	Amount	Formula	
Accounts receivable (net)		Amount	Formula	Amount	Formula	
Short-term investments		Amount	Formula	Amount	Formula	
Inventories		Amount	Formula	Amount	Formula	
Prepaid expense		Amount	Formula	Amount	Formula	
Fixed assets		Amount	Formula	Amount	Formula	
Accumulated depreciation		Amount	Formula	Amount	Formula	
Total		Formula	Formula	Formula	Formula	
						
Liabilities and Stockholders’ Equity						
Accounts payable		Amount	Formula	Amount	Formula	
Accrued expenses		Amount	Formula	Amount	Formula	
Bonds payable		Amount	Formula	Amount	Formula	
Capital stock		Amount	Formula	Amount	Formula	
Retained earnings		Amount	Formula	Amount	Formula	
Total		Formula	Formula	Formula	Formula	
						
"(b) Prepare a comparative balance sheet of Gilmour Company showing the dollar change and the
     percentage change for each item."						
						
						
GILMOUR COMPANY						
Comparative Balance Sheet						
December 31, 2013 and 2012						
		December 31		Increase or (Decrease)		
Assets		2013	2012	$ Change	% Change	
Cash		Amount	Amount	Formula	Formula	
Accounts receivable (net)		Amount	Amount	Formula	Formula	
Short-term investments		Amount	Amount	Formula	Formula	
Inventories		Amount	Amount	Formula	Formula	
Prepaid expense		Amount	Amount	Formula	Formula	
Fixed assets		Amount	Amount	Formula	Formula	
Accumulated depreciation		Amount	Amount	Formula	Formula	
Total		Formula	Formula	Formula	Formula	
						
Liabilities and Stockholders’ Equity						
Accounts payable		Amount	Amount	Formula	Formula	
Accrued expenses		Amount	Amount	Formula	Formula	
Bonds payable		Amount	Amount	Formula	Formula	
Capital stock		Amount	Amount	Formula	Formula	
Retained earnings		Amount	Amount	Formula	Formula	
Total		Formula	Formula	Formula	Formula	
						
(c) Of what value is the additional information provided in part (a)?						
						
Enter text answer as appropriate.						
						
						
						
						
						
						
						
						
						
						
						
(d) Of what value is the additional information provided in part (b)?						
						
Enter text answer as appropriate.