Ratio Analysis at S&S Air, Inc.
Chris Guthrie was recently hired by S&S Air, Inc., to assist thecompany with its financial planning and to evaluate the company’sperformance. Chris graduated from college five yearsago with a finance degree. He has been employed in the financedepartment of a Fortune 500 company since then.
S&S Air was founded 10 years ago by friends MarkSexton and Todd Story. The company has manufactured andsold light airplanes over this period, and the company’s productshave received high reviews for safety and reliability. Thecompany has a niche market in that it sells primarily to individuals who own and fly their-own airplanes. The companyhas two models; the Birdie, which sells for $53,000, and theEagle, which sells for $78,000.
Although the company manufactures aircraft, its operationsare different from commercial aircraft companies. S&SAir builds aircraft to order. By using prefabricated parts, thecompany can complete the manufacture of an airplane in onlyfive weeks. The company also receives a deposit on each
order, as well as another partial payment before the order iscomplete. In contrast, a commercial airplane may take oneand one-half to two years to manufacture once the order isplaced.
Mark and Todd have provided the following financialstatements. Chris has gathered the industry ratios for the lightairplane manufacturing industry.
S&S Air INC.
2015 Income Statement
Sales $ 40,259,230
|S&S Air Inc
2014 Balance Sheet
|Assets Liabilities & Equalities|
Current assetsCurrent liabilities
Cash $ 456,435 Accounts payable $ 929,005
Net plant and equipment$17,723,430 Shareholders equity common stock $ 400,000
Total assets $19,986,170Total liabilities and equity$19,986,170
Light Airplane Industry Ratios
|Lower quartileMedianUpper quartile|
Current Ratio .50 1.43 1.89
- In your textbook, Fundamentals of Corporate Finance, read:
- Chapter 3, “Working with Financial Statements,” pages 57–80 (sections 3.3, 3.4, and 3.5)
- Download and review the PowerPoint file Chapter 3 – Working with Financial Statements.ppt to help you further understand the chapter.
- In your textbook, Fundamentals of Corporate Finance, complete the requirements of the Mini-case “Ratio Analysis at S&S Air, Inc.” on pages 89 and 90:
- Question # 1: Use an Excel spreadsheet to calculate each of the ratios listed in the table. Be sure to show your work.
- Question #2: Briefly comment in your Excel spreadsheet on the appropriateness of Boeing and the other competitors as an aspirant company for comparison.
- Question # 3: In your Excel spreadsheet, compare each calculated ratio to the industry ratios given in the table. Briefly explain whether the calculated ratio would be viewed positively or negatively relative to the industry and why. (Exclude the second half of this question regarding the creation of an inventory ratio)