amortization chart loan calculator

Reviews
Shared by: harvey1
Stats
views:
350
rating:
not rated
reviews:
0
posted:
1/4/2009
language:
English
pages:
0
Time Value of Money • • • • Ref. Ch 5 Future Value and Compounding Present Value and Discounting More on Present and Future Values 1/4/2009 1 Time Value of Money • To compare cash flows (in- or out-) occuring at different points in time we need to adjust them with an adequate time value of money. • This adjustment is called either “discounting” to present or “compounding” to future. 1/4/2009 2 Basic Definitions • Present Value – earlier money on a time line • Future Value – later money on a time line • Interest rate – “exchange rate” between earlier money and later money. Also called: – Discount rate – Cost of capital – Opportunity cost of capital – Required return 1/4/2009 3 Time lines show timing of cash flows. 0 r% 1 2 3 CF0 CF1 CF2 CF3 Tick marks at ends of periods, so Time 0 is today; Time 1 is the end of Period 1; or the beginning of Period 2. 1/4/2009 4 What’s the FV of an initial $100 after 2 years if i = 10%? 0 10% 1 2 FV = ? 100 Finding FVs (moving to the right on a time line) is called compounding. 1/4/2009 5 After 1 year: FV1 = PV + INT1 = PV + PV (r) = PV(1 + r) = $100(1.10) = $110.00. After 2 years: FV2 = FV1(1+r) = PV(1 + r)(1+r) = PV(1+r)2 = $100(1.10)2 = $121.00. 1/4/2009 6 Future Values: General Formula • FV = PV(1 + r)t – FV = future value – PV = present value – r = period interest rate, expressed as a decimal – T = number of periods • Future value interest factor = (1 + r)t 7 Effects of Compounding • Simple interest • Compound interest • Consider the previous example – FV with simple interest = 100 + 10 + 10 = 120 – FV with compound interest = 121 – The extra1 comes from the interest of .1(10) = 1 earned on the first interest payment 8 Future Values – Example 2 • Suppose you invest the $1,000 from the previous example for 5 years. How much would you have? – FV = 1,000(1.05)5 = 1,276.28 • The effect of compounding is small for a small number of periods, but increases as the number of periods increases. (Simple interest would have a future value of $1,250, for a difference of $26.28.) 9 Future Values – Example 3 • Suppose you had a relative deposit $10 at 5.5% interest 200 years ago. How much would the investment be worth today? – FV = 10(1.055)200 = 447,189.84 • What is the effect of compounding? – Simple interest = 10 + 200(10)(.055) = 120.00 – Compounding added $447,069.84 to the value of the investment 10 Future Value as a General Growth Formula • Suppose your company expects to increase unit sales of widgets by 15% per year for the next 5 years. If you currently sell 3 million widgets in one year, how many widgets do you expect to sell in 5 years? – FV = 3,000,000(1.15)5 = 6,034,072 11 Present Values • How much do I have to invest today to have some amount in the future? – FV = PV(1 + r)t – Rearrange to solve for PV = FV / (1 + r)t • When we talk about discounting, we mean finding the present value of some future amount. • When we talk about the “value” of something, we are talking about the present value unless we specifically indicate that we want the future value. 12 Present Value – One Period Example • Suppose you need $10,000 in one year for the down payment on a new car. If you can earn 7% annually, how much do you need to invest today? • PV = 10,000 / (1.07)1 = 9,345.79 • 13 Present Values – Example 2 • You want to begin saving for your daughter’s college education and you estimate that she will need $150,000 in 17 years. If you feel confident that you can earn 8% per year, how much do you need to invest today? – PV = 150,000 / (1.08)17 = 40,540.34 14 Present Values – Example 3 • Your parents set up a trust fund for you 10 years ago that is now worth $19,671.51. If the fund earned 7% per year, how much did your parents invest? – PV = 19,671.51 / (1.07)10 = 10,000 15 Present Value – Important Relationship I • For a given interest rate – the longer the time period, the lower the present value – What is the present value of $500 to be received in 5 years? 10 years? The discount rate is 10% – 5 years: PV = 500 / (1.1)5 = 310.46 – 10 years: PV = 500 / (1.1)10 = 192.77 16 Present Value – Important Relationship II • For a given time period – the higher the interest rate, the smaller the present value – What is the present value of $500 received in 5 years if the interest rate is 10%? 15%? • Rate = 10%: PV = 500 / (1.1)5 = 310.46 • Rate = 15%; PV = 500 / (1.15)5 = 248.59 17 The Basic PV Equation Refresher • PV = FV / (1 + r)t • There are four parts to this equation – PV, FV, r and t – If we know any three, we can solve for the fourth • 18 Discount Rate • Often we will want to know what the implied interest rate is in an investment • Rearrange the basic PV equation and solve for r – FV = PV(1 + r)t – r = (FV / PV)1/t – 1 • Example 1 • You are looking at an investment that will pay $1,200 in 5 years if you invest $1,000 today. What is the implied rate of interest? – r = (1,200 / 1,000)1/5 – 1 = .03714 = 3.714% 19 Discount Rate – Example 2 • Suppose you are offered an investment that will allow you to double your money in 6 years. You have $10,000 to invest. What is the implied rate of interest? – r = (20,000 / 10,000)1/6 – 1 = .122462 = 12.25% 20 Discount Rate – Example 3 • Suppose you have a 1-year old son and you want to provide $75,000 in 17 years towards his college education. You currently have $5,000 to invest. What interest rate must you earn to have the $75,000 when you need it? – r = (75,000 / 5,000)1/17 – 1 = .172688 = 17.27% 21 Quick Quiz • What are some situations in which you might want to know the implied interest rate? • You are offered the following investments: – You can invest $500 today and receive $600 in 5 years. The investment is considered low risk. – You can invest the $500 in a bank account paying 4%. – What is the implied interest rate for the first choice and which investment should you choose? 22 Finding the Number of Periods • Start with basic equation and solve for t (remember your logs) – FV = PV(1 + r)t – t = ln(FV / PV) / ln(1 + r) • 23 Number of Periods – Example 1 • You want to purchase a new car and you are willing to pay $20,000. If you can invest at 10% per year and you currently have $15,000, how long will it be before you have enough money to pay cash for the car? – t = ln(20,000 / 15,000) / ln(1.1) = 3.02 years 24 Number of Periods – Example 2 • Suppose you want to buy a new house. You currently have $15,000 and you figure you need to have a 10% down payment plus an additional 5% of the loan amount for closing costs. Assume the type of house you want will cost about $150,000 and you can earn 7.5% per year, how long will it be before you have enough money for the down payment and closing costs? 25 Number of Periods – Example 2 Continued • How much do you need to have in the future? – Down payment = .1(150,000) = 15,000 – Closing costs = .05(150,000 – 15,000) = 6,750 – Total needed = 15,000 + 6,750 = 21,750 • Compute the number of periods • Using the formula – t = ln(21,750 / 15,000) / ln(1.075) = 5.14 years • 26 Quick Quiz – Part IV • • Suppose you want to buy some new furniture for your family room. You currently have $500 and the furniture you want costs $600. If you can earn 6%, how long will you have to wait if you don’t add any additional money? 27 Spreadsheet Example • Use the following formulas for TVM calculations – – – – FV(rate,nper,pmt,pv) PV(rate,nper,pmt,fv) RATE(nper,pmt,pv,fv) NPER(rate,pmt,pv,fv) • The formula icon is very useful when you can’t remember the exact formula • Click on the Excel icon to open a spreadsheet containing four different examples. 28 Work the Web Example • Many financial calculators are available online • Click on the web surfer to go to Investopedia’s web site and work the following example: – You need $50,000 in 10 years. If you can earn 6% interest, how much do you need to invest today? – You should get $27,919.74 29 The Rule of 72 • The rule of 72 is a quick way to estimate how long it will take to double your money. • # years to double = 72 / r – where r is a percentage. • Example: 72/7% = 10.3 years 1/4/2009 30 Discounted Cash Flow Valuation Multiple Cash Flows Ch. 6 31 Key Concepts and Skills • Be able to compute the future value of multiple cash flows • Be able to compute the present value of multiple cash flows • Be able to compute loan payments • Be able to find the interest rate on a loan • Understand how interest rates are quoted • Understand how loans are amortized or paid off 32 Chapter Outline • Future and Present Values of Multiple Cash Flows • Valuing Level Cash Flows: Annuities and Perpetuities • Comparing Rates: The Effect of Compounding • Loan Types and Loan Amortization 33 Multiple Cash Flows – FV • Suppose you invest $500 in a mutual fund today and $600 in one year. If the fund pays 9% annually, how much will you have in two years? • 0 1 2 3 4 5 • |--------|------|------|------|------|--• 500 600 1/4/2009 – FV = 500(1.09)2 + 600(1.09) = 1248.05 34 Multiple Cash Flows – Example Continued • How much will you have in 5 years if you make no further deposits? • First way: – FV = 500(1.09)5 + 600(1.09)4 = 1616.26 • Second way – use value at year 2: – FV = 1248.05(1.09)3 = 1616.26 1/4/2009 35 Multiple Cash Flows – FV Example 2 • Suppose you plan to deposit $100 into an account in one year and $300 into the account in three years. How much will be in the account in five years if the interest rate is 8%? – FV = 100(1.08)4 + 300(1.08)2 = 136.05 + 349.92 = 485.97 36 Present Value 0 1 2 3 4 200 178.57 318.88 400 600 800 427.07 508.41 1432.93 1/4/2009 37 Multiple Cash Flows • Find the PV of each cash flows and add them – Year 1 CF: 200 / (1.12)1 = 178.57 – Year 2 CF: 400 / (1.12)2 = 318.88 – Year 3 CF: 600 / (1.12)3 = 427.07 – Year 4 CF: 800 / (1.12)4 = 508.41 – Total PV = 178.57 + 318.88 + 427.07 + 508.41 = 1432.93 1/4/2009 38 Multiple Cash Flows Using a Spreadsheet • You can use the PV or FV functions in Excel to find the present value or future value of a set of cash flows • Setting the data up is half the battle – if it is set up properly, then you can just copy the formulas • Click on the Excel icon for an example 39 Decisions, Decisions • Your broker calls you and tells you that he has this great investment opportunity. If you invest $100 today, you will receive $40 in one year and $75 in two years. If you require a 15% return on investments of this risk, should you take the investment? • 0 1 2 • |--------|------|--- , i=15% • -100 40 75 • PV = 91.49 – No – the broker is charging more than you would be willing to pay. 1/4/2009 40 Annuities and Perpetuities Defined • Annuity – finite series of equal payments that occur at regular intervals – If the first payment occurs at the end of the period, it is called an ordinary annuity – If the first payment occurs at the beginning of the period, it is called an annuity due • Perpetuity – infinite series of equal payments 41 Annuities and Perpetuities – Basic Formulas • • Annuities: 1   1  (1  r ) t  PV  C   r        (1  r ) t  1 FV  C   r   42 What’s the PV of this ordinary annuity? 0 10% 1 100 2 100 3 100 90.91 82.64 75.13 248.69 = PV 1/4/2009 43 PV Annuity Formula • The present value of an annuity with n periods and an interest rate of i can be found with the following formula: 1 1(1  r )t C r 1 1(1  0.10)3 100  248.69 0.10 1/4/2009 44 Annuity – Sweepstakes Example • Suppose you win the Publishers Clearinghouse $10 million sweepstakes. The money is paid in equal annual installments of $333,333.33 over 30 years. If the appropriate discount rate is 5%, how much is the sweepstakes actually worth today? – PV = 333,333.33[1 – 1/1.0530] / .05 = 5,124,150.29 1/4/2009 45 Buying a House • You are ready to buy a house and you have $20,000 for a down payment and closing costs. Closing costs are estimated to be 4% of the loan value. You have an annual salary of $36,000 and the bank is willing to allow your monthly mortgage payment to be equal to 28% of your monthly income. The interest rate on the loan is 6% per year with monthly compounding (.5% per month) for a 30-year fixed rate loan. How much money will the bank loan you? How much can you offer for the house? 46 Buying a House - Continued • Bank loan – Monthly income = 36,000 / 12 = 3,000 – Maximum payment = .28(3,000) = 840 – PV = 840[1 – 1/1.005360] / .005 = 140,105 • Total Price – Closing costs = .04(140,105) = 5,604 – Down payment = 20,000 – 5604 = 14,396 – Total Price = 140,105 + 14,396 = 154,501 47 Annuities on the Spreadsheet Example • The present value and future value formulas in a spreadsheet include a place for annuity payments • Click on the Excel icon to see an example 48 Saving For Retirement • You are offered the opportunity to put some money away for retirement. You will receive five annual payments of $25,000 each beginning in 40 years. How much would you be willing to invest today if you desire an interest rate of 12%? – 1/4/2009 49 Saving For Retirement Timeline 0 1 2 … 39 40 41 42 43 44 0 0 0 … 0 25K 25K 25K 25K 25K Notice that the year 0 cash flow = 0 (CF0 = 0) The cash flows years 1 – 39 are 0 (C01 = 0; F01 = 39) The cash flows years 40 – 44 are 25,000 (C02 = 25,000; F02 = 5) 1/4/2009 50 Quick Quiz – Part II • You know the payment amount for a loan and you want to know how much was borrowed. Do you compute a present value or a future value? • You want to receive 5,000 per month in retirement. If you can earn .75% per month and you expect to need the income for 25 years, how much do you need to have in your account at retirement? 51 Finding the Payment • Suppose you want to borrow $20,000 for a new car. You can borrow at 8% per year, compounded monthly (8/12 = .66667% per month). If you take a 4 year loan, what is your monthly payment? – 20,000 = C[1 – 1 / 1.006666748] / .0066667 – C = 488.26 1/4/2009 52 Finding the Payment on a Spreadsheet • Another TVM formula that can be found in a spreadsheet is the payment formula – PMT(rate,nper,pv,fv) – The same sign convention holds as for the PV and FV formulas • Click on the Excel icon for an example 1/4/2009 53 Finding the Number of Payments – Example • Suppose you borrow $2000 at 5% and you are going to make annual payments of $734.42. How long before you pay off the loan? 2000 = 734.42(1 – 1/1.05t) / .05 .136161869 = 1 – 1/1.05t 1/(1+i)t = 1- (PV/PMT)i 1/1.05t = .863838131 1.157624287 = 1.05t t = ln(1.157624287) / ln(1.05) = 3 years 1/4/2009 54 Finding the Rate • Suppose you borrow $10,000 from your parents to buy a car. You agree to pay $207.58 per month for 60 months. What is the monthly interest rate? – Sign convention matters!!! – 60 N – 10,000 PV – -207.58 PMT – CPT I/Y = .75% 1/4/2009 55 Annuity – Finding the Rate Without a Financial Calculator • Trial and Error Process – Choose an interest rate and compute the PV of the payments based on this rate – Compare the computed PV with the actual loan amount – If the computed PV > loan amount, then the interest rate is too low – If the computed PV < loan amount, then the interest rate is too high – Adjust the rate and repeat the process until the computed PV and the loan amount are equal 1/4/2009 56 Quick Quiz – Part III • You want to receive $5000 per month for the next 5 years. How much would you need to deposit today if you can earn .75% per month? • What monthly rate would you need to earn if you only have $200,000 to deposit? • Suppose you have $200,000 to deposit and can earn .75% per month. – How many months could you receive the $5000 payment? – How much could you receive every month for 5 1/4/2009 years? 57 What’s the FV of a 3-year ordinary annuity of $100 at 10%? 0 10% 1 100 2 100 3 100 110 121 FV = 331 58 1/4/2009 FV Annuity Formula • The future value of an annuity with n periods and an interest rate of i can be found with the following formula: (1  r )  1 FV  C r 3 (1  0.10)  1  100  331. 0.10 t 1/4/2009 59 Future Values for Annuities • Suppose you begin saving for your retirement by depositing $2000 per year in an IRA. If the interest rate is 7.5%, how much will you have in 40 years? – FV = 2000(1.07540 – 1)/.075 = 454,513.04 1/4/2009 60 What’s the difference between an ordinary annuity and an annuity due? Ordinary Annuity 0 i% 1 PMT 2 PMT 3 PMT Annuity Due 0 i% PMT 1/4/2009 PV PMT PMT FV 61 1 2 3 Find the FV and PV if the annuity were an annuity due. 0 10% 1 2 3 100 100 100 1/4/2009 62 PV and FV of Annuity Due vs. Ordinary Annuity • PV of annuity due: PV = (PV of ordinary annuity) (1+i) PV = (248.69) (1+ 0.10) = 273.56 • FV of annuity due: FV = (FV of ordinary annuity) (1+i) FV = (331.00) (1+ 0.10) = 364.1 1/4/2009 63 Perpetuity • A certain (constant) cash flow forever (e.g. a consol bond). • What is the present value of a perpetuity with cash flow C forever? PV  • 1/4/2009  n 1  C n 1  r  PV = C / r 64 Perpetuities: How we get there? • Sometimes the annuities are indefinite, or perpetual, e.g. straight preferred stock. In this case, we have: pmt  1  PV  * 1   1  i n   i   • If we let n  infinity with i > 0, then we get: pmt PV  i 1/4/2009 65 Example: PV of Perpetuity • Your cousin would like to buy your Acura. Unfortunately, he is just a student and has very little money. Instead of paying for the car, he offers to pay you $100/month forever. You know that the Bank offers for your money at annual interest rate (compounded monthly) of 12%. How much is your cousin offering to pay for the car? – Hint: Suppose that your cousin is as dependable as the Bank. 1/4/2009 66 Example continues ... • Let us find out the periodical interest rate: – rm = ra / 12 = 0.12 / 12 = 0.01 – • So, PV = C / rm = 100 / 0.01 = $10.000,00 • What if your cousin is not as dependable as the Bank? 1/4/2009 67 Effective Annual Rate (EAR) • This is the actual rate paid (or received) after accounting for compounding that occurs during the year • If you want to compare two alternative investments with different compounding periods you need to compute the EAR and use that for comparison. 68 Annual Percentage Rate • This is the annual rate that is quoted by law • By definition APR = period rate times the number of periods per year • Consequently, to get the period rate we rearrange the APR equation: – Period rate = APR / number of periods per year • You should NEVER divide the effective rate by the number of periods per year – it will NOT give you the period rate 69 Computing APRs • What is the APR if the monthly rate is .5%? – .5(12) = 6% • What is the APR if the semiannual rate is .5%? – .5(2) = 1% • What is the monthly rate if the APR is 12% with monthly compounding? – 12 / 12 = 1% 70 Things to Remember • You ALWAYS need to make sure that the interest rate and the time period match. – If you are looking at annual periods, you need an annual rate. – If you are looking at monthly periods, you need a monthly rate. • If you have an APR based on monthly compounding, you have to use monthly periods for lump sums, or adjust the interest rate appropriately if you have payments other than monthly 71 Computing EARs - Example • Suppose you can earn 1% per month on $1 invested today. – What is the APR? 1(12) = 12% – How much are you effectively earning? • FV = 1(1.01)12 = 1.1268 • Rate = (1.1268 – 1) / 1 = .1268 = 12.68% • Suppose if you put it in another account, you earn 3% per quarter. – What is the APR? 3(4) = 12% – How much are you effectively earning? • FV = 1(1.03)4 = 1.1255 • Rate = (1.1255 – 1) / 1 = .1255 = 12.55% 72 EAR - Formula  APR  EAR  1  1  m   Remember that the APR is the quoted rate m is the number of compounding periods per year m 73 Will the FV of a lump sum be larger or smaller if we compound more often, holding the stated (quoted) NI% constant? Why? LARGER! If compounding is more frequent than once a year--for example, semiannually, quarterly, monthly, or daily--interest is earned on interest more often. 1/4/2009 74 Effect of frequent compounding: Quoted Compounding Periodical Rate % Freq. Interest Rate % 12 12 12 12 12 1/4/2009 Prncpl (YTL) FV, after a year: Realized Rate of Return % 12 12,36 12,55 12,68 Annual, 1 Semiannual, 2 Quarterly, 4 Monthly, 12 Daily, 365 12 6 3 1 0,032876 100000 112000 100000 PV(1,06)2= 112360 100000 PV(1,03)4= 112550 100000 PV(1,01)12= 112683 100000 PV(1,00329)365 12,76 = 112757 75 Decisions, Decisions II • You are looking at two savings accounts. One pays 5.25%, with daily compounding. The other pays 5.3% with semiannual compounding. Which account should you use? – First account: • EAR = (1 + .0525/365)365 – 1 = 5.39% – Second account: • EAR = (1 + .053/2)2 – 1 = 5.37% • Which account should you choose and why? 76 • Let’s verify the choice. Suppose you invest $100 in each account. How much will you have in each account in one year? – First Account: • Daily rate = .0525 / 365 = .00014383562 • FV = 100(1.00014383562)365 = 105.39 Decisions, Decisions II Continued – Second Account: • Semiannual rate = .0539 / 2 = .0265 • FV = 100(1.0265)2 = 105.37 • You have more money in the first account. 77 Computing APRs from EARs • If you have an effective rate, how can you compute the APR? Rearrange the EAR equation and you get: (1  EAR) APR  m   1 m  -1   78 APR - Example • Suppose you want to earn an effective rate of 12% and you are looking at an account that compounds on a monthly basis. What APR must they pay? APR  12 (1  .12 ) or 11.39%  1 / 12  1  .113 8655152  79 Computing Payments with APRs • Suppose you want to buy a new computer system and the store is willing to sell it to allow you to make monthly payments. The entire computer system costs $3,500. The loan period is for 2 years and the interest rate is 16.9% with monthly compounding. What is your monthly payment? – – – – Monthly rate = .169 / 12 = .01408333333 Number of months = 2(12) = 24 3,500 = C[1 – (1 / 1.01408333333)24] / .01408333333 C = 172.88 80 Future Values with Monthly Compounding • Suppose you deposit $50 a month into an account that has an APR of 9%, based on monthly compounding. How much will you have in the account in 35 years? – Monthly rate = .09 / 12 = .0075 – Number of months = 35(12) = 420 – FV = 50[1.0075420 – 1] / .0075 = 147,089.22 81 Present Value with Daily Compounding • You need $15,000 in 3 years for a new car. If you can deposit money into an account that pays an APR of 5.5% based on daily compounding, how much would you need to deposit? – Daily rate = .055 / 365 = .00015068493 – Number of days = 3(365) = 1,095 – FV = 15,000 / (1.00015068493)1095 = 12,718.56 82 Continuous Compounding • Sometimes investments or loans are figured based on continuous compounding • EAR = eq – 1 – The e is a special function on the calculator normally denoted by ex • Example: What is the effective annual rate of 7% compounded continuously? – EAR = e.07 – 1 = .0725 or 7.25% 83 Amortization Schedules • Tables showing how do you amortize your loan to a bank (for example). • Amortization tables are widely used--for home mortgages, auto loans, business loans, retirement plans, and so on. • Financial calculators (and spreadsheets) are great for setting up amortization tables. 1/4/2009 84 Amortization Construct an amortization schedule for a car loan of 20.000 YTL, 1.2% monthly rate, loan to be paid back in 3 years – monthly payments. 1.20% -20000 1/4/2009 PMT PMT PMT 85 Developing the amortization schedule – fixed payments • 1. We start by finding the required payments. • 20000 = PMT (1/0,012 – 1/0,012(1,012)36) • PMT = 20000 / (83.33 – 54.24) = 687,52 ytl • 2. Find interest charge for month 1: • Beginning balance * periodical int. rate • 20000 * 0,012 = 240 ytl 1/4/2009 86 Developing the amortization schedule • 3. Find repayment of principal in month 1: • Repmt = PMT – Interest • Repmt = 687,52 – 240 = 447,52 ytl • 4. Find ending balance after Year 1: • Ending Balance = Beginning Balance – Repmt • End. Balance = 20.000 – 447,52 = 19.552,48 ytl • Let us see the rest of it on excel. 1/4/2009 87 Amortized Loan with Fixed Principal Payment - Example • Consider a $50,000, 10 year loan at 8% interest. The loan agreement requires the firm to pay $5,000 in principal each year plus interest for that year. • Click on the Excel icon to see the amortization table 1/4/2009 88 Before we resume ... • • A Basis Point: It is simply1/100 of one percent. Say, an interest rate (initially 10%) increased by 5%. It could mean that the interest rate increased to 10 * (1+5%) = 10.5% or 10+5=15%. It is not clear. I better say the interest rate increased either 50 basis points or 500 basis points. 1/4/2009 89 Some Problems: • Q1) • On January 1 you deposit $100 in an account that pays a nominal interest rate of 11.33463%, with daily compounding (365 days). • How much will you have on October 1, or after 9 months (273 days)? (Days given.) 1/4/2009 90 iPer = 11.33463%/365 = 0.031054% per day. 0 0.031054% 100 273 1 2 273 FV=? FV273 = $1001.00031054  = $1001.08846 = $108.85. 1/4/2009 91 Q2) What’s the value at the end of Year 3 of the following CF stream if the quoted interest rate is 10%, compounded semiannually? 0 5% 1 2 100 3 4 100 5 6 6-mos. periods 100 1/4/2009 92 • Payments occur annually, but compounding occurs each 6 months. • So we can’t use normal annuity valuation techniques. 1/4/2009 93 1st Method: Compound Each CF 0 5% 1 2 3 4 5 6 100 100 100.00 110.25 121.55 331.80 FVA3 = $100(1.05)4 + $100(1.05)2 + $100 = $331.80. 1/4/2009 94 2nd Method: Treat as an Annuity Yes, by following these steps: a. Find the EAR for the quoted rate: 2 0.10 EAR = 1 + 2 - 1 = 10.25%. ( ) b. Use EAR = 10.25% as the annual rate for an annuity for N=3 years. Do the exercise! 1/4/2009 95 2nd Method: Treat as an Annuity 0 5% 1 100 n 2 100 3 100 (1  i)  1  PMT i (1  0.1025 )3  1  100  331 .80 0.1025 1/4/2009 96 Q3) You are offered a note which pays $1,000 in 15 months (or 456 days) for $850. You have $850 in a bank which pays a 6.76649% nominal rate, with 365 daily compounding, which is a daily rate of 0.018538% and an EAR of 7.0%. You plan to leave the money in the bank if you don’t buy the note. The note is riskless. Should you buy it? 1/4/2009 97 iPer =0.018538% per day. 0 365 456 days -850 1,000 3 Ways to Solve: 1. Greatest future wealth: FV 2. Greatest wealth today: PV 3. Highest rate of return: Highest EFF% 1/4/2009 98 1. Greatest Future Wealth Find FV of $850 left in bank for 15 months and compare with note’s FV = $1,000. FVBank = $850(1.00018538)456 = $924.97 in bank. Buy the note: $1,000 > $924.97. 1/4/2009 99 2. Greatest Present Wealth Find PV of note, and compare with its $850 cost: PV = $1,000/(1.00018538)456 = $918.95. PV of note is greater than its $850 cost, so buy the note. Raises your wealth. 1/4/2009 100 3. Rate of Return Find the EAR% on note and compare with 7.0% bank pays, which is your opportunity cost of capital: FVn = PV(1 + i)n $1,000 = $850(1 + i)456 Now we must solve for i per day. 1/4/2009 101 Using interest conversion: İ% EAR = 0.035646 = (1.00035646)365 - 1 = 13.89%. Since 13.89% > 7.0% opportunity cost, buy the note. 1/4/2009 102

