Finance Ratio and Perspective Analysis

Assignment is to research, calculate, and analyze a company (which will be provided after the order is booked) in two sections and an Excel document. The first section “Financial Ratio Analysis” consists of two pages and the excel doc. The second section “prospective Analysis” will be three pages. See details below.

Please only bid if you have an understanding of this area and the calculations involved.

Financial Ratio Analysis: (2 pages, 2 sources, 1 excel doc): Analyze financial ratios and cash flow measures of the company relative to its historical performance. A 2 year look back is sufficient and required. You must use the Piotroski Method and discuss in detail the company’s profitability, capital structure, and operating efficiency based on the ratio results and comparison to its competitors. Show your calculations and use reputable sources. What trends are occurring? What are the company’s financial strengths and weaknesses? Research two (2) articles to review (one (1) of which is peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum two (2) pages APA format, include a Piotroski method in Excel of financial ratios on the selected company and at least one of its competitors.
Prospective Analysis: (3 pages, 2 sources) Create a forecast of future cash flows for the next two (2) years using the current income statement. First estimate the growth rate of revenue and expenses, to derive estimated earnings before interest and taxes. Then estimate the interest expense and tax liability to derive the net come. Develop forecasted performance measures and list the assumptions associated with your forecast. You may also cite the works of other analysts who have published forecasted earnings for the time frame you are addressing. (Hint: take a look at Yahoo/finance – analysts opinion). Discuss your findings. Research two (2) articles to review (one (1) of which is peer reviewed not more than 5 years old and one (1) current year article from a reputable website. Minimum three (3) pages.

Last Completed Projects