An entrepreneur, Susan, is investigating the possibility of going into business and you are assigned to help her prepare pro-forma financial statements.

She is going into a small retail business selling two products i.e. high quality sweaters and hats. The uniqueness of her products is that when a sweater or hat is purchased the customer can, using a computer, select or design the logo they wish installed and it will be installed immediately with a computerized sewing machine using a patented process.

The anticipated total sales for the launch in 2022 and the percentage sales increases for the following months are given below:

Jan 0

Feb. - Sweaters 500 units

- Hats 70 units

Mar. +40%

Apr. +15%

May. +5%

June +5%

July - onwards +3% each month

The percentage increases shown for March onwards are applicable to both product lines. The increases represent the increase over the previous month’s sales levels, NOT the increase from February sales level.

It is projected that sales will be made at the following average selling prices:

- Sweater $32.00 each

- Hats $18.00 each

It is anticipated that the average cost of sales per unit including logo will be:

- Sweaters $11.20 each

- Hats $7.20 each

Since it is anticipated that some sales will be made to companies and teams, credit will be provided on 50% of their sales. Collection on credit sales is anticipated to be 30 days on average.

The investment by the owners and the amount borrowed from rich relatives through a note payable are as follows, arranged in December of the prior year.

INVESTMENT NOTE PAYABLE

$10,000 $5,000

The note payable is interest only paid monthly at an annual rate of 5%.

They all decided to keep a minimum of $2,000 cash at all times starting in January in case of emergencies.

The business will have to pay prepaid rent equal to their first and last month’s rent. The term of their leases is 5 years. The rents is $1,000 per month

The shop is 500 square feet but because of different locations, and different clientele their furnishings, shelving, display cases will require different fixed asset purchases (leasehold improvements). The estimated costs are at $40 per sq ft.

The contractor will accept 50% of the payment in January with the balance due in February. Depreciation must be calculated. i.e. Leasehold Improvements should be written off over the life of the lease. All our entrepreneurs must purchase the computerized sewing machine for installing the logos at a cost of $4,500 prior to January. This equipment depreciates at a diminishing balance rate of 20% per yr.

Susan now has to look at inventory purchases. Their inventory stocking policy and the payment terms she has been able to negotiate with her suppliers are as follows:

- purchase inventory one-month prior to sale. Both their sweater and hat manufacturers will only agree to 100% C.O.D.

Also they will all have to purchase their opening inventories under the same terms. (i.e. January purchase for February sales)

The owner has come up with the following information regarding monthly expenses:

Salaries/mo. 2000

Insurance/mo. 150

Advertising/mo. 100

Municipal Taxes/mo. 85

Travel Expenses/mo. 60

Heat Light & Water/mo. 125

Accounting/mo. 115

The accounts illustrated in the Cash Flow Projection & Income Statement may have to be modified.

i.e. other accounts may have to be added, or some accounts may not be needed

REQUIRED:

1. Complete the “Sales & Cost of Sales by Product”for the company.
2. Complete the Cash Flow Projection, Income Statement & Balance Sheet.

3. What line of credit will have to be negotiated so that their cash balance during the first six months does not fall below $2,000. (from Cash Flow Projection)
4. Calculate the following Financial Ratios:

1. Gross Margin Ratio = Gross Profit/Sales
2. Current ratio = Current assets/current liabilities
3. Debt to equity ratio = total debt (total liabilities)/equity (net worth)
4. Return On Investment = Income (before taxes but after interest)/net worth
5. Inventory turnover ratio = Cost of goods sold/average inventory

(average inventory is beginning inventory + ending inventory divided by 2)

Compare your calculations with the https://www.ic.gc.ca/eic/site/pp-pp.nsf/eng/home. The government website only publishes the Gross Margin Ratio. Can you make any comments on the other ratios?

Is there any action that Susan needs to take?

Answer rating: 100% (QA)

GOVERN January February Sales Cost March Sales Cast April COS Sales GP S... View the full answer