Summarize the information from the 3 years’ financial statements, the ratio calculations, and industry comparisons provided in the case to present possible solutions to the company’s profitability problems.

Summarize the information from the 3 years’ financial statements, the ratio calculations, and industry comparisons provided in the case to present possible solutions to the company’s profitability problems. Be sure to conclude with projecting the future success of the company based on your findings.

Explain the relationship between financial statements and why it is useful for managers to understand all three.

Statement of earnings, a statement of retained earnings

Use the reading on preparing financial statements provided in the course pack, the course text chapter examples to prepare these statements.

Various balance sheet and statements of earnings accounts for Home Restoration Outlet Ltd. are listed below in random order. You will have to determine which account goes in which statement to solve the questions.

The balance sheet accounts are as of December 31, 2005, except as noted. The statement of earnings amounts are for the year January 1 to December 31, 2005. All accounts are shown in thousands of dollars.

1) Prepare a statement of earnings, a statement of retained earnings, and a balance sheet.

2) Explain the relationship between financial statements and why it is useful for managers to understand all three.

3) Perform a “current ratio” analysis for the company and explain the company’s liquidity position.

Balance sheet and statement of earnings accounts

Cash $40
Retained earnings, Dec 31, 2004 $255
Inventory, Dec 31, 2004 $425
Note payable, due Feb 2006 $25
Selling expenses $482
Accounts payable $85
Accounts receivable $104
Sales $2,409
Income tax rate 50%
Building and equipment, cost $150
Dividends $70
Total Long term loan, due June 2015 $110
– 2006 portion $10 ($10 of the $110)
Purchases $1,304
Income tax payable $25
Marketable securities $30
Depreciation expense, building and equipment $23
General and administrative expenses $215
Cost of goods sold $1,419
Goodwill $85
Other expenses, interest $20
Prepaid expenses $42
Common stock $130
“Accumulated depreciation,
build. & equip. Dec 31, 2004” $53

Discuss why an understanding of ratios and their fluctuations is essential for Hotel management in analysing the information seen in their financial statements.Discuss the benefits and limitations of using ratio analysis to aid decision making within the hotel and tourism industry.

International hotel management-Financial Management for the Hotel Industry

Calculate suitable ratios for 2019 and 2020 to aid the analysis of the financial information included within the attached financial statements. You should discuss the trends seen in these ratios in detail, and draw appropriate conclusions about the profitability, liquidity and gearing of the hotel chain.

Discuss why an understanding of ratios and their fluctuations is essential for Hotel management in analysing the information seen in their financial statements.

Discuss the benefits and limitations of using ratio analysis to aid decision making within the hotel and tourism industry.

What did the company mention as Events after the reporting period? Did the company change its accounting policy during the period covered by its financial statements?

Advanced Financial Reporting

Did the company change its accounting policy during the period covered by its financial statements?

Did the company correct an accounting error during the period covered by its financial statements? If yes,include details.

What did the company mention as Events after the reporting period?

What are the areas the company recognised provisions for?

What are the areas the company disclosed as its contingent liabilities?

Did the company disclose any contingent assets? If yes, include details.

Did the company acquire a new subsidiary in the period covered by its financial statements? If yes,  include the names of subsidiaries acquired (or, if this is not explicitly stated, the number of subsidiaries acquired) and describe what the company discloses about these acquisitions.

What is the web address that leads to your financial reports?Why are you interested in this company?

Find an annual report for a company of interest (perhaps your employer). Publicly held company annual reports (10K) can be located via Edgar Archives on the Security and Exchange website.

To perform the search in the Edgar Archives you can use either the company name or “ticker symbol” for the company. [View instructions on how to access the annual reports]

Click on the link to “Interactive Data” and then the link to the “Financial Statements”. Locate and review the Income Statement and Balance Sheet. Title your post with the name of your company and share the following in your post:

What is the name of your company?

What is the web address that leads to your financial reports?

Why are you interested in this company?

Calculate the debt ratio.

What have you learned from this analysis?

In 50-100 words each, provide an analysis overview for both the projected financial statement and balance sheet.

Financial Statements

Description

Refer to and follow the steps given in Chapter 8 of the David text to learn how to complete financial statements.

Apply current acceptable financing percentages afforded your CLC group’s company according to the Standard and Poor’s or Moody’s rating (PetMed Inc.).

Make any other assumptions necessary for this segment of the project.

Assume that the firm needs to secure capital to implement the strategy your team proposes to recommend.

Use the information gathered above to prepare a projected income statement and balance sheet for the firm.

In 50-100 words each, provide an analysis overview for both the projected financial statement and balance sheet.

What is your assumption about financing of capex and change in working capital??What model you would like to use stable growth, two periods or three period growths???

Finance valuation of En+ group

The Final Assignment

1. Find and download financial statements for 5-7 years.  put the data in excel file. Put Income statement data (for different years in one sheet, the balance sheet data in another, the same for the cash flow data… make sure that data are consistent through year (so that you can do horizontal analysis)

2. In addition download market data for the target (P/E, MV/BV, stock prices) + multiples for similar firms (peers)

The idea is

• Value your company by two methods
1) Discounted CF method
2) Relative valuation (using multiples)

• Compare your results with the market price

 

For discounted cash flow approach
• What model you would like to use stable growth, two periods or three period growths??? To decide you need to check if company is mature or growing.

• In case you see that the company’s current growth (EPS, sales) above 2%-3% (above the industry average, fluctuate a lot) you have to use either two or 3 stage growth model

• Project cash flow for the period of unstable growth (use percentage of sale method to project financials)

• Estimate the terminal value at the end of the period of unstable growth ( using formula for growing perpetuity)

• Think of the discount rate you would like to use to compute PV of cash flow. Different rate for different stage of growth? Or the same???

• Remember discount rate will depends on the capital structure of the firm, (If country significantly changed its D/E ratio in recent period you

have to use industry average as a target structure and use it for calculation of discount rate for stable growth period) You may ned to adjust cash flow as well to reflect this changes

• Do not forget to make assumptions about growth rate of capex, depreciation in different periods of growth (you might look at industry peers data). They should align with your projections of sales.

• What you would like to value 1) entire firm (FCFF) or only equity part (FCFE or Dividend)

• Use WACC for firm valuation, required rate of return for equity for equity valuation
For equity valuation

• Dividend discount model or) Free cash flow to the equity.

• This depends on if company pays dividends, whether they are stable and some other factors ( imagine you purchase a big stake of the equity and you can influence the firm decision on dividends, in this case you should use FCFE)

• How to estimate the growth rate of dividend and growth rate of FCFE (ratios using historical average, industry average)

• What is your assumption about financing of capex and change in working capital??

• After computing value of equity you will add MV of debt to get your own estimate of the value of the firm. Remember you will compute enterprise value (PV (Future CF to the equity)+Debt)).

Valuation of FCFF will give you the enterprise value.

• If your company change its capital structure one way to avoid mistakes is to use FCFF, (at least you do not need to adjust FCFE)

• Still if you think that the current capital structure will not sustain in the future you should adjust WACC.

• To compare your results with market value

• Market price of the stock x Nmb of stocks outstanding + MV(Debt) – Cash =Enterprise value

For relative valuation, you need to do is to decide which multiple is more relevant in your case.

Questions to keep in mind

• Equity multiples versus Firm multiples

Rem: Firm value multiples allow for direct comparison of different firms, regardless of capital structure.

• EBITDA (both equity of firm)multiple is one of the most commonly used valuation metrics, as EBITDA is commonly used as a proxy for cash flow available to the firm.

• When a company has negative EBITDA, the EBITDA and EBIT multiples will not be material. In such cases, Sales multiple may be the most appropriate multiple to use.

• When depreciation and amortization expenses are small, as in the case of a non-capital-intensive company such as a consulting firm, EBIT and EBITDA will be similar.

• For the sake of consistency (because you want to compare both DCF and relative valuation results), if you value FCFF, use the multiples that estimate the value of the firm, if you estimate the value of equity FCFE, use the equity multiples.

Provide a background of the firm, industry, economy, and outlook for the future.Analyze the short term liquidity of the firm.

Fundamental financial analysis

Description

Prepare an eight page or more fundamental financial analysis (excluding appendices, title page, abstract, and references page) that will cover each of the following broad areas based on the financial statements of your chosen company:

1. Provide a background of the firm, industry, economy, and outlook for the future.

2. Analyze the short term liquidity of the firm.

3. Analyze the operating efficiency of the firm.

4. Analyze the capital structure of the firm.

5. Analyze the profitability of the firm.

6. Conclude with recommendations for the future analysis of the company (trend analysis).

Writing the Final Paper

The paper

Eight double-spaced pages in length (not including title and references pages) and formatted according to APA Style 7

Must utilize academic voice.