A company owns the same asset in a U.S. plant (New York) and in a EU plant

Question:

A company owns the same asset in a U.S. plant (New York) and in a EU plant (Paris). It has B = $2,000,000 and a of 20% of B. For tax depreciation purposes, the United States allows a straight line write-off over 5 years, while the EU allows SL write-off over 8 years. The general managers of the two plants want to know the difference in
(a) The depreciation amount for year 5
(b) The book value after 5 years.
Using a spreadsheet, write cell functions in only two cells to answer both questions.

Salvage Value
Salvage value is the estimated book value of an asset after depreciation is complete, based on what a company expects to receive in exchange for the asset at the end of its useful life. As such, an asset’s estimated salvage value is an important...