Use Segment Disclosures to Forecast Revenue Following are 2017 and 2018 revenue data for...

80.2K

Verified Solution

Question

Accounting

Use Segment Disclosures to Forecast Revenue
Following are 2017 and 2018 revenue data for Honeywell International's four segments. Use these data to forecast its 2019 revenue.
Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places.
a. Calculate historic (year-on-year) sales growh for each business unit, segment, and total consolidated sales.
Do not round answers. Then enter the answers into the provided spaces below with .
Note: Use negative signs with answers, when appropriate.
b. Use the historic growth in Total consolidated sales (from 2017 to 2018) calculated in Part a to estimate total consolidated sales for 2019.
Estimated total consolidated sales for 2019
consolidated sales for 2019.
Estimated total consolidated sales for 2019
(calculated in part a) to estimate 2019 total consolidated sales.
Estimated total consolidated sales for 2019
e. Which approach do we believe is more accurate in forecasting total consolidated sales?
image

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students