Financial ToolBoxes
(Gray-shaded boxes are the outputs based on the given inputs above them. Do not type in the shaded boxes.)
APR
4.00%
APR
18.00%
APR
8.00%
Compounding Periods
12
Compounding Periods
12
Compounding Periods
4
Present Value
150000.00
Present Value
1200.00
Payment
-25
Payment
-716.12
Payment
-24
Present Value
-250.00
Years
15
Future Value
0
Years
45
Future Value:
($96,814.92)
Years:
7.8
Investment Interest:
$46,981.25
APR
4.00%
APR
4.00%
APR
9.00%
Compounding Periods
12
Compounding Periods
12
Compounding Periods
12
Present Value
250000
Future Value
0.00
Original # of Payments
360
Future Value
0
Payment
-1000.00
Present Value
60000.00
Years
30
Years
30
Years
30
Payment:
($1,193.54)
Present Value:
$209,461.24
Debt Interest:
($113,798.49)
APR
3.25%
APY
3.29%
Compounding Periods
4
Compounding Periods
4
Effective Yield (APY):
3.29%
Nominal Yield (APR):
3.25%
So that you can see all of the formulas of the gray boxes at once, they are listed here for your convenience:
Future Value:
Years:
Savings Interest:
Payment:
Present Value:
=PV(F13/F14,F17*F14,F16,F15)
Debt Interest:
Effective Yield:
=(1+C21/C22)^C22-1
Nominal Yield:
Why the Negative? (Rules of Thumb):=F22*((1+F21)^(1/F22)-1)
1.
Notice that present value and future value are always opposite in sign.
2.
Use the "Inflow-Outflow" way of thinking:
Inflow is money "coming in the door" and outflow is money "going out".
3.
If all else fails, try changing the sign of any of the inputs to see how it affects the result and act accordingly.
4.
Don't get "burned" by the negative or lack of a negative. In other words, always keep it in the back of your mind.
Note: The formulas in the gray boxes above are cell-protected. The word 'byui' is the password if you wish to turn off the protection. Also, understanding
the role that the
negative
plays is crucial. You may want to scroll several rows down below to read more about it.
=FV(C5/C6,C6*C9,C8,C7)
=(NPER(F5/F6,F8,F7,F9))/F6
=FV(I13/I14,I17*I14,I15,I16)+I15*I14*I17+I16
=PMT(C13/C14,C17*C14,C15,C16)
=CUMIPMT(I13/I14,I15,I16,1,I17*I14,0)
My Personal Annuity Worksheet
Given:
Principal
Compounds
APR
Payment
Months
Principal
Interest
Payment
Total
Month #9
(Formula Method)
Month #9
(Excel Function Method)
Month #9
(Iteration Method)
Reflection Paragraph
:
(
Briefly summarize insights gained from the three methods to calculate the
important for young investors to know.
)
Start here . . .
future value, the impact that interest can have on your investments, and what is
($)
(%)
(%)
Current
Career
Calendar
Annual
Salary
Employee
Age
Year
Year
Salary
Increase
Contribution
0
35
1
2018
n/a
2.00%
36
2
2.00%
37
3
2.00%
38
4
2.00%
39
5
2.00%
40
6
2.00%
41
7
2.00%
42
8
2.00%
43
9
2.00%
44
10
2.00%
45
11
2.00%
46
12
2.00%
47
13
2.00%
48
14
2.00%
49
15
2.00%
50
16
2.00%
51
17
2.00%
52
18
2.00%
53
19
2.00%
54
20
2.00%
55
21
2.00%
56
22
2.00%
57
23
2.00%
58
24
2.00%
59
25
2.00%
60
26
2.00%
61
27
2.00%
62
28
2.00%
63
29
2.00%
64
30
2.00%
Personal 401(k) Retirement
Planning Worksheet
65
31
2.00%
66
32
2.00%
67
33
2.00%
68
34
2.00%
69
35
2.00%
70
36
2.00%
71
37
2.00%
72
38
2.00%
73
39
2.00%
74
40
2.00%
75
41
2.00%
76
42
2.00%
77
43
2.00%
78
44
2.00%
79
45
2.00%
80
46
2.00%
81
47
2.00%
82
48
2.00%
83
49
2.00%
84
50
2.00%
85
51
2.00%
86
52
2.00%
87
53
2.00%
88
54
2.00%
89
55
2.00%
90
56
2.00%
91
57
2.00%
92
58
2.00%
93
59
2.00%
94
60
2.00%
95
61
2.00%
96
62
2.00%
97
63
2.00%
98
64
2.00%
99
65
2.00%
100
66
2.00%
Career Scenarios:
Investment Scenarios:
Number of Years Planning to Work
45
Present Value at the St
Age During First Year of Career
35
Number of Payments Ma
Beginning Salary Year
2018
Projected Inv
Ending Salary Year
2064
Average Inflation Rate
Starting Salary
45,000
Initial Employee C
Annual Salary Increase
2.50%
