Solve using EXCEL

Problem 3 - 10 points For the last 10 years, a coal company use the cost depletion factor of 2,500 per 100 tons to write off the investment of 35 million. Depletion thus far totals 24.8 million. A new study apprises mine reserves indicates that no more than 800,000 tons of coals remains. Determine next year's percentage and cost depletion amount. The estimated gross income is expected to be between 6.125 and 8.5 million on a production level of 72,000 tons