Solar power is to be installed to handle a large portion of a company's electrical load. Even though the system will likely work for 20-25 years, there is concern about functional obsolescence and the need to replace the system with more efficient components much sooner. The cost will be $265,000 and the system is expected to have a useful life of 8 years with a salvage value of $20,000 at that time.

Develop a table showing the depreciation and book value for each year using double declining balance switching to straight-line depreciation at the optimal time. Do NOT use the Excel VDB worksheet function.

arry all interim calculations to 5 decimal places and then round your final answers to 2 decimal places. The tolerance is 1.00.

How do you determine the optimal time to switch to straight line depreciation?

The optimum time to switch is the first time the depreciation charge with straight-line depreciation is ______ (greater or less) than the one that results from using declining balance method.

PLS BOX FINAL ANSWER NEED ASAP WILL GIVE THUMBS UP

Year Depreciation Book Value 0 $ 1 $ $ 2 $ $ 3 A $ 4 $ $ 5 $ $ 6 $ $ 7 $ $ 8 A A