Prepare a report analysing the performance

Assignment Help Financial Management
Reference no: EM132474228 , Length: word count:1200

Assignment - Finance for Managers

You first need to choose a company for the analysis.

You need to access the companies' financial statements. A simplified version is available via the database Amadeus which is available to you after signing in with your university details. Search for Amadeus in the university catalogue

search for Amadeus
and choose the Amadeus database, online access
Then click onResource available at amadeus
Log in using your university details
Then enter your company name.
Select the worksheet view at the top of the Global standard format section, you can then open the file in excel.

Please compute the ratios yourself rather use than the ones provided. Do not worry if yours are different.

Most of the data you will need will be provided in the income statement and statement of financial position in the accounts you have retrieved. Other data you need, such as end of year market price, number of shares outstanding etc, is accessed by clicking on stock data and then Annual stock data.

The data you require (including an explanation of the item name if it is different from what we have used in lectures) is as follows
Operating profit (EBIT) (operating P/L)
Gross profit
Cost of goods sold
Operating Revenue (turnover)
Financial expenses (interest)
Net profit (P/L for period, net income)
Shareholders funds (capital and reserves)
Stock (inventory)
Debtors (accounts receivable)
Creditors (accounts payable)
Long term debt (do not use non-current liabilities)
Market price
Number of shares outstanding
Market capitalisation

Please note that the format often shows the total at the top with the breakdown below

Required

For shareholder funds you should just use the top figure ie €630,007 (000s). Docheck the units the figures are given in as they can differ. Also note that the financial statements are given in € but the annual stock data is given in £ so you need to find the conversion rate on the relevant dates and convert one of them if they are in different currencies.

For the dividend per share please see the end of this document.

Calculating appropriate accounting ratios prepare a report analysing the performance of and comparing the performance of the companyover the last 2 years under the following headings:
a) Profitability,
b) Liquidity,
c) Working capital management,
d) Solvency & risk,
e) Shareholder return,
f) Overall financial performance.

The word count is 1,200 words

Attachment:- Finance for Managers.rar

Reference no: EM132474228

Questions Cloud

What was the observed coffee sales value : Managers of an outdoor coffee stand in Coast City are examining the relationship between (hot) coffee sales and daily temperature, hoping to be able
Prepare the table showing the yearly depreciation : The equipment is expected to last 5 years. Prepare the table showing the yearly depreciation, accumulated depreciation, and net book value of the equipment
Determine the amount of estimated uncollectible accounts : Determine the amount of estimated uncollectible accounts receivable at the end of 2018. estimate bad debt expense at the end of each accounting year
Discuss the various concepts of descriptive statistics : Discuss the various concepts of descriptive statistics we use to describe our sample and the center of the sample.
Prepare a report analysing the performance : Calculating appropriate accounting ratios prepare a report analysing the performance of and comparing the performance of the companyover the last 2
What is an arithmetic mean : What is an "arithmetic mean" ? Does it have the same meaning as the word "average"? Explain
Value of the slope of the least-squares regression line : What is the value of the slope of the least-squares regression line for these data? (Round your answer to at least two decimal places.)
How has caused a discrepancy in the account : During bank reconciliation Kevin finds that his company's account has earned interest that has caused a discrepancy in the account.
Prepare the necessary journal entries on Bat books : Bat, a U.S. corporation, anticipates a contract based on December 2, 2016, Prepare the necessary journal entries on Bat's books to account for forward contract

Reviews

Write a Review

Financial Management Questions & Answers

  Forecasting interest rates based on prevailing

forecasting interest rates based on prevailing conditions.consider the prevailing conditions for the following factors

  Yield to maturity on this bond when it was issued

Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1,000, and a coupon rate of 7.9% (annual payments). The yield to maturity on this bond when it was issued was 5.5%. What was the price of ..

  Determine what is the current price of the bond

16 years ago, Blue Lake Corp. issued 30 year to maturity zero-coupon bonds with a par value of $5,000.

  What return are shareholders expecting

The dividend is expected to grow at a rate of 0.7%. At a current stock price of $14.35, what return are shareholders expecting.

  Analyze the year-to-year change in account balance

Analyze the year-to-year change in account balance for at least five financial statement line items.

  Describe multi-level modeling

Describe multi-level modeling. Using formulas show the connection between multi-level modeling and regression analysis.

  What is the addition to retained earnings

Billy’s Exterminators, Inc., has sales of $592,000, costs of $284,000, depreciation expense of $36,000, interest expense of $28,000, a tax rate of 35 percent and paid out $63,000 in cash dividends. What is the addition to retained earnings?

  What is its cost of common equity and its WACC

The last dividend was D0 = $2.50, and it is expected to grow at a 7% constant rate. What is its cost of common equity and its WACC?

  Purchasing new equipment to replace existing equipment

Urban-Gym Inc.is considering purchasing new equipment to replace existing equipment that has book value of zero and market value of $75,000 today

  What is the firm equity cost of capital

The A corporation is a firm with regular free cash flow $60,000 and no corporate tax. A uses $300,000 OF 10% DEBT financing and the equity cost of capital to unlevered firm the same risk classes is 12%. What is the value of the firm ? What is the fir..

  Calculate balance of the performance bond account

Assume today's settlement price on a CME EUR futures contract is $1.3140/EUR. You have a short position in one contract.

  Value of the company due to expected bankruptcy costs

Dragula, Inc., has debt outstanding with a face value of $5 million. The value of the firm if it were entirely financed by equity would be $18 million. The company also has 390,000 shares of stock outstanding that sell at a price of $37 per share. Th..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd