The following data (in millions) were adapted from recent annual reports of United Parcel Service, Inc. (UPS). UPS provides delivery and freight services throughout the world. Vehicles Aircraft Land X Open spreadsheet Year 2 book value Year 2 Year 1 book value $6,648 Buildings Equipment Construction in progress Less: accumulated depreciation (18,678) This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. $ 13,928 1,009 5,766 8,190 263 (19,691) a. Compute the net property, plant, and equipment (book value) for Years 1 and 2. Year 1 million $5,961 13,902 1,025 5,620 7,787 million 215

The following data (in millions) were adapted from recent annual reports of United Parcel Service, Inc. (UPS). UPS provides dellvery and freight services throughout the world. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Compute the net property, plant, and equipment (book value) for Years 1 and 2. Year 2 book value million Year 1 book value million The following data (in millions) were adapted from recent annual reports of United Parcel Service, Inc. (UPS). UPS provides delivery and freight services throughout the world. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet. a. Compute the net property, plant, and equipment (book value) for Years 1 and 2. Year 2 book value Year 1 book value million million