1 / 2

PMT = ?

7. Your company is considering borrowing $5,000,000 at a cost of debt of 8.4000 p.a. If your company pays $500,000 each quarter towards this debt, how many years will it take to pay off the loan? Solution Opt 1: r per = r nom /m = 8.4%/4 = 2.1000%

wyoming-mendoza
Download Presentation

PMT = ?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MGT 326 Fall 2014 Test 1 Problem Solutions 7.Your company is considering borrowing $5,000,000 at a cost of debt of 8.4000 p.a. If your company pays $500,000 each quarter towards this debt, how many years will it take to pay off the loan? Solution Opt 1: rper = rnom/m = 8.4%/4 = 2.1000% P/Y=1, I/Y=2.1, PV=-5000000, PMT=500000: CPT, N; N =11.34; yrs = 11.34/4 = 2.84 yrs Solution Option 2: P/Y=4, I/Y=8.4, PV=-5000000, PMT=500000: CPT, N; N =11.34; yrs = 11.344/4 = 2.84 yrs 8.You are considering two different stock mutual funds in which to invest. Fund A offers 10.4500% p.a. rate of return with monthly reinvestment of profits. Fund B offers a 10.4700% p.a. rate of return with quarterly reinvestment of profits. Compute the Effective Annual Rate for each fund. Which fund is more profitable? Fund A: 2nd, INCONV, 10.45%, ENTER, ↓, ↓, 12, ENTER, ↓, ↓, CPT: 10.9653% Fund B: 2nd, INCONV, 10.47%, ENTER, ↓, ↓, 4, ENTER, ↓, ↓, CPT: 10.8883% 9.You are considering buying a new car which cost $24,999. You do not have that kind of cash so you must borrow the money. Your bank offers a nominal rate of 4.1200% for a 5 year amortized loan with monthly payments. You cannot afford to pay more than $450 per month. If you borrow the money from your bank, can you afford this car? n = T x m = 5 x 12 = 60 Solution Option 1: Find the PMT P/Y=12, N=60, I/Y=4.12, PV=24999; CPT PMT: $461.75 No Solution Option 2: Find the PV @ PMT of $450 P/Y=12, N=60, I/Y=4.12, PMT=450; CPT PV: $24,362.88 No Solution Option 3: Find the I/Y @ PMT of $450 and PV of $24,999 P/Y=12, N=60, PV=-24999, PMT=450; CPT I/Y: 3.0720% No Solution Option 4: Find the number of periods P/Y=12, I/Y=4.12, PV=-24,999, PMT=450; CPT N: N = 61.74 No 10.What is the present value of an annuity due yielding 8.6400% APR that pays quarterly payments of $1,000 for 1 year? (Do the math; do not use the financial functions on your calculator. Draw a cash flow diagram) PV = FV/(1 + r/m)n + FV/(1 + r/m)n-1 + ………….. = 1000 + 1000/(1 + 0.0864/4)1 + 1000/(1 + 0.0864/4)2 + 1000/(1 + 0.0864/4)3 = 1000 + 1000/(1.0216)1 + 1000/(1.0216)2+ 1000(1.0216)3 = 1000 + 1000/(1.0216) + 1000/(1.04367)+ 1000/(1.06621) = 1,000 + 978.86 + 958.16 + 937.90 = $3,874.92 11. You are considering leasing a car that cost $31,300. The lease will be for 6 years and requires monthly payments of $275.50. Somewhere on the lease paperwork you notice a statement to the affect that you will be charged an APR of 4.4800%. What kind of annuity is this?___________________ What is the implied value of the car at end of the lease (i.e. what is its turn-in value)? Annuity Due Solution Opt 1: rperiodic = rnominal/m = 4.48%/12 = 0.373333%; Set BGN, P/Y=1, N=72, I/Y=0.373333, PV=-31300, PMT= -275.5; CPT FV: $18,137.97 Solution Option 2: Set BGN, P/Y=12, N=72, I/Y=4.48, PV=-31300, PMT= 275.5; CPT FV: $18,137.97 PV = $24,999 5 yrs 58 59 60 0 1 2 PMT = ? 0 PV = ? 0 4 1 2 3 PMT = $1,000 PV = $31,300 m=12, T=6; n = m x T = 12 x 6 = 72 6 yrs 70 71 72 0 1 2 PMT = $275.50 Turn-in Value = ?

  2. MGT 326 Fall 2014 Test 1 Problem Solutions 12. Today you open a new investment account for your company with a $15,000 deposit. The account has had an average yield of 6.2400% over the last four years and compounds every six months. You plan to deposit $15,000 into this account every month at the beginning of the month. How much will you have in this account 4.5 years from now? n = T x m = 4.5 x 12 = 58 Set BGN, P/Y=12, C/Y=2, N=54 I/Y=6.24, PMT=15000; CPT,FV: FV =$935,453.44 OR Convert the weekly rate into a quarterly rate then solve for FV 2nd , ICONV, 6.24, ENTER, ↓, 2, ENTER, ↓, ↓, CPT: EFF% = 6.3373% ↓, 12, ENTER. ↓, CPT: NOM% = 6.1604% Set BGN, P/Y=12, N=54, I/Y=6.1604, PMT=15000; CPT,FV: FV =$935,453.44 13. You are tasked with estimating the fair market value of a security that promises uneven future payments. The table below shows the semiannual payment schedule (each cash flow occurs at the end of the semester). You consider 6.2000% APR to be the appropriate opportunity cost of capital. What is the theoretical value of this security? FV = ? 52 53 54 mos 0 1 2 PMT = $5,000 I/Y = rperiodic = rnominal/m = 6.2%/2 = 3.1% CF, 2nd, CLR WORK (Clear Cash Flow Registers) 0, ENTER, ↓, 700, ENTER ↓, ↓, 750, ENTER ↓, ↓, 850, ENTER ↓, ↓, -950, ENTER ↓, ↓, 600, ENTER ↓, ↓, 900 ENTER NPV, 3.1, ENTER ↓, CPT = $2,583.77 14. You plan to retire on your 65th birthday. After that time, you want to withdraw $7,000.00 each month at the beginning of the month for the rest of your life. How much money must you deposit monthly into a retirement account starting on your 22nd birthday to fund the above described retirement plan? You will make these deposits at the beginning of each month. You estimate the average rate of return over the rest of your life will be 7.2000% p.a. [Hint: Treat the retirement cash flows as a perpetuity.] Step 1: Find the PV of the retirement perpetuity. PV = PMT/rperiodic = $7,000/(0.072/12) = $1,166,666.67 Step 2: Find the PMT of the retirement savings annuity. Set BGN, P/Y=12, N=43x12=516, I/Y=7.2, FV=1,166,666.67; CPT,PMT: $332.84

More Related