401k Excel Project - Financial ToolBoxes(Gray-shaded boxes...

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):
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)
=F22*((1+F21)^(1/F22)-1)

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
28 1 2018 45,000 n/a 2.00%
29 2 2019 46,125 2.50% 2.00%
30 3 2020 47,278 2.50% 2.00%
31 4 2021 48,460 2.50% 2.00%
32 5 2022 49,672 2.50% 2.00%
33 6 2023 50,913 2.50% 2.00%
34 7 2024 52,186 2.50% 2.00%
35 8 2025 53,491 2.50% 2.00%
36 9 2026 54,828 2.50% 2.00%
37 10 2027 56,199 2.50% 2.00%
38 11 2028 57,604 2.50% 2.00%
39 12 2029 59,044 2.50% 2.00%
40 13 2030 60,520 2.50% 2.00%
41 14 2031 62,033 2.50% 2.00%
42 15 2032 63,584 2.50% 2.00%
43 16 2033 65,173 2.50% 2.00%
44 17 2034 66,803 2.50% 2.00%
45 18 2035 68,473 2.50% 2.00%
46 19 2036 70,185 2.50% 2.00%
47 20 2037 71,939 2.50% 2.00%
48 21 2038 73,738 2.50% 2.00%
49 22 2039 75,581 2.50% 2.00%
50 23 2040 77,471 2.50% 2.00%
51 24 2041 79,407 2.50% 2.00%
52 25 2042 81,393 2.50% 2.00%
53 26 2043 83,427 2.50% 2.00%
54 27 2044 85,513 2.50% 2.00%
55 28 2045 87,651 2.50% 2.00%
56 29 2046 89,842 2.50% 2.00%
57 30 2047 92,088 2.50% 2.00%
Personal 401(k) Retirement
Planning Worksheet

58 31 2048 94,391 2.50% 2.00%
59 32 2049 96,750 2.50% 2.00%
60 33 2050 99,169 2.50% 2.00%
61 34 2051 101,648 2.50% 2.00%
62 35 2052 104,189 2.50% 2.00%
63 36 2053 106,794 2.50% 2.00%
64 37 2054 109,464 2.50% 2.00%
65 38 2055 112,201 2.50% 2.00%
66 39 2056 115,006 2.50% 2.00%
67 40 2057 117,881 2.50% 2.00%
68 41 2058 120,828 2.50% 2.00%
69 42 2059 123,849 2.50% 2.00%
70 43 2060 126,945 2.50% 2.00%
71 44 2061 130,118 2.50% 2.00%
72 45 2062 133,371 2.50% 2.00%
73 46 2063 136,706 2.50% 2.00%
74 47 2064 140,123 2.50% 2.00%
75 48 2065 143,626 2.50% 2.00%
76 49 2066 147,217 2.50% 2.00%
77 50 2067 150,897 2.50% 2.00%
78 51 2068 154,670 2.50% 2.00%
79 52 2069 158,537 2.50% 2.00%
80 53 2070 162,500 2.50% 2.00%
81 54 2071