Preparing a report on the financial analysis of a company

Assignment Help Accounting Basics

Reference no: EM13824729

Question-

Financial Investment Pty (FIP) wishes to invest long term in one or more Australian listed companies. As a financial analyst employed by the Investment department of FIP, you have been asked to assess Harvey Norman, JB Hi-Fi, and Good Guys.
Therefore your first step is to examine the three financial statements (cash-flow, Income Statement, and Balance sheet) and develop a spread sheet model that will facilitate analysis of the financial statements of these companies. You would have to consider the five groups of financial ratios in order to rank the proposed investment in these four companies. Your boss has indicated that although this may be the initial list of companies, your spreadsheet model should be developed in such a way that it can easily be utilized for other companies should the need arise. As your boss has had nasty experiences when making decisions using spreadsheet models, she would also like to be able to understand the assumptions built into the model.

The deliverables required therefore are a report containing:

• Assumptions you made in the financial model;

• A spreadsheet or other model that satisfies the above requirements;

• A short group task report of the analysis of the short-listed companies in a chosen industry in Australia, including a reasoned opinion regarding the financial health of each company.

• Given an investment (from general reserve of FIP) budget, calculate the % of capital that should be invested in each firm based on the developed financial model and the financial ratios as criteria.

• Hints: 1) use common size financial statements; 2) assign a weight for each financial ratio and compute the aggregated weight for comparison; 3) you may use the following weights or you own weights for each financial ratio.

Financial ratio	Weight
Total asset Turnover	0.20
Profit Margin on Sales	0.15
Return on Asset	0.15
Earning per share	0.15
Debt ratio	0.10
Price/Cash Flow ratio	0.05
Basic Earning Power	0.05
Current Ratio	0.05
Return on Equity	0.05
Market/ Book	0.05
Total	1.00 (i.e. 100%)

Additional information-

This question belongs to Accounting and it illustrate about preparing a report on the financial analysis of a company.

Word limit- 1600.

Reference no: EM13824729

Questions Cloud

Conviction for homicide under survival conditions : Three men and a boy were shipwrecked in a small boat 1500 km at sea in the South Atlantic. What little food they had was exhausted within a few days.

Calculation of restaurant capacity : Calculation Of Restaurant Capacity

Determine the key components of supply chain management : Determine the key components of supply chain management for the company you have selected. Determine three major issues that could affect the structuring, sourcing, purchasing, and the supply chain of your organization.

The hr department in a large company : What should be indicators for measuring the effectiveness of the HR department in a large company?

Preparing a report on the financial analysis of a company : This question belongs to Accounting and it illustrate about preparing a report on the financial analysis of a company

What is a condition precedent : What is a condition precedent? Provide me with an example.

Elizabeth works for a large appliances store in the midwest : Elizabeth works for a large appliances store in the Midwest. She has heard a rumor that employees are filmed in the restroom. Can this rumor be true? a) No, because it would violate the Privacy Act of 1974. b) No, because it would violate the Decen..

Role in identifying and solving work-related problem : Why does a learning organization have a competitive advantage over other types of organizations? For all of these reasons except a) All members take an active role in identifying and solving work-related problems. b) Intense competition lets the bes..

User Account

All Pages