Please prepare in Excel Format

The following is a schedule of machinery owned by Sturdy Construction Company Estimated Salvage Value $ 30,000 Estimated Life in Years 10 Total Cost Machine A Machine B Machine C Machine D $ 260,500 315,000 35,000 56,000 110,000 741, 50 7,000 Sturdy computes depreciation on the straight-line basis using the group method. Based on the information presented (1) Calculate the depreciation rate for the group. Round the depreciation rate to 2 decimal (2) Prepare journal entries to record the acquisition and the first year's depreciation expense (3) If the company sells Machine D after 4 years for S10,000, prepare thejournal entry. places (example-14.56%) Round all amounts to the nearest dollar