GENERAL INSTRUCTIONS:

1. Exercise to be done individually.

2. Although the use of Excel is emphasized, you can hand-deliver it.

to. If you use Excel, the formulas used in determining results are expected to appear.

3. You can write the assumptions used in calculating the quantities obtained.

4. Follow the instructions indicated in the classroom or announced by message in Announcements in Bb.

5. Answer everything required in the exercise and in the Evaluation Rubric published in Bb.

INFORMATION AND BASIC DATA FOR THE PROJECTIONS AND CONFORMATION OF THE BUDGETS

EMPRESAS SOTOMENOR lists below historical financial data, bases for the required budget projections and predictions.

SALES PER MONTH DURING THE LAST YEAR 20X1

JANUARY $ 550,000 FEBRUARY $ 825,000 MARCH $ 575,000

APRIL $ 870,000 MAY $ 1,080,000 JUNE $ 1,065,000

JULY $ 1,070,000 AUGUST $ 1,060,000 SEPTEMBER $ 1,180,000

OCTOBER $ 1,140,000 NOVEMBER $ 1,290,000 DECEMBER $ 1,460,000

I. Sales Projection: 20X2

After consulting the Company's Management Committee, it was agreed that business plans and strategies were deemed appropriate, a 35% increase in sales reported during the months of last year 20x1. All sales are estimated on credit.

Projection of collections based on the monthly sales projection:

70% of the projected sales of each month, (January, February, March, etc.) are projected to be collected during the same month (January, February, March, etc.).

o Due to a new collection policy, a two (2)% discount will be offered, if customers pay within ten days from the invoice date. It is projected that 3/4 parts of the clients will take advantage of this collection term.

15% of sales for each month are projected to be collected the month following the month of sale. For example: January sales charged in February, and so on.

10% of sales for each month are projected to be collected two months after the month of sale. For example: January sales collected in March.

5% of sales for each month are projected to be collected three months after the month of sale.

o Due to the economic indicators and financial forecasts of the experts, it is advisable to consider that of this projected collection product, 2.75% is uncollectible. For example: January sales charged in April.

Emergency situations policy.

Due to considerations and learning from the hurricane phenomenon of Mara, the company officials have recommended that after determining and calculating the projections of collections for each month, appropriate (separate) 10% of the projected collections, as a fund to alleviate and attend to such emergencies. This policy implies that such funds are not to cover disbursements of the costs and operating expenses that are projected for the budget year.

Projections of sales, collections and emergency situations are key to the formulation, structuring and calculations of the projections of the Sales Budget and Collections of Sales.

II. Projection of Merchandise Purchases, necessary to fulfill the projected sales. 20X2

Sales projections affect purchases in the same way. These represent 55% of the projected monthly sales. They are purchased during the month of sale and are projected to pay within the same month with a two% cash discount.

Projections of purchases are for the formulation, structuring and calculations of projections of the Purchase Budget

III. Projection of monthly disbursements for operating expenses and principal of debts with their corresponding interests. 20X2

Expenses: all are paid from projected sales and in the month they are incurred. These are:

Salaries: 27.50% of projected monthly sales

Commissions 2% of monthly projected sales, plus 3.5% of monthly charges.

Payroll: 10.9% of what was paid in wages and commissions.

Profits: $ 45,000 monthly

Insurance: $ 12,000 monthly

Mortgage Interest: 6.5% simple interest, from the balance of the principal to be divided monthly, payable monthly.

Interest Other debts: 12% simple interest on the principal balance to be divided monthly to apply to the others.

Amortization of the principal of the debts:

MORTGAGES $ 950,000 of total principal as of January. Monthly principal payments of $ 30,000. HINT: Simple interest calculation. The principal decreases monthly and the time in the formula will increase monthly one month at a time.

OTHER DEBTS $ 750,000 Of total principal. Monthly principal payments of $ 25,000, at the end of the month. The principal decreases monthly and the time in the formula will increase monthly one month at a time.

The information presented in this section is for the formulation, structuring and calculations of the Expense and Debt Budget projections.

IV. Cash flow projection to shape and structure the Cash Budget. 20X2

The basis for making this budget are the results calculated in terms of collections and disbursements for purchases, expenses and debts of the previous budgets; plus the information below.

Initial Cash Balance - Cash is $ 50,000

Minimum monthly cash balance in the budget period is $ 100,000.

The shareholders are requesting dividends of $ 150,000 in the months of March, June, September, and December.

o Such dividends will be awarded as long as the company does not have to borrow or finance them with debts. There must be cash to grant it. No payments less than $ 150,000 proceed.

Operational deficiencies and minimum desired cash balance, in the projected months, may be financed by short-term debts.

REQUIRED: PREPARE THE FOLLOWING BUDGETS FOR 20X2:

1. Sales and Collections Budget. Section I. (Remember that the business existed last year 20X1. Therefore, sales for the last months of 20X1 are projected to be collected in the 20X2 period. Not including such charges, significantly affecting all calculations in the 20X2 budgets) .

2. Purchase Budget and purchase payments - Section II.

3. Budget of payments for expenses and debt repayment. Section III.

4. CASH BUDGET Section IV, with effect of the previous ones.

All budgets will be set aside for a full year divided into months.

I recommend using a column total, after the last month of the budget period for block purposes.

NOTE: MAKE SURE THE PRESENTATION IS IN ELECTRONIC SHEET FORMAT. OR BY HAND. Remember the components of the Assessment Rubric.