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 growth for each business unit, segment, and total consolidated sales.

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.$