# Standard Financial Calculator

Teaching Tool 12 - Financial Calculator for Excel
6-Nov-07
Personal Finance: Another Perspective
Purpose:
The purpose of this spreadsheet is to give an Excel template for a financial calculator.
It is written in Excel, and uses the Excel financial functions. Again, as with all
financial estimates, if you use reasonable estimates your results are likely to be
reasonable as well.
Disclosure:
spreadsheet, please bring them to our attention and we will correct them in upcoming
versions. The teacher, and BYU, specifically disclaim any liability, or responsibility for
claims, loss, or risk incurred, directly or indirectly, from using this material.
Instructions:
Note: Input data in the green cells only. Hit [Clear] after each problem to clear the
information. If the answer is #DIV/0, there is likely not enough information to
answer the problem. Use the Inputs Needed Table (in yellow) to make sure you
have sufficient information to solve the problem.
In using this calculator, assume that money you pay out to invest is negative, i.e.
you pay it out. Then, when you receive money the sign should be positive, i.e.
For example, you have invested \$3,000 each year for 15 years at 8% interest.
Since you pay the \$3,000 out each year the sign should be negative. When you
solve for your Future Value [Calculate FV] the answer will come back a positive
number, i.e. PMT = -3,000, N = 15, P/Y = 1, I = 8%, then solve for Future
Value [Calculate FV] = \$81,456. This is the amount of money you will have at
the end of 15 years assuming your investments returned 8% each year.
Page 1/3

## Standard Financial Calculator XLS

Favor this template? Just fancy it by voting!
•
•
•
•
•
0.0
Related Forms
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•