PLEASE GIVE EXCEL FORMULAS

LLC has been farming a new strain of radioactive-material-eating bacteria that the electrical utility industry can use to help dispose of its nuclear waste. Two opposing factors affect Biotech's decision of when to harvest the bacteria. The bacteria are currently growing at a 22 percent annual rate, but due to known competition from other top firms, biotech analysts estimate that the price for the bacteria will decline according to the schedule below. If the opportunity cost of capital is 10 percent, then when should Biotech harvest the entire bacteria colony at one time? Hint: Compute the change in total revenue each year and recommend harvesting when the percentage change in revenue falls below the cost of capital. LLC has been farming a new strain of radioactive-material-eating bacteria that the electrical utility industry can use to help dispose of its nuclear waste. Two opposing factors affect Biotech's decision of when to harvest the bacteria. The bacteria are currently growing at a 22 percent annual rate, but due to known competition from other top firms, biotech analysts estimate that the price for the bacteria will decline according to the schedule below. If the opportunity cost of capital is 10 percent, then when should Biotech harvest the entire bacteria colony at one time? Hint: Compute the change in total revenue each year and recommend harvesting when the percentage change in revenue falls below the cost of capital