Brief Exercise 12-2 Prepare horizontal analysis Perform a horizontal analysis providing both the amount and percentage change. (Round Percentag Decreases should be indicated by a minus sign.) Cash Accounts receivable Inventory Long-term assets Total assets Cash Accounts receivable Inventory Long-term assets Total assets Year 2021 2020 $300,000 $ 800,000 200,000 700,000 2,300,000 500,000 800,000 3,400,000 $5,000,000 $4,000,000 Increase (Decrease) Amount

Brief Exercise 12-2 Prepare horizontal analysis Perform a horizontal analysis providing both the amount and percentage change. (Round Percentag Decreases should be indicated by a minus sign.) Cash Accounts receivable Inventory Long-term assets Total assets Cash Accounts receivable Inventory Long-term assets Total assets Year 2021 2020 $300,000 $ 800,000 200,000 700,000 2,300,000 500,000 800,000 3,400,000 $5,000,000 $4,000,000 Increase (Decrease) Amount

College Accounting, Chapters 1-27

23rd Edition

ISBN:9781337794756

Author:HEINTZ, James A.

Publisher:HEINTZ, James A.

Chapter24: Analysis Of Financial Statements

Section: Chapter Questions

Problem 10SPB: RATIO ANALY SIS OF COMPARATI VE FIN ANCIAL STATE MENT S Refer to the financial statements in Problem...

See similar textbooks

Similar questions

Question Content Area Cash and accounts receivable for Adams Company are as follows: Current Year Prior Year Cash $63,104 $54,400 Accounts receivable (net) 34,736 66,800 What are the amounts and percentages of increase or decrease that would be shown with horizontal analysis? Account Dollar Change Percent Change Cash $fill in the blank 1 fill in the blank 2 % Accounts Receivable $fill in the blank 4 fill in the blank 5 %
Data needed: SFP Asset section 1. Cash 16.3% 2. AR 6.3% 3. Short term investment 0.2% 4. Inventory 2.2% 5. Prepaid expenses 0.4% 6. PPE 74.7% Data needed: SFP Liabilities and OE section. 1. Current liab 16% 2. Non-current liab 34.2% 3. OE 49.9% Data needed: SCI 1. COGS 38.6% 2. Selling and admin exp 6.8% 3. Interest exp 0.1% 4. Income tax exp 0.5% 5. Net income 54%
Question Content Area Cash and accounts receivable for Adams Company are provided below: Current Year PriorYear Cash $76,835 $63,500 Accounts receivable (net) 48,794 78,700 Based on this information, what is the amount and percentage of increase or decrease that would be shown with horizontal analysis? Enter a decrease using a minus sign before the amount and the percentage. Account Dollar Change Percent Change Cash $fill in the blank 1 fill in the blank 2 % Accounts Receivable $fill in the blank 4 fill in the blank 5 %
Brief Exercise 170 Using these data from the comparative balance sheet of Banner Company, perform vertical analysis. (Round answers to 1 decimal place, e.g. 15.2.) December 31, 2020 December 31, 2019 Amount Percentage Amount Percentage Accounts Receivable $ 480,000 % $ 336,000 % Inventory 720,000 % 504,000 % Total Assets 4,000,000 % 2,800,000 %
Question Content Area Cash and accounts receivable for Adams Company are as follows: Line Item Description Current Year Prior Year Cash $51,246 $43,800 Accounts receivable (net) 17,596 33,200 What is the amount and percentage of increase or decrease that would be shown with horizontal analysis? Enter a decrease using a minus sign before the amount and the percentage. Account Dollar Change Percent Change Effect Cash $fill in the blank 1 fill in the blank 2 % Accounts Receivable $fill in the blank 4 fill in the blank 5 %
Good day, how do we calculate the missing amounts when doing a comparative balance sheet? Comparative Balance Sheet December 31, 2020 and 2019 2020 2019 Increase/Decrease Assets Cash and cash Equivalent $ 51,500.00 $ 45,400.00 Accounts Receivable Inventories $ 61,400.00 $ 9,500.00 Fixed Assets, net $ 160,000.00 $ 110,000.00 Total Assets $ 324,000.00 $ 268,700.00 $ 55,600.00 Liabilities Accounts Payable Accrued liabilities $ 31,000.00 -$ 6,550.00 Long-term notes payable $ 60,000.00 $ 78,540.00 Stockholders Equity: Common Stock $ 143,050.00 $ 105,110.00 $ 37,940.00 Retained Earnings $ 54,800.00 $ 19,700.00 $ 35,100.00 Total liabilities and Stockholders equity $ 324,300.00 $ 268,700.00 $ 55,600.00
Question Content Area Cash and accounts receivable for Adams Company are as follows: Line Item Description Current Year Prior Year Cash $41,180 $35,500 Accounts receivable (net) 29,394 41,400 What is the amount and percentage of increase or decrease that would be shown with horizontal analysis? Enter a decrease using a minus sign before the amount and the percentage. Account Dollar Change Percent Change Effect Cash Accounts Receivable
Question Content Area The following information is available from the current period financial statements: Net income $102,978 Depreciation expense 26,870 Increase in accounts receivable 15,293 Decrease in accounts payable (29,031) The net cash flows from operating activities using the indirect method is a. $174,172 b. $85,524 c. $102,978 d. $31,784
Perform a horizontal analysis for the balance sheet entry "Cash" given below. That is, find the amount of increase or decrease and the associated percent (rounded to the nearest tenth). Increase/Decrease Assets 2019 2018 Amount Percent Current Assets Cash $18,800 $12,900 ??? ??? Accounts Receivable 22,300 18,100 Merchandise Inventory 30,100 25,900 Supplies 5,600 7,600 Total Current Assets 76,800 64,500 Property, Plant, and Equipment Machinery and Equipment 56,000 57,100 Total Assets $132,800 $121,600 Step 1 In horizontal analysis, each item of the current period is compared in dollars and percent with the corresponding item from a previous period. First, the dollar difference between the most recent and previous periods will be found and entered in the Amount column for each entry. If the amount is a decrease, it is entered in parentheses. A horizontal analysis is to be done on the…
Exercise 13-3 (Algo) Computing and analyzing trend percents LO P1 Sales Cost of goods sold Accounts receivable. 2021 $ 706,675 363,004 34,274 2020 2019 $464,918 $ 371,9341 238,808 193, 136 27,058 25,477 2018 $ 260,094 133,898 15,268 2017 $ 194, 100 98,991 13,296 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.
Required information [The following information applies to the questions displayed below.] Current Year ed Cash $ 11,500 Prior Year $ 14,200 Accounts receivable 61,500 27,000 Equipment, net Land Total assets 59,000 99,000 52,000 73,500 $ 231,000 $ 166,700 Express the items in common-size percents. Note: Round your percentage answers to one decimal place. Current Year Prior Year Cash % % ces Accounts receivable % % Equipment, net % % Land Total assets % % 0.0 % 0.0 %
Required information Skip to question [The following information applies to the questions displayed below.] Current Year Prior Year Cash $ 7,440 $ 8,000 Accounts receivable 54,000 18,000 Equipment, net 44,000 40,000 Land 91,680 66,000 Total assets $ 197,120 $ 132,000 Express the items in common-size percents. (Round your percentage answers to one decimal place.) Required information Skip to question [The following information applies to the questions displayed below.] Current Year Prior Year Cash $ 7,440 $ 8,000 Accounts receivable 54,000 18,000 Equipment, net 44,000 40,000 Land 91,680 66,000 Total assets $ 197,120 $ 132,000 Express the items in common-size percents. (Round your percentage answers to one decimal place.)