Please answer using Excel.

c D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 Required: silver mine can yield 10,000 ounces of silver at a variable cost of $32 per ounce. The fixed costs of owning the Imine are $40,000 per year regardless of whether the mine is open or closed. In half the years, silver can be sold for $48 per ounce; in the other years, silver can be sold for only $24 per ounce. Ignore taxes. a. What is the average cash flow you will receive from the mine if it is always kept in operation and the silver always sold in the year it is mined? b. Now suppose you can costlessly shut down the mine in years of low silver prices. What happens to the average cash flow from the mine? Note: Use cells A7 to BII from the given information to complete this question. You may use the hardcoded number "2" in your formulas. No other hardcoded numbers may be used. Input area: Silver yield in ounces Variable cost per ounce Fixed costs Sales price #1 Sales rice #2 Output area: . Average cash flow b. Average cash flow 10,000 $32 $40,000 $48 $24