Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Financial Accounting Expert

Attach case presents a small manufacturer of sporting goods. A concise outline of the firm and its industry is given, and a few tips for your attention. You are given three years’ worth of income statements and balance sheets to inspect.

You are a financial analyst working for the investment firm. This manufacturer has asked for your firm’s assist in raising capital for the forthcoming season’s production requirements. It is your job to analyse the financial statements and comment to investment brokers on this firm’s present financial situation. It is late July, and the firm’s financial statements (representing fiscal year end June 30) have just been released.

For this project you should reconstruct the attached financial statements on separate worksheets in an Excel workbook. Then, on one more worksheet, you should create formulas to compute the financial ratios that can be derived from the given financial statements. These ratios are to be computed using formulas in the cells that are linked to the other worksheets: no credit will be given if the ratios are find outd by hand and entered into the cells. You must determine which ratios can be computed with the detail given, based on the ratios given in your textbook. There is sufficient data for you to compute liquidity, asset management, leverage, as well as profitability ratios. You must compute the Du Pont ratio analysis separately. All three years’ worth of ratios should be computed, and must be presented in chronological order for you to do trend analysis.

Next, you should prepare a paper discussing the findings of your ratio analysis. You should include not only the present situation, but also how the ratios have changed over the precedent 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.

 

Outdoor Sports, Inc.

Outdoor Sports, Inc. is a manufacturer of wind surfers, surfboards, and related equipment. The company was started by two surfers tinkering in their garage with surfboards of their individual design. The company has grown speedily, cashing in on the growing popularity of wind surfing.

Outdoor Sports’ business is highly cyclical. Inventory is built up throughout the late fall and winter months, and the majority of sales are booked and delivered to distributors throughout the early spring. Competition between the many manufacturers of this easily made product line is intense.

Small manufacturers like Outdoor Sports are under great pressure from main sports equipment makers, who have substantial promotional resources at their disposal, and complementary products, countercyclical to the sale of surfing equipment. Brand recognition is a significant selling point in this competitive business, achieved at considerable expenditure through sport personality endorsements and other promotional campaigns.

What to anticipate from Outdoor Sports’ financials depends on when they are examined throughout the fiscal year. At June 30, the company’s fiscal year-end, the financials must look most favourable. Receivables, inventory, payables, and working capital borrowings must be at seasonal lows. The firm must be cash rich, as it is about to gear up for the next season’s production run. Property, plant and equipment must be at some significant level commensurate with the company’s manufacturing demands, supported by equity and long-term debt.

Sales margins bear close watching. Pricing pressures caused by the intense competition can erode them to dangerously low levels. Given the seasonality of the business, there might be a cash flow crunch throughout the winter months. Entire, cash flow might be a problem if the business is still growing speedily, and requires outside financial resources to do so.

The potential of overproducing throughout the winter period for a spring sales period that fails to live up to management’s anticipations is also a significant risk.

 

 

OUTDOOR SPORTS, INC.

 

 

 

 

 

 

Balance Sheet ($000s)

 

 

 

 

 

 

June 30, 2011

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2009

 

2010

 

2011

ASSETS

 

 

 

 

 

 

Current Assets

 

 

 

 

 

 

 

Cash

 

182

 

25

 

30

 

Accounts Receivable

 

338

 

391

 

349

 

Inventory

 

283

 

831

 

1,207

 

Prepaid Expenses

 

63

 

33

 

11

 

Other Current Assets

 

11

 

8

 

3

 

 

Total Current Assets

877

 

1,287

 

1,601

 

 

 

 

 

 

 

 

 

Propert, Plant & Equipment

 

 

 

 

 

 

Land, Buildings & Equipment

842

 

842

 

941

 

Less Accumulated Depreciation

179

 

226

 

286

 

Net land, Buildings & Equipment

663

 

616

 

655

 

 

 

 

 

 

 

 

 

Total Assets

 

 $   1,540

 

 $   1,903

 

 $   2,255

 

 

 

 

 

 

 

 

 

LIABILITIES

 

 

 

 

 

 

 

Accounts Payable, Trade

129

 

283

 

347

 

Accounts Payable, Other

80

 

52

 

61

 

Accrued Expenses

 

0

 

0

 

0

 

Short-Term Debt

 

184

 

413

 

745

 

Income Tax Payable

 

61

 

0

 

0

 

 

Total Current Liabilities

454

 

748

 

1,152

 

 

 

 

 

 

 

 

 

Long-Term Debt

 

578

 

682

 

869

 

 

Total Liabilities

 

1,031

 

1,430

 

2,021

 

 

 

 

 

 

 

 

 

Stockholders' Equity

 

 

 

 

 

 

 

Capital Stock

 

275

 

275

 

275

 

Retained Earnings

 

234

 

198

 

(41)

 

 

Total Stockholders' Equity

509

 

473

 

234

 

 

 

 

 

 

 

 

 

Total Liabilities and Equity

 $   1,540

 

 $   1,903

 

 $   2,255

 

Outdoor Sports, Inc.

 

 

 

 

 

Income Statement ($000s)

 

 

 

 

 

June 30, 2011

 

 

 

 

 

 

 

 

 

 

 

 

 

2009

 

2010

 

2011

Sales

2,519

 

4,914

 

6,185

Cost of Goods Sold

1,460

 

2,899

 

4,172

 

Gross Income

1,059

 

2,016

 

2,013

 

 

 

 

 

 

 

Operating Expenses

732

 

1,898

 

2,060

Depreciation Expense

30

 

47

 

61

 

Operating Income (EBIT)

297

 

72

 

(107)

 

 

 

 

 

 

 

Interest Expense

72

 

107

 

132

Income Tax Expense

90

 

0

 

0

Other Expense

47

 

0

 

0

 

 

 

 

 

 

 

Net Income

 $      89

 

 $     (36)

 

 $    (239)

Financial Accounting, Accounting

  • Category:- Financial Accounting
  • Reference No.:- M91664

Have any Question? 


Related Questions in Financial Accounting

1 wellplace hospital provides you with the following

1. Wellplace Hospital provides you with the following financial statements for 20X2 and 20X1: December 31 20X2 20X1 Cash $ 168 $ 211 Temporary investments 126 34 Receivables-patients, net 1,011 893 Inventory 296 315 Prep ...

Assignmentsqueezed by rising costs a confectioner struggles

Assignment Squeezed by Rising Costs, a Confectioner Struggles to Cope Telford James and his wife Ivey are the second-generation owners of James Confectioners, a family-owned manufacturer of premium chocolates that was st ...

Assignmentuse the following information for questions 1

Assignment Use the following information for Questions 1 through 5: Assume you are presented with the following mutually exclusive investments whose expected net cash flows are as follows: EXPECTED NET CASH FLOWS: Year P ...

Exxon versus chevronaccording to the textbook the income

Exxon versus Chevron According to the textbook, the income statement measures the success of a company's operations for a given period. The income statement is important to investors and creditors, because it determines ...

Assignment ccr report amp power point presentationrefer to

Assignment: CCR REPORT & POWER POINT PRESENTATION Refer to www.agacgfm.org for information on the CCR. A CCR is a 4 page document summarizing information and creating a presentation for citizens and other stakeholders. A ...

Financial statement analysismy company is walmartpart

Financial Statement Analysis My company is Walmart. Part I • Perform at least one profitability ratio to measure the income and operating success of your selected company. • Perform at least one liquidity ratio to measur ...

Assignmentangies empanadas cvp and cost behaviortired of

Assignment Angie's Empanadas: CVP and Cost Behavior Tired of the corporate life Angie opened Angie's Empanadas in on April 1st near a large university campus. She had long been told that her empanadas were the best in to ...

Qualified stock purchaseabc corporation acquired 20 of xyz

Qualified Stock Purchase ABC Corporation acquired 20% of XYZ Corporation on January 2, April 1, June 1, October 1 and December 31 of the year 20x1. a. Has a qualified stock purchase taken place? How long does ABC Corpora ...

Hanson company is constructing a building construction

Hanson Company is constructing a building. Construction began on February 1 and was completed on December 31. Expenditures were $1,872,000 on March 1, $1,236,000 on June 1, and $3,008,500 on December 31. Compute Hanson’s ...

Excel project instructionsassume abc company has asked you

EXCEL PROJECT INSTRUCTIONS Assume ABC Company has asked you to not only prepare their 2015 year-end Balance Sheet but to also provide pro-forma financial statements for 2016. In addition, they have asked you to evaluate ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro