1. Assume that you have $1,000 to invest, so insert 1000 as your Present Value in the following table. Assume that you want to invest your money for 5 years (insert 5 for Number of Periods). Assume an annual interest rate of 3.00% (insert 3 for Interest Rate per Period). The table will determine the Future Value of your investment. If you input the numbers correctly, your Future Value is computed to be $1.159, which is what your investment will be worth in 5 years. Now revise the input to reflect your actual savings and the prevailing interest rate so that you can see how your savings will grow in 5 years. Even if you have no savings now, you can at least see how the interest rate affects the future value of savings by revising your input in the Interest Rate per Period, and then observing the change in the Future Value.
Future Value of a Present Amount
Present Value					$1,500
Number of Periods					5
Interest Rate per Period					3.0%	FV = PV*(1+R)^N
Future Value					$1,739
2. Assume that you have $1,000 to invest at the end of each of the next 5 years, so insert 1000 as your Payment per Period in the following table. Assume that you want to invest your money for 5 years (insert 5 for Number of Periods). Assume an annual interest rate of 3.00% (insert 3 for Interest Rate per Period). The following table will determine the Future Value of your investment. If you input the numbers correctly, your Future Value is computed to be $5,309, which is what your investments will be worth in 5 years. Now revise the input to reflect your actual expected savings per year over the next 5 years, and existing interest rate quotations so that you can estimate how your savings will grow in 5 years. You can now revise the table to fit your own desired level of saving.
Future Value of an Annuity
Payment per Period					$1,500
Number of Periods					5
Interest Rate per Period					3.0%	FV = FV(R, N, PMT, (PV), beginning=1, end=0)
Future Value					$7,964
3. Assume that you want to deposit savings that will be worth $10,000 in 5 years, so insert 10000 as the Future Amount and 5 as the Number of Periods in the following table. Assume an annual interest rate of 3.00% (insert 3 for Interest Rate per Period). The following table will determine the Present Value, which represents the amount of savings you need today that would accumulate to be worth $10,000 in 5 years. If you input the numbers correctly, the Present Value is estimated in the table to be $8,606. Now revise the input to reflect your own desired savings amount in 5 years so that you can estimate how much you need now to achieve your savings goal in 5 years.
Present Value of a Future Amount
Future Amount					$20,000
Number of Periods					5
Interest Rate per Period					3.0%	PV = FV / (1+R)^N
Present Value					$17,252
4. Assume that you want to deposit savings at the end of each of the next 5 years so that you will have $10,000 in 5 years. So insert 10000 as the Future Amount, and 5 for Number of Periods. Assume an annual interest rate of 3.00% (insert 3 for Interest Rate per Period). The following table will determine the Annual Payment, which represents the annual payments that will accumulate to your future desired investment. If you input the numbers correctly, your Annual Payment is computed to be $1,884. Now revise the input to reflect your own desired savings amount in 5 years so that you can estimate how much you need to save per year to achieve your savings goal in 5 years.
Compute Payment Needed to Achieve Future Amount
Future Amount					$15,000.00
Number of Periods					9.00
Interest Rate per Period					3.00%	PMT = FV / [FV(R, N, -1)]
Annual Payment					$1,477
Decisions
1. Using the above formulas and understanding of the impact of interest rates and time on your savings, report on how much you must save per year and the return you must earn to meet your savings goal for graduation, and your savings goal in your first three years of post-graduation life. Here is an answer that I got; Soln : Saving goal till graduation = 20000, no. of years to complete graduation = 5 years. Interest rate 3% As you have calculated correctly here, saving needed at the end of each year = PMT (rate,nper, pv, FV) on using the values , PMT = 3767.09 is required each year, if it is needed to be calculated monthly then we cannot simply divide it with 12, as there will be interest on interest earned each month. So, for monthly saving, nper = 60, interest rate = 3/12 = 0.25% So, PMT = PMT(0.25%, 60,0,20000) = 309.37 Similarly saving goal for 1st year of PG = $15000, nper = 12*6 = 72, rate = 0.25% PMT on monthly basis = PMT(0.25%, 72,0,15000) = $190.41 Similarly saving goal for 2nd year of PG = $15300, nper = 12*7 = 84, rate = 0.25% PMT on monthly basis = PMT(0.25%, 84,0,15300) = $163.91 Similarly saving goal for 3rd year of PG = $15606, nper = 12*8 = 96, rate = 0.25% PMT on monthly basis = PMT(0.25%, 96,0,15606) = $144.04 What you have given in fig. will be right in case if the calculation is to be done for yearly basis. PLease explain the caluclations on how you get the monthly basis, what numbers were used to get those amounts. Also why did we start with 20000 and drop to 15000 15300 15606 Some one please explain the calculations for me thank you.