Prepare A Report Based On Financial Analysis


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


Total asset Turnover


Profit Margin on Sales


Return on Asset


Earning per share


Debt ratio


Price/Cash Flow ratio


Basic Earning Power


Current Ratio


Return on Equity


Market/ Book



1.00 (i.e. 100%)



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


  • HWA

    this is a very good website

  • HWA

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

  • HWA

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

  • HWA

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

  • HWA

  • HWA

    This solution is perfect ...thanks

  • HWA

    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

    Perfect bank of solution. 

  • HWA

    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

    works fine.