Question

In: Finance

RATIO ANALYSIS AT S&S AIR, INC. Chris Guthrie was recently hired by S&S Air, Inc., to...

RATIO ANALYSIS AT S&S AIR, INC.

Chris Guthrie was recently hired by S&S Air, Inc., to assist the company with its financial planning and to evaluate the company’s performance. Chris graduated from college five years ago with a finance degree. He has been employed in the finance department of a Fortune 500 company since then.

S&S Air was founded 10 years ago by friends Mark Sexton and Todd Story. The company has manufactured and sold light airplanes over this period, and the company’s products have received high reviews for safety and reliability. The company has a niche market in that it sells primarily to individuals who
own and fly their own airplanes. The company has two models: the Birdie, which sells for $103,000, and the Eagle, which sells for $178,000.

Although the company manufactures aircraft, its operations are different from commercial aircraft companies. S&S Air builds aircraft to order. By using prefabricated parts, the company can complete the manufacture of an airplane in only five weeks. The company also receives a deposit on each order, as well as another partial payment before the order is complete. In contrast, a commercial airplane may take one and one-half to two years to manufacture once the order is placed.

Mark and Todd have provided the following financial statements. Chris has gathered the industry ratios for the light airplane manufacturing industry.

S&S AIR, INC.
2018 Income Statement

Sales

Cost of goods sold

Other expenses

Depreciation

EBIT

Interest

Taxable income

Taxes (25%)

Net income

Dividends $    705,000

Add to retained earnings 1,612,789

$46,298,115

34,536,913

5,870,865

2,074,853

$ 3,815,484

725,098

$ 3,090,386

772,597

$ 2,317,789

S&S AIR, INC.
2018 Balance Sheet

Assets

Liabilities and Equity

Current assets

Current liabilities

Cash

$ 524,963

Accounts payable

$ 1,068,356

Accounts receivable

843,094

Notes payable

2,439,553

Inventory

1,235,161

Total current liabilities

$ 3,507,909

Total current assets

$ 2,603,218

Long-term debt

$ 6,300,000

Fixed assets

Net plant and equipment

$20,381,945

Shareholder equity

Common stock $ 460,000

Retained earnings

12,717,254

Total equity

$ 13,177,254

Total assets

$22,985,163

Total liabilities and equity

$ 22,985,163

Light Airplane Industry Ratios

Lower
Quartile

Median

Upper
Quartile

Current ratio

Quick ratio

Cash ratio

Total asset turnover

Inventory turnover

Receivables turnover

Total debt ratio

Debt-equity ratio

Equity multiplier

Times interest earned

Cash coverage ratio

Profit margin

Return on assets

Return on equity

.50

.21

.08

.68

4.89

6.27

.41

.68

1.68

5.18

5.84

4.05%

6.05%

9.93%

1.43

.35

.21

.85

6.15

9.82

.52

1.08

2.08

8.06

9.41

5.10%

9.53%

15.14%

1.89

.62

.39

1.38

10.89

14.11

.61

1.56

2.56

9.83

10.27

7.15%

13.21%

19.15%

QUESTIONS

  1. Using the financial statements provided for S&S Air, calculate each of the ratios listed in the table for the light aircraft industry.

Solutions

Expert Solution

Current ratio = Current Assets/ Current Liabilities = (2,603,218)/(3,507,909) = 0.742

Quick ratio = (Current Assets - Inventory)/ Current Liabilities = (2,603,218- 1,235,161)/ (3,507,909) = 0.389

Cash ratio = Cash / Current Liabilities = (524,963)/(3,507,909) = 0.149

Total asset turnover = Sales/ Total Assets = (46,298,115)/ (22,985,163) = 2.014

Inventory turnover = COGS/ Average inventory = (34,536,913)/(1,235,161) = 27.96

Receivables turnover = Sales/ Average receivables = (46,298,115) / (843,094) = 54.91

Total debt ratio= Total Debt/ Assets = ( Total CL + Long term debt)/ Assets = (3,507,909+6,300,000)/22,985,163 = 42.67%

Debt-equity ratio= Total debt/ Equity = 3,507,909+6,300,000/ 13,177,254 = 74.43%

Equity multiplier = (Total Assets/ Equity) = 22,985,163/ 13,177, 254 = 1.744

Times interest earned = EBIT/ Interest = 3,815, 484/725,098 = 5.26

Cash coverage ratio = (EBIT + Depreciation)/ Interest = (3,815, 484+ 2,074,853)/725,098 = 8.12

Profit margin = Net Income/ Sales = (2,317,789)/(46,298,115) = 5.006%

Return on assets = Net Income/ Total Assets = 2,317,789/ 22,985,163 = 10.08%

Return on equity = Net Income/ Equity = 2,317,789/13,177, 254 = 17.58 %


Related Solutions

Chris Guthrie was recently hired by S&S Air, Inc., to assist the company with its financial...
Chris Guthrie was recently hired by S&S Air, Inc., to assist the company with its financial planning and to evaluate the company’s performance. Chris graduated from college five years ago with a finance degree. He has been employed in the finance department of a Fortune 500 company since then. S&S Air was founded 10 years ago by friends Mark Sexton and Todd Story. The company has manufactured and sold light airplanes over this period, and the company’s products have received...
Chris Guthrie was recently hired by S&S Air, Inc., to asset the company with its financial...
Chris Guthrie was recently hired by S&S Air, Inc., to asset the company with its financial planning and to evaluate the company's performance. Chris graduated from college five years ago with a finance degree. He has been employed in the finance department of a Fortune 500 company since then. S&S Air was founded 10 years ago by friends Mark Sexton and Todd Story. The company has manufactured and sold light airplanes over this period, and the company's products have received...
CASE 7: Ratios and Financial Planning at S&S Air Chris Gumede was recently hired by S&S Air to assist the company with its
Chris Gumede was recently hired by S&S Air to assist the company with its financial planning and to evaluate the company’s performance. Chris graduated from university five years ago with a finance degree.S&S Air was founded 10 years ago by friends Mark and Thandi. The company has manufactured and sold light aeroplanes over this period and the company’s products have received high reviews for safety and reliability. The company has a niche market in that it sells primarily to individuals...
Chapter 4 Mini Case 2 Ratios and Financial Planning at S & S Air Chris Gumede...
Chapter 4 Mini Case 2 Ratios and Financial Planning at S & S Air Chris Gumede was recently hired by S&S Air to assist the company with itsfinancial planning and to evaluate the company’s performance. Chris graduatedfrom university five years ago with a finance degree.S&S Air was founded 10 years ago by friends Mark and Thandi. Thecompany has manufactured and sold light aeroplanes over this period and thecompany’s products have received high reviews for safety and reliability. Thecompany has a...
Air Taxi, Inc. has a long-term debt ratio of .48 and a current ratio of 1.27....
Air Taxi, Inc. has a long-term debt ratio of .48 and a current ratio of 1.27. Current liabilities are $3,526, sales are $10,792, profit margin is 8 percent, and ROE is 11.7 percent. What is the total of the firm's net fixed assets? Download the linked spreadsheet template and use it for your answer. Once complete, upload the template to this question. Don't forget to show your work!
0.2 kg/s of moist air at 45oC (DBT) and Humidity ratio 0.006 kgw/kgda (dry air) is...
0.2 kg/s of moist air at 45oC (DBT) and Humidity ratio 0.006 kgw/kgda (dry air) is mixed with 0.3 kg/s of moist air at 250C (DBT) and a humidity ratio of 0.018 kgw/kg da in an adiabatic mixing chamber. After mixing, the mixed air is heated to a final temperature of 40o C using a heater. Assume the barometric pressure to be 1 atm. Find Enthalpies of both fluids Temperature and humidity ratio of air after mixing. Heat transfer rate...
MINICASE A JOB AT S&S AIR You recently graduated from college, and your job search led...
MINICASE A JOB AT S&S AIR You recently graduated from college, and your job search led you to S&S Air. Because you felt the company’s business was taking off, you accepted a job offer. The first day on the job, while you are finishing your employment paperwork, Chris Guthrie, who works in Finance, stops by to inform you about the company’s 401(k) plan. A 401(k) plan is a retirement plan offered by many companies. Such plans are tax-deferred savings vehicles,...
As a recently hired accountant for a small business, SMC, Inc., you are provided with last...
As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. You are also given the following information that summarizes the business activity for the current year,2020 As arecently hired accountantfor a smallbusiness,SMC,Inc., you are providedwithlast year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance Sheet December 31, 2019 Assets Cash...
As a recently hired accountant for a small business, SMC, Inc., you are provided with last...
As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance sheet December 31, 2019 Assets $34,500 Cash $25,000 Accounts receivable $10,000 Supplies $200 Total assets $69,700 Liabilities and stockholders equity Liabilities: Accounts payable $12,000 Salaries payable $1,000 Income taxes payable $3,675 Total liabilities    $16,675 Stockholders equity: Capital stock (10,000 shares outstanding) $25,000 Retained earnings $28,025...
As a recently hired accountant for a small business, SMC, Inc., you are provided with last...
As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business. SMC, Inc. Balance sheet December 31, 2019 Assets $34,500 Cash $25,000 Accounts receivable $10,000 Supplies $200 Total assets $69,700 Liabilities and stockholders equity Liabilities: Accounts payable $12,000 Salaries payable $1,000 Income taxes payable $3,675 Total liabilities $16,675 Stockholders equity: Capital stock (10,000 shares outstanding) $25,000 Retained earnings $28,025 Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT