Use Segment Disclosures to Forecast Revenue
Following are and revenue data for Honeywell International's four segments. Use these data to forecast its 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 yearonyear 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 to calculated in Part a to estimate total consolidated sales for
Estimated total consolidated sales for
consolidated sales for
Estimated total consolidated sales for
calculated in part a to estimate total consolidated sales.
Estimated total consolidated sales for
e Which approach do we believe is more accurate in forecasting total consolidated sales?
