Don Williams received a memo requesting that he complete a trend analysis of the following numbers using 2021 as the base year. Sales Gross profit Net income 2024 $ 390,000 210,000 41,100 Could you help Don with the request? 2024 Sales Gross profit Net income % % % 2023 $ 462,000 285,000 53,100 2023 % % % 2022 $ 486,000 410,000 23,100 2022 % % % 2021 2021 $ 600,000 500,000 30,000 100 % 100 % 100 %

Don Williams received a memo requesting that he complete a trend analysis of the following numbers using 2021 as the base year. Sales Gross profit Net income 2024 $ 390,000 210,000 41,100 Could you help Don with the request? 2024 Sales Gross profit Net income % % % 2023 $ 462,000 285,000 53,100 2023 % % % 2022 $ 486,000 410,000 23,100 2022 % % % 2021 2021 $ 600,000 500,000 30,000 100 % 100 % 100 %

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter11: Investment Planning

Section: Chapter Questions

Problem 7FPE: Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for...

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)
Suppose we want to compute the four-quarter moving average of Company ABC’s sales as of the beginning of the first quarter of 2022. ABCs sales in the previous four quarters were as follows: 1Q 2021, R 1,200,000; 2Q 2021, R 800,000; 3Q 2021, R 750,000; and 4Q 2021, R 1,600,000. Calculate the four-quarter moving average of sales as of the beginning of the first quarter of 2022.
Here are the abbreviated financial statements for Planner’s Peanuts: INCOME STATEMENT, 2022 Sales $ 5,000 Cost 3,900 Net income $ 1,100 BALANCE SHEET, YEAR-END 2021 2022 2021 2022 Assets $ 7,500 $ 12,100 Debt $ 833 $ 1,000 Equity 6,667 11,100 Total $ 7,500 $ 12,100 Total $ 7,500 $ 12,100 If sales increase by 10% in 2023 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 10%), what must be the balancing item? What will be the value of this balancing item?
USING JOHNSON AND JOHNSON AS THE COMPANY..... Create the sales growth forecast based on the past 5-10 years, which should use multiple methods, such as arithmetic, geometric, regression methods. Excel forms should be used so that it's clear for everyone to see the work." Johnson & Johnson Annual Revenue(Millions of US $) 2023 $85,159 2022 $79,990 2021 $78,740 2020 $82,584 2019 $82,059 2018 $81,581 2017 $76,450 2016 $71,890 2015 $70,074 2014 $74,331 2013 $71,312 2012 $67,224
he following data represents the annual sales of a Digitech Automation products SAOG. Year 2014 2015 2016 2017 2018 Sales (in Millions) OMR 380 440 520 396 514 Use method of least squares to calculate the trend values and the forecast for the future period. Which of the following is the annual sales forecast for the year 2019 using least squares method? a. 539.6 Million OMR b. 584.4 Million OMR c. 606.8 Million OMR d. 562 Million OMR
CAN SOMEONE HELP ME PREPARE A SCHEDULE VERTICAL ANALYSIS? Operating data for Joshua Corporation are presented below. 2020 2019 Sales revenue $754,000 $605,000 Cost of goods sold 465,218 392,645 Selling expenses 122,148 69,575 Administrative expenses 61,828 54,450 Income tax expense 33,176 21,780 Net income 71,630 66,550
Here are the abbreviated financial statements for Planner’s Peanuts: INCOME STATEMENT, 2019 Sales $ 5,000 Cost 3,900 Net income $ 1,100 BALANCE SHEET, YEAR-END 2018 2019 2018 2019 Assets $ 7,500 $ 12,100 Debt $ 833 $ 1,000 Equity 6,667 11,100 Total $ 7,500 $ 12,100 Total $ 7,500 $ 12,100 a. If sales increase by 10% in 2020 and the company uses a strict percentage of sales planning model (meaning that all items on the income and balance sheet also increase by 10%), what must be the balancing item? b. What will be the value of this balancing item?
Flingen Inc. reveals the following information in its annual report for FY 2021 Income Statement Items Sales $11,000,000 Cost of goods sold $5,700,000 Pretax earnings $800,000 Selected Balance Sheet Items Merchandise inventory $100,000 Total assets $2,500,000 Management plans to cut cost of goods sold by 6% for the upcoming year while retaining the same sales. What will Flingen's profit leverage effect be for 2022? (Select the closest answer to your calculation of profit leverage). Group of answer choices $13.05 $10.40 $9.63 $11.15
Assume figures were presented for the past 5 years on merchandise sold at Chicago department and discount stores ($ million). Sales in 2022 were $3,174; in 2021, $3,434; in 2020, $3,188; in 2019, $3,172; and in 2018, $3,236. Using 2018 as the base year, complete a trend analysis. (Round your answers to the nearest whole percent.)
Flingen Inc. reveals the following information in their annual report for FY 2021 Selected Income Statement Items: Sales $9,000,000 Cost of goods sold $5,000,000 Pretax earnings $500,000 Selected Balance Sheet Items: Merchandise inventory $80,000 Total assets $2,000,000 What is Flingen's projected profit margin for 2022, assuming they plan to reduce cost of goods sold by 5.0% for the coming year while maintaining the same sales revenue? (Please round answer to nearest whole percentage). Group of answer choices 9% 10% 8% 7%
C Company has the following data for the year ending 12/31/2020 (dollars are in thousands): Net income = $600; EBIT = $1,184; Total assets = $3,000; Short-term investments = $200; Total capital employed = $2,193; and tax rate = 30%. The company’s WACC is 11.07%. What was its Economic Value Added (EVA) for the year 2020? Round your answer to the nearest dollar. Group of answer choices: $583 $586 $577 $572 $580
The management of Bataan corporation asked you to submit an analysis of the increase in their gross profit in 2021 based on their past two-year comparative income statements which shows: sales =2020 -1,000,000; 2012- 1,237,500. Cost of Sales= 2020- 800,000; 2021- 950,000. Gross profit =2020- 200,000; 2021 - 287,000. The only known factor given to you is the sales price increased 12.5% beginning January 2021. The increase in gross profit due to increase in volume is a. 50,000 B. 35,000 C. 20,000 D. None of these