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?