Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have been hired as a financial analyst at Morgan Corporation. Your responsibilities are to assist in the construction and interpretation of the financial statements

You have been hired as a financial analyst at Morgan Corporation. Your responsibilities are to assist in the construction and interpretation of the financial statements and communicate on the overall results of the company. You will be reporting to the senior management team of Morgan. During your first few weeks with the company, you have heard about big plans for a new product line. In the past, Morgan has always sold sporting goods and equipment. However, management wants to begin selling clothing and other apparel items starting this year. Morgan is expecting you to accomplish three specific items in the near future:

1. Create comparative financial statements for 2010 and 2011

.2. Perform select ratio analysis on these financial statements . 

3. Take assumptions from management for this new clothing line and construct a Pro Forma income Statement for 2012. Basically, you want to give management an idea of what the company could look like after 2012 from a sales and profit perspective if their assumptions prove correct. Remember that pro forma statements forecast the future.4. You are encouraged to be creative. However, be sure to follow good financial statement format. Refer to your textbook for samples for using proper formats to create financial statements. Deliverable Descriptions: . 

Part 1: Construct Comparative Multistep Income Statements and Balance Sheets You will take various account balance information from Morgan for the past 2 years, interpret the accounts, and then construct Comparative Multistep Income Statements and Classified Balance Sheets for 2010 and 2011. •You will then take these statements and use them to create a Statement of Cash Flows for 2011.This should be handed in as an excel spreadsheet (s). 

• Part 2:Five Ratios and Interpret your results You will take the completed financial statements from ratio Analyses on Profit Margin, Current Ratio, Receivables Turnover, Inventory Turnover, and Return on Assets. After completing the 5 ratios interpret your results and communicate them in a report to management Describe the strengths and weaknesses of the company based on your evaluation of the financial statements and ratios. Part 3: Create a Pro Forma Income Statement • Using the 2011 Income Statement you completed, take the current year 2012 assumptions from management to construct a Pro Forma Income Statement .

Step by Step Solution

3.48 Rating (164 Votes )

There are 3 Steps involved in it

Step: 1

Solution Multistep Income Statement 2010 2011 Sales 3600000 3300000 Less Cost Of Goods Sold 2300000 2250000 Gross Profit 1300000 1050000 Less Operating Expenses Selling Administrative expenses 650000 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

14th edition

1285867971, 978-1305480742, 1305480740, 978-0357686393, 978-1285867977

More Books

Students also viewed these Accounting questions

Question

Calculate the missing value.

Answered: 1 week ago