Income statements and balance sheets, Accounting Basics

Income Statements and Balance Sheets

Case study

A brief outline of the firm and its industry is given, as well as a few tips for your attention. You are given three years' worth of income statements and balance sheets to examine. You are a financial analyst working for an investment firm. This manufacturer has asked for your firm's help in raising capital for the upcoming season's production requirements. It is your job to analyze the financial statements and comment to the investment brokers on this firm's current financial situation. It is late July, and the firm's financial statements (representing the fiscal year ending June 30) have just been released.

For this project you must recreate the attached financial statements on separate worksheets in an Excel workbook. Then, on another worksheet, you must create formulas to calculate the financial ratios that can be derived from the given financial statements. These ratios are to be calculated using formulas in the cells that are linked to the other worksheets: no credit will be given if the ratios are calculated by hand and entered into the cells. You must determine which ratios can be calculated with the information given, based on the ratios given in your textbook. There is enough data for you to calculate liquidity, asset management, leverage, and profitability ratios. You must calculate the Du Pont ratio analysis separately. All three years' worth of ratios must be calculated, and should be presented in chronological order for you to do trend analysis.  Next, you must write a one-page paper discussing the findings of your ratio analysis. You must include not only the current situation, but also how the ratios have changed over the past three years (trend analysis). Any recommendations you can make as to what the firm can do to correct any problem areas would make you look better in the eyes of your superiors.

Posted Date: 2/15/2013 2:13:02 AM | Location : United States







Related Discussions:- Income statements and balance sheets, Assignment Help, Ask Question on Income statements and balance sheets, Get Answer, Expert's Help, Income statements and balance sheets Discussions

Write discussion on Income statements and balance sheets
Your posts are moderated
Related Questions
want to know sbp bsc rato analysis for 2010 t0 2014

Houston Corporation has the following stock outstanding:     In 2012, Houston paid $330,000 in dividends. No dividends were paid in 2011 or 2010. Required : a)

Q. LIFO under periodic inventory procedure? The LIFO (last-in, firstout) method of inventory costing presume that the costs of the most recent purchases are the first costs cha

Critique the Ethics of those involved in the News of the World phone hacking scandal. Demonstrate in your critical analysis how the use of Ethics by the parties involved could have

Hello, I work in the Events Department for a country club in Rhode Island. We are trying to figure out the following question for an invoice: A restaurant bill is $18.50 and inclu

Given a net income of $90,000, what is the return on investment for 2000? A. 7.9% B. 22.22% C. 22.78% D. 24.8%

Q. Example of horizontal analysis? Several companies have been restructuring their organizations and reducing the number of employees to cut expenses. AT&T, General Motors, IBM

introduction,features,objectives,types of branches,difference between branches and departments

Kim presently owns a business that processes and distributes fresh vegetable to local supermarkets. She is looking to expand her business by acquiring the Lackawaxen Emu Oil Compan

PRICE FOR A 3-6 PAGE PAPER IN APA FORMAT