This is an individual assessment contributing 50% of your marks for the module. The assignment is intended to help you develop skills of implementing financial models in Excel. The assignment provides you with the opportunity to produce spreadsheet applications that solve and analyse corporate finance problems.

You are required to set up a separate worksheet (spreadsheet model) for each of the following two problems:
1) Calculate the yield to maturity of a 7-year $1,000 par value bond with an annual coupon rate of 7.5% and a current price of $1,125. Provide the spreadsheet solutions for both annual and semi-annual payments of interest. Comment on the relationship between the yield to maturity and the timing of interest payments, providing an appropriate table or graph.

2) Obtain from Bloomberg (or Datastream, or Thomson ONE Banker, or Yahoo!Finance) the beginning of month values for the period 2009-2012 of the Standard & Poor's (S&P) SMALL CAP 600 Index and New York Stock Exchange (NYSE) World Leaders Index. Assume that you are a risk-averse investor.

For each of the two assets represented by the indices, calculate annual returns and build a frequency distribution of annual returns. Provide graphs of the distributions.

Explore the risk-return relationship for the two assets. Plot your results on a graph with the standard deviation of annual returns of each asset on the horizontal axis and the average annual return on the vertical axis, and comment on which asset performed better.
Assume that you form a portfolio by investing equal amount of money in each asset. Determine the average and standard deviation of the portfolio's annual returns. Provide your interpretation of the risk and return of the equally-weighted portfolio compared to those of the individual assets.

Calculate and graph the average annual returns and standard deviations of all portfolios that are combinations of the S&P SMALL CAP 600 Index and NYSE World Leaders Index with the proportion of the S&P SMALL CAP 600 Index being 0, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100%. Comment on the profile of the risk-return trade-off between the portfolios.

 

Posted Date: 3/29/2013 5:50:13 AM | Location : United States

Ask an Expert

Related Discussions:- Calculate and graph the average annual returns , Assignment Help, Ask Question on Calculate and graph the average annual returns , Get Answer, Expert's Help, Calculate and graph the average annual returns Discussions

Write discussion on Calculate and graph the average annual returns
Your posts are moderated

Write your message here..

Related Questions

Maximum cost recovery deduction, In May of 2010 a calendar year taxpayer, p... In May of 2010 a calendar year taxpayer, placed in service $2,137,000 of USED 15-year recovery property. The taxpayer has taxable income of $1,175,000 before the cost recover

Reduces retained earnings by the fair market value, Q. If a stockholder rec... Q. If a stockholder receives a dividend that reduces retained earnings by the fair market value of the stock, the stockholder has received a a. large stock dividend. b. cash divide

Final accounts-branches, Final accounts 1) Examination questions – ... Final accounts 1) Examination questions – two types of problems arise in examinations: transfers between head office and branch are made at cost; or Transfers bet

A realized gross profit, On December 15, 2011 Risby Sales Co. sold a track ... On December 15, 2011 Risby Sales Co. sold a track of land that cost $3,600,000 for $4,500,000. Rigsby appropriately uses the installment sale method of accounting for this transact

Disclaimer of leases-bankruptcy and liquidation, Disclaimer of leases I... Disclaimer of leases In principle where the bankrupt is a lessee the lease cannot be disclaimed without leave of the court; but such leave is not required in the following case

Annuity, An annuity is explained as stream of uniform duration cash flows. ... An annuity is explained as stream of uniform duration cash flows. The payment of life insurance premium through the policyholder to the insurance company is an illustration of an a

Determine income statement and balance sheet, Prepare an Excel spreads... Prepare an Excel spreadsheet containing the following: - Construct the next five-year pro-forma statements (income statement and balance sheet). - Estimate annual F

What is depreciation reserve fund, Q. What is Depreciation Reserve Fund ? ... Q. What is Depreciation Reserve Fund ? Depreciation Reserve Fund is the fund specially reserved for replacement of assets. Once the assets are purchased from the capital money

Hsa advantages , A HEALTH SAVINGS ACCOUNT AT FRONTLINE PR Susan Berry... A HEALTH SAVINGS ACCOUNT AT FRONTLINE PR Susan Berry just returned from a national conference on compensation and benefits where she attended a session on Health Savings Accou

Help, I need help with my homework I need help with my homework