textbook title:  Steven J. Peterson, MBA, PE, Construction Accounting and Financial Management, Fourth Edition, Pearson Education, Inc., Saddle River, NJ, 2013 

Please note the Straight-line Depreciation  Please consider this example as well as those included in the textbook when completing your homework assignment.  Please remember that your homework is due Monday, February 17, 2020, ch 3,5

see example file, this homework based in the book ch 3,5. You have to use Excel