# 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 : The 2007 Financial Crash

The 2007 financial crash was the most impactful financial event since the Great Depression. Many of its effects are still being felt today; however many people do not understand what actually happened or how it happened. The Causes of the financial crash were a combination of mortgage-backed assets and debt. Following the second world war, housing prices have been on an upward trend. It started in the 1980s when financial institutions realized that mortgages had a greater potential. These traders…

Words: 1839 - Pages: 8
• ###### Essay Financial Statement Analysis And Financial Analysis

in knowing the financial health and financial soundness of the business. Financial statement analysis or financial analysis is the process of reviewing and analyzing a company’s financial statements to make better economic decisions. These statements include the income statements, balance sheet, statement of cash flows and a statement of retained earnings. Financial statement analysis is a method or process involving specific techniques for evaluating the risk, performance, financial health and future…

Words: 1772 - Pages: 8
• ###### Essay Financial Access And Understanding Financial Services

Having financial access and understanding financial services and which to choose from are extremely important for economic success. Unfortunately, financial literacy and access to these services are a major concern for immigrants in the United States. Many families immigrate in search of economic security and financial opportunities, but are the necessary steps being taken to provide this key component to achieving the “American Dream” to immigrants and their families? Access to financial services…

Words: 713 - Pages: 3
• ###### Essay Financial Statements And Financial Ratios

Financial Statements and Financial Ratios Income Statement The income statement is a financial statement which is prepared by Accountants to show a company’s revenues, expenses, and income over time. It is also referred to as a profit and loss statement. The bottom line (net profit) on the income statement is calculated as net profit = revenue – costs. The major types of expenses that are sown on the typical income statement are cost of goods sold, operating expenses –selling, operating expenses…

Words: 1124 - Pages:
• ###### Essay Financial Crisis Response For Financial Institutions

Cansu Cebeci James H. Mccann Financial Management 26 February 2015 Financial Crisis Response There are no financial markets immune to the sweeping changes for financial institutions as a direct response to the financial crisis of September 2008. The U.S. Congress very hastily set to work and developed a Trouble Asset Relief Program, or bailout of some of the largest financial businesses in the United States. The initial bank bailout was to cost American taxpayers in excess of \$350 million, and…

Words: 980 - Pages: 4
• ###### Essay Financial Analysis On Financial Wellbeing

There is no doubt that financial wellbeing is a key component of human happiness. Financial planning could help us to enhance our financial well-being through the set-up of financial goals and associated strategies to achieve these goals. When I propose my financial goals in the future fifteen years, I have to make trade-offs among so many life events. This financial narrative includes ten main aspects of my financial positions in the future fifteen years. Family Status and Job/Salary/ Benefits…

Words: 1087 - Pages:
• ###### Essay Financial Statement Fraud : Financial Statements

Financial Statement Fraud Company financial statements provides information that is utilized by investors to evaluate the conduct of managers and to compose economic arrangements (Chinniah, 2015, p. 1). The consumers of the financial statement may consider the financial information received as dependable and appropriate for its function (p. 1). Chinniah indicates accounting standards and regulations have been put in place to try to certify the financial information provided is consistent with…

Words: 1706 - Pages:
• ###### Essay Financial Markets And The Financial Market

A financial market can be defined as a marketplace where assets such as equities, bonds, currencies and derivatives are traded between buyers and sellers. Financial markets are also known to have the following characteristics, transparent pricing, conditions and regulations on trading, fees and costs (Investopedia). Bonetti and Cobham (1992) state that financial markets can be seen as a system which allows ultimate lenders also referred to as the economic agents to lend money ultimate borrowers…

Words: 2530 - Pages: 11
• ###### Essay Financial Failure Of Financial Distress

INTRODUCTION Financial failure is a company’s inability to fulfill their debt requirements; thus, going into bankruptcy; experiencing liquidation and other form of asset seizure and distribution. A company’s financial failure is often a creditor’s delight; however, in order for all companies to operate and grow, they must, in one way or another, have some form of debt. An organized and duly structured business plan will always involve a financial plan that includes both short term and long term…

Words: 785 - Pages: 4
• ###### Essay Financial Planning For Financial Management

According to Glenn Stevick, financial planning process has six steps: “establish financial goals, gather relevant data, analyze the data, develop a plan for achieving goals, implement the plan and finally, monitor the plan” (Stevick, 2006). It is imperative for a business to have and use because without establishing goals and managing where money is being expended, those goals may end up being obsolete and as a result, a closed business. In order to accomplish these six steps, there are two fundamentals…

Words: 761 - Pages: 4