ACC00716 Finance Session 3
Task:
At the beginning of Week 4, you will be assigned an ASX listed company as the context for this assignment. At that time, you can find your case company's ASX code in ‘Grades and Feedback’ on the unit's MySCU Learning site.
All input data you need to find for calculations in this assignment must be sourced from S&P Capital IQ. To use this database, you will need to apply for a user account. Instructions and the link to the database can be found in the Web Links section of this unit’s MySCU site. Please read those instructions carefully and set your account up early in the session. Attempt each of the following sections in your assignment submission:
1. TVM and bond valuation questions :
a. Your case company has decided to purchase a new asset necessary for a proposed expansion to its business. The company has decided to speak with their bank. The bank is offering a fixed rate of 3.85% APR, compounded monthly. Your case company is required to make payments monthly as shown in Table 1 (page 4 of this document) at the end of every month for 7 years. What amount will your case company be required to borrow?
b. Your company has annual operating revenue as shown in Table 1. Assume this revenue will grow continuously at the annual rate shown in Table 1. What is your prediction for annual operating revenue in 7 years?
c. Your company needs to borrow funds and has several options available to it, Loans A, B and
C. The interest rates (APR) for these options are given in Table 1. What is the EAR of the loan option the company should choose?
d. Your company is buying new property for the amount given in Table 1. To finance this, the company’s bank has offered an amortised loan at 3.25% APR, quarterly compounding, with 25 years of quarterly payments. What quarterly payment will the company have to make on this loan? Assume that the entire property cost is financed and that payments are made at the end of each period.
e. Your company has an issue of $1000 par value annual coupon bonds with 8 years remaining until maturity. The annual coupon rate is given in Table 1, along with the current price of the bonds. What is the yield to maturity on the bonds?
f. Your company has an issue of $100 par value bonds that offer a 6% coupon rate paid semiannually. The bonds have 6 years remaining until maturity. The market’s required return on these bonds is given in Table 1. What is the amount of each coupon payment?
2. Risk and return estimates:
a. Use CAPM to estimate the expected return for the shares of: i) your case company; and ii) ahypothetical company with a beta of 1.10. To do this, use the yield to maturity of a 10-year Australian Government bond on 7 December as a proxy for the risk-free rate, assume the market risk premium is 4.50% and use the company’s most recent 5 year beta.
b. Using the data from part 2a, estimate portfolio expected return and beta, assuming a portfolio made up of your case company and the hypothetical company in equal weighting.
3. Risk and return analysis:
a. Drawing on expectations from theory and incorporating the overall context of your chosen company, discuss and interpret the risk and return measures from parts 2a and 2b. You may include additional measures. If so, clearly source the data and ensure you clearly explain your calculations.
Marking Criteria:
The answer to each TVM and bond valuation question in part 1 will be marked as correct or incorrect (0 marks). Give your final answer to each of the 6 questions on a separate line in the first section of your assignment submission. Give all answers to two decimal places. No workings are required and no part marks will be provided but if you want feedback on any errors, provide brief workings (e.g. screenshot of completed spreadsheet template section) for each question under the list of 6 answers.
