Sequences & Series: Arithmetic, Geometric & Their Money Uses
nth terms, sums, growth and depreciation, the annuity formula behind FV, perpetuities, recursions, Σ with SUMPRODUCT and convergence tests: 8 graded labs with salaries, savings and a bouncing ball.
The first lesson is free — no account needed.
About this course
A sequences and series course that follows one junior analyst's salary, savings and job offers through the formulas, in a spreadsheet, for high school and college students and anyone who wants to see where the finance formulas come from. You find the nth term and the sum of an arithmetic sequence and the year a salary goal is reached, model growth and depreciation with geometric sequences and solve for the year with LN, add up a savings plan with the geometric series formula and match it to FV, value perpetuities and a growing perpetuity and the path of a bouncing ball with infinite series, build Fibonacci and a harvested fish population recursively, write Σ sums as one-cell SUMPRODUCT formulas, find the crossover of a fixed and a percentage raise and test convergence with partial sums and the ratio test. The first lab is free.
Lessons
- Arithmetic Sequences: nth Term, Sum & Salary RaisesFree
- Geometric Sequences: Growth & Depreciation Pro
- Geometric Series & the Annuity Formula: Sum vs FV Pro
- Infinite Geometric Series: Perpetuities & a Bouncing Ball Pro
- Recursive Sequences: Fibonacci & a Fish Population with Harvest Pro
- Sigma Notation with SUMPRODUCT & ROW Pro
- Linear vs Compound Growth: Two Salary Offers & a Chart Pro
- Convergence Tests by Computation: Partial Sums & the Ratio Test Pro