Video Activity

Name and describe the five primary keys on a financial calculator that are used to solve time value of money problems.

Following the instructions laid out in this video, practice calculating the following TVM variables using these inputs:

Find a Future Value (FV): Calculate FV when

$\mathrm{P}\mathrm{V}=-<!--\; -\; -->\text{1,000},\mathrm{N}=5,\mathrm{I}/\mathrm{Y}=4$, and $\mathrm{P}\mathrm{M}\mathrm{T}=0$.

Find a Present Value (PV): Calculate PV when

$\mathrm{F}\mathrm{V}=\text{2,000},\mathrm{N}=7,\mathrm{I}/\mathrm{Y}=5$, and $\mathrm{P}\mathrm{M}\mathrm{T}=0$.

Find the Number of Periods (N) when

$\mathrm{F}\mathrm{V}=\text{5,000,}\mathrm{P}\mathrm{V}=-<!--\; -\; -->\text{3,000},\mathrm{I}/\mathrm{Y}=3$, and $\mathrm{P}\mathrm{M}\mathrm{T}=0$.

Find the Interest Rate (I/Y) when

$\mathrm{F}\mathrm{V}=\text{6,000},\mathrm{P}\mathrm{V}=-<!--\; -\; -->\text{1,500},\mathrm{N}=10$, and $\mathrm{P}\mathrm{M}\mathrm{T}=2$.

Find the Payment (PMT) when

$\mathrm{F}\mathrm{V}=\text{15,000},\mathrm{P}\mathrm{V}=-<!--\; -\; -->\text{8,000},\mathrm{N}=12,$ and $\mathrm{I}/\mathrm{Y}=4$.

Continue to practice using a financial calculator to solve various time value of money problems using different input factors until you feel comfortable with the process of using a calculator to solve TVM problems.

Where within the Excel spreadsheet and its different menus (under what menu button option) can you find the different functions that will enable you to solve for different time value of money factors?

Following the instructions laid out in this video, practice calculating the following TVM variables in Excel.

Find a Future Value (FV): Calculate FV when

$\text{PV}=-<!--\; -\; -->\text{1,000},\text{N}=5,\text{I}/\text{Y}=4$, and $\mathrm{P}\mathrm{M}\mathrm{T}=0$.

Find a Present Value (PV): Calculate PV when

$\text{FV}=\text{2,000},\text{N}=7,\text{I/Y}=5$, and $\mathrm{P}\mathrm{M}\mathrm{T}=0$.

Find the Number of Periods (N) when

$\text{FV}=\text{5,000},\text{PV}=-<!--\; -\; -->\text{3,000},\text{I/Y}=3$, and $\mathrm{P}\mathrm{M}\mathrm{T}=0$.

Find the Interest Rate (I/Y) when

$\text{FV}=\text{6,000},\text{PV}=-<!--\; -\; -->\text{1,500},\text{N}=10$, and $\mathrm{P}\mathrm{M}\mathrm{T}=2$.

Find the Payment (PMT) when

$\text{FV}=\text{15,000},\text{PV}=-<!--\; -\; -->\text{8,000},\text{N}=12$, and $\mathrm{I}/\mathrm{Y}=4$.

Go back and check the answers to these questions that you ended up with under the video Time Value of Money Calculations with Financial Calculator. You should get the exact same answers when using both methods (calculator and Excel).

Continue to practice using Excel to solve various time value of money problems using different input factors until you feel comfortable with the process of using spreadsheets to solve TVM problems.