FIN 502 Chapter Notes - Chapter 2: Annual Percentage Rate, Discount Window, Investment
Document Summary
Get access
Related Documents
Related Questions
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 $20,000.00 Number of Periods 5.00 Interest Rate per Period 3.00% PMT = FV / [FV(R, N, -1)] Annual Payment $3,767
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.
I need a report on how much to save per year and the return to earn to meet savings goal for graduation, and savings goal in the first three years of post graduation. Can you please use the numbers above that are already calculated in the formula. I have had an answer on this below. I don't understand why the periods don't stay the same for 5 years. The annuity is 7964 I took that divided b y 60 = 132.7 per month and multiplied it by 12 for a year and got 1592.4. Is that the savings for the answer to saving for a year. IF not I need help figuring out the calculation for the return to meet after gradutaion and the next three years post graduation.
Goal 1 | Savings Goal for graduation, FV | $ 20,000 | |||||
Time till graduation (Number of periods) | 5 | ||||||
Present value of savings | $ - | ||||||
Expected interest rates | 3% | ||||||
Savings needed per year, PMT | $3,767.09 | =PMT(3%,5,0,20000,) | |||||
Goal 2 | Savings Goal for 1st year of post graduation, FV | $ 15,000 | |||||
Time till post graduation year 1 (Number of periods) | 6 | ||||||
Present value of savings | $ - | ||||||
Expected interest rates | 3% | ||||||
Savings needed per year, PMT | $2,318.96 | =PMT(3%,6,0,15000,) | |||||
Goal 3 | Savings Goal for 2nd year of post graduation, FV | $ 15,300 | |||||
Time till post graduation year 1 (Number of periods) | 7 | ||||||
Present value of savings | $ - | ||||||
Expected interest rates | 3% | ||||||
Savings needed per year, PMT | $1,996.75 | =PMT(3%,7,0,15300,) | |||||
Goal 4 | Savings Goal for 3rd year of post graduation, FV | $ 15,606 | |||||
Time till post graduation year 1 (Number of periods) | 8 | ||||||
Present value of savings | $ - | ||||||
Expected interest rates | 3% | ||||||
Savings needed per year, PMT | $1,754.99 | =PMT(3%,8,0,15606,) |
Required:
Compare the results of the three (3) methods by quality of information for decision making. Using what you have learned about the three (3) methods, identify the best project by the criteria of long term increase in value. (You do not need to do further research.) Convey your understanding of the Time Value of Money principles used or not used in the three (3) methods. Review the video titled âNPV, IRR, MIRR for Mac and PC Excelâ (located at https://www.youtube.com/watch?v=C7CryVgFbBc and previously listed in Week 4) to help you understand the foundational concepts:
Scenario Information:
Assume that two gas stations are for sale with the following cash flows; CF1 is the Cash Flow in the first year, and CF2 is the Cash Flow in the second year. This is the time line and data used in calculating the Payback Period, Net Present Value, and Internal Rate of Return. The calculations are done for you. Your task is to select the best project and explain your decision. The methods are presented and the decision each indicates is given below.
Investment | Sales Price | CF1 | CF2 |
Gas Station A | $50,000 | $0 | $100,000 |
Gas Station B | $50,000 | $50,000 | $25,000 |
Three (3) Capital Budgeting Methods are presented:
Payback Period: Gas Station A is paid back in 2 years; CF1 in year 1, and CF2 in year 2. Gas Station B is paid back in one (1) year. According to the payback period, when given the choice between two mutually exclusive projects, the investment paid back in the shortest time is selected.
Net Present Value: Consider the gas station example above under the NPV method, and a discount rate of 10%:
NPVgas station A = $100,000/(1+.10)2 - $50,000 = $32,644
NPVgas station B = $50,000/(1+.10) + $25,000/(1+.10)2 - $50,000 = $16,115
Internal Rate of Return: Assuming 10% is the cost of funds; the IRR for Station A is 41.421%.; for Station B, 36.602.
Summary of the Three (3) Methods:
Gas Station B should be selected, as the investment is returned in 1 period rather than 2 periods required for Gas Station A.
Under the NPV criteria, however, the decision favors gas station A, as it has the higher net present value. NPV is a measure of the value of the investment.
The IRR method favors Gas Station A. as it has a higher return, exceeding the cost of funds (10%) by the highest return.