USE EXCEL ONLY

Problem 1: A certain type of machine loses 10% of its value each year. The machine costs P20,000 originally. Make out a schedule showing the yearly depreciation, the total depreciation, and the book value at the end of each year for 5 years. Problem 2: Determine the rate of depreciation, the total depreciation up to end of the 8 th year, and the book value at the end of 8 years for an asset that costs P15,000 now and has an estimated scrap value of P2,000 at the end of 10 years by (a) declining balance method and (b) the double declining balance method