FINA 503 Below is information on the financial results of the Company Caribe Supplies Inc.

Question # 00048728 Posted By: lborges Updated on: 02/15/2015 09:11 AM Due on: 02/16/2015
Subject Business Topic General Business Tutorials:
Question
Dot Image

BUDGET INFORMATION

Below is information on the financial results of the Company Caribe Supplies Inc. This information over the projections presented will be the basis for planning and preparing budgets for next year.

MONTHLY SALES DURING THE PAST YEAR 2014

JANUARY $ 320,000FEBRUARY $ 400,000MARCH $ 525,000

APRIL $ 470,000 MAY $ 680,000JUNE $ 725,000

JULY $ 490,000 AUGUST $ 560,000 SEPTEMBER$ 680,000

OCTOBER $ 660,000NOVEMBER $ 790,000DECEMBER $ 890,000

According to the company plans an estimated 15% increase in sales reported during the months of last year are appropriate.

PROJECTING THE CHARGES BEING OF SALES AS FOLLOWS:

60% of sales are projected monthly charge during the same month. Due to a new collection policy will offer one and a half (11/2)% discount if customers pay within ten days from the invoice date. It is projected that 3/5 of customers are welcome to this term receivables.

20% of sales are projected to charge each month following the month of the sale month.

15% of sales each month are projected to charge two months following the month of sale.

5% sales charge each month projected three months following the month of sale. Because economic indicators and financial forecasts of the experts, you should consider this product projected recovery, 2.75% is uncollectible.

SHOPPING FOR GOODS SALES

Sales projections equally affect purchases. These represent 50% of monthly sales projected. Purchased during the month of sale and are projected to pay within the same month with a two% cash discount.

MONTHLY EXPENSES AND EXPENDITURES FOR HOME OF DEBTS

EXPENSES:

WAGES24.5% OF SALES MONTHLY

COMMISSIONS $ 2% IN PROJECTED MONTHLY SALES MORE THAN 3.5% CHARGED MONTHLY

PAYROLL10.9% FROM THE PAID IN WAGES AND COMMISSIONS

UTILITIES $ 55,000 MONTHLY EARNINGS

INTEREST 6.5% ANNUAL INTEREST OF BALANCE OF HOME A DIVIDED TO IMPLEMENT A MONTHLY

MORTGAGE

12% ANNUAL PRINCIPAL BALANCE OF A DIVIDED MONTHLY TO APPLY TO THE OTHER

HOME OF DEBTS:

MORTGAGE $ 450,000 PAYMENT OF TOTAL MONTHLY HOME HOME OF $ 10,000.

OTHER DEBTS $ 500,000 HOME WITH TOTAL MONTHLY PAYMENTS OF PRINCIPAL OF $ 5,000.

REQUIRED PREPARE FOR NEXT BUDGETS 2014:

1. BUDGET OF SALES AND COLLECTIONS

2. BUDGET FOR PURCHASES AND PAYMENTS SHOPPING

3. BUDGET EXPENDITURES OF EXPENSES AND LIABILITIES

4. CASH BUDGET.

a. BALANCE AT THE BEGINNING IS $ 0.00

b. DESIRED MINIMUM BALANCE $ 50,000 MONThly

5. IF NEED FINANCING TO MEET THE DEFICIENCY OF CASH FOR THE MONTH AND POLICIES OF THE COMPANY BALANCE OF THIS BUILD A 10% INTEREST FOR SIMPLE AND TIME OUTSTANDING BALANCE. AS SOON CASH BALANCE OVER THE DESIRED MINIMUM PROVIDED.

NOTE; BE SURE THE PRESENTATION IN ELECTRONIC FORMAT SHEET WHETHER OR SIMILAR AND EXCEL that fits ON A (S) SHEET

Dot Image

Click chat on right side to get answer. Click on Chat
Whatsapp Lisa