Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several

ID: 340632 • Letter: P

Question

Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $510,000 long-term loan from Gulfport State Bank, $105,000 of which will be used to bolster the Cash account and $405,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent years follow:

     During the past year, the company introduced several new product lines and raised the selling prices on a number of old product lines in order to improve its profit margin. The company also hired a new sales manager, who has expanded sales into several new territories. Sales terms are 3/10, n/30. All sales are on account.

     Assume that Paul Sabin has asked you to assess his company’s profitability and stock market performance.

You decide first to assess the company’s stock market performance. For both this year and last year, compute:

Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now experiencing a severe cash shortage. For this reason, it is requesting a $510,000 long-term loan from Gulfport State Bank, $105,000 of which will be used to bolster the Cash account and $405,000 of which will be used to modernize equipment. The company’s financial statements for the two most recent years follow:

a. The earnings per share. There has been no change in common stock over the last two years. Round your answers to 2 decimal places.) This Year Last Year Earnings per share b. The dividend yield ratio. The company's stock is currently selling for $50 per share; last year it sold for $46 per share. (Do not round intermediate calculations. Round your percentage answers to decimal place (i.e., 0.1234 should be entered as 12.3).) This Year Last Year Dividend yield ratio c. The dividend payout ratio. (Round intermediate calculations to 2 decimal places. Round your percentage answers to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) This Year Last Year Dividend payout ratio

Explanation / Answer

Solution 1.

a. The earrings per share

This Year

Last Year

Earnings per share

=(Net Income - Dividends on Preferred Stock) / Number of Outstanding common shares

Note: Dividend on preferred stock is 0, as there is no preferred stock in the question.

= ($302,400-0)/ ($ 700,000/$ 20)

=$302,400 /35,000

=$ 8.64 per share (Answer)

=($ 204,400-0)/ ($ 700,000/$ 20)

=$ 204,400/ 35,000

=$ 5.84 per share (Answer)

b.The Dividend Yield Ratio

This Year

Last Year

Dividend Yield Ratio

=Dividend per share / Current Market Price per share X 100

*Note: Number of common shares outstanding

= $ 700,000 / $ 20 = 35,000 shares

= ($111,000/ 35,000*) /$ 50 X 100

= $ 3.17 / $ 50 X 100

= 6.3 % (Answer)

=($ 90,000/ 35000) /$ 46 X 100

=$ 2.57 /$ 46 X 100

=5.6 % (Answer)

c.The Dividend Payout Ratio

This Year

Last Year

Dividend Payout Ratio = Dividends per share / Earnings per share X 100

= ($ 111,000 /35,000) /$ 8.64 X 100

=

=$ 3.17 / /$ 8.64 X 100

= 36.7 % (Answer)

= ($ 90,000/ 35,000)/ $ 5.84 X100

=$ 2.57 / $ 5.84 X100

=44.0 % (Answer)

d.The price-earnings ratio

This Year

Last Year

Price-earnings ratio

=Market Value per Share / Earnings per Share

= $ 50 /$ 8.64

=5.79 (Answer)

=$ 46/ $ 5.84

=7.88 (Answer)

e. The book value per share of common stock

This Year

Last Year

Book value per share of common stock

=Net Assets / Number of Outstanding common shares

*Nets Assets = Total Assets –Total Liabilities

= ($2,918,400-$ 1,400,000) / 35,000

=$ 1,518,400 /35,000

= $ 43.38 (Answer)

=($ 2,417,000-$ 1,090,000) / 35,000

=$ 1,327,000 /  35,000

= $ 37.91   (Answer)

Solution 2.

a.The gross margin percentage

This Year

Last Year

Gross margin percentage

= Gross margin / Sales X 100

= $ 1,165,000 /$ 5,050,000 X 1 00

=23.1 % (Answer)

= $ 920,000/$ 4,380,000 X 100

= 21.0% (Answer)

b.The net profit margin percentage

This Year

Last Year

Net profit margin percentage = Net profit or net income margin / Sales X 100

= $ 302,400/$ 5,050,000 X     100

=5.9 % (Answer)

= $ 204,400/$ 4,380,000 X 100

= 4.6% (Answer)

c.The return on total assets

This Year

Last Year

Return on total assets

=Net Income / Average Total assets X100

=$ 302,400/ ($2,417,000 + $ 2,918,400) /2] X100

=$ 302,400 / $ 2,667,700 X100

=11.3% (Answer)

= $ 204,400 /[($ 2,330,000 +$ 2,417,000) /2] X 100

=$ 204,400/ $ 2,373,500 X100

=8.6%    (Answer)

d.The return on equity

This Year

Last Year

Return on equity

=Net Income/Shareholders' Equity X100

=$ 302,400/ ($1,327,000+ $ 1,518,400) /2] X100

=$ 302,400 / $ 1,422,700 X100

=21.3% (Answer)

= $ 204,400 /[($ 1,317,000 +$ 1,327,000) /2] X 100

=$ 204,400/ $ 1,322,000 X100

=15.5%    (Answer)

e.Is the company’s financial leverage or position negative?

Degree of financial leverage

= % Change in Earning per *share /% Change in net income**

=47.94 / 47.94

= 1

Answer-    The company’s financial leverage is positive, as degree of financial leverage is 1.

*% Change in Earning per share

= (Earnings per share this year - Earnings per share last year) / Earnings per share last year X 100

= ($ 8.64 - $ 5.84)/ $ 5.84 X 100

= $ 2.8 /$ 5.84 X 100

= 47.94 %

**% Change in net income

= (Net income this year - Net income last year) / Net income last year X 100

= ($302,400 - $ 204,400)/ $ 204,400 X 100

= $ 98,000 /$ 204,400 X 100

= 47.94 %

This Year

Last Year

Earnings per share

=(Net Income - Dividends on Preferred Stock) / Number of Outstanding common shares

Note: Dividend on preferred stock is 0, as there is no preferred stock in the question.

= ($302,400-0)/ ($ 700,000/$ 20)

=$302,400 /35,000

=$ 8.64 per share (Answer)

=($ 204,400-0)/ ($ 700,000/$ 20)

=$ 204,400/ 35,000

=$ 5.84 per share (Answer)