Question

In: Finance

Interpret the tables trend for revenue, expense & dividend year by year comparing both company? Revenue...

  1. Interpret the tables trend for revenue, expense & dividend year by year comparing both company?

Revenue

YR 2020

YR 2021

YR 2022

ABC Ltd

2138935.4

2117546.05

1905791.44

XYZ Ltd

2595389.4

2465619.93

1232809.97

Expense

YR 2020

YR 2021

YR 2022

ABC Ltd

42821.1

29974.77

20982.339

XYZ Ltd

2116066.4

1481246.48

1036872.54

Dividend

YR 2020

YR 2021

YR 2022

ABC Ltd

397200

297900

223425

XYZ Ltd

296243.64

293281.204

290348.392

Solutions

Expert Solution

Revenue YR 2020 YR 2021 YR 2022
ABC Ltd        2,138,935        2,117,546        1,905,791
% YoY change -1.0% -10.0%
XYZ Ltd        2,595,389        2,465,620        1,232,810
% YoY change -5.0% -50.0%
Expense YR 2020 YR 2021 YR 2022
ABC Ltd             42,821             29,975             20,982
% YoY change -30.0% -30.0%
XYZ Ltd        2,116,066        1,481,246        1,036,873
% YoY change -30.0% -30.0%
Dividend YR 2020 YR 2021 YR 2022
ABC Ltd           397,200           297,900           223,425
% YoY change -25.0% -25.0%
XYZ Ltd           296,244           293,281           290,348
% YoY change -1.0% -1.0%

The above table gives the year on year (YoY) change in revenues, expenses and dividends.

1) Revenue:

ABC-->The revenues for ABC are projected to decrease in the next two years with revenues falling by 10% in Yr2022

XYZ-->The revnues of XYZ are also going to decrease over the next two years and falling by more than 50% from Yr 2020 to Yr2022.

2)Expense: Expenses for both the companies are expected to fall by 30% each year from Yr2020-22

3)Dividend: Similarly dividends are also falling in tandem with revenues. For ABC dividends are going to fall 25% each year  whereas for XYZ they are going to fall by 1% each year.

YoY growth formula: FY2022/FY2021-1

Please reach out in case of any further clarifications

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

1. Interpret the tables trend year by year comparing both company? OPEX - Product expension YR...
1. Interpret the tables trend year by year comparing both company? OPEX - Product expension YR 2015 YR 2016 YR 2017 YR 2018 YR 2019 ABC Ltd 5,630,473.00 6,077,410.00 5,482,371.00 4,444,446.00 3,022,952.00 XYZ Ltd 26,636.00 33,166.00 58,641 .00 57,677.00 61,173.00
1. Interpret the table trend year by year comparing both company NP before tax? Net profit...
1. Interpret the table trend year by year comparing both company NP before tax? Net profit before tax Yr 2015 Yr 2016 Yr 2017 Yr 2018 Yr 2019 ABC Ltd 1,577,816 2,329,767 2,061,769 1,373,517 1,302,697 XYZ Ltd 2,168,564 2,412,228 2,331,999 2,669,716 2,994,449
Revenue and expense data for the current calendar year for Dawg Electronics Company and for the...
Revenue and expense data for the current calendar year for Dawg Electronics Company and for the electronics industry are as follows. Dawg Electronics Company data are expressed in dollars. The electronics industry averages are expressed in percentages. Dawg Electronics Company Electronics Industry Average Sales $ 3,750,000 100 % Cost of goods sold (2,062,500) (61.0) Gross profit $1,687,500 39.0 % Selling expenses $(1,125,000) (23.0) % Administrative expenses (262,500) (10.0) Total operating expenses $(1,387,500) (33.0) % Operating income $300,000 6.0 % Other...
Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics...
Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages. 1 Tannenhill Company Electronics Industry Average 2 Sales $4,920,000.00 100.0% 3 Cost of goods sold 2,533,800.00 56.5 4 Gross profit $2,386,200.00 43.5% 5 Selling expenses $1,328,400.00 24.0% 6 Administrative expenses 787,200.00 14.0 7 Total operating expenses $2,115,600.00 38.0% 8 Operating income $270,600.00 5.5% 9 Other revenue...
Revenue and expense data for Bluestem Company are as follows: Year 2 Year 1 administrative expenses...
Revenue and expense data for Bluestem Company are as follows: Year 2 Year 1 administrative expenses 37,720 20,300 COGS 360,000 319,900 Income tax 41,000 32,200 Sales 820,000 700,000 Selling expense 154,160 109,900 1) Required: (a) Prepare a comparative income statement, with vertical analysis, stating each item for both years as a percent of sales. Round your percentages to one decimal place. Enter all amounts as positive numbers. Refer to the Accounts and Amount Descriptions for correct wording of text entries....
Q4. What is the y/y revenue trend? in apple company
Q4. What is the y/y revenue trend? in apple company
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages. Tannenhill Company Electronics Industry Average Sales $1,060,000 100 % Cost of goods sold 699,600 69 Gross profit $360,400 31 % Selling expenses $212,000 18 % Administrative expenses 84,800 7 Total operating expenses $296,800 25 % Operating income $63,600 6 % Other income 21,200...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill’s data are expressed in dollars. The electronics industry averages are expressed in percentages. Tannenhill Company Electronics Industry Average Sales $2,240,000 100 % Cost of goods sold 1,478,400 71 Gross profit $761,600 29 % Selling expenses $448,000 16 % Administrative expenses 179,200 7 Total operating expenses $627,200 23 % Operating income $134,400 6 % Other revenue 44,800...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and...
Common-Sized Income Statement Revenue and expense data for the current calendar year for Tannenhill Company and for the electronics industry are as follows. Tannenhill's data are expressed in dollars. The electronics industry averages are expressed in percentages. Tannenhill Company Electronics Industry Average Sales $4,000,000 100.0 % Cost of goods sold (2,120,000) (60.0) Gross profit $1,880,000 40.0 % Selling expenses $(1,080,000) (24.0) % Administrative expenses (640,000) (14.0) Total operating expenses $(1,720,000) (38.0) % Operating income $160,000 2.0 % Other revenue and...
Discuss the importance and process of financial forecasting. Provide examples of both revenue and expense forecasting...
Discuss the importance and process of financial forecasting. Provide examples of both revenue and expense forecasting methods.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT