Exercise 12-4 (Algo) Prepare vertical and horizontal analyses (LO12-1, 12-2) [The following information applies to the questions displayed below.] The balance sheets for Federer Sports Apparel for 2025 and 2024 are presented below. Exercise 12-4 (Algo) Part 1 Required: 1. Prepare a vertical analysis of the balance sheet data for 2025 and 2024. Express each amount as a percentage of tota assets. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.) Assets Cash Accounts receivable Inventory Buildings Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Contingent liability Common stock Retained earnings Total liabilities and stockholders' equity FEDERER SPORTS APPAREL Balance Sheet December 31 $ Amount 2025 $ 3,045,000 1,743,000 3,045,000 15,561,000 (2,394,000) $ 21,000,000 1,827,000 1,827,000 8,778,000 8,568,000 $ 21,000,000 % S Amount 988,000 1,368,000 2,280,000 15,561,000 (1,197,000) $ 19,000,000 S 2024 2,337,000 1,180,000 8,778,000 6,705,000 $ 19,000,000 %

Exercise 12-4 (Algo) Prepare vertical and horizontal analyses (LO12-1, 12-2) [The following information applies to the questions displayed below.] The balance sheets for Federer Sports Apparel for 2025 and 2024 are presented below. Exercise 12-4 (Algo) Part 1 Required: 1. Prepare a vertical analysis of the balance sheet data for 2025 and 2024. Express each amount as a percentage of tota assets. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.) Assets Cash Accounts receivable Inventory Buildings Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Contingent liability Common stock Retained earnings Total liabilities and stockholders' equity FEDERER SPORTS APPAREL Balance Sheet December 31 $ Amount 2025 $ 3,045,000 1,743,000 3,045,000 15,561,000 (2,394,000) $ 21,000,000 1,827,000 1,827,000 8,778,000 8,568,000 $ 21,000,000 % S Amount 988,000 1,368,000 2,280,000 15,561,000 (1,197,000) $ 19,000,000 S 2024 2,337,000 1,180,000 8,778,000 6,705,000 $ 19,000,000 %

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter12: Fainancial Statement Analysis

Section: Chapter Questions

Problem 89PSA

See similar textbooks

Similar questions

In cell D22, by using cell references, calculate the total long-term assets for year 2014 Use the relevant cells from the given data in the balance sheet. In call D23, by using a cell reference, calculate the total assets for year 2014. Refer to the relevant cell from the given data in the balance sheet. Note: The total assets must equal the total liabilities and owners' equity." in cell D18, by using cell references, calculate the total current assets for year 2014. Use the relevant cells in the balance sheet. In cell D16, by using cell references, calculate the accounts receivable for year 2014. Use the relevant cells in the balance sheet, in cell H14, by using cell references, calculate the accounts payable for year 2014. Use the relevant cells from the given cata in the balance sheet. In cell H22, by using cell references, calculate the total owners' equity for year 2014. Use the relevant cells from the given data in the balance sheet. In cell H18, by using cell references,…
Required Information Problem 12-3A Perform vertical and hortzontal analysis (LO12-1, 12-2) [The following information applies to the questions displayed below.] The balance sheets for Sports Unlimited for 2021 and 2020 are provided below. Problem 12-3A Part 1 Required: 1. Prepare a vertical analysis of Sports Unlimited's 2021 and 2020 balance sheets. Express each amount as a percentage of total assets for that year. (Amounts to be deducted should be Indicated by a minus slgn. Round your percentage answers to 1 decimal place.) SPORTS UNLIMITED Balance Sheets For the yeare ended December 31 2021 2020 Amount Amount Assete Current assels: Cush 103,500 70,400 Accounts receivable 46,800 32,000 Inventory 44,550 71,200 Prepaid rent 7,200 3,600 Long-lerm assets Investment in bonds 54,900 Land 117,450 141,600 Equipment 106,200 102,000 Less Accurmulated depreciation (30.600) (20.800) Total assels 450,000 400,000 Llablitles and Stockholders Equity Current liabilities: 30,150 46,800 3.600 Accounts…
Required Infomation Problem 12-3A Perform vertical and hortzontal analysis (LO12-1, 12-2) [The following information applies to the questions displayed below.] The balance sheets for Sports Unlimited for 2021 and 2020 are provided below. Problem 12-3A Part 2 2 Prepare a horizontal analysis of Sports Unlimited's 2021 balance sheet using 2020 os the base year. (Negative amounts and Decreases should be Indicated by a minus sign. Round your percentage answers to 1 decimal place.) SPORTS UNLIMITED Balance Sheeta For the yeara ended December 31 Year Increase (Decrease) Amount 2021 2020 Assete Current assels: Cash 103,500 70,400 Accounits receivable 46,800 32,000 Inventory 44,550 71,200 Prepaid rent 7,200 3,600 Lang term assets. Investment in bonds 54,900 Land 117,450 141,600 Equipment 106,200 102,000 Less Accumulated depreciation (30.600) 450,000 S (20.800) Total assels 400,000 Llablitles and stockholdere' Equity Current labiities. Accounts payable 30,150 46,000 7.200 3,600 Interest payable…
Create a new sheet named vertical analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate vertical analysis for the income statement and balance sheet. STATEMENT OF INCOME 2020-12-31 2019-12-31 2018-12-31 2017-12-31 Create a new sheet named horizontal analysis in the Excel workbook and insert the necessary equations or functions in related cells to calculate horizontal analysis for Sales 768,109,000 1,105,696,000 1,194,376,000 835,983,000 the income statement and balance sheet. Sales Cost BALANCE SHEET 12/31/2020 12/31/2019 12/31/2018 12/31/2017 Total Income 768,109,000 1,105,696,000 1,194,376,000 835,983,000 Current Assets 340,079,000 320,122,000 339,609,000 213,006,000 Other Revenues 93,982,000 131,089,000 152,641,000 150,176,000 Inventory 51,999,000 42,607,000 43,580,000 34,013,000 Total Revenues 862,091,000 1,236,785,000 1,347,017,000 986,159,000 Investments 95,638,000 85,161,000 39,987,000 52,329,000 46,970,000 36,647,000…
The income statements for Federer Sports Apparel for 2025 and 2024 are presented below. Required: Prepare a vertical analysis of the data for 2025 and 2024. Note: Round your percentage answers to 1 decimal place.
ETYMISHTE 16598 (AIYv, i un Miyul 2. Prepare a horizontal analysis of Fantasy Football's 2024 balance sheet using 2023 as the base year. (Values to be deducted and decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) Assets Current assets: Cash Accounts receivable Inventory Supplies Long-term assets: Equipment Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Interest payable Income tax payable Long-term liabilities: Notes payable Stockholders' equity: Common stock Retained earnings Total liabilities and stockholders' equity Answer is complete but not entirely correct. FANTASY FOOTBALL Balance Sheets December 31 $ 2024 Year 2023 190,800 $ 284,800 748,800 835,200 1,839,600 1,094,400 158,400 92,800 1,123,200 1,123,200 (460,800) (230,400) $ 3,600,000 $ 3,200,000 $ 151,200 $ 80,000 0 3,200 86,400 86,400 950,400 950,400 Increase (Decrease) Amount % 94,000,000 86,400,000 X…
Please Complete the Following: 1. Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement", use total assets on the balance sheet and net sales on the income statement for your vertical analysis. 2. Using the balance sheet and income statement, complete the ratios on the tab labeled "Ratios" 3. Answer the final OBSERVATION QUESTION (listed under Ratios calculations) Consolidated Balance Sheets (USD $) 12/31/2020 Vertical Analysis 12/31/2019 Vertical Analysis Horizontal Analysis In Millions, unless otherwise specified Current Assets: Cash and Cash Equivalents $1,723 $1,929 Receivables, net 1,484 1,398 Merchandise Inventories 11,079 11,057 Other Current Assets 1,016 895 Total Current Assets 15,302 15,279 Property and Equipment, at…
My Question: Hello I need help finding the percentage total for the vertical analysis of the balance sheet data for Nike Inc 2022 For Question # 1. The Balance sheet will be provided below to solve for the Question # 1 Hypothetical balance sheets of Nike, Inc. are presented down below: Prepare a horizontal analysis of the balance sheet data for Nike, using 2021 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g. -55,000, -20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.5%.) NIKE, INC.Condensed Balance SheetMay 31($ in millions) 2022 2021 Assets Current Assets $9,880 $8,810 Property, plant, and equipment (net) 1,940 1,830 Other assets 1,580 1,700 Total assets $13,400 $12,340 Liabilities and Stockholders' Equity Current Liabilities $3,300 $3,300 Long-term liabilities 1,350 1,450 Stockholders’ equity…
VII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Secuities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 220,000 200,000 160,000 P445,000 P380,000 245,000 Operating Expenses: Fixed Assets Selling Expenses 22,000 25,000 Total…
VII. Direction: Compute and interpret. The following comparative financial statements are provided by Avatar Industries. You were asked to compute the different financial ratios and provide your interpretations with regards to profitability, efficiency, liquidity and solvency of the company. Use the Answer Sheet template below to input your answer and solution. AVATAR INDUSTRIES AVATAR INDUSTRIES Comparative Statement of Financial Position For the years 2019 and 2018 Comparative Income Statement For the years 2019 and 2018 2019 2018 2019 2018 ASSETS Current Assets: Sales P200,000 P210,000 Cash & Cash Equivalent P65,000 P70,000 Sales Returns and Allowances 40,000 25,000 Accounts Receivable 40,000 35,000 Net Sales 160,000 185,000 Marketable Securities 40,000 35,000 Cost of Goods Sold 100,000 115,625 Inventory 100,000 80,000 Gross Profit 60,000 69,375 Total Current Assets 245,000 220,000 Operating Expenses: Fixed Assets 200,000 160,000 Selling Expenses 22,000 25,000 Total Assets P445,000…
Exercise 12-4B Prepare vertical and horizontal analyses (LO12-1, 12-2) [The following information applies to the questions displayed below.] The balance sheets for Company A for Year 2 and Year 1 are presented below. Exercise 12-4B Part 1 Required: 1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. Express each amount as a percentage of total assets. (Amounts to be deducted should be indicated by a minus sign. Round your answers to 1 decimal place.) COMPANY A Balance Sheet December 31 Year 2 Year 1 Amount Amount Assets Cash $ 2,310,000 $ 840,000 Accounts receivable 1,305,000 1,044,000 Inventory 4,005,000 2,136,000 Buildings 8,580,000 8,580,000 Less: Accumulated depreciation (1,200,000) (600,000) Total assets $ 15,000,000 $ 12,000,000 Liabilities and Stockholders' Equity Accounts payable $ 1,725,000 $ 1,380,000 Contingent liability 1,230,000 Common stock 4,920,000 4,920,000 Retained earnings 7,125,000 5,700,000 Total liabilities and stockholders' equity $…
Using the balance sheets provided above for The Enchanted Forest Boutique, the amount that should be included in box L of the vertical analysis above is: Group of answer choices A. 100% B. 0% C. 4.41% D . 23.76% The Enchanted Forest Boutique Balance Sheets As of December 31, 2018 and December 31, 2019 Cash Accounts receivable Inventory Prepaid insurance Total current assets Equipment Less: Accumulated depreciation Net fixed assets Total assets Accounts payable Wages and payroll taxes payable Short-term portion of mortgage payable Total current liabilities Mortgage payable Total liabilities Owner's equity c Total liabilities and owner's equity 2018 Minimize global navigation 19,541 40.285 1.258 67,405 127,300 21.150 106,150 $173,555 $ 16,996 6.647 7.800 31,443 45,000 76.443 97,112 2019 $173.555 17,555 20,145 39,552 1.313 68.565 131,300 23.150 108,150 $176,715 $ 17,113 7,916 7,800 32.829 37.200 70.029 106.686 $176,715 Vertical Analysis 2019 A BCDE с Ε F G H I J K L M N P Q R