# Financial Regressiom Essay

3259 Words Jun 16th, 2013 14 Pages
FINA 6204
Problem Set 1

The purpose of the assignment is to review basic hypothesis testing and regression techniques. There is an appendix in your textbook, Appendix C: Using Excel to Conduct Analysis, which may help you with running regressions in Microsoft Excel. You may also wish to use a basic statistics text for guidance if needed. I have also provided you with a table with the t distribution.

If you have an older version of EXCEL and have not previously loaded the Analysis ToolPak, go to TOOLS, ADD-INS, Analysis Tool Pak. This will load the regression software that you will need. Then go to TOOLS, DATA ANALYSIS, Regression. Now you are ready to run regressions in EXCEL. Alternatively, if you have the most
The beta coefficient is the estimated coefficient for the independent or X variable, the excess rate of return for the market. (10 points)
SUMMARY OUTPUT Regression Statistics
Multiple R 0.86831328
R Square 0.75396796
Standard Error 8.76947674
Observations 20 ANOVA df SS MS F Significance F
Regression 1 4242.1018 4242.102 55.1612 6.945E-07
Residual 18 1384.267 76.90372
Total 19 5626.3688 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 0.24635305 2.0982897 0.117407 0.907838 -4.1619901 4.654696 -4.16199 4.654696
Market 1.47503908 0.1986034 7.427059 6.95E-07 1.0577888 1.892289 1.057789 1.892289

Alpha is the intercept = 0.24635305
Beta Coefficient = 1.47503908
Excess Rate of Return (firm) = 0.24635305 + 1.47503908 X [Excess Of Return Market] – Residual Error

A beta of 1.47503908 implies the following: a 1% increase in the excess rate of return (market) suggests an increase of 1.47503908 % in the excess rate of return (firm).

1c. Assuming that the market return for the coming year is expected to be 12 percent and that the risk-free rate is expected to be 8 percent, use market model (your regression model) to estimate the expected rate of return to the firm’s shareholders for the coming year. (Hint: You will first need to calculate the expected

## Related Documents

• ###### Essay Financial Analysis

Rachelle Stanley Columbia College FINC 350 A firm’s performance and financial situation is measured by financial ratios. In order to reach these ratios a financial analysis must be done on the company’s financial information. Financial analysis is the evaluation, selection and interpretation of financial data to assist in investment and financial decision-making. Financial data is drawn from many sources however, the primary source is data that is provided by the company in its annual reports…

Words: 1195 - Pages: 5
• ###### Essay Financial Analysis

demonstration for Aberdeen to indicate that the traffic control system actually worked. Competition for the order was high since the new concept of traffic control was new in the global market (Poterba, 1999). Q4 Commutronics argument for and against a financial solution Contract withdrawal entailed redundancies in Rio and Aberdeen and the free issue had no impact on pre-tax results. Any loss in UK would have been offset through CdB’s gain. Against the free issue were several views, cost incurred by UK…

Words: 1223 - Pages: 5
• ###### The Relation Between Financial Literacy and Financial Wellbeing

2015, credit card debt has actually increased almost back to what it was in 2007. In a journal article entitled "The Relation between Financial Literacy, Financial Wellbeing and Financial Concerns", Roshan Abdoreza states that a questionnaire showed that married people and men are the most financially literate, and higher financial literacy leads to less financial concern. Daniel Ray's statistics from CreditCards.com state that in 2012, Generation X(people born between the early 1960s and the early…

Words: 1319 - Pages: 6
• ###### Essay Regulations of Financial Markets and Global Financial Crisis

gula Regulation of Financial Markets BA (Hons) Business Management Word Count: 2750 ------------------------------------------------- Q: Explain the main reasons why financial markets are regulated? To what extent do you think that recent problems in the financial markets are the result of too little regulation? Introduction: Since the inception of this world, people are following rules in one way or the other. Every aspect of our lives follows a pattern. The best patterns and practices…

Words: 2933 - Pages: 12
• ###### Financial Risk Measurement for Financial Risk Management Essay

NBER WORKING PAPER SERIES FINANCIAL RISK MEASUREMENT FOR FINANCIAL RISK MANAGEMENT Torben G. Andersen Tim Bollerslev Peter F. Christoffersen Francis X. Diebold Working Paper 18084 http://www.nber.org/papers/w18084 NATIONAL BUREAU OF ECONOMIC RESEARCH 1050 Massachusetts Avenue Cambridge, MA 02138 May 2012 Forthcoming in Handbook of the Economics of Finance, Volume 2, North Holland, an imprint of Elsevier. For helpful comments we thank Hal Cole and Dongho Song. For research support, Andersen…

Words: 41696 - Pages: 167
• ###### Essay on Financial

Assigment Financial Statement Analysis Dec 2013 Prepare for: Mr. PH Tan Prepare by: Mohamed Yusri Bin Sehat ST1110537 Contents Introduction 2 Objective of paper 2 Executive summary 2 Firm, Industry, and Environment 2 Description of firm and its management 2 Discussion of competitive environment 2 Economic climate and outlook 2 Other factors, e.g. government regulations, labor relations 2 Building blocks of financial statement analysis 2 Vertical and horizontal…

Words: 1665 - Pages: 7
• ###### Financial Essay

Financial Analysis of the McDonald’s Corporation MCD, New York Stock Exchange One McDonalds Corp Plaza Dept. 332 Oak Brook, IL 60523 630-623-3154 Sheena Harper-Nelson Webster University COMPANY OVERVIEW: Brief description of the company McDonald’s is one of the largest fast food restaurants today. There are over 35,000 restaurants in 117 countries at the end of 2013. Out of those restaurants, 26,338 are franchised or licensed. That is over 80 % of the company. There…

Words: 2681 - Pages: 11
• ###### Key to Financial Reporting, Financial Statement Analysis and Evaluation

Chapter 1 An Overview of Financial Management and The Financial Environment ANSWERS TO END-OF-CHAPTER QUESTIONS 1-1 a. A proprietorship, or sole proprietorship, is a business owned by one individual. A partnership exists when two or more persons associate to conduct a business. In contrast, a corporation is a legal entity created by a state. The corporation is separate and distinct from its owners and managers. b. In a limited partnership, limited partners’ liabilities, investment returns and control…

Words: 4306 - Pages: 18
• ###### Essay Financial Health

Assessing A Company's Future Financial Health Jonathan B. Mendez FIN 504 May 7, 2014 Tanisha Morgan Assessing A Company's Future Financial Health Google is a multinational corporation that serves thousands of consumers worldwide. Through Internet related products such as Internet searches, maps, emails, mobile apps, and other online contents for users Google became the company it is today. Every employee of Google is different in his or her own way; making it a well-diversified…

Words: 2256 - Pages: 10
• ###### Essay Financial Management

customers and projects with his loan application. He also included a list of current receivables. Gupta told the loan officer that he had monitored his firm's financial status closely and that he had financial reports prepared every six months. He said that the would send a copy to the bank. In addition, he was willing to file a personal financial statement with the bank. Question: 1. Prepare your recommendation on Agarwal Cast Company Caselet 2 This case has been framed in order to test the skills…

Words: 1067 - Pages: 5