Solution Library

Prepare A Report Based On Financial Analysis

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%)

           

Summary

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

Total Word Count 1583

Download Full Solution

Comments

  • HWA
    Rasha

    this is a very good website

  • HWA
    maani

    I have 50 questions for the same test your page is showing only 28

  • HWA
    joeanne

    hi can you please help or guide me to answer my assignments. thanks

  • HWA
    joeanne

    hi can anyone help or guide me to my assignments. thanks

  • HWA
    Monik


  • HWA
    Cristina

    This solution is perfect ...thanks

  • HWA
    Janete

    Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes

  • HWA
    Sandeep

    Perfect bank of solution. 

  • HWA
    Oxana

    great !

  • HWA
    Paul Brandon-Fritzius

    thanks for the quick response. the solution looks good. :)

  • HWA
    tina Johnson

    thnx for the answer. it was perfect. just the way i wanted it. 

  • HWA
    Giuseppe

    works fine.