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

Find a Future Value (FV): Calculate FV when

PV = -1,000, N = 5, I/Y = 4, and PMT = 0.

Find a Present Value (PV): Calculate PV when 

FV = 2,000, N = 7, I/Y = 5, and PMT = 0.

Find the Number of Periods (N) when 

FV = 5,000, PV = -3,000, I/Y = 3, and PMT = 0.

Find the Interest Rate (I/Y) when 

FV = 6,000, PV = -1,500, N = 10, and PMT = 2.

Find the Payment (PMT) when 

FV = 15,000, PV = -8,000, N = 12, and I/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.