Unit 2 ? MBA6016 - Jul 11 2016 to Aug 19 2016 - Section 103

• Assignment SubmissionYou are required to use the textbook problems template in the Resources to complete the problems. This Excel document contains unique details and cells specific to the problems that you must use to derive your solutions. Where numeric solutions are expected, provide full detail of the process used to reach the solution using Excel. Where analysis is expected, use information from the textbook to inform your analysis, not replace it, incorporating creativity, critical thinking, and real-life perspectives. Cite all resource materials used in your analysis, using proper APA format.A thorough, professional presentation of your analysis and results is an important consideration. Enhance your presentation skills by using applicable tools such as tables, graphs, diagrams, and commentary as appropriate in all assignments in this course.

UNIT 2: TEXTBOOK PROBLEMS CHAPTER 4: PROBLEM 2 (a through c) Present Value Interest Rate Number of Years Future Value = A. 3,200 6% 10 B. 3,200 8% 10 C. 3,200 6% 20 A. 15,451 7% 12 B. 51,557 9% 8 C. 886,073 14% 19 D. 550,164 16% 24 A. 217 307 3 B. 432 896 10 C. 41,000 162,181 13 D. 54,382 483,500 26 A. 625 1,284 9% B. 810 4,341 11% C. 18,400 402,662 7% D. 21,500 173,439 10% 5% $960 $840 $1,935 $1,350 13% $960 $840 $1,935 $1,350 18% $960 $840 $1,935 $1,350 CHAPTER 4: PROBLEM 3 Future Value = Interest Rate Number of Years Present Value = CHAPTER 4: PROBLEM 4 Present Value = Future Value Number of Years Interest Rate CHAPTER 4: PROBLEM 5 Present Value = Future Value Interest Rate Number of Years (or Periods) CHAPTER 4: PROBLEM 11 Discount Rate Year 1: Year 2: Year 3: Year 4: Present Value @ 5%, 13%, and 18% = (Note: Use the built-in NPV CHAPTER 5: PROBLEM 2 A. Settlement (Think of Settlement as the beginning of the duration of Maturity Rate YTM Redemption Frequency Basis Bond Price Multiply by 10 (Think of Maturity as the end of the duration of the bond (Coupon Rate) (Yield to Maturity or Required Rate of Return) (Bonds Face Value, Par Value, or Fair Price; Note that i (Coupon payments are semiannual, so you put in a 2. If (Always leave it blank.) (The answer. But you need to multiply it by 10 to get the (Microsoft gives the bond price in 2 digits. You need to m CHAPTER 5: PROBLEM 3 Settlement Maturity Rate Pr Redemption Frequency Basis: YTM (Think of Settlement as the beginning of the duration of (Think of Maturity as the end of the duration of the bond (Coupon Rate) (The bonds price per $100 face value) (Bonds Face Value, Par Value, or Fair Price; Note that i (Coupon payments are semiannual, so you put in a 2. If (Always leave it blank.) CHAPTER 6: PROBLEM 2 Dividend Payment Dividend Growth Rate ZYX Stock Price $1.99 4.50% $31 Required Return = CHAPTER 6: PROBLEM 4 Dividend Dividend increase per year Required Return (Return on Investment) Stock Price = $2.65 4.75% 11% (Note: Use the built-in NPV formula in Excel.) beginning of the duration of the bond.) d of the duration of the bond.) d Rate of Return) ue, or Fair Price; Note that is $100, not $1,000. You make the adjustments by multiplying the answer by 10.) iannual, so you put in a 2. If they are annual, then you input a 1.) o multiply it by 10 to get the actual bond price.) ice in 2 digits. You need to multiply it by 10 to get the actual bond price.) beginning of the duration of the bond.) d of the duration of the bond.) ue, or Fair Price; Note that is $100, not $1,000.) iannual, so you put in a 2. If they are annual, then you input a 1.)