Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using excel and the internet (I highly recommend using Yahoo Finance), collect the daily price data for the Russell 2000 Index from Sept 9, 1927
- Using excel and the internet (I highly recommend using Yahoo Finance), collect the daily price data for the Russell 2000 Index from Sept 9, 1927 to Mar 27, 2022 (inclusive) and calculate the following:
- The average return over the period
- The variance over the period
- The standard deviation over the period
Please provide your excel with working formulas (10 pts total).
- Price out a bond with the following characteristics
- 15 year maturity
- 6.2% coupon bond
- 2.25% risk free rate
- 3.15% credit spread
- $1000 face value
Please show your work in excel. If the bond is being offered initially for $100, should you buy it based on your calculation (6 points)?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started