Question

In: Accounting

Problem 3-18 Common-Size and Common-Base-Year Financial Statements In addition to common-size financial statements, common-base-year financial statements...

Problem 3-18 Common-Size and Common-Base-Year Financial Statements

In addition to common-size financial statements, common-base-year financial statements are often used. Common-base year financial statements are constructed by dividing the current-year account value by base-year account value. Thus, the result shows the growth rate in the account.
  
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2016 as the base-year. (Do not round intermediate calculations. Enter all common-size answers as a percent. Round your common-size answers to 2 decimal places, e.g., 32.16, and common-base-year answers to 4 decimal places, e.g., 32.1616.)
  

JARROW CORPORATION
2016 Common-size 2017 Common-size Common-base
year
Assets
Current assets
Cash $ 8,364 % $ 10,304 %
Accounts receivable 21,153 % 23,637 %
Inventory 37,522 % 42,497 %
Total $ 67,039 % $ 76,438 %
Fixed assets
Net plant and equipment 216,070 % 244,040 %
Total assets $ 283,109 % $ 320,478 %
Liabilities and Owners’ Equity
Current liabilities
Accounts payable $ 41,598 % $ 46,584 %
Notes payable 18,164 % 17,735 %
Total $ 59,762 % $ 64,319 %
Long-term debt 24,700 % 31,700 %
Owners' equity
Common stock and paid-in surplus 38,700 % 39,900 %
Accumulated retained earnings 159,947 % 184,559 %
Total $ 198,647 % $ 224,459 %
Total liabilities and owners' equity $ 283,109 % $ 320,478 %

Solutions

Expert Solution

JARROW CORPORATION
2016 Common-size 2017 Common-size Common-base
year
Assets
Current assets
Cash 8,364 2.95% 10,304 3.22% 1.2319
Accounts receivable 21,153 7.47% 23,637 7.38% 1.1174
Inventory 37,522 13.25% 42,497 13.26% 1.1326
Total 67,039 23.68% 76,438 23.85% 1.1402
Fixed assets
Net plant and equipment 216,070 76.32% 244,040 76.15% 1.1294
Total assets 283,109 100.00% 320,478 100.00% 1.1320
Liabilities and Owners’ Equity
Current liabilities
Accounts payable 41,598 14.69% 46,584 14.54% 1.1199
Notes payable 18,164 6.42% 17,735 5.53% 0.9764
Total 59,762 21.11% 64,319 20.07% 1.0763
Long-term debt 24,700 8.72% 31,700 9.89% 1.2834
Owners' equity
Common stock and paid-in surplus 38,700 13.67% 39,900 12.45% 1.0310
Accumulated retained earnings 159,947 56.50% 184,559 57.59% 1.1539
Total 198,647 70.17% 224,459 70.04% 1.1299
Total liabilities and owners' equity 283,109 100.00% 320,478 100.00% 1.1320

Related Solutions

Problem 14-18 Common-Size Statements and Financial Ratios for a Loan Application [LO14-1, LO14-2, LO14-3, LO14-4] Paul...
Problem 14-18 Common-Size Statements and Financial Ratios for a Loan Application [LO14-1, LO14-2, LO14-3, LO14-4] Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $520,000 long-term loan from Gulfport State Bank, $110,000 of which will be used to bolster the Cash account and $410,000 of which...
Problem 14-18 Common-Size Statements and Financial Ratios for a Loan Application [LO14-1, LO14-2, LO14-3, LO14-4] Paul...
Problem 14-18 Common-Size Statements and Financial Ratios for a Loan Application [LO14-1, LO14-2, LO14-3, LO14-4] Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $570,000 long-term loan from Gulfport State Bank, $135,000 of which will be used to bolster the Cash account and $435,000 of which...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 500 1.5 % Accounts receivable 6,000 18.2 Inventory 9,450 28.7 Total current assets $ 15,950 48.4 % Net property, plant, and equipment 16,980 51.6 Total assets $ 32,930 100.0 % Accounts payable $ 7,240 22.0 % Short-term notes 6,750 20.5 Total current liabilities $ 13,990 42.5 % Long-term liabilities 6,990 21.2 Total liabilities $ 20,980 63.7 % Total common shareholders’...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: LOADING... to respond to your​...
​(Analyzing common-size financial​ statements) Use the​ common-size financial statements found​ here: LOADING... to respond to your​ boss' request that you write up your assessment of the​ firm's financial condition.​ Specifically, write up a brief narrative that responds to the following​ questions: a. How much cash does Patterson have on hand relative to its total​ assets? b. What proportion of​ Patterson's assets has the firm financed using​ short-term debt?​ Long-term debt? c. What percent of​ Patterson's revenues does the firm have...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup window: LOADING... . Which company is doing a better job of getting sales dollars to net income? Where is the one company having an advantage over the other company in turning revenue into net income? Complete the table below: (Round to two decimal places. Net income to three decimal places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window: Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below: (Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart, Inc. Starbucks...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window:   LOADING... . Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below:  ​(Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Refer back to Textbook Problem 17.5. Recast the financial statements for Green Valley into common size...
Refer back to Textbook Problem 17.5. Recast the financial statements for Green Valley into common size financial statements. Describe at least two advantages of a common size presentation of financial statements.
Problem 12-89A Preparing Common Size Statements The financial statements for Burch Industries follow: Burch Industries Consolidated...
Problem 12-89A Preparing Common Size Statements The financial statements for Burch Industries follow: Burch Industries Consolidated Income Statements (in thousands, except per share data) Year ended December 31, 2019 2018 2017 Revenues $3,930,984 $3,405,211 $3,003,610 Costs and expenses: Cost of goods sold $2,386,993 $2,089,089 $1,850,530 Selling and administrative 922,261 761,498 664,061 Interest 25,739 30,665 27,316 Other expenses (income) 1,475 2,141 (43) Total costs and expenses $3,336,468 $2,883,393 $2,541,864 Income before income taxes $594,516 $521,818 $461,746 Income taxes 229,500 192,600 174,700...
Problem 14-16 Common-Size Financial Statements [LO14-1] You have just been hired as a financial analyst for...
Problem 14-16 Common-Size Financial Statements [LO14-1] You have just been hired as a financial analyst for Lydex Company, a manufacturer of safety helmets. Your boss has asked you to perform a comprehensive analysis of the company’s financial statements, including comparing Lydex’s performance to its major competitors. The company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 950,000 $ 1,110,000 Marketable securities 0 300,000 Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT