Exercise 12-4 (Algo) Part 2 2. Prepare a horizontal analysis for 2025 using 2024 as the base year. (Note: If the percentage increase or decrease cannot be calculated, then leave the cell blank. Decreases should be indicated by a minus sign. Round your percentage 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 $ 2025 $ Year 2,370,000 $ 948,000 1,215,000 972,000 4,275,000 2,280,000 8,460,000 8,460,000 (1,320,000) (660,000) $ 15,000,000 $12,000,000 2024 1,725,000 $ 1,500,000 1,470,000 1,010,000 6,000,000 6,000,000 5,805,000 3,490,000 $ 15,000,000 $ 12,000,000 Increase (Decrease) Amount %

Exercise 12-4 (Algo) Part 2 2. Prepare a horizontal analysis for 2025 using 2024 as the base year. (Note: If the percentage increase or decrease cannot be calculated, then leave the cell blank. Decreases should be indicated by a minus sign. Round your percentage 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 $ 2025 $ Year 2,370,000 $ 948,000 1,215,000 972,000 4,275,000 2,280,000 8,460,000 8,460,000 (1,320,000) (660,000) $ 15,000,000 $12,000,000 2024 1,725,000 $ 1,500,000 1,470,000 1,010,000 6,000,000 6,000,000 5,805,000 3,490,000 $ 15,000,000 $ 12,000,000 Increase (Decrease) Amount %

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter2: Financial Statements, Cash Flow,and Taxes

Section: Chapter Questions

Problem 21SP: Begin with the partial model in the file Ch02 P21 Build a Model.xlsx on the textbooks Web site. a....

See similar textbooks

Similar questions

Begin with the partial model in the file Ch02 P21 Build a Model.xlsx on the textbooks Web site. a. Using the financial statements shown here for Lan Chen Technologies, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for 2020. The federal-plus-state tax rate is 25%. b. Assume there were 15 million shares outstanding at the end of 2019, the year-end closing stock price was 65 per share, and the after-tax cost of capital was 10%. Calculate EVA and MVA for 2020. Lan Chen Technologies: Income Statements for Year Ending December 31 (Millions of Dollars) Lan Chen Technologies: December 31 Balance Sheets (Thousands of Dollars)
3.Net income for 2020 was P1,825,600. In 2021, it decreased by 53%. Still using the 2020 net income as the base year, by 2022, net income increased by 130%. Determine the net income for 2021 and 2022, respectively. (separate the values by a comma followed by a space ", ")
Summary financial information for Gandaulf Company is as follows.Compute the amount and percentage changes in 2020 using horizontal analysis, assuming 2019 is the base year. (Enter negative amounts and percentages using either a negative sign preceding the number e.g. -45, -45% or parentheses e.g. (45), (45%). Round percentages to 2 decimal places, e.g. 1.25%.) Increase (Decrease) in 2020 December 31, 2020 December 31, 2019 Amount Percent Current Assets $ 180,600 $ 210,000 $ enter a dollar amount enter your answer in percentages rounded to 2 decimal places % Plant Assets 821,600 790,000 enter a dollar amount enter your answer in percentages rounded to 2 decimal places % Total assets $ 1,002,200 $ 1,000,000 $ enter a total of the two previous amounts enter your answer in percentages rounded to 2 decimal places
Determine the following (1–18) measures for 20Y2, rounding to one decimal place, except the dollar amount, which should be rounded to the nearest cent. Use the rounded answer to the requirement for subsequent requirements, if required. Assume 365 days a year. Show each formula and calculation on the worksheet. amount which should be rounded to the nearest cent. use the rounded answer to the requirment for subsequent requirements, if required. Assume 365 days a year. Formula Calculation and Answer 1 Working Capital Stargel Inc. 2 Current ratio Comparative Retained Earnings Statement 3 Quick ratio For the Years Ended December 31, 20Y2 and 20Y1 4 Accounts receivable turnover 20Y2 20Y1 5 Number of days' sales in receivables days Retained…
Shouldn't the operating expenses for 2020 be 8074.9? Forecasting an Income StatementADP reports the following income statement. AUTOMATIC DATA PROCESSING INC.Statement of Consolidated EarningsFor Year Ended June 30, 2019, $ millions Total revenues $14,175.2 Operating expenses 7,145.9 Systems development and programming costs 636.3 Depreciation and amortization 304.4 Total cost of revenues 8,086.6 Selling, general, and administrative expenses 3,064.2 Interest expense 129.9 Total expenses 11,280.7 Other income expense, net 111.1 Earnings before income taxes 3,005.6 Provision for income taxes 712.8 Net earnings $ 2,292.8 Forecast ADP’s 2020 income statement assuming the following income statement relations. All percentages (other than total revenue growth and provision for income taxes) are based on historic percent of total revenues. Total revenues growth 13% Depreciation and amortization $460.5 million Interest expense No change Other…
E23.10B (L0 1,4) (Classification of Transactions) Following are selected balance sheet accounts of BioLazer Corp. at December 31, 2020 and 2019, and the increases or decreases in each account from 2019 to 2020. Also presented is selected income statement information for the year ended December 31, 2020, and additional information. Increase Selected balance sheet accounts 2020 2019 (Decrease)AssetsAccounts receivable $154,000 $120,000 $34,000Property, plant, and equipment 631,000 581,000 50,000Accumulated…
Whatiseachofthefollowinginvestmentsworthtodayassuminganannualdiscountrateof 7%? 1.(a) A3-yearmaturity“B”ratedcorporatebondwith4%annualinterestpaymentsanda principal value of £1,000
Perform a horizontal analysis providing both the amount and percentage change. (Round your Percentage answers to 1 decimal place. Decreases should be indicated by a minus sign.) Year 2021 2020 Cash $ 420,000 $ 1,050,000 Accounts receivable 660,000 300,000 Inventory 1,020,000 925,000 Long-term assets 3,900,000 2,725,000 Total assets $ 6,000,000 $ 5,000,000
Here is financial information for Sage Hill Inc. Prepare a schedule showing a horizontal analysis for 2020, using 2019 as the base year. (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.1%.) Here is financial information for Sage Hill Inc.. December 31, 2020 December 31, 2019 Current assets $101,007 $ 87,000 Plant assets (net) 367,488 319,000 Current liabilities 99,227 67,000 Long-term liabilities 126,268 96,000 Common stock, $1 par 126,000 112,000 Retained earnings 117,000 131,000
Locate Gap Inc.’s 2020 Annual Report (for fiscal year 2/2/20-1/30/21) There are 10 sections of questions. You will find the information necessary to answer the questions in “Item 8. Financial Statements and Supplementary Data,” of the report. Read through the questions carefully and answer in the space provided. What are the following amounts at 1/30/21: Total Assets : Total Liabilities: Total Owner’s Equity : At 1/30/21: What is the percentage of debt used to finance Gap? What is the percentage of owner’s equity used to finance Gap? What is the significance of these two percentages?
Using the information from question 1, calculate the current ratio for 2018 and 2019 respectively: 12/31/2018 12/31/2019 Current Assets $101,600 $97,350 Current Liabilities ($33,650) ($32,800) Working Capital (CA-CL) $67,950 $64,550
Net income for 2020 was P1.825.600.in 2021. it decreased by 53%. Still using the 2020 net income as the base year, by 2022, net income increased by 130%. Determine the net income for 2021 and 2022. respectively separate the valves by a commafollowed by a space :