please solve the table below and show all formulas used. thanks

1 U 1 1 10 1 2 3 4 5 6 7 rall problems nif N>10 can be hidden to make printable region cover a 10-year project life Probleme 11-64. Acquisition cost: $2,500,000: N-15 years year-1=90 000 bbt production decreases 6000 bbl/year selling price = $10/bbl expenses = $4/bbl. Depletion Allowance Calculation 2 3 4 5 6 8 TO 0 Cost Depletion Recoverable Units Purchased Annual Production Mineral Acquisition Cost Cost Depletion 0.15 a in 11 12 13 14 15 16 17 18 19 2n 21 22 23 24 25 26 27 28 29 31 22 33 24 35 36 Percentage Depletion Depletion Percentage Rate (8) Price/unit Units sold Mineral Sales Revenue Mineral Sales x Depletion Expenses (except Depletion $4/bbl Minerals Income 50% income Cap Maximum Allowable Depletion Depletion Deduction PV of Depletion Deductions (12% MARR) 10,000 bbl production decreases 6000 bbl/year,selling price = $10/bbt expenses = $4/bbl. 6 3 5 6 B 10 11 13 14 15 JIANG-SDONDIA- 11 12 13 14 15 16 17 18 19 2n 21 22 22 24 25 26 27 28 29 20 31 24 35 26 37 35880 11-64 The Red River oil field will become less productive each year. Rojas Brothers is a small company that owns Red River, which is eligible for percentage depletion. Red River costs $2.5M to acquire, and it will be produced over 15 years. Initial production costs are $4 per barrel, and the wellhead value is $10 per barrel. The first year's production is 90,000 barrels, which will decrease by 6000 barrels per year. (a)Compute the annual depletion (each year may be cost-based or percentage-based). (b) What is the PW at i = 12% of the depletion schedule? 1 U 1 1 10 1 2 3 4 5 6 7 rall problems nif N>10 can be hidden to make printable region cover a 10-year project life Probleme 11-64. Acquisition cost: $2,500,000: N-15 years year-1=90 000 bbt production decreases 6000 bbl/year selling price = $10/bbl expenses = $4/bbl. Depletion Allowance Calculation 2 3 4 5 6 8 TO 0 Cost Depletion Recoverable Units Purchased Annual Production Mineral Acquisition Cost Cost Depletion 0.15 a in 11 12 13 14 15 16 17 18 19 2n 21 22 23 24 25 26 27 28 29 31 22 33 24 35 36 Percentage Depletion Depletion Percentage Rate (8) Price/unit Units sold Mineral Sales Revenue Mineral Sales x Depletion Expenses (except Depletion $4/bbl Minerals Income 50% income Cap Maximum Allowable Depletion Depletion Deduction PV of Depletion Deductions (12% MARR) 10,000 bbl production decreases 6000 bbl/year,selling price = $10/bbt expenses = $4/bbl. 6 3 5 6 B 10 11 13 14 15 JIANG-SDONDIA- 11 12 13 14 15 16 17 18 19 2n 21 22 22 24 25 26 27 28 29 20 31 24 35 26 37 35880 11-64 The Red River oil field will become less productive each year. Rojas Brothers is a small company that owns Red River, which is eligible for percentage depletion. Red River costs $2.5M to acquire, and it will be produced over 15 years. Initial production costs are $4 per barrel, and the wellhead value is $10 per barrel. The first year's production is 90,000 barrels, which will decrease by 6000 barrels per year. (a)Compute the annual depletion (each year may be cost-based or percentage-based). (b) What is the PW at i = 12% of the depletion schedule