Excel File Edit View Insert Format Tools Data Window Help 79% Mon 3:09 PM a a E AutoSave OFF OFF A SU Delta Quant Assignment-Students a Home Insert Draw Page Layout Formulas Data Review View Share Comments X Insert Calibri (Body VA AA 11 LDH av General II 4 V Delete v Paste BIU O A Conditional Format Cell SX L! Format Sort & Ideas V Formatting as Table Styles X Filter Find & Select Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A3 1 x B D F F G H ! K L M N O P R S T 1 Delta Airlines Depreciation Worksheet 2 3 Residual Purchase Price Useful Value First Year Depreciation ($ millions) 6 Year Aircraft Type Aircraft # ($ millions) Life(Years) $ millions) 7 1989 MD88 D2851 33.00 8 1986 MD88 D2882 39.00 10 15 15 65.00 $ $ S $ $ S 68.00 20 210.00 25 220.00 30 9 1992 B-757(200) D3921 10 1993 B-757(200) D3932 11 2006 B-777-200ER 04061 12 2007 B-777-200ER 04072 13 14 For years 1985-2005, use a residual factor of 5%. 15 For years 2006 forward, use a residual factor of 10% 16 17 To be completed 18 19 20 21 22 23 24 25 26 27 28 29 30 Sheet1 + Ready Average: 678 Count: 17 Sum: 4068 IBI + 100% 21 A W