CHAPTER 5



CHAPTER 5DISCOUNTED CASH FLOW VALUATIONAnswers to Concepts Review and Critical Thinking Questions1.Assuming positive cash flows and a positive interest rate, both the present and the future value will rise.2.Assuming positive cash flows and a positive interest rate, the present value will fall, and the future value will rise.3.It’s deceptive, but very common. The deception is particularly irritating given that such lotteries are usually government sponsored!4.The most important consideration is the interest rate the lottery uses to calculate the lump sum option. If you can earn an interest rate that is higher than you are being offered, you can create larger annuity payments. Of course, taxes are also a consideration, as well as how badly you really need $5 million today. 5.If the total amount of money is fixed, you want as much as possible as soon as possible. The team (or, more accurately, the team owner) wants just the opposite.6.The better deal is the one with equal installments.7.Yes, they should. APRs generally don’t provide the relevant rate. The only advantage is that they are easier to compute, but, with modern computing equipment, that advantage is not very important.8.A freshman does. The reason is that the freshman gets to use the money for much longer before interest starts to accrue.9.The subsidy is the present value (on the day the loan is made) of the interest that would have accrued up until the time it actually begins to accrue.10.The problem is that the subsidy makes it easier to repay the loan, not obtain it. However, the ability to repay the loan depends on future employment, not current need. For example, consider a student who is currently needy, but is preparing for a career in a high-paying area (such as corporate finance!). Should this student receive the subsidy? How about a student who is currently not needy, but is preparing for a relatively low-paying job (such as becoming a college professor)?Solutions to Questions and ProblemsNOTE: All end-of-chapter problems were solved using a spreadsheet. Many problems require multiple steps. Due to space and readability constraints, when these intermediate steps are included in this solutions manual, rounding may appear to have occurred. However, the final answer for each problem is found without rounding during any step in the problem.Basic1.To solve this problem, we must find the PV of each cash flow and add them. To find the PV of a lump sum, we use:PV = FV / (1 + r)tPV@10% = $950 / 1.10 + $730 / 1.102 + $1,420 / 1.103 + $1,780 / 1.104 = $3,749.57PV@18% = $950 / 1.18 + $730 / 1.182 + $1,420 / 1.183 + $1,780 / 1.184 = $3,111.72PV@24% = $950 / 1.24 + $730 / 1.242 + $1,420 / 1.243 + $1,780 / 1.244 = $2,738.562.To find the PVA, we use the equation:PVA = C({1 – [1/(1 + r)t]} / r )At a 6 percent interest rate:X@6%: PVA = $4,300{[1 – (1/1.06)9 ] / .06 } = $29,247.28Y@6%: PVA = $6,100{[1 – (1/1.06)5 ] / .06 } = $25,695.42And at a 22 percent interest rate:X@22%: PVA = $4,300{[1 – (1/1.22)9 ] / .22 } = $16,281.03Y@22%:PVA = $6,100{[1 – (1/1.22)5 ] / .22 } = $17,468.20Notice that the PV of Investment X has a greater PV at a 6 percent interest rate, but a lower PV at a 22 percent interest rate. The reason is that X has greater total cash flows. At a lower interest rate, the total cash flow is more important since the cost of waiting (the interest rate) is not as great. At a higher interest rate, Y is more valuable since it has larger annual payments. At a higher interest rate, getting these payments early are more important since the cost of waiting (the interest rate) is so much greater. 3.To solve this problem, we must find the FV of each cash flow and sum. To find the FV of a lump sum, we use:FV = PV(1 + r)tFV@8% = $910(1.08)3 + $1,140(1.08)2 + $1,360(1.08) + $2,100 = $6,044.83FV@11% = $910(1.11)3 + $1,140(1.11)2 + $1,360(1.11) + $2,100 = $6,258.74FV@24% = $910(1.24)3 + $1,140(1.24)2 + $1,360(1.24) + $2,100 = $7,274.29Notice, since we are finding the value at Year 4, the cash flow at Year 4 is simply added to the FV of the other cash flows. In other words, we do not need to compound this cash flow.4.To find the PVA, we use the equation:PVA = C({1 – [1/(1 + r)t]} / r )PVA@15 yrs: PVA = $8,500{[1 – (1/1.09)15 ] / .09} = $68,515.85PVA@40 yrs: PVA = $8,500{[1 – (1/1.09)40 ] / .09} = $91,437.56PVA@75 yrs: PVA = $8,500{[1 – (1/1.09)75 ] / .09} = $94,297.15To find the PV of a perpetuity, we use the equation:PV = C / rPV = $8,500 / .09 PV = $94,444.44Notice that as the length of the annuity payments increases, the present value of the annuity approaches the present value of the perpetuity. The present value of the 75-year annuity and the present value of the perpetuity imply that the value today of all perpetuity payments beyond 75 years is only $147.29.5.Here we have the PVA, the length of the annuity, and the interest rate. We want to calculate the annuity payment. Using the PVA equation:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $25,000 = $C{[1 – (1/1.079)12 ] / .079}We can now solve this equation for the annuity payment. Doing so, we get:C = $25,000 / 7.57528C = $3,300.216.To find the PVA, we use the equation:PVA = C({1 – [1/(1 + r)t]} / r )PVA = $45,000{[1 – (1/1.0825)9 ] / .0825} PVA = $278,210.88The present value of the revenue is greater than the cost, so your company can afford the equipment.7.Here we need to find the FVA. The equation to find the FVA is:FVA = C{[(1 + r)t – 1] / r}FVA for 20 years = $4,000[(1.09520 – 1) / .095] FVA for 20 years = $216,488.93FVA for 40 years = $4,000[(1.09540 – 1) / .095] FVA for 40 years = $1,546,079.97Notice that doubling the number of periods more than doubles the FVA.8.Here we have the FVA, the length of the annuity, and the interest rate. We want to calculate the annuity payment. Using the FVA equation:FVA = C{[(1 + r)t – 1] / r}$25,000 = $C[(1.04758 – 1) / .0475]We can now solve this equation for the annuity payment. Doing so, we get: C = $25,000 / 9.46414C = $2,641.559.Here we have the PVA, the length of the annuity, and the interest rate. We want to calculate the annuity payment. Using the PVA equation:PVA = C({1 – [1/(1 + r)t]} / r )$60,000 = C{[1 – (1/1.09)7 ] / .09}We can now solve this equation for the annuity payment. Doing so, we get:C = $60,000 / 5.03295 C = $11,921.4310.This cash flow is a perpetuity. To find the PV of a perpetuity, we use the equation:PV = C / rPV = $35,000 / .06 PV = $583,333.3311.Here we need to find the interest rate that equates the perpetuity cash flows with the PV of the cash flows. Using the PV of a perpetuity equation:PV = C / r$600,000 = $35,000 / rWe can now solve for the interest rate as follows:r = $35,000 / $600,000 r = .0583 or 5.83%12.For discrete compounding, to find the EAR, we use the equation:EAR = [1 + (APR / m)]m – 1EAR = [1 + (.08 / 4)]4 – 1= .0824 or 8.24%EAR = [1 + (.18 / 12)]12 – 1= .1956 or 19.56%EAR = [1 + (.14 / 365)]365 – 1 = .1502 or 15.02%EAR = [1 + (.10 / 2)]2 – 1 = .1025 or 10.25%13.Here we are given the EAR and need to find the APR. Using the equation for discrete compounding:EAR = [1 + (APR / m)]m – 1We can now solve for the APR. Doing so, we get:APR = m[(1 + EAR)1/m – 1]EAR = .12 = [1 + (APR / 2)]2 – 1APR = 2[(1.12)1/2 – 1]= 11.66%EAR = .08 = [1 + (APR / 12)]12 – 1APR = 12[(1.08)1/12 – 1]= 7.72%EAR = .13 = [1 + (APR / 52)]52 – 1APR = 52[(1.13)1/52 – 1]= 12.24%EAR = .11 = [1 + (APR / 365)]365 – 1APR = 365[(1.11)1/365 – 1]= 10.44%14.For discrete compounding, to find the EAR, we use the equation:EAR = [1 + (APR / m)]m – 1So, for each bank, the EAR is:First National: EAR = [1 + (.101 / 12)]12 – 1 = .1058 or 10.58%First United: EAR = [1 + (.103 / 2)]2 – 1 = .1057 or 10.57%For a borrower, First United would be preferred since the EAR of the loan is lower. Notice that the higher APR does not necessarily mean the higher EAR. The number of compounding periods within a year will also affect the EAR.15.The reported rate is the APR, so we need to convert the EAR to an APR as follows:EAR = [1 + (APR / m)]m – 1APR = m[(1 + EAR)1/m – 1]APR = 365[(1.16)1/365 – 1] = .1485 or 14.85%This is deceptive because the borrower is actually paying annualized interest of 16% per year, not the 14.85% reported on the loan contract.16.For this problem, we simply need to find the FV of a lump sum using the equation:FV = PV(1 + r)tIt is important to note that compounding occurs semiannually. To account for this, we will divide the interest rate by two (the number of compounding periods in a year), and multiply the number of periods by two. Doing so, we get: FV = $1,560[1 + (.09/2)]26 FV = $4,899.4617.For this problem, we simply need to find the FV of a lump sum using the equation:FV = PV(1 + r)tIt is important to note that compounding occurs daily. To account for this, we will divide the interest rate by 365 (the number of days in a year, ignoring leap year), and multiply the number of periods by 365. Doing so, we get: FV in 5 years = $5,000[1 + (.053/365)]5(365) = $6,517.03FV in 10 years = $5,000[1 + (.053/365)]10(365) = $8,494.33FV in 20 years = $5,000[1 + (.053/365)]20(365) = $14,430.7418.For this problem, we simply need to find the PV of a lump sum using the equation:PV = FV / (1 + r)tIt is important to note that compounding occurs on a daily basis. To account for this, we will divide the interest rate by 365 (the number of days in a year, ignoring leap year), and multiply the number of periods by 365. Doing so, we get: PV = $80,000 / [(1 + .06/365)6(365)] PV = $55,815.7619.The APR is simply the interest rate per period times the number of periods in a year. In this case, the interest rate is 15 percent per month, and there are 12 months in a year, so we get:APR = 12(15%) APR = 180% To find the EAR, we use the EAR formula:EAR = [1 + (APR / m)]m – 1EAR = (1 + .15)12 – 1 EAR = 4.3503 or 435.03%Notice that we didn’t need to divide the APR by the number of compounding periods per year. We do this division to get the interest rate per period, but in this problem we are already given the interest rate per period.20.We first need to find the annuity payment. We have the PVA, the length of the annuity, and the interest rate. Using the PVA equation:PVA = C({1 – [1/(1 + r)t]} / r )$73,800 = $C[1 – {1 / [1 + (.062/12)]60} / (.062/12)]Solving for the payment, we get: C = $73,800 / 51.47757C = $1,433.63To find the EAR, we use the EAR equation:EAR = [1 + (APR / m)]m – 1EAR = [1 + (.062 / 12)]12 – 1 EAR = .0638 or 6.38%21.Here we need to find the length of an annuity. We know the interest rate, the PV, and the payments. Using the PVA equation:PVA = C({1 – [1/(1 + r)t]} / r )$14,720 = $500{ [1 – (1/1.009)t ] / .009} Now we solve for t:1/1.009t = 1 – [($14,720)(.009) / ($500)]1.009t = 1 / 0.73504 = 1.36047 t = ln 1.36047 / ln 1.009 t = 34.36 months22.Here we are trying to find the interest rate when we know the PV and FV. Using the FV equation:FV = PV(1 + r)$6 = $4(1 + r) r = $6/$4 – 1 r = .5000 or 50.00% per weekThe interest rate is 50.00% per week. To find the APR, we multiply this rate by the number of weeks in a year, so:APR = (52)50% = 2,600.00%And using the equation to find the EAR, we find:EAR = [1 + (APR / m)]m – 1EAR = [1 + .50]52 – 1 EAR = 14,346,483,744,816 or 143,464,837,448.16%23.Here we need to find the interest rate that equates the perpetuity cash flows with the PV of the cash flows. Using the PV of a perpetuity equation:PV = C / r$325,000 = $3,100 / rWe can now solve for the interest rate as follows:r = $3,100 / $325,000 r = .0095 or 0.95% per monthThe interest rate is 0.95% per month. To find the APR, we multiply this rate by the number of months in a year, so:APR = (12)0.95% APR = 11.45%And using the equation to find the EAR, we find:EAR = [1 + (APR / m)]m – 1EAR = [1 + .0095]12 – 1 EAR = .1207 or 12.07%24.This problem requires us to find the FVA. The equation to find the FVA is:FVA = C{[(1 + r)t – 1] / r}FVA = $400[{[1 + (.105/12) ]360 – 1} / (.105/12)] FVA = $1,006,560.4025.In the previous problem, the compounding period is monthly. This assumption still holds. Since the cash flows are annual, we need to use the EAR to calculate the future value of annual cash flows. It is important to remember that you have to make sure the compounding periods of the interest rate matches with the cash flows. In this case, we have annual cash flows, so we need the EAR since it is the true annual interest rate you will earn. So, finding the EAR:EAR = [1 + (APR / m)]m – 1EAR = [1 + (.105/12)]12 – 1 EAR = .1102 or 11.02%Using the FVA equation, we get:FVA = C{[(1 + r)t – 1] / r}FVA = $4,800[(1.110230 – 1) / .1102] FVA = $959,033.8726.The cash flows are simply an annuity with four payments per year for four years, or 16 payments. We can use the PVA equation:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $2,500{[1 – (1/1.0065)16] / .0065} PVA = $37,873.6027.To solve this problem, we must find the PV of each cash flow and add them. To find the PV of a lump sum, we use:PV = FV / (1 + r)tPV = $1,200 / 1.084 + $1,100 / 1.0842 + $800 / 1.0843 + $600 / 1.0844 PV = $3,105.7428.To solve this problem, we must find the PV of each cash flow and add them. To find the PV of a lump sum, we use:PV = FV / (1 + r)tPV = $1,900 / 1.0929 + $2,300 / 1.09292 + $4,500 / 1.09293 + $5,100 / 1.09294 PV = $10,686.11 Intermediate29.The total interest paid by First Simple Bank is the interest rate per period times the number of periods. In other words, the interest by First Simple Bank paid over 10 years will be:.08(10) = .8First Complex Bank pays compound interest, so the interest paid by this bank will be the FV factor of $1, or:(1 + r)10Setting the two equal, we get:(.08)(10) = (1 + r)10 – 1 r = 1.81/10 – 1 r = .0605 or 6.05%30.We need to use the PVA due equation, which is:PVAdue = (1 + r) PVAUsing this equation:PVAdue = $43,000 = [1 + (.0625/12)] × C[{1 – 1 / [1 + (.0625/12)]60} / (.0625/12)$42,777.20 = $C{1 – [1 / (1 + .0625/12)60]} / (.0625/12)C = $831.98Notice, to find the payment for the PVA due, we find the PV of an ordinary annuity, then compound this amount forward one period. 31. Here we need to find the FV of a lump sum, with a changing interest rate. We must do this problem in two parts. After the first six months, the balance will be: FV = $10,000[1 + (.021/12)]6 FV = $10,105.46 This is the balance in six months. The FV in another six months will be: FV = $10,105.46[1 + (.17/12)]6 FV = $10,995.43The problem asks for the interest accrued, so, to find the interest, we subtract the beginning balancefrom the principal. The interest accrued is:Interest = $10,995.43 – 10,000.00 Interest = $995.4332.We will calculate the time we must wait if we deposit in the bank that pays simple interest. The interest amount we will receive each year in this bank will be:Interest = $92,000(.06) Interest = $5,520 per yearThe deposit will have to increase by the difference between the amount we need by the amount we originally deposit with divided by the interest earned per year, so the number of years it will take in the bank that pays simple interest is:Years to wait = ($175,000 – 92,000) / $5,520 Years to wait = 15.04 yearsTo find the number of years it will take in the bank that pays compound interest, we can use the future value equation for a lump sum and solve for the periods. Doing so, we find:FV = PV(1 + r)t $175,000 = $92,000 [1 + (.06/12)]t t = 128.92 months or 10.74 years33.Here we need to find the future value of a lump sum. We need to make sure to use the correct number of periods. So, the future value after one year will be:FV = PV(1 + r)tFV = $1(1.0127)12 FV = $1.16And the future value after two years will be:FV = PV(1 + r)tFV = $1(1.0127)24 FV = $1.3534.Here we are given the PVA, number of periods, and the amount of the annuity. We need to solve for the interest rate. Even though the currency is pounds and not dollars, we can still use the same time value equations. Using the PVA equation:PVA = C({1 – [1/(1 + r)t]} / r )?440 = ?60[{1 – [1 / (1 + r)]31}/ r]To find the interest rate, we need to solve this equation on a financial calculator, using a spreadsheet, or by trial and error. If you use trial and error, remember that increasing the interest rate decreases the PVA, and decreasing the interest rate increases the PVA. Using a spreadsheet, we find:r = 13.36%Not bad for an English Literature major!35.Here we need to compare two cash flows. The only way to compare cash flows is to find the value of the cash flows at a common time, so we will find the present value of each cash flow stream. Since the cash flows are monthly, we need to use the monthly interest rate, which is:Monthly rate = .07 / 12Monthly rate = .0058 or .58%The value today of the $6,800 monthly salary is:PVA = C({1 – [1/(1 + r)t]} / r )PVA = $6,800{[1 – (1 / 1.0058)24 ] / .0058} PVA = $151,878.68To find the value of the second option, we find the present value of the monthly payments and add the bonus. We can add the bonus since it is paid today. So:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $5,500{[1 – (1/1.0058)24] / .0058} PVA = $122,843.05So, the total value of the second option is:Value of second option = $122,843.05 + 30,000Value of second option = $152,843.05The difference in the value of the two options today is:Difference in value today = $152,843.05 – 151,878.68Difference in value today = $964.37What if we found the future value of the two cash flows? For the annual salary, the future value will be:FVA = C{[(1 + r)t – 1] / r}FVA = $6,800{[(1 + .0058)24 – 1] / .0058}FVA = $174,631.01To find the future value of the second option we also need to find the future value of the bonus as well. So, the future value of this option is:FV = C{[(1 + r)t – 1] / r} + PV(1 + r)tFV = $5,500{[(1 + .0058)24 – 1] / .0058} + $30,000(1 + .0058)24FV = $175,739.85So, the first option is still the better choice. The difference between the future value of the two options is:Difference in future value = $175,739.85 – 174,631.01Difference in future value = $1,108.84No matter when you compare two cash flows, the cash flow with the greatest value on one period will always have the greatest value in any other period. Here’s a question for you: What is the future value of $964.37 (the difference in the cash flows at time zero) in 24 months at an interest rate of .58 percent per month? With no calculations, you know the future value must be $1,108.84, the difference in the cash flows at the same time!36.The cash flows are an annuity, so we can use the present value of an annuity equation. Doing so, we find:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $12,000[1 – (1/1.09)20 / .09] PVA = $109,542.5537.The investment we should choose is the investment with the higher rate of return. We will use the future value equation to find the interest rate for each option. Doing so, we find the return for Investment G is:FV = PV(1 + r)t$150,000 = $85,000(1 + r)6 r = ($150,000/$85,000)1/6 – 1 r = .0993 or 9.93%And, the return for Investment H is:FV = PV(1 + r)t$270,000 = $85,000(1 + r)13 r = ($270,000/$85,000)1/13 – 1 r = .0930 or 9.30%So, we should choose Investment G.38.The present value of an annuity falls as r increases, and the present value of an annuity rises as r decreases. The future value of an annuity rises as r increases, and the future value of an annuity falls as r decreases.Here we need to calculate the present value of an annuity for different interest rates. Using the present value of an annuity equation and an interest rate of 10 percent, we get:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $15,000{[1 – (1/1.10)10] / .10} PVA = $92,168.51At an interest rate of 5 percent, the present value of the annuity is:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $15,000{[1 – (1/1.05)10] / .05} PVA = $115,826.02And, at an interest rate of 15 percent, the present value of the annuity is:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $15,000{[1 – (1/1.15)10] / .15} PVA = $72,281.5339.Here we are given the future value of an annuity, the interest rate, and the number of payments. We need to find the number of periods of the annuity payments. So, we can solve the future value of an annuity equation for the number of periods as follows:FVA = C{[(1 + r)t – 1] / r}$50,000 = $175[{[1 + (.10/12)]t – 1 } / (.10/12) ]175 = {[1 + (.10/12)]t – 1 } / (.10/12) 1.458 = (1 + .0083)t – 1 2.458 = (1.0083)t ln 2.458 = t ln 1.0083 t = ln 2.458 / ln 1.0083 t = 146.79 payments40.Here we are given the PVA, number of periods, and the amount of the annuity. We need to solve for the interest rate. Using the PVA equation:PVA = ({1 – [1/(1 + r)t]} / r ))$58,000 = $1,200[{1 – [1 / (1 + r)]60}/ r]To find the interest rate, we need to solve this equation on a financial calculator, using a spreadsheet, or by trial and error. If you use trial and error, remember that increasing the interest rate decreases the PVA, and decreasing the interest rate increases the PVA. Using a spreadsheet, we find:r = .00738 or .738%This is the monthly interest rate. To find the APR with a monthly interest rate, we simply multiply the monthly rate by 12, so the APR is:APR = .00738 × 12APR = .0886 or 8.86% 41.To solve this problem, we must find the PV of each cash flow and add them. To find the PV of a lump sum, we use:PV = FV / (1 + r)tPV = $2,000,000 + $27,000,000/1.11 + $33,000,000/1.112 + $33,000,000/1.113 + $32,000,000/1.114 + $30,000,000/1.115 + $32,000,000/1.116 + $25,000,000/1.117 + $21,000,000/1.118 + $20,000,000/1.119 + $20,000,000/1.1110PV = $169,244,719.6742.To solve this problem, we must find the PV of each cash flow and add them. To find the PV of a lump sum, we use:PV = FV / (1 + r)tPV = $16,000,000 + $6,500,000/1.11 + $7,000,000/1.112 + $8,500,000/1.113 + $9,000,000/1.114 + $9,000,000/1.115 + $11,500,000/1.116 PV = $51,170,349.9643.Here we are given the PVA, number of periods, and the amount of the annuity. We need to solve for the interest rate. First, we need to find the amount borrowed since it is only 80 percent of the building value. So, the amount borrowed is:Amount borrowed = .80($3,200,000)Amount borrowed = $2,560,000Now we can use the PVA equation:PVA = C({1 – [1/(1 + r)t]} / r ))$2,560,000 = $15,300[{1 – [1 / (1 + r)]360}/ r]To find the interest rate, we need to solve this equation on a financial calculator, using a spreadsheet, or by trial and error. If you use trial and error, remember that increasing the interest rate decreases the PVA, and decreasing the interest rate increases the PVA. Using a spreadsheet, we find:r = .00498 or .498%This is the monthly interest rate. To find the APR with a monthly interest rate, we simply multiply the monthly rate by 12, so the APR is:APR = .00498 × 12APR = .0597 or 5.97%And the EAR is:EAR = [1 + (APR / m)]m – 1EAR = [1 + .00498]12 – 1 EAR = .0614 or 6.14%44.Here, we have two cash flow streams that will be combined in the future. To find the withdrawal amount, we need to know the present value, as well as the interest rate and periods, which are given. The present value of the retirement account is the future value of the stock and bond account. We need to find the future value of each account and add the future values together. For the bond account the future value is the value of the current savings plus the value of the annual deposits. So, the future value of the bond account will be:FV = C{[(1 + r)t – 1] / r} + PV(1 + r)tFV = $8,000{[(1 + .07)10 – 1] / .07} + $160,000(1 + .07)10FV = $425,275.80The total value of the stock account at retirement will be the future value of a lump sum, so:FV = PV(1 + r)t FV = $600,000(1 + .105)10FV = $1,628,448.51The total value of the account at retirement will be:Total value at retirement = $425,275.80 + 1,628,448.51Total value at retirement = $2,053,724.31This amount is the present value of the annual withdrawals. Now we can use the present value of an annuity equation to find the annuity amount. Doing so, we find the annual withdrawal will be:PVA = C({1 – [1/(1 + r)t]} / r ))$2,053,724.31 = C[{1 – [1 / (1 + .0625)]25}/ .0625]C = $164,492.2745.Here we are given the PVA for an annuity due, number of periods, and the amount of the annuity. We need to solve for the interest rate. Using the PVA equation:PVA = [{1 – [1 / (1 + r)]60}/ r](1 + r)$34,000 = $645[{1 – [1 / (1 + r)]60}/ r](1 + r)To find the interest rate, we need to solve this equation on a financial calculator, using a spreadsheet, or by trial and error. If you use trial and error, remember that increasing the interest rate decreases the PVA, and decreasing the interest rate increases the PVA. Using a spreadsheet, we find:r = .0045 or .45%This is the monthly interest rate. To find the APR with a monthly interest rate, we simply multiply the monthly rate by 12, so the APR is:APR = .0045 × 12APR = .0540 or 5.40%46.a. If the payments are in the form of an ordinary annuity, the present value will be:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $12,000[{1 – [1 / (1 + .09)]5}/ .09]PVA = $46,675.82If the payments are an annuity due, the present value will be:PVAdue = (1 + r) PVAPVAdue = (1 + .09)$46,675.82PVAdue = $50,876.64b.We can find the future value of the ordinary annuity as:FVA = C{[(1 + r)t – 1] / r}FVA = $12,000{[(1 + .09)5 – 1] / .09}FVA = $71,816.53If the payments are an annuity due, the future value will be:FVAdue = (1 + r) FVAFVAdue = (1 + .09)$71,816.53FVAdue = $78,280.01c.Assuming a positive interest rate, the present value of an annuity due will always be larger than the present value of an ordinary annuity. Each cash flow in an annuity due is received one period earlier, which means there is one period less to discount each cash flow. Assuming a positive interest rate, the future value of an annuity due will always higher than the future value of an ordinary annuity. Since each cash flow is made one period sooner, each cash flow receives one extra period of compounding.47.Here, we need to find the difference between the present value of an annuity and the present value of a perpetuity. The present value of the annuity is:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $8,500{[1 – (1/1.08)30] / .08} PVA = $95,691.16And the present value of the perpetuity is:PVP = C / rPVP = $8,500 / .08PVP = $106,250So, the difference in the present values is:Difference = $106,250 – 95,691.16Difference = $10,558.84There is another common way to answer this question. We need to recognize that the difference in the cash flows is a perpetuity of $8,500 beginning 31 years from now. We can find the present value of this perpetuity and the solution will be the difference in the cash flows. So, we can find the present value of this perpetuity as:PVP = C / rPVP = $8,500 / .08PVP = $106,250This is the present value 30 years from now, one period before the first cash flows. We can now find the present value of this lump sum as:PV = FV / (1 + r)tPV = $106,250 / (1 + .08)30PV = $10,558.84This is the same answer we calculated before.48.Here we need to find the present value of an annuity at several different times. The annuity has semiannual payments, so we need the semiannual interest rate. The semiannual interest rate is:Semiannual rate = 0.09/2 Semiannual rate = .045Now, we can use the present value of an annuity equation. Doing so, we get:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $7,800{[1 – (1 / 1.045)10] / .045} PVA = $61,719.20This is the present value one period before the first payment. The first payment occurs nine and one-half years from now, so this is the value of the annuity nine years from now. Since the interest rate is semiannual, we must also be careful to use the number of semiannual periods. The value of the annuity five years from now is:PV = FV / (1 + r)tPV = $61,719.20 / (1 + .045)8PV = $43,400.02And the value of the annuity three years from now is:PV = FV / (1 + r)tPV = $61,719.20 / (1 + .045)12PV = $36,393.58And the value of the annuity today is:PV = FV / (1 + r)tPV = $61,719.20 / (1 + .045)18PV = $27,946.4849.Since the first payment is received six years form today and the last payment is received 20 years from now, there are 15 payments. We can use the present value of an annuity formula, which will give us the present value four years from now, one period before the first payment. So, the present value of the annuity in four years is:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $1,625{[1 – (1/1.07)15] / .07} PVA = $14,800.36And using the present value equation for a lump sum, the present value of the annuity today is:PV = FV / (1 + r)tPV = $14,800.36 / (1 + .07)5PV = $10,552.4550.Here, we have an annuity with two different interest rates. To answer this question, we simply need to find the present value in multiple steps. The present value of the last six years payments at a 7 percent interest rate is:PVA = C({1 – [1/(1 + r)t]} / r ))PVA = $2,500[{1 – 1 / [1 + (.07/12)]72} / (.07/12)] PVA = $146,636.11We can now discount this value back to time zero. We must be sure to use the number of months as the periods since interest is compounded monthly. We also need to use the interest rate that applies during the first four years. Doing so, we find:PV = FV / (1 + r)tPV = $146,636.11 / (1 + .09/12)48PV = $102,442.06Now we can find the present value of the annuity payments for the first four years. The present value of these payments is:PVA = C({1 – [1/(1 + r)t]} / r )PVA = $2,500[{1 – 1 / [1 + (.09/12)]48} / (.09/12)] PVA = $100,461.95So, the total present value of the cash flows is:PV = $102,442.06 + 100,461.95PV = $202,904.0151.To answer this question we need to find the future value of the annuity, and then find the present value that makes the lump sum investment equivalent. We also need to make sure to use the number of months as the number of periods. So, the future value of the annuity is:FVA = C{[(1 + r)t – 1] / r}FVA = $1,680{[(1 + .08/12)120 – 1] / (.08/12)}FVA = $307,349.34Now we can find the present value that would permit the lump sum investment to be equal to this future value. This investment has annual compounding, so the number of periods is the number of years. So, the present value we would need to deposit is:PV = FV / (1 + r)tPV = $307,349.34 / (1 + .10)10PV = $118,496.4852.Here we need to find the present value of a perpetuity at a date before the perpetuity begins. We will begin by find the present value of the perpetuity. Doing so, we find:PVP = C / rPVP = $3,100 / .0635PVP = $48,818.90This is the present value of the perpetuity at year 19, one period before the payments begin. So, using the present value of a lump sum equation to find the value at year 7, we find:PV = FV / (1 + r)tPV = $48,818.90 / (1 + .0635)12PV = $23,320.5153.Here we are given the PVA, number of periods, and the amount of the annuity. We need to solve for the interest rate. We need must be careful to use the cash flows of the loan. Using the present value of an annuity equation, we find:PVA = C({1 – [1/(1 + r)t]} / r )$23,400 = $1,950[{1 – [1 / (1 + r)]12}/ r]To find the interest rate, we need to solve this equation on a financial calculator, using a spreadsheet, or by trial and error. If you use trial and error, remember that increasing the interest rate lowers the PVA, and increasing the interest rate decreases the PVA. Using a spreadsheet, we find:r = .02502 or 2.502%This is the monthly interest rate. To find the APR with a monthly interest rate, we simply multiply the monthly rate by 12, so the APR is:APR = .02502 × 12APR = .3003 or 30.03%And the EAR is:EAR = [1 + (APR / m)]m – 1EAR = [1 + .02520]12 – 1 EAR = .3452 or 34.52%54.To solve this problem, we must find the FV of each cash flow and add them. To find the FV of a lump sum, we use:FV = PV(1 + r)tFV = $21,000(1.078)3 + $39,000(1.078)2 + $57,000 FV = $128,628.53Notice, since we are finding the value at Year 5, the cash flow at Year 5 is simply added to the FV of the other cash flows. In other words, we do not need to compound this cash flow. To find the value in Year 10, we simply need to find the future value of this lump sum. Doing so, we find:FV = PV(1 + r)tFV = $128,628.53(1.078)5 FV = $187,254.0155.The payment for a loan repaid with equal payments is the annuity payment with the loan value as the PV of the annuity. So, the loan payment will be:PVA = C({1 – [1/(1 + r)t]} / r )$60,000 = C{[1 – 1 / (1 + .09)3] / .09}C = $23,703.29The interest payment is the beginning balance times the interest rate for the period, and the principal payment is the total payment minus the interest payment. The ending balance is the beginning balance minus the principal payment. The ending balance for a period is the beginning balance for the next period. The amortization table for an equal payment is:YearBeginning BalanceTotalPaymentInterestPaymentPrincipalPaymentEnding Balance1$60,000.00$23,703.29$5,400.00$18,303.29$41,696.71241,696.7123,703.293,752.7019,950.5821,746.13321,746.1323,703.291,957.1521,746.130In the third year, $1,957.15 of interest is paid. Total interest over life of the loan = $5,400.00 + 3,752.70 + 1,957.15 Total interest over life of the loan = $11,109.8656.This amortization table calls for equal principal payments of $20,000 per year. The interest payment is the beginning balance times the interest rate for the period, and the total payment is the principal payment plus the interest payment. The ending balance for a period is the beginning balance for the next period. The amortization table for an equal principal reduction is:YearBeginning BalanceTotalPaymentInterestPaymentPrincipalPaymentEnding Balance1$60,000.00$25,400.00$5,400.00$20,000.00$40,000.00240,000.0023,600.003,600.0020,000.0020,000.00320,000.0021,800.001,800.0020,000.000In the third year, $1,800 of interest is paid. Total interest over life of the loan = $5,400 + 3,600 + 1,800 Total interest over life of the loan = $10,800Notice that the total payments for the equal principal reduction loan are lower. This is because more principal is repaid early in the loan, which reduces the total interest expense over the life of the loan.Challenge57.To find the APR and EAR, we need to use the actual cash flows of the loan. In other words, the interest rate quoted in the problem is only relevant to determine the total interest under the terms given. The cash flows of the loan are the $15,000 you must repay in one year, and the $12,600 you borrow today. The interest rate of the loan is:$15,000 = $12,600(1 + r)r = ($15,000 / 12,600) – 1 r = .1905 or 19.05%Because of the discount, you only get the use of $12,600 and the interest you pay on that amount is 19.05%, not 16%.58.Here we have cash flows that would have occurred in the past and cash flows that would occur in the future. We need to bring both cash flows to today. Before we calculate the value of the cash flows today, we must adjust the interest rate so we have the effective monthly interest rate. Finding the APR with monthly compounding and dividing by 12 will give us the effective monthly rate. The APR with monthly compounding is:APR = 12[(1.09)1/12 – 1] = 8.65%To find the value today of the back pay from two years ago, we will find the FV of the annuity, and then find the FV of the lump sum. Doing so gives us:FVA = ($47,000/12) [{[1 + (.0865/12)]12 – 1} / (.0865/12)] FVA = $48,908.59FV = PV(1 + r)tFV = $48,908.59(1.09) FV = $53,310.36Notice we found the FV of the annuity with the effective monthly rate, and then found the FV of the lump sum with the EAR. Alternatively, we could have found the FV of the lump sum with the effective monthly rate as long as we used 12 periods. The answer would be the same either way.Now, we need to find the value today of last year’s back pay: FVA = ($50,000/12) [{[1 + (.0865/12)]12 – 1} / (.0865/12)] FVA = $52,030.41Next, we find the value today of the five year’s future salary:PVA = ($54,000/12){[{1 – {1 / [1 + (.0865/12)]12(5)}] / (.0865/12)}PVA = $218,570.57The value today of the jury award is the sum of salaries, plus the compensation for pain and suffering, and court costs. The award should be for the amount of:Award = $53,310.36 + 52,030.41 + 218,570.57 + 150,000 + 20,000 Award = $493,911.34As the plaintiff, you would prefer a lower interest rate. In this problem, we are calculating both the PV and FV of annuities. A lower interest rate will decrease the FVA, but increase the PVA. So, by a lower interest rate, we are lowering the value of the back pay. But, we are also increasing the PV of the future salary. Since the future salary is larger and has a longer time, this is the more important cash flow to the plaintiff.59.Again, to find the interest rate of a loan, we need to look at the cash flows of the loan. Since this loan is in the form of a lump sum, the amount you will repay is the FV of the principal amount, which will be: Loan repayment amount = $10,000(1.10) = $11,000The amount you will receive today is the principal amount of the loan times one minus the points. Amount received = $10,000(1 – .02) = $9,800Now, we simply find the interest rate for this PV and FV.$11,000 = $9,800(1 + r) r = ($11,000 / $9,800) – 1 = .1224 or 12.24%60.We need to find the FV of the premiums to compare with the cash payment promised at age 65. We have to find the value of the premiums at year 6 first since the interest rate changes at that time. So: FV1 = $750(1.11)5 = $1,263.79FV2 = $750(1.11)4 = $1,138.55FV3 = $850(1.11)3 = $1,162.49FV4 = $850(1.11)2 = $1,047.29FV5 = $950(1.11)1 = $1,054.50Value at year six = $1,263.79 + 1,138.55 + 1,162.49 + 1,047.29 + 1,054.50 + 950 = $6,616.62Finding the FV of this lump sum at the child’s 65th birthday:FV = $6,616.62(1.07)59 = $358,326.50The policy is not worth buying; the future value of the deposits is $358,326.50, but the policy contract will pay off $350,000. The premiums are worth $8,326.50 more than the policy payoff.Note, we could also compare the PV of the two cash flows. The PV of the premiums is:PV = $750/1.11 + $750/1.112 + $850/1.113 + $850/1.114 + $950/1.115 + $950/1.116 PV = $3,537.51And the value today of the $350,000 at age 65 is:PV = $350,000/1.0759 = $6,462.87PV = $6,462.87/1.116 = $3,455.31The premiums still have the higher cash flow. At time zero, the difference is $82.20. Whenever you are comparing two or more cash flow streams, the cash flow with the highest value at one time will have the highest value at any other time.Here is a question for you: Suppose you invest $82.20, the difference in the cash flows at time zero, for six years at an 11 percent interest rate, and then for 59 years at a seven percent interest rate. How much will it be worth? Without doing calculations, you know it will be worth $8,326.50, the difference in the cash flows at time 65! Calculator Solutions1.CFo$0CFo$0CFo$0C01$950C01$950C01$950F011F011F011C02$730C02$730C02$730F021F021F021C03$1,420C03$1,420C03$1,420F031F031F031C04$1,780C04$1,780C04$1,780F041F041F041I = 10I = 18I = 24NPV CPTNPV CPTNPV CPT$3,749.57$3,111.72$2,738.562.Enter96%$4,300NI/YPVPMTFVSolve for$29,247.28Enter56%$6,100NI/YPVPMTFVSolve for$25,695.42Enter922%$4,300NI/YPVPMTFVSolve for$16,281.03Enter522%$6,100NI/YPVPMTFVSolve for$17,468.203.CFo$0CFo$0CFo$0C01$910C01$910C01$910F011F011F011C02$1,140C02$1,140C02$1,140F021F021F021C03$1,360C03$1,360C03$1,360F031F031F031C04$2,100C04$2,100C04$2,100F041F041F041I = 8I = 11I = 24NFV CPTNFV CPTNFV CPT$6,044.83$6,258.74$7,274.294.Enter159%$8,500NI/YPVPMTFVSolve for$68,515.85Enter409%$8,500NI/YPVPMTFVSolve for$91,437.56Enter759%$8,500NI/YPVPMTFVSolve for$94,297.155.Enter127.9%$25,000NI/YPVPMTFVSolve for$3,300.216.Enter98.25%$45,000NI/YPVPMTFVSolve for$278,210.887.Enter209.5%$4,000NI/YPVPMTFVSolve for$216,488.93Enter409.5%$4,000NI/YPVPMTFVSolve for$1,546,079.978.Enter84.75%$25,000NI/YPVPMTFVSolve for$2,641.559.Enter79%$60,000NI/YPVPMTFVSolve for$11,921.4312.Enter8%4NOMEFFC/YSolve for8.24%Enter18%12NOMEFFC/YSolve for19.56%Enter14%365NOMEFFC/YSolve for15.02%Enter10%2NOMEFFC/YSolve for10.25%13.Enter12%2NOMEFFC/YSolve for11.66%Enter8%12NOMEFFC/YSolve for7.72%Enter13%52NOMEFFC/YSolve for12.24%Enter11%365NOMEFFC/YSolve for10.44%14.Enter10.1%12NOMEFFC/YSolve for10.58%Enter10.3%2NOMEFFC/YSolve for10.57%15.Enter16%365NOMEFFC/YSolve for14.85%16.Enter13 × 2 9% / 2 $1,560NI/YPVPMTFVSolve for$4,899.4617.Enter5 365 5.3% / 365 $5,000NI/YPVPMTFVSolve for$6,517.03Enter10 365 5.3% / 365 $5,000NI/YPVPMTFVSolve for$8,494.33Enter20 365 5.3% / 365 $5,000NI/YPVPMTFVSolve for$14,430.7418.Enter6 365 6% / 365 $80,000NI/YPVPMTFVSolve for$55,815.7619.APR = 12(15%) = 180%Enter180%12NOMEFFC/YSolve for435.03%20.Enter606.2% / 12 $73,800NI/YPVPMTFVSolve for$1,433.63Enter6.2%12NOMEFFC/YSolve for6.38%21.Enter0.9%$14,720$500NI/YPVPMTFVSolve for34.3622.Enter1±$4$6NI/YPVPMTFVSolve for50%APR = 52(50.00%) = 2,600%Enter2,600%52NOMEFFC/YSolve for143,464,837,448%24.Enter30 12 10.5% / 12 $400NI/YPVPMTFVSolve for$1,006,560.4025.Enter10.5%12NOMEFFC/YSolve for11.02%Enter3011.02%$4,800NI/YPVPMTFVSolve for$959,033.8726.Enter4 4 .65%$2,500NI/YPVPMTFVSolve for$37,873.6027.CFo$0C01$1,200F011C02$1,100F021C03$800F031C04$600F041I = 8.40NPV CPT$3,105.7428.CFo$0C01$1,900F011C02$2,300F021C03$4,500F031C04$5,100F041I = 9.29NPV CPT$10,686.1129. First Simple: $100(.08) = $8; 10 year investment = $100 + 10($8) = $180Enter10±$100$180NI/YPVPMTFVSolve for6.05%30.2nd BGN 2nd SETEnter606.25% / 12 $43,000NI/YPVPMTFVSolve for$831.9831.Enter62.10% / 12 $10,000NI/YPVPMTFVSolve for$10,105.46Enter617% / 12 $10,105.46NI/YPVPMTFVSolve for$10,995.43Interest = $10,995.43 – 10,000 Interest = $995.4332.First: $92,000 (.06) = $5,520 per year($175,000 – 92,000) / $5,520 = 15.04 years Second:Enter6% / 12 $92,000$175,000NI/YPVPMTFVSolve for128.92128.92 / 12 = 10.74 years33.Enter121.27%$1NI/YPVPMTFVSolve for$1.16Enter241.27%$1NI/YPVPMTFVSolve for$1.3534.Enter31±?440?60NI/YPVPMTFVSolve for13.36%35.Enter247% /12 $6,800NI/YPVPMTFVSolve for$151,878.68Enter247% / 12 $5,500NI/YPVPMTFVSolve for$122,843.05$122,843.05 + 30,000 = $152,843.0536.Enter209%$12,000NI/YPVPMTFVSolve for$109,542.5537.Enter6±$85,000$150,000NI/YPVPMTFVSolve for9.93%Enter13±$85,000$270,000NI/YPVPMTFVSolve for9.30%38.Enter1010%$15,000NI/YPVPMTFVSolve for$92,168.51Enter105%$15,000NI/YPVPMTFVSolve for$115,826.02Enter1015%$15,000NI/YPVPMTFVSolve for$75,281.5339.Enter10% / 12±$175$50,000NI/YPVPMTFVSolve for146.7940.Enter60±$58,000$1,200NI/YPVPMTFVSolve for.738%APR = .738%(12) = 8.86% 41.42.CFo$2,000,000CFo$16,000,000C01$27,000,000C01$6,500,000F011F011C02$33,000,000C02$7,000,000F022F021C03$32,000,000C03$8,500,000F031F031C04$30,000,000C04$9,000,000F041F042C05$32,000,000C05$11,500,000F051F051C06$25,000,000C06F061F06C07$21,000,000C07F071F07C08$20,000,000C08F082F08I = 11%I = 11%NPV CPTNPV CPT$169,244,719.67$51,170,349.9643.Enter30 12.80($3,200,000)±$15,300NI/YPVPMTFVSolve for.498%APR = 0.498%(12) = 5.97%Enter5.97%12NOMEFFC/YSolve for6.14%44.Future value of bond account:Enter107%$160,000$8,000NI/YPVPMTFVSolve for$425,275.80Future value of stock account:Enter1010.5%$600,000NI/YPVPMTFVSolve for$1,628,448.51Future value of retirement account:FV = $425,275.80 + 1,628,448.51FV = $2,053,724.31Annual withdrawal amount:Enter256.25%$2,053,724.31NI/YPVPMTFVSolve for$164,492.2745.2nd BGN 2nd SETEnter60$34,000$645NI/YPVPMTFVSolve for0.45%APR = 0.45%(12) = 5.40%46.a.Enter59%$12,000NI/YPVPMTFVSolve for$46,675.822nd BGN 2nd SETEnter59%$12,000NI/YPVPMTFVSolve for$50,876.64b.Enter59%$12,000NI/YPVPMTFVSolve for$71,816.532nd BGN 2nd SETEnter59%$12,000NI/YPVPMTFVSolve for$78,280.0147.Present value of annuity:Enter308%$8,500NI/YPVPMTFVSolve for$95,691.16And the present value of the perpetuity is:PVP = C / rPVP = $8,500 / .08PVP = $106,250.00So the difference in the present values is:Difference = $106,250 – 95,691.16Difference = $10,558.8448.Value at t = 9Enter109% / 2 $7,800NI/YPVPMTFVSolve for$61,719.20Value at t = 5Enter4 2 9% / 2 $61,719.20NI/YPVPMTFVSolve for$43,400.02Value at t = 3Enter6 2 9% / 2 $61,719.20NI/YPVPMTFVSolve for$36,393.58Value todayEnter9 2 9% / 2 $61,719.20NI/YPVPMTFVSolve for$27,946.4849. Value at t = 5Enter157%$1,625NI/YPVPMTFVSolve for$14,800.36Value todayEnter57%$14,800.36NI/YPVPMTFVSolve for$10,552.4550. Value at t = 4Enter6 12 7% / 12 $2,500NI/YPVPMTFVSolve for$146,636.11Value todayEnter4 12 9% / 12 $2,500$146,636.11NI/YPVPMTFVSolve for$202,904.0151.FV of AEnter10 12 8% / 12 $1,680NI/YPVPMTFVSolve for$307,349.34Value to invest in BEnter1010%$307,349.34NI/YPVPMTFVSolve for$118,496.4853.Enter12±$20,000$1,950NI/YPVPMTFVSolve for2.502%APR = 2.502%(12) = 30.03%Enter30.03%12NOMEFFC/YSolve for34.52%54.CFo$0C01$0F011C02$21,000F021C03$39,000F031C04$0F041C05$57,000F051I = 7.8%NPV NFV$128,628.53Enter57.8%±$128,628.53NI/YPVPMTFVSolve for$187,254.0157.Enter1±$12,600$15,000NI/YPVPMTFVSolve for19.05%58.Enter9%12NOMEFFC/YSolve for8.65%Enter128.65% / 12 $47,000 / 12 NI/YPVPMTFVSolve for–$48,908.59Enter19%$48,908.59NI/YPVPMTFVSolve for$53,310.36Enter128.65% / 12 $50,000 / 12 NI/YPVPMTFVSolve for–$52,030.41Enter608.65% / 12 $54,000 / 12NI/YPVPMTFVSolve for$218,570.57Award = $53,310.36 + 52,030.41 + 218,570.57 + 150,000 + 20,000 = $493,911.3459.Enter1$9,800$11,000NI/YPVPMTFVSolve for12.24%60.Value at Year 6:Enter511%$750NI/YPVPMTFVSolve for$1,263.79Enter411%$750NI/YPVPMTFVSolve for$1,138.55Enter311%$850NI/YPVPMTFVSolve for$1,162.49Enter211%$850NI/YPVPMTFVSolve for$1,047.29Enter111%$950NI/YPVPMTFVSolve for$1,054.50So, at Year 5, the value is: $1,263.79 + 1,138.55 + 1,162.49 + 1,047.29 + 1,054.50 + 950 = $6,616.62At Year 65, the value is:Enter597%$6,616.62NI/YPVPMTFVSolve for$358,326.50The policy is not worth buying; the future value of the deposits is $358,326.50 but the policy contract will pay off $350,000. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download