64011 – Maximum 1200 wordsUse S&P Capital IQ to collect all

SOLUTION AT Australian Expert Writers

Assignment Details:
Maximum 1200 S&P Capital IQ to collect all missing inputs for calculations in Part 2a. This will also be useful for more background research on your allocated company. Required:1. TVM and bond valuation (1 mark each, give answers to 2 decimal places):a. Your case company has an issue of $1,000 par value semi-annual coupon bonds with 7 years remaining until maturity. The annual coupon rate and yield to maturity for bonds are given in the spreadsheet. What is the of the bonds?b. Your case company is considering a contract in which its customer will makeend-of-month payments of the amount shown in the data spreadsheet (see instructions above) for 3 years. Your company’s discount rate is also shown in the spreadsheet. What is the value of the contract to your case company at its commencement?c. Your case company needs to invest funds and has alternatives available to it, A, B and C, all of equal risk. The interest rates for these options are given in the spreadsheet.What is the EAR of the alternative the company should choose if it wishes to maximise value?d. Your case company has gross profit as shown in the spreadsheet. Assuming thegross profit grows continuously over time at a given rate (see spreadsheet), what will the gross profit be in 10 years?e. Your case company is buying land for the amount given in the spreadsheet. Thetransaction will be financed by an amortised loan at 4.2% APR, quarterly compounding, with 20 years of end-of-quarter payments. What is the amount of the quarterly payment? Assessment 2Finance 2f. Your case company has an issue of $100 par value annual coupon bonds with 5 yearsremaining until maturity. The annual coupon rate is given in the spreadsheet, along with the current price of the bonds. What is the YTM of the bonds?2. Risk and return estimates (4 marks):a. Use CAPM to estimate the expected return for the shares of:i) your case company; and ii) a hypothetical company with a beta of 1.40. To do this, use the yield to maturityof a 10-year Australian Government bond on 29 March 2021 as a proxy for the risk-free rate, assume the market risk premium is 5% and use your case company’s current 5-year beta.b. the data from part 2a, estimate portfolio expected return and beta, assuming a portfolio with 20% invested in your case company and the remainder invested in the hypothetical company.3. Risk and return analysis (15 marks):a. Interpret and discuss your risk and return measures from parts 2a and 2b.

Order from Australian Expert Writers
Best Australian Academic Writers