Question
Please show calculations on Excel. Date Ford GM 1-Dec-99 5.52% -1.50% 3-Jan-00 -5.70% 10.83% 1-Feb-00 -16.32% -4.99% 1-Mar-00 10.32% 8.89% 3-Apr-00 20.27% 13.05% 1-May-00 -11.30%
Please show calculations on Excel.
| Date | Ford | GM |
| 1-Dec-99 | 5.52% | -1.50% |
| 3-Jan-00 | -5.70% | 10.83% |
| 1-Feb-00 | -16.32% | -4.99% |
| 1-Mar-00 | 10.32% | 8.89% |
| 3-Apr-00 | 20.27% | 13.05% |
| 1-May-00 | -11.30% | -24.12% |
| 1-Jun-00 | -7.81% | -17.79% |
| 3-Jul-00 | 9.47% | -1.94% |
| 1-Aug-00 | -9.18% | 23.95% |
| 1-Sep-00 | 5.42% | -7.14% |
| 2-Oct-00 | 3.63% | -4.43% |
| 1-Nov-00 | -12.89% | -19.61% |
| 1-Dec-00 | 3.02% | 2.89% |
| 2-Jan-01 | 21.56% | 5.43% |
| 1-Feb-01 | -3.29% | 4.56% |
| Intercept |
|
|
| Slope |
|
|
| R-squared value |
|
|
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
Venture Capital Valuation
Authors: Lorenzo Carver
1st Edition
0470908289, 978-0470908280
