Financial functions

The aim of the three linked sheets below is to develop the necessary skills to create the dynamic spreadsheet with the functionality as seen in the illustration below.  

• Basic functions - The most common financial functions are explained and exercises given
• Table - Static variables where calculations with multiple versions can be performed in one operation
• Simple calculator - A simple calculator is created with the Future Value function, then adapted so that two variables can be dynamically manipulated
• Dynamic spreadsheet - The goal of this excercise.

The dynamic spreadsheet

or

or

Return to Computer Studies lesson plan index of Pinelands High School.  This work may be freely copied for non-commercial use only. Copyright © Pam Miller.