Overview:

Financial Analysis

One has recently joined a consulting firm, 3 mini cases to work on are given.

Case 1: Tele KS Solutions - An analysis of their financial statement, cash flow and taxes;

Case 2: H. E. Service Group - Ratio Analysis;

Case 3: Inv. Property - Capital Budgeting.

Data and requirements for the three cases are provided in the accompanying spreadsheet.

The first step is to examine the three cases and develop a spreadsheet model that will facilitate the analysis required for each of these companies.

Your boss has indicated that although this may be the initial list of companies, the spreadsheet model should be developed in such a way that it can easily be utilised 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.

Needed:

• A spreadsheet model for each of the cases that satisfies the above requirements.
• Flexibility and ease of use of spreadsheet model for decision making.
• A short report addressing all the questions posed in each of the case and recommendation where necessary.

A short memorandum or cover letter to your boss briefly stating the 3 cases addressed in the report to be made. One should also state any assumptions you made in the financial model.