annual data series for S&P 500 stocks

Get your original paper written from scratch starting at just $10 per page with a plagiarism report and free revisions included!

4.8

rating

SiteJabber

4.9

rating

ResellerRatings

4.9

rating

Reviews.io

Hire A Writer

http://pages.stern.nyu.edu/~adamodar/New_Home_Page/datafile/histretSP.html

12.B

1. Copy from the link source and paste into your own Excel sheet the 1928-2013 annual data series for S&P 500 stocks, 3-month T-bills, and 10-year T-bonds.

2. Apply Excel function =AVERAGE(…) to compute the 1928-2013 annual average return for S&P 500, 3-month T-bills, and 10-year T-bonds, respectively. Note: Only do so on % return data series, but not on $ amount data.??

3. Apply Excel function =STDEV(…) to compute the 1928-2013 standard deviation (i.e., “total risk”) for S&P 500, 3-month T-bills, and 10-year T-bonds, respectively. Note: Only do so on % return data series, but not on $ amount data.

10.B

We have foundthat the longest-maturity CAT bond (01-March-2097) has a most current “yield to maturity” of 5.236% per year, and thus this 5.236% (per year) on CAT bond is used as the required return for your long-term-debt-financed capital investment.

Based on the required return (financing cost) of 5.236%, if CAT applies the IRR rule, shall CAT purchase the order entry system or not?

Based on the required return (financing cost) of 5.236%,if CAT applies the NPV rule, shall CAT purchase the order entry system or not? (Show the resulting NPV)

If everything is correctly formatted in Excel I will tip you nicely. Thankyou!

Stay Anonymous
With Our Essay Writing Service

The aim of our service is to provide you with top-class essay help when you ask us to write my paper; we do not collect or share any of your personal data. We use the email you provide us to send you drafts, final papers, and the occasional promotion and discount code, but that’s it!

Order Now