# Bayside Inc. 2005 Income State

Bayside Inc. 2005 Income Statement ($ in thousands)

Net sales $5,680

Less: Cost of goods sold 4,060

Less: Depreciation 420

Earnings before interest and taxes 1,200

Less: Interest paid 30

Taxable Income $1,170

Less: Taxes 410

Net income $ 760

Bayside, Inc. 2004 and 2005 Balance Sheets ($ in thousands)

2004 2005 2004 2005

Cash $ 70 $ 180 Accounts payable $1,350 $1,170

Accounts rec. 980 840 Long-term debt 720 500

Inventory 1,560 1,990 Common stock 3,200 3,500

Total $2,610 $3,010 Retained earnings 940 1,200

Net fixed assets 3,600 3,360

Total assets $6,210 $6,370 Total liabilities & equity $6,210$6,370

Calculate the following: for 2005 only (You will show your work). Additional Information at the end of 2005:

Fair Market Value of the Stock $190 per share

Number of Common Shares Outstanding 100,000

Dividends paid during 2005 – $4 per share

Calculate the Current Ratio for 2005.

A current ratio of 2.2 would appear to show that the company hasa healthy current ratio.Is this statement true or false.

What is the Quick Ratio for this company for 2005?

Calculate the Inventory Turnover in days for 2005.

If a seller of fresh fruit had an Inventory Turnover Ratio of125 days, would this be a good ratio?

Calculate the Average Days Sales for Collecting Receivables.

If this companies terms are Net 15 on items it sells and itsAverage Days Sales for collecting those receivables is 39 days,should the company be concerned?

Calculate the Debt to Equity Ratio.

The ratio reflects that the company has used more debt thanequity to finance the growth of the company.

Calculate the Profit Margin for the company.

Explain this Profit Margin Percentage. What does it mean?

Calculate the Earnings Per Share for thecompany. (Net Income/Oustanding Shares)

Calculate the Price to Earnings Ratio.

If the industry Price to Earnings ratio is at 15, what couldaccount for the difference from the industry average?

CAlculate

Beginning Retained Earnings $100,000

Dividends Paid for the Year $20,000

Net Loss for the Year $30,000

Based on the information above, the Ending Retained EarningsBalance will be?

Answer:

Solution :

First, we shall calculate the current ratio of the company :

1 a) The current ration is defined as the ability of the companyto pay off the short-term and long-term obligation of the company.It is calculated by considering total current asset divided by thetotal current liabilities.

Hence = Current Asset /Current Liabilities = (Cash + Acc rec+inventory )/accounts payable

= (180 +840 +1990 )/1170

= 3010 /1170

therefore the current ratio = 2.57

Since the company has a current ratio of more than 2 hence yesthe statement holds true as higher the number depicts that thecompany has 2 times more current assets to pay off the obligationof the company.

b) Quick ratio – It is defined as how can a company meets itsshort-term financial liabilities and it is also known as acid testratio. In the Quick ratio, we will not consider Inventory.

Quick ratio = (Cash +marketable securities + Acc Rec) /AccPayable

= (180+840)/1170

= 1020/1170 = 0.87 is the quick ratio which implies that sinceit is less than 1 that shows that the company has an inventory highand doesn’t have enough liquid asset to meet their short-termfinancial obligations.

c) Inventory turnover – It is defined as how many times theinventory is sold and replaced over a period by the company.Generally, we consider the cost of goods sold and not sales whilecalculating the inventory turnover divided by average inventory i.e(2014+2015 )/ 2

= Cost of goods sold / Avg Inventory

= 4060 / (1560+1990)/2

= 4060 / 1775 = 2.29 hence the inventory turnover in days willbe = 365 / 2.29 = 159 days

d) If the company has 125 days of inventory turnover that isgood because it shows that the company takes 125 days to sell theaverage inventory and 3 times in a year the inventory isreplaced.

Thank you so much.