Using cross-sectional data for a sample of 40 Singapore companies for 2019, the following model was estimated by ordinary least squares regression: Market Cap of Coy, = X₁ + X₂Growth; + XEBITDA_EV+X+ROC where Market Cap of Coy is the value of the company defined as number of shares *share price Growth is the estimated growth rate of revenues for the next two years EBITDA EV is the ratio of EBITDA (Earnings Before Interest, Depreciation and Amortisation) to Enterprise Value ROC is before-tax return on capital The regression results are given below: Coefficient Std. estimate Error Constant Growth EBITDA_EV ROC 0.436 0.04 0.448 -0.3 t-stat 1.817 0.215 0.336 0.118 -2.542 0.24 0.186 1.335 p-value 0.0769 0.8309 0.7387 0.0151 The R-square is 0.60 and Adjusted R-square of the regression is 0.58. Using these results, answer the questions below. The F-stats is 0.0655. a) Comment on the accuracy of the regression model. Suggest improvements that could be made to increase the accuracy of the model. b) Calculate the expected market cap of a firm with the following characteristics: Growth = 0.10, EBITDA_EV =0.26 and ROC=0.1 c) A college professor is interested to find out if the students taking quantitative subjects such as finance will score as well in non- quantitative subjects such as management theory. He conducted a survey on a sample of students and which resulted in the following exam scores of the students taking both Corporate Finance and Management Theory. Calculate Spearman's Rank Correlation and comment on the results. You can use Excel to perform the calculations.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Pls do ASAP ... I WILL GIVE LIKE FOR SURE Try to give solution in typed form
Using cross-sectional data for a sample of 40 Singapore companies for 2019,
the following model was estimated by ordinary least squares regression:
Market Cap of Coy=X₁ + X₂Growth; +
X3EBITDA_EV₁+X+ROC
where
Market Cap of Coy is the value of the company defined as number of shares
* share price
Growth is the estimated growth rate of revenues for the next two years
EBITDA_EV is the ratio of EBITDA (Earnings Before Interest, Depreciation
and Amortisation) to Enterprise Value
ROC is before-tax return on capital
The regression results are given below:
Coefficient
estimate
Constant
Growth
EBITDA_EV
ROC
0.436
0.04
0.448
-0.3
Std.
Error
t-stat
1.817
0.215
0.336
0.24
0.186
1.335
0.118 -2.542
p-value
0.0769
0.8309
0.7387
0.0151
The R-square is 0.60 and Adjusted R-square of the regression is 0.58.
Using these results, answer the questions below. The F-stats is 0.0655.
a) Comment on the accuracy of the regression model. Suggest improvements
that could be made to increase the accuracy of the model.
b) Calculate the expected market cap of a firm with the following
characteristics:
Growth = 0.10, EBITDA_EV =0.26 and ROC=0.1
c) A college professor is interested to find out if the students taking
quantitative subjects such as finance will score as well in non-
quantitative subjects such as management theory. He conducted a
survey on a sample of students and which resulted in the following exam
scores of the students taking both Corporate Finance and Management
Theory. Calculate Spearman's Rank Correlation and comment on the
results. You can use Excel to perform the calculations.
M
un 1, 2
Transcribed Image Text:Using cross-sectional data for a sample of 40 Singapore companies for 2019, the following model was estimated by ordinary least squares regression: Market Cap of Coy=X₁ + X₂Growth; + X3EBITDA_EV₁+X+ROC where Market Cap of Coy is the value of the company defined as number of shares * share price Growth is the estimated growth rate of revenues for the next two years EBITDA_EV is the ratio of EBITDA (Earnings Before Interest, Depreciation and Amortisation) to Enterprise Value ROC is before-tax return on capital The regression results are given below: Coefficient estimate Constant Growth EBITDA_EV ROC 0.436 0.04 0.448 -0.3 Std. Error t-stat 1.817 0.215 0.336 0.24 0.186 1.335 0.118 -2.542 p-value 0.0769 0.8309 0.7387 0.0151 The R-square is 0.60 and Adjusted R-square of the regression is 0.58. Using these results, answer the questions below. The F-stats is 0.0655. a) Comment on the accuracy of the regression model. Suggest improvements that could be made to increase the accuracy of the model. b) Calculate the expected market cap of a firm with the following characteristics: Growth = 0.10, EBITDA_EV =0.26 and ROC=0.1 c) A college professor is interested to find out if the students taking quantitative subjects such as finance will score as well in non- quantitative subjects such as management theory. He conducted a survey on a sample of students and which resulted in the following exam scores of the students taking both Corporate Finance and Management Theory. Calculate Spearman's Rank Correlation and comment on the results. You can use Excel to perform the calculations. M un 1, 2
Corporate
Finance
81
55
29
42
77
64
Management
Theory
21
47
87
53
94
38
Transcribed Image Text:Corporate Finance 81 55 29 42 77 64 Management Theory 21 47 87 53 94 38
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman