SUBJECT: ENGINEERING ECONOMY

PLEASE WRITE LEGIBLY!!!

solve the following with complete solution and submit in Excel format

An engine bought for Php 1,800,000.00 has a service life of 13 yrs which can then estimated to be valued at Php 500,000.00. Perform all 5 depreciation methods if the interest is 7% compounded annually. The following must be presented:

1. Tabular form in exact order: Year, Depreciation charge on each year, Total depreciation on each year, Book Values
2. Book value curves of each methods all in ONE graph with proper and identifiable labeling.