Assignment Task:

INFORMATION AND DATABASES FOR PROJECTIONS AND WITH BUDGET OPERATION

1. Sales Projection: 20X2

Having consulted on the Company's Managers' Committee, it is agreed or that the business plans and strategies, it was estimated appropriate, 35% increase in sales reported during the months of last year  20x1. All sales are estimated on credit.

Predicting collections based on the monthly sales projection:

  • 70% of projected sales for each month (January, February, March, etc.) plan to charge during the same month  (January, February, March, etc.) . 
  • 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 customers will be eligible for this payment term.
  • 15% of each month's sales are projected to collect the month following the month of the sale. For example: January sales charged in February  and so on.
  • 10% of sales each month are projected to charge two months after the month of the sale. For example: January sales charged in March.
  • 5% of sales each month are projected to charge three months after the month of the sale.
  • 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.
For considerations and apprenticeships of the hurricane phenomenon of Maria, the company's officials have recommended that after determining and calculating the collection projections for each month, appropriate (separate) 10%, from 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 expenses that are projected for the budget year.

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

2. Merchandise Purchase Projection, necessary to meet projected sales. 20X2

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

Procurement projections are for the formulation, structuring and calculations of the Procurement Budget projections

3. Projection of monthly disbursements for operating expenses and the principal of debts with their corresponding interest.  20X2

Gastos: all are paid from projected sales and in the month that is incurred. These are:

Swings:      27.50% of projected monthly sales

Commission:     2% of monthly projected sales, plus 3.5% of what was charged monthly.

Nominee:     10.9% of what is paid in salaries and commissions.

Utilities  :     $4,000per month 

Insurance :    $12,000 per month

Mortgage:     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's balance sheet to be divided monthly to apply to the others.


Amortization of principal of debts:

HIPOTECAS$950,000 of total principal to January. Payments at the end of the month to the main at $30,000. HINT: Simple interest calculation. The main one decreases monthly and the time in the formula will increase the monthly one month at a time.

OTHER DENS$750,000 Dand total main.  Monthly terms of $25,000 principal, at the end of the month. The main one decreases monthly and the time in the formula anger increasing monthly one month at a time.

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

4. Projection of cash flow 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 from previous budgets; plus the information provided below.

  • Initial cash balance - Cash is $50,000
  • The minimum monthly cash balance in the budget period is $100,000.
  • Shareholders are requiring dividends of $150,000 in the months of March, June, September and December.
  • Such dividends will be awarded as long as the company does not have to borrow or finance them with debts. There has to be cash to grant it. There are no payments of less than $150,000.
  • Operational and maximum cash balance gaps,  in the planned months, may be financed by short-term debts.

 

REQUIRED:  PREPARE THE FOLLOWING BUDGETS FOR THE 20X2:

  1. Sales and Collections Budget. Section I. (Remember that the business existed last year 20X1. Therefore, sales in the last months of20X1 are planned to be collected in the period 20X2. Do not include such collections, significantly affect all calculations in  20X2 budgets).
  2. sore of Purchases and Purchase Payments – Section II.
  3. Proposing payments for expenses and debt repayment. Section III.
  4. CASH BUDGET Section IV, with effect from the above.


This Accounting Assignment has been solved by our Accounting Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Alex Cerry
  • Posted on : February 22nd, 2019

Whatsapp Tap to ChatGet instant assistance