StudentShare solutions
Triangle menu

Financial Analysis and Forecasting - Coursework Example

Not dowloaded yet

Extract of sample
Financial Analysis and Forecasting

analysis shows that there exist a perfect relationship between sales and assets. The value of R-square is 1 this shows a perfect relationship that will produce a best-line-of fit that passes through the origin. The proportionality assumption that the value of assets increases proportionally with sales is therefore, holds, and is true. B) Repeat the part a regression analysis assuming the given data. Under these conditions, does it appear that the proportionality assumption holds true? Explain. From the results obtained below, the R squared value is 0.906304 this shows a good relationship because the R square value tends to 1, which is usually a perfect relation. SUMMARY OUTPUT Regression Statistics Multiple R 0.952 R Square 0.906304 Adjusted R Square 0.875073 Standard Error 4.495916 Observations 5 ANOVA   df SS MS F Significance F Regression 1 586.5602 586.5602 29.01858 0.012533 Residual 3 60.63978 20.21326 Total 4 647.2         Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -50.9698 16.52736 -3.08396 0.053968 -103.567 1.627654 -103.567 1.62765 X Variable 1 3.246979 0.602756 5.38689 0.012533 1.328741 5.165216 1.328741 5.16522 From the above evaluation, it is clear that the best-line-of fit does not pass through the origin making the assumption not to hold true for sales and assets analyzed. This is because there is no close association between the dependent and independent variables in the study. C) Which of the preceding situations is likely to hold for most firms? What implications does your answer have for use of the percentage-of-sales-method? From the above situations, both cases have close range on R-square but the first is preferred most. The first situation is likely to hold for most firms because each firm will try as much as possible to ensure there is a good correlation between sales and assets. Any imbalance on these two variables may lead to collapse of the business because there might be too much expense in relation to company assets. Such a situation may result because of poor management and control of measures and standards. R is a measure of goodness of fit. Quantities neighboring 1 show a very suitable good fit. When the firm’s R is squared, it illustrates the percentage of changeability of y accounted for by x.In some other terms, most firms tend to ensure that their R-Square value stays or should not go below 0.95, as this will account for 95% of the changeability in y with respect to x. In business, usually an R-square values more than 0.9 are preferred, but it is essential to mark that even when a firm has an R-square value of 0.35, this implies that x is still demonstrating a considerable percentage of the y trait. Nevertheless, those below 0.5 are taken as somewhat inadequate for bivariate evaluation, since the related error is so wide. Multivariate analysis for firms is however, different. In addition, when applying mathematical associations to forecast y given x, then the pact is to present an error = 2 ? SSE, but this resolution is not often the case. Implications on use of the percentage-of-sales-method Percentage-of-sales-method is an approach of forecasting cash needs by stating revenues and costs as percentage of sales, and from these percentages to develop a pro forma income statement. While predicating financial information ...Show more


Financial Analysis and Forecasting Name Institution Financial Analysis and Forecasting A) Does it appear that the proportionality assumption holds true? Explain. SUMMARY OUTPUT Regression Statistics Multiple R 1 R Square 1 Adjusted R Square 1 Standard Error 1.03226E-15 Observations 5 ANOVA   df SS MS F Significance F Regression 1 160.1971 160.1971 1.5E+32 1.2E-48 Residual 3 3.2E-30 1.07E-30 Total 4 160.1971         Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 3.55271E-15 1.6E-15 2.216969 0.113363 -1.5E-15 8.65E-15 -1.5E-15 8.65E-15 X Variable 1 0.5 4.08E-17 1.23E+16 1.2E-48 0.5 0.5 0.5 0.5 From the results obtained above, the regression…
Author : kaseykautzer
Financial Analysis and Forecasting essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the coursework on your topic
"Financial Analysis and Forecasting"
with a personal 20% discount.
Grab the best paper

Related Essays

Financial Analysis
Dividend policy is the making of a decision to either paying cash dividends at a later period or at the present time. Dividends are also paid in stock dividends because they do not provide liquidity to stockholders or investors but create capital gains. According to Modigliani and Miller, they believe that capital gains and current dividends are not investor’s preferences.
6 pages (1500 words) Coursework
Managing Finance: Financial ratio analysis
The first two sections of the paper focuses on analyzing the financial soundness of Barney Bakes plc as well discuss some the management practices that should be adopted to enhance the profitability of the organization. This includes beyond budgeting and corporate governance.
15 pages (3750 words) Coursework
Tesco Plc Financial Analysis
Tesco is well known of being the most successful operator in retail groceries and merchandise in the UK. It is rated as the third largest retailer in the world. Tesco also owns fourteen stores with a wide variety. The main reason for the success of Tesco is the various products they deal in, popular products and the brand preferences.
8 pages (2000 words) Coursework
Strategic planning and Financial Analysis Ratios
Strategic planning and Financial Analysis Ratios Customer’s name Institution Instructor’s Name: Course Name Strategic Planning and Financial Analysis Ratios Strategic planning is the process of developing and maintaining consistency between the organizational objectives and resources and its changing opportunities.
3 pages (750 words) Coursework
Financial Analysis of Burberry Group Plc

This report shall carry out a financial analysis and equity valuation of Burberry Group Plc using information from its financial statements for the four-year period ended on 31st March 2012. The researcher analyzes the importance of income statement vis-à-vis that of the balance sheet as the primary financial statement from the perspective of an equity investor.

14 pages (3500 words) Coursework
Managing Financial Principles and Techniques
Based on the nature of the company activities, We recommended convertible debts as a means to finance new investment opportunities. This security remains a mainstream choice of most academic and financial practitioners. The empirical evidence of this model is supported from the fact that it has an attractive feature based of a capital market equilibrium and value maximisation argument.
32 pages (8000 words) Coursework
Financial and Strategic Planning
The patient turnout is currently lower than expected. This can be attributed to the fact that there is a reduced number of patients coming for return services. This points out to either of two
2 pages (500 words) Coursework
Financial and Strategic Planning1
The company’s current ratio is generally good, above 1. A current ratio of more than 2 means the company has the ability to pay off twice the value of its current liabilities should they become due at any given point within
2 pages (500 words) Coursework
Financial Reporting & Analysis
The IASB Conceptual Framework elaborates on the main typical concepts that underlie the design and preparation of statements. The main idea behind the introduction of the conceptual framework lies in the provision of the structure for creating accounting standards that act as the main center for resolving emergent accounting disputes.
6 pages (1500 words) Coursework
Financial analysis in healthcare
It is highly important that prudent management of the financial resources of a firm be practiced in order to achieve effectiveness of the organizations performance in the end. The financial stability of a firm determines its
3 pages (750 words) Coursework
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation