I need help on question 2.

MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value FV = future value type = 0 or omiited for regular annuity: = 1 for annuity due guess = your guess for what the rate will be Notes: 1. Make sure that you are consistent about your specifications for I and N. If you make monthly payments on a three-year loan at 8 percent annual rate, use 0.75% (8%/12) for I and 36 (3*12) for N. PMT and PV must be entered as a negative number. 2. Future Value Formula: Excel: FVN = PV (1+1)N =FV(I, N, PMT, PV, type) Example 1: If you deposit $1.000 in a savings account that pays 8% interest compounded annually how much will you receive 10 years from today? Answer: =FV(0.08, 10, 0,-1000,0) = $2,158.92 Example 2: Same as Example 1 except that interest rate is compounded quarterly. Answer: =FV(0.02, 40, 0,-1000,0) = $2,208.04 Present Value Formula: Excel: PV = FVN/(1+1)N =PV(I, N, PMT, FV, type) Example 3: What is the present value of $500 to be received 10 years from today if interest rate is 6 percent? Answer: =PV(0.06, 10, 0, 500,0) = ($279.20). The result is negative because it represents money that you would pay, an outgoing cash flow, for receiving $500 in 10 years. Future Value of An Annuity Formula: FVAN = PMT S1 + 1) - = PMT +7 - tal Excel: =FV(I, N, PMT, PV, type) Example 4: If you deposit $100 at the end of each year for three years in a savings account that pays 5 percent interest per year, how much will you have at the end of 3 years? Answer: =FV(0.05, 3. -100, 0, 0) = $315.25 where PMT is entered as -100. Example 5: You deposit $1,000 into a savings account that earns 6 percent annual interest compounded monthly. You also plan to deposit $100 at the beginning of each month for the next 12 months. How much money will be in the account at the end of 12 months? Answer: =FV(0.005, 12, -100, -1000, 1) = $2,301.40 Present Value of An Annuity N Formula: PVAN = PMT (1+1)* = PMT 1 - - t=1 =PV(I, N, PMT, FV, type) Excel: Example 6: What is the present value of a 3-vear annuity with vear given as percent annual interest rate? lue of a 3-year annuity with payment of $100 at the end of each Answer: =PV(0.05, 3, -100,0,0) = $272.32 Example 7: Answer: o except that the payment occurs at the beginning of each period. =PV(0.05. 3. -100.0, 1) = $285.94 Solving for Interest Rate and Time Excel: =RATE(N, PMT, PV, FV, type, guess), where PMT is enter PV as negative, and 0.01 is entered for guess ENPER(I, PMT, PV, FV, type) Excel: Example 8: If you borrow $10.000 for 5 vears and the monthly payment is $222.44, what is the annual percentage rate (APR) on the loan? Answer: ERATE(60, 222.44. - 10.000,0,0,0.01) = 1%, which is the monthly rate. To find APR, you multiply monthly rate 1% by 12 months = 12%. Example 9: How many years does it take to grow an investment from $300 to $774 with a 9 percent annual return? Answer: ENPER(0.09, 0, -300, 774,0) = 11 Present Value of Perpetuities Formula: Excel: PV (Perpetuity) = PMT/ =PMT/I Present Value of An Uneven Cash Flow Stream N Formula: 1+1 PV = CFGM =NPV(I, CF, CF2,....) Excel: Example 10: Suppose you're considering an investment in which you pay $10,000 one year from today! and receive an annual income of $3.000, $4,000, and $7.000 in the three years that follow. Assuming an annual discount rate of 10 percent, what is the ne this investment? le net present value of Answer: If the above cash flows are entered in Al through A4. Tesnenie CF; = -10,000, CF2 = 3,000, CF3 = 4,000, and CF4 = 7,000, then the net this investment is given by: =NPV(0.1, A1:A4) = $1,174.78 le net present value of Amortized Loans To calculate the payment for a loan based on constant payments and a constant interest rate, the Excel formula is =PMT(I, N, PV, FV, type) where PV must be entered as negative. To calculate the cumulative interest paid on a loan between start_period and end_period, the Excel formula is =CUMIPMT(I, N, PV, start period, end period, type). PV must be entered as positive. To calculate the cumulative principal paid on a loan between start period and end period, the Excel formula is =CUMPRINC(I, N, PV, start_period, end_period, type) Example 11: Assume that you borrow $1.000 at a 10 percent annual rate to be repaid in 3 equal payments at the end of each of the next 3 years. Annual total payment is: =PMT(0.1, 3,-1,000,0,0) = $402.11 Interest payment in year 2 is: =CUMIPMT(0.1.3, 1000, 2,2,0) = -$69.79 Total principal payment at the end of year 2 is: =CUMPRINC(0.1. 3. 1000,1,2,0) = -5634.44 Continuous Compounding And Discounting Formula: Excel: FVN = PVN and =PV X EXP(I x N) and PV = FVne =FVNX EXP(-IX N) Example 12: $1.000 at 10 percent per year, which is continuously compounded, how much will you receive in year 20? FV2 = 1000 x EXP(0.1 x 20) = $7,389.06 Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at ercent annual rate, compounded $700 every three months at a 6 percent am much will you have at the end of 20 years? Question 2: You borrow a five-year $13.000 loan with monthly percentage rate (APR) on the loan? 3,000 loan with monthly payments of $250. What is the annual Question 3: How much would you have to invest today to receive per year? have to invest today to receive $50,000 in 10 years at 9.5 percent Question 4: Ms. Nelson will receive $12.000 a year for the next 20 years from 00 a year for the next 20 years from her retirement fund. If a 6 percent interest rate is applied what is the current value of her retirement rund: Question 5: Assume you deposit $2.000 every six months at 10 percent compounded semi-annually. How much will you have at the end of 10 years? Question 6: If you need $40,000 for your son's education in 10 years, how much must you deposit at the beginning of each year in the bank earning 6 percent in order to have the college money ready? Question 7: If you have $30,000 in a savings account earning 10 percent, how large an annuity can you draw out each year if you want nothing left at the end of 8 years? Question 8: You borrow $6,000 at a 10 percent annual rate to be repaid in 3 equal payments at the end of each of the next 3 years. How large is the total interest payment over the three years? Question 9: I invested $600.000 in a cattle ranch and I sold that ranch for $1.800.000 ten years later, What was my annual percentage rate return? Question 10: How much can I borrow for the purchase of my first home if I can afford to make hly payments of $1,000, and the annual interest rate is 4.8 percent on a 30-year mortgage? Time Value of Money Spreadsheet Example ASSIGNMENT # NAME: LAB TIME: Answer Sheet for Time Value of Money Exercise From Previous Page. Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9 Question 10 PROBLEM: Single Amount or Annuity Periodic Interest Rate Number of Periods $3.000 0.006 60 Answer: formula Present Value of Single Amount formula Future Value of Single Amount formula Future Value of An Annuity formula Future Value of An Annuity Due formula Present Value of An Annuity formula Present Value of An Annuity Due