The following information from Compaa El Faro SA is presented below :

Compaa El Faro SA
Balance sheet
As of December 31, 201 9
Dollar amounts
	AMOUNTS
ASSETS
Cash	130,000
Accounts receivable	150,000
Inventories	440,000
Expenses paid in advance	58,000
Current Assets	778,000
Equipment , furniture and other	370,000
Accumulated depreciation	- 128,000
Net Fixed Assets	242,000
TOTAL ASSETS	1,020,000
PASSIVES
Accounts payable Suppliers	183,2 00
Commissions payable	25,000
Current liabilities	208,200
Long-term bank debts	200,000
TOTAL LIABILITIES	408,200
HERITAGE
Social Capital	544,800
Earnings Retained from prior periods	67,000
TOTAL ASSETS	611,800
PASSIVE AND HERITAGE	1,020,000

Sales royal December 2019 in September were $ 500,000. The budgeted monthly sales for the coming months are as follows:

	January	February	March	April	May	June	July
Sales	$ 600,000	$ 700,000	$ 500,000	$ 600,000	$ 900,000	$ 700,000	$700,000

Sales are made 70% in cash and 30% on credit that is collected in the following month. The amount of bad debts is insignificant.

The desired by the inventory COMPANY at the end of each month is as follows: a basic inventory of $ 200,000 over 4 0% of the sales of the following month.

The 60% of purchases are paid in cash and 40% in the following month.

The cost of merchandise sold is 9 5% of the desired ending inventory.

Wages and commissions are divided into two parts: $ 25,000 monthly fixed salaries and commissions l 5% sales total for the month. The commission is paid the following month , while the fixed wages are paid in the same month .

On March 1 20 20 buy ra a new truck valued at $ 30, 000, which has a shelf life of four years and a salvage value of $ 6,000. You depreciate the straight - line method is used.

Other monthly expenses are:

• Miscellaneous expenses: 8% of cash sales
• $ 20,000 rental
• $ 5,000 depreciation not including the new truck.

The company wishes to maintain a minimum cash balance of $ 100,000 to the end of each month. If needed loans , payments are made in multiples of $ 10,000. The interest rate is 12% per annum. Loans are requested on the 5th of the month they are needed and are paid on the 30th of the month that there is cash left over.

You are asked to:

1. Using the above data, prepare the following certificates:

a) Budget of sales and collections.

b) Certificate of purchases to be made and disbursements for purchases.

c) Certificate of salaries and commissions (Expenses and disbursements).

2. Using the data from the calculated schedules prepare the following financial statements:

a) Projected monthly cash flow for the first semester of 2020. Detailed per month.

b) Projected income statement for the first semester of 2020, detailed for each one of the months from January to June .

c) Projected balance sheet for June 30, 20 20 .

3. Make a general comment on the prepared financial projections and on the future financial situation of the company . Use at least one of the financial analysis tools learned throughout the course : Vertical, Horizontal Analysis, State of Origin and Application of Funds , Financial Indicators.