TVM Solver and Loan Payment Calculator - Google Sheets Version
CalfordMath
1.1k Followers
Grade Levels
11th - 12th
Subjects
Standards
CCSSHSA-SSE.A.1b
CCSSHSA-SSE.B.4
Formats Included
- PDF
- Google Apps™
Pages
1 page
CalfordMath
1.1k Followers
Includes Google Apps™
The Teacher-Author indicated this resource includes assets from Google Workspace (e.g. docs, slides, etc.).
Description
This Google Sheets-based TVM Solver mimics the behavior of the familiar TI-84 calculator application. You can use all the same instructions you always do. Students simply leave the field they wish to solve for blank.
I know how difficult it can be to get a good TVM solver into the hands of your students when they are working from home on a variety of devices.
I also included a Loan Payment Calculator to determine the monthly, weekly, or biweekly payment, given the principal amount, annual interest rate, and term length in years. It assumes the compounding and payment frequency are the same. Sometimes a TVM Solver is overkill for what your course requires! I’ve found this one helpful.
Total Pages
1 page
Answer Key
N/A
Teaching Duration
N/A
Last updated Feb 10th, 2021
Report this resource to TPT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TPT’s content guidelines.
Standards
to see state-specific standards (only available in the US).
CCSSHSA-SSE.A.1b
Interpret complicated expressions by viewing one or more of their parts as a single entity. For example, interpret 𝘗(1 + 𝘳)ⁿ as the product of 𝘗 and a factor not depending on 𝘗.
CCSSHSA-SSE.B.4
Derive the formula for the sum of a finite geometric series (when the common ratio is not 1), and use the formula to solve problems. For example, calculate mortgage payments.
Reviews
Questions & Answers
1.1k Followers
