Calculate the Present Value of the Depreciation Tax Shield for an Asset

question 114

Essay

Calculate the present value of the depreciation tax shield for an asset with a three-year estimated life costing $100,000.The firm has a 35 percent tax rate and a 10 percent cost of capital.Its CCA is 30 percent declining balance with a half-year rule.Compare this present value to that calculated for straight-line depreciation with no salvage value in both cases.

Understand the process of refreshing PivotTable data and changing the data source.

Identify how to create and utilize PivotCharts effectively.

Know how to use Excel functions and features to retrieve and summarize data in PivotTables.

Recognize how to apply corrections, effects, and styles to pictures in worksheets.

---

Definitions:

During Surgery

The period in which surgical operations are performed on a patient under medical supervision.

After Surgery

After surgery, also known as postoperative, refers to the period following a surgical procedure, a critical time for recovery and monitoring for complications.

Active Role

Participation or involvement in an activity or process in a dynamic, engaged manner.

Cultural Beliefs

The shared values, traditions, norms, customs, arts, history, folklore, and institutions of a group of people.