The future value of either an ordinary annuity or an annuity due may be calculated in Google Sheets. The Sheets command FV helps you to do this.
Author: drdave
How Do You Find Compound Interest Future Value In Google Sheets?
Google Sheets contains several powerful commands for calculating compound interest. This MathFAQ demonstrates how to compute future value using compound interest.
Death and Piecewise Linear Functions
Although this may seem a little gruesome, it is not uncommon for businesses to give discounts for volume sales. In this case, a mortician charges less per pound for bodies weighing more than a certain amount.
The local mortician charges by the pound for embalming according to the following table:
Find a piecewise linear function that models the cost as a function of weight.
How Do You Use Google Sheets To Do Row Operations For The Simplex Method?
In an earlier post, I showed how to set up a standard minimization problem from an application. In another post, I demonstrated how to find the corresponding dual maximization problem and to solve it with the Simplex Method. This algorithm is tedious and prone to arithmetic errors.
In the video below, the steps in the Simplex Methods are carried out in Google Sheets. The same steps can also be carried out in other spreadsheets such as Microsoft Excel.
Please note that there is a typo in the original matrix in the process. The cell in D2 should be a 1 instead of a zero to account for the slack variable in the first constraint.
Rates and Rational Models
Many situations require us to take the derivative of a quotient. One situation like this is a model of a stocks price to earning ratio. In this situation the price is modeled by a function P(t) and the earnings by E(t).To find the rate at which the PE ratio is changing, you need to need to take the derivative of the model for the PE ratio.
The ratio is modeled by a quotient, P(t)/E(t). Since this is a quotient, we need to apply the quotient rule for derivative, 
but apply this to our functions. This means u will be replaced with P and v will be replaced with E to give