Related docs
Loan Amortization Calculator
Views: 692  |  Downloads: 76
Amortization Chart
Views: 82  |  Downloads: 3
Amortization Chart
Views: 630  |  Downloads: 9
Free Loan Amortization
Views: 147  |  Downloads: 0
Amortization Calculator Annual Payments
Views: 20  |  Downloads: 0
Amortization Schedule Calculator
Views: 1122  |  Downloads: 15
Interest Loan Amortization Calculator
Views: 13  |  Downloads: 0
loan amortization chart
Views: 77  |  Downloads: 4
Auto Loan Amortization Calculator
Views: 7  |  Downloads: 1
Loan Amortization Table Calculator
Views: 84  |  Downloads: 0
premium docs
Other docs by harvey1
textil machinery
Views: 162  |  Downloads: 2
how to legally change your name
Views: 3191  |  Downloads: 11
legal letters and forms
Views: 695  |  Downloads: 11
cease and desist letter sample
Views: 5740  |  Downloads: 40
deposit demand letter
Views: 3870  |  Downloads: 33
mail order catelogs
Views: 261  |  Downloads: 1
legal letter forms
Views: 255  |  Downloads: 5
letter release of liability
Views: 1381  |  Downloads: 9
contract assignment letter
Views: 599  |  Downloads: 2
goodwill balance sheet
Views: 1580  |  Downloads: 30
title affidavit
Views: 257  |  Downloads: 3
real estate purchase offer letter
Views: 6478  |  Downloads: 64
tennessee quit claim
Views: 258  |  Downloads: 11
unlicensed real estate assistant
Views: 303  |  Downloads: 6
real estate supply and demand
Views: 268  |  Downloads: 9