Question

-Auta Week 3 Imvemtory Concept and Depreciastion Methods Template-1 - Rea. E able Toals Ms Trent = Tell me what you want to de- frammary Acrohat File Do Design Refesences Maiings Review iw Design Share Home Insert Help aynurt Find Ans A:EbC ABb. Assgnm, 14ssgrm BbC 4gubceD AabCer Aabc:D Aa Assanm Normal Reterence. AaBbccc AaB ABbcct AggbCcD 4asbcco: Replace Copy A = = = - |- Creste and Share Reguet в гU Paste Орег 1 Ne Seac. Heacang 1 Hesdng a ab x. x Ite Subtle mat Painte Siyrыlura Gaтеты зb Ргарар Clebpard Ending Residus Example of Acelerated Deok Deprecialion. SYD Cost Residua Depreciation Useful Life Method Malun f Years Digits) Method Sum of Years $20,000 $2.000 $13,000 Dielts Fnd of Year Aumulation Rcok Vakue Use the following (Cost Minus Resadual Fraction for Yeary intormation to calculate the SYD epreds Ead cе Voor Accumulation Dopredation .Fixed asset cast $20 000 Usetul Ite: tve vears Rosidual valuo: $2,000 3 Borldual Value HEAS12 /12 Page 6 of 8 Engish jUnted Sda Pge 3 ef 045 werds DE 100 1 ENG

Answer 1

End of Year	Cost-residual	Fraction of year	-	Yearly depreciation	Accumulated depreciation	Book value EOY
1	18000	0.333333333		6000	6000	14000
2	18000	0.266666667		4800	10800	9200
3	18000	0.2		3600	14400	5600
4	18000	0.133333333		2400	16800	3200
5	18000	0.066666667		1200	18000	2000

WORKINGS

Book1- Excel X AutoSave ( Off Sign in Tell me what you want to do File Formulas Review View Help Share Home Insert Draw Page Layout Data A A Calibri General aWrap Text 11 Conditional Format as Cell Formatting BIU Insert Delete Format Sort & Find & Paste A Merge & Center $% Filter Select Table Styles Clipboard Alignment Number Styles Cell: Editing Font A2 End of Year F C G A H 2 End of Year Cost-residual Fraction of year - Yearly depreciation Accumulated depreciation Book value EOY - 20000-E3 =B3*C3 3 1 =20000-2000 5/15 -E3 =20000-2000 =4/15 -B4*C4 -G3 - E4 4 2 F3+E4 - B5 *C5 - B6 *C6 -20000-2000 3/15 5 3 =F4+E5 G4-E5 20000-2000 2/15 20000-2000 =1/15 6 4 =F5+E6 G5- E6 -B7*C7 7 5 F6+E7 G6-E7 8 9 10 11 12 13 14 15 16 17 Sheet1 +1009% Ready P ENG 5:57 AM