Question Three:

Amman Company on January1, 2016 purchased machine for 80000 JD with an estimated life 6 Years and estimated residual value of 8000 JD.

Required

1. By using Excel create a new worksheet name Depreciation Expenses and entered the previous data on it, then insert necessary equations and functions in related cells to calculate depreciation expense, accumulated depreciation and carrying value of machine using three methods (straight- line, sum-of-the-Years- Digits and the Double Declining method) for the six years.
2. Represent the depreciation expense of the machine in the three different methods by graph (by chart).