cpa canada FA3 第3章作业
- 格式:docx
- 大小:41.59 KB
- 文档页数:6
Corporate Finance Fundamentals Assignment 31 LESSON 3 Assignment Question 1 (35 marks) Computer question There are two alternative solutions to part (a) — you can use the trial and error method, or solve the problem directly using the IRR (internal rate of return) function. Since internal rate of return will not be covered until Lesson 6, the worksheet I-FN1L3Q1 has been set up to use the trial and error method. This is the method that you should employ.
Required The worksheet in the file I-FN1L3Q1 has been partially completed for you.
a. (15 marks) Suppose a 6%, €1,000 bond with 5 years left to maturity is selling for €1,089.04. In order to obtain the effective yield, assuming that the interest is paid annually, enter appropriate formulas or values in the following cells:
B17 so that the calculated market value of the bond in cell B20 is the same as the given market value of the bond in cell B14 B18 to calculate the present value of the face value of the bond B19 to calculate the present value of all the coupons B20 to calculate the market value of the bond
b. (3 marks) What is the effective yield?
c. (7 marks) If interest were paid semi-annually, the market value of the bond would change even if the effective yield remained unchanged. Enter appropriate formulas in the following cells:
B31 to calculate the effective semi-annual rate B32 to calculate the market value of the bond, based on semi-annual interest payments
d. (5 marks) Report the effective semi-annual rate and the market value of the bond under these circumstances. 2 Assignment3 Corporate Finance Fundamentals
e. (5 marks) After completing the preceding parts, use your completed worksheet to conduct the following what-if analysis:
i) (2.5 marks) If the given market value of the bond is changed to €1,065.85, with the coupon rate unchanged at 6%, what are your answers for parts (b) and (d)?
ii) (2.5 marks) If the given market value of the bond remains at €1,089.04, but the coupon rate is changed to 5.5%, what are your answers for parts (b) and (d)?
Procedure 1. Open the file I-FN1L3Q1. The file contains one partially completed worksheet, L3Q1. Examine the worksheet and note that the data given in the problem has already been entered in the worksheet. Part (a) and (b) are set up in rows 17 to 20, and part (c), (d) and (e) in rows 23 to 32.
2. Enter appropriate formulas in cells B18 to B20. After you have entered formulas for these cells, try different values in cell B17 until the calculated market value of the bond in cell B20 is the same as the given market value in cell B14.
3. Enter appropriate formulas in cells B31 and B32. 4. Save your completed worksheet. 5. Using the completed spreadsheet, prepare your answer to parts (b) and (d). 6. For part (e), use the spreadsheet to perform the what-if analysis for cases (i) and (ii). 7. Copy and paste cells A1 to B32 for all 3 scenarios described in parts (d) and (e). 8. Display the formulas in your completed worksheet. Copy and paste the formulas in cells A16 to B32 into your Word document.
Question 2 (35 marks) Computer question
Investment in foreign countries is extremely dynamic because of the constant fluctuation in interest and exchange rates. Worksheets are ideal for this type of analysis because such fluctuations can be readily reflected in the worksheet without tedious calculations. In this question, you complete a worksheet to allow instant evaluation of alternative foreign investments. You are given the following data: Corporate Finance Fundamentals Assignment 33
Spot exchange rates: s(C|US) = C$1.57829 S(US|C) = US$0.63360 s(C|GB) = C$2.49845 S(GB|C) = £0.40025 s(US|GB) = US$1.58301 S(GB|US) = £0.63171
where C = Canada, US = United States, and GB = Great Britain. Also one-year interest rates are Canada kc = 5.2500% United States kus = 4.2500% Great Britain kgb = 4.5000%
Required a. Calculate the forward C|US, forward C|GB, and forward US|GB exchange rates. b. Calculate the forward US|C, forward GB|C, and forward GB|US exchange rates. c. Suppose a US investor has US$100,000 to invest. Determine the one-year rate of return to
1. direct investment in Canada 2. direct investment in the United States 3. direct investment in Great Britain 4. investment in Great Britain through Canadian dollars 5. investment in Canada through English pounds
d. Of the five investment possibilities, what is the best one-year investment? (Round all final figures to 2 decimal places.)