AutoSave Off Final Exam Problem #2 Template Public Saved to this PC Search File Home Insert...

Transcribed Image Text:

AutoSave Off Final Exam Problem #2 Template Public Saved to this PC Search File Home Insert Page Layout Formulas Data Review View Automate Help Century 14 ab Wrap Text Custom Paste BIU v A v Merge & Center $ % 5000 Alignment Number 09 Clipboard Font fx 300 A Barbara Rudolph 10 Comments Share Conditional Format as Formatting Table Cell Styles Insert Delete Format Sort & Find & Filter Select Sensitivity Add-ins Analyze Data Styles Cells Editing Sensitivity Add-ins B E F 1 2 Accumulated Book Value Year Cost Depreciation 3 2018 4 Beg. of Year Beg. of Year 8,500 8,500 20% G H Units of Production Depreciation Schedule Rate K M Depreciation Expense Accumulated Depreciation End of Year 410 410 Book Value End of Year 8,090 2019 8,500 8,090 8,090 20% 1,968 2,432 5,658 5 2020 8,500 5,658 5,658 20% 1,856 4,288 4,810 6 2021 8,500 4,810 4,810 20% 1,800 6,088 3,170 7 2022 8,500 3.170 3,170 20% 1,544 7,632 1,530 8 2023 8,500 1,530 1,530 0% 992 8,624 300 9 10 11 12 13 14 < > Straight-Line Units of Production Declining Balance + Ready Public Accessibility: Good to go Type here to search (4)) 6:39 PM 12/6/2023 90% AutoSave Off Final Exam Problem #2 Template Public Saved to this PC Search File Home Insert Page Layout Formulas Data Review View Automate Help Century 14 ab Wrap Text Custom Paste BIU v A v Merge & Center $ % 5000 Alignment Number 09 Clipboard Font fx 300 A Barbara Rudolph 10 Comments Share Conditional Format as Formatting Table Cell Styles Insert Delete Format Sort & Find & Filter Select Sensitivity Add-ins Analyze Data Styles Cells Editing Sensitivity Add-ins B E F 1 2 Accumulated Book Value Year Cost Depreciation 3 2018 4 Beg. of Year Beg. of Year 8,500 8,500 20% G H Units of Production Depreciation Schedule Rate K M Depreciation Expense Accumulated Depreciation End of Year 410 410 Book Value End of Year 8,090 2019 8,500 8,090 8,090 20% 1,968 2,432 5,658 5 2020 8,500 5,658 5,658 20% 1,856 4,288 4,810 6 2021 8,500 4,810 4,810 20% 1,800 6,088 3,170 7 2022 8,500 3.170 3,170 20% 1,544 7,632 1,530 8 2023 8,500 1,530 1,530 0% 992 8,624 300 9 10 11 12 13 14 < > Straight-Line Units of Production Declining Balance + Ready Public Accessibility: Good to go Type here to search (4)) 6:39 PM 12/6/2023 90%