Pluto

$$

s Pct Store Limited

Youssef & Emma have just won the lottery and have been approached by a local company for them to provide them with a loan. Pluto

$$

s is looking for a $

$2$

$0$

$0$

$,$

$0$

$0$

$0$

$$loan so they can purchase a new building. Emma and Youssef know that you are currently taking an accounting course and have come to you for assistance. They have provided you with the income statement, balance sheet and statement of cash flows for the last

$2$

$$years for the company, Pluto

$$

s Pet Store Limited, as well as some selected industry averages for

$2$

$0$

$2$

$3$

$.$

$$

Additional Information:

Pluto

$$

s Pet Store has

$1$

$0$

$,$

$0$

$0$

$0$

$$common shares outstanding at December

$3$

$1$

$,$

$2$

$0$

$2$

$2$

$$&

$2$

$0$

$2$

$3$

$.$

$$The market value of the shares was $

$1$

$5$

$/$

$$share on December

$3$

$1$

$,$

$2$

$0$

$2$

$2$

$$& $

$1$

$2$

$/$

$$share on December

$3$

$1$

$,$

$2$

$0$

$2$

$3$

$.$

Dividends declared & paid

$2$

$0$

$2$

$3$

$$ $

$3$

$6$

$,$

$4$

$0$

$0$

Dividends declared & paid

$2$

$0$

$2$

$2$

$$ $

$3$

$0$

$,$

$0$

$0$

$0$

Selected data from December

$3$

$1$

$,$

$2$

$0$

$2$

$1$

$,$

$$yearend financial statements:

Accounts receivable s

$3$

$6$

$.$

$0$

$0$

$0$

Inventory

$9$

$0$

$,$

$0$

$0$

$0$

Total assets

$3$

$0$

$8$

$,$

$6$

$0$

$0$

Accounts payable

$5$

$8$

$,$

$9$

$0$

$0$

Shareholders

$$

$$equity

$1$

$2$

$7$

$,$

$6$

$0$

$0$

Selected industry averages for

$2$

$0$

$2$

$3$

:

Gross profit margin ratio

$3$

$5$

$.$

$0$

$0$

$\%$

Return on sales

$($

net profit margin

$)$

$9$

$\%$

Rate of return on assets

Debt ratio

$0$

$.$

$6$

Days inventory outstanding

$7$

$0$

Earnings per share

$7$

$.$

$0$

Quick Ratio

$0$

$.$

$9$

$0$

Required:

$1$

$.$

$$Prepare a ratio analysis for Pluto's Pet Store Limited

$($

you must calculate at least

$1$

$$ratios

$)$

$2$

$.$

$$Prepare a memo for Youssef & Emma advising them on whether they should provide Pluto's Pet Store Limited with the loan. The memo should include a discussion on

$4$

$$ratios$,$ the strengths or weaknesses identified in the statement of cash flows and your recommendation on whether they should make the loan.

Pluto's Pct Store Limited Income Statement

Year Ended December

$3$

$1$

$,$

$2$

$0$

$2$

$3$

$$

$$

$2$

$0$

$2$

$3$

$2$

$0$

$2$

$2$

Sales

$7$

$0$

$0$

$,$

$0$

$0$

$0$

$4$

$5$

$0$

$,$

$0$

$0$

$0$

Cost of goods sold

$4$

$5$

$0$

$,$

$0$

$0$

$0$

$3$

$0$

$0$

$,$

$0$

$0$

$0$

Selling & Admin

$2$

$5$

$0$

$,$

$0$

$0$

$0$

$1$

$5$

$0$

$,$

$0$

$0$

$0$

Advertising

$1$

$5$

$,$

$0$

$0$

$0$

$7$

$,$

$5$

$0$

$0$

Depreciation expense

$9$

$,$

$0$

$0$

$0$

$7$

$,$

$0$

$0$

$0$

Insurance expense

$2$

$,$

$4$

$0$

$0$

$2$

$,$

$0$

$0$

$0$

Office supplies expense

$7$

$,$

$6$

$0$

$0$

$3$

$,$

$5$

$0$

$0$

Salary expense

$9$

$8$

$,$

$0$

$0$

$0$

$5$

$0$

$,$

$0$

$0$

$0$

Utilities expense

$1$

$8$

$,$

$0$

$0$

$0$

$1$

$5$

$,$

$0$

$0$

$0$

$$

$1$

$5$

$0$

$,$

$0$

$0$

$0$

$8$

$5$

$,$

$0$

$0$

$0$

Income before interest & income tax

$1$

$0$

$0$

$,$

$0$

$0$

$0$

$6$

$5$

$,$

$0$

$0$

$0$

Interest expense

$1$

$0$

$,$

$0$

$0$

$0$

$4$

$,$

$0$

$0$

$0$

Income before income taxes

$9$

$0$

$,$

$0$

$0$

$0$

$6$

$1$

$,$

$0$

$0$

$0$

Income tax expense

$1$

$8$

$,$

$0$

$0$

$0$

$1$

$2$

$,$

$4$

$0$

$0$

$$Net income

$7$

$2$

$,$

$0$

$0$

$0$

$4$

$8$

$,$

$6$

$0$

$0$

Pluto's Pct Storc Limited

Balance Shcct

December

$3$

$1$

$,$

$2$

$0$

$2$

$3$

Current Assets

$2$

$0$

$2$

$3$

$2$

$0$

$2$

$2$

Cash

$2$

$5$

$,$

$0$

$0$

$0$

$2$

$0$

$,$

$0$

$0$

$0$

Accounts receivable, net

$5$

$5$

$,$

$0$

$0$

$0$

$4$

$5$

$,$

$0$

$0$

$0$

Inventory

Prepaid expenses

$1$

$0$

$0$

$,$

$0$

$0$

$0$

$8$

$5$

$,$

$0$

$0$

$0$

$$

$6$

$0$

$0$

$4$

$0$

$0$

$$

$1$

$8$

$0$

$,$

$0$

$0$

$0$

$1$

$5$

$0$

$,$

$4$

$0$

$0$

Property Plant and equipment

$3$

$0$

$0$

$,$

$0$

$0$

$0$

$2$

$0$

$0$

$,$