Question

In: Finance

n addition to common-size financial statements, common-base year financial statements are often used. Common-base year financial...

n 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 the base year account value. Thus, the result shows the growth rate in the account.

  

Construct the common-size balance sheet and common-base year balance sheet for the company. Use 2018 as the base year. (Do not round intermediate calculations. Enter your common-size answers as a percent and your common base year answers as a times. 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
2018 Common-size 2019 Common-size Common-base year
Assets
Current assets
Cash $8,264 % $10,204 %
Accounts receivable 20,953 % 23,437 %
Inventory 37,322 % 42,297 %
Total $66,539 % $75,938 %
Fixed assets
Net plant and equipment $215,870 % $243,840 %
Total assets $282,409 % $319,778 %
Liabilities and Owners’ Equity
Current liabilities
Accounts payable $41,398 % $46,384 %
Notes payable 17,964 % 17,535 %
Total $59,362 % $63,919 %
Long-term debt $24,500 % $31,500 %
Owners' equity
Common stock and paid-in surplus $38,500 % $39,700 %
Retained earnings 160,047 % 184,659 %
Total $198,547 % $224,359 %
Total liabilities and owners' equity $282,409 % $319,778 %

Solutions

Expert Solution

For Common-size % = (% of line item) / (total of the assets/liabilities)

Common-base year % = (% of line item) / (% of line item in base year)

Particulars 2018 Common-size 2019 Common-size Common-base year(2018)
Assets
Current assets
Cash $8,264 2.93% $10,204 3.19% 123.4753%
Accounts receivable 20,953 7.42% 23,437 7.33% 111.8551%
Inventory 37,322 13.22% 42,297 13.23% 113.3299%
Total $66,539 23.56% $75,938 23.75% 114.1256%
Fixed assets
Net plant and equipment $215,870 76.44% $243,840 76.25% 112.9569%
Total assets $282,409 100.00% $319,778 100.00% 113.2322%
Liabilities and Owners’ Equity
Current liabilities
Accounts payable $41,398 14.66% $46,384 14.51% 112.0441%
Notes payable 17,964 6.36% 17,535 5.48% 97.6119%
Total $59,362 21.02% $63,919 19.99% 107.6766%
Long-term debt $24,500 8.68% $31,500 9.85% 128.5714%
Owners' equity
Common stock and paid-in surplus $38,500 13.63% $39,700 12.41% 103.1169%
Retained earnings 160,047 56.67% 184,659 57.75% 115.3780%
Total $198,547 70.30% $224,359 70.16% 113.0004%
Total liabilities and owners' equity $282,409 100.00% $319,778 100.00% 113.2322%

Related Solutions

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...
​(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,...
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $...
Use the​ common-size financial statements found​ here: Common-Size Balance Sheet 2016 Cash and marketable securities $ 470 1.4 % Accounts receivable 5,990 18.2 Inventory 9,450 28.7 Total current assets $ 15,910 48.4 % Net property, plant, and equipment 16,990 51.6 Total assets $ 32,900 100.0 % Accounts payable $ 7,150 21.7 % Short-term notes 6,790 20.6 Total current liabilities $ 13,940 42.4 % Long-term liabilities 7,040 21.4 Total liabilities $ 20,980 63.8 % Total common shareholders’ equity 11,920 36.2 Total...
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 as the...
Prepare the common-size balance sheet and common-base-year balance sheet for the company. Use 2013 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 2013 Common-size 2014 Common-size Common-base year Assets   Current assets     Cash $8,964 % $10,904 %     Accounts receivable 22,353 % 24,837 %     Inventory 38,722 % 43,697 %         Total $70,039 % $79,438...
1. What is a common-size income statement? 2. What is the typical base used in vertical...
1. What is a common-size income statement? 2. What is the typical base used in vertical analysis of a balance sheet?
​(Preparing common-size financial​ statements) As the newest hire to the financial analysis group at Patterson Printing​...
​(Preparing common-size financial​ statements) As the newest hire to the financial analysis group at Patterson Printing​ Company, you have been asked to perform a basis financial analysis of the​ company's most recent financial statements. The 2016 balance sheet and income statement for the Patterson are shown​ here: Patterson Printing Company Balance​ Sheet, December​ 31, 2016 Cash and marketable securities $500 Accounts receivable 6,000 Inventory 9,500 Total current assets $16,000 Net​ property, plant, and equipment 17,000 Total assets $33,000 Accounts payable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT