Question

In: Accounting

Additional information on the financial results of the company Caribe Supplies Inc. This information plus the...

Additional information on the financial results of the company Caribe Supplies Inc. This information plus the projections are based on the basis for planning and preparing budgets for next year.

SALES FOR MONTHS DURING THE PAST YEAR 2015

JANUARY $ 320,000 FEBRUARY $ 400,000 MARCH $ 525,000
APRIL $ 470,000 MAY $ 680,000 JUNE $ 725,000
JULY $ 490,000 AUGUST $ 560,000 SEPTEMBER $ 680,000
OCTOBER $ 660,000 NOVEMBER $ 790,000 DECEMBER $ 890,000

According to the plans of the company it is estimated that a 15% increase in sales reported during the months of last year appropriate child.

THE SALES CHARGES ARE BEING PROJECTED IN THE FOLLOWING WAY:

60% of the sales of each month are projected to be charged during the same month. Due to a new billing policy, a half (11/2)% discount is offered if customers pay within ten days from the billing date. It is expected that 3/5 of the customers will benefit from this collection term.

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

15% of the sales of each month was created in charging the two months to the month of the sale.

5% of the sales of each month was created in the second month of the sale. Because 2.75% is uncollectible, 2.75% is co-productive.

PURCHASES OF GOODS FOR SALES

Sales projections affect purchases equally. These represent 50% of the projected unified sales. They are purchased during the month of the sale and offered within the same month with a cash discount.

MONTHLY DISBURSEMENTS FOR EXPENDITURE AND PRINCIPAL OF DEBTS

EXPENSES:

WAGES 24.5% OF MONTHLY SALES
COMMISSIONS $ 2% IN THE PROJECTED SALES EACH MONTH MORE THAN 3.5% OF THE MONTHLY COLLECTED
NOMINAS 10.9% OF WHAT WAS PAID IN WAGES AND COMMISSIONS
UTILITIES $ 55,000 MONTHLY
INTERESTS 6.5% YEARLY OF THE BALANCE SHEET OF THE PRINCIPAL A DIVISION MONTHLY TO APPLY TO THE MORTGAGE
12% ANNUAL OF THE BALANCE OF THE MAIN ONE DIVISION MONTHLY TO APPLY TO THE OTHERS

MAIN DEBTS:

MORTGAGES $ 450,000 OF MAIN TOTAL WITH MONTHLY PRINCIPAL PAYMENTS OF $ 10,000.

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


REQUIRED PREPARE THE FOLLOWING BUDGETS FOR 2014:

1. SALES AND CHARGES BUDGET
2. BUDGET OF PURCHASES AND PAYMENTS OF PURCHASES
3. BUDGET OF DISBURSEMENTS OF EXPENDITURE AND DEBTS
4. CASH BUDGET.
to. BALANCE AT THE BEGINNING IS $ 0.00
second. MINIMUM EQUILIBRIUM DESIRED $ 50,000 MONTHLY
5. IN THE CASE OF THE NEED FOR FINANCING, TO COMPLY WITH THE DEFICIENCY OF CASH FOR THE MONTH AND THE BALANCE POLICIES OF THE COMPANY, THIS WILL ACCUMULATE 10% SIMPLE INTEREST FOR THE BALANCE AND TIME IN CIRCULATION. AS SOON AS EFFECTIVE IS AVAILABLE IN EXCESS TO THE MINIMUM BALANCE DESIRED.

NOTE; MAKE SURE THAT THE PRESENTATION IS IN ELECTRONIC SHEET FORMAT, EITHER EXCEL OR SIMILAR AND THAT IT IS ACCOMMODATED IN ONE (S) SHEET

Solutions

Expert Solution

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

The following financial statements and additional information are reported
Required information Exercise 12-11 Indirect: Preparing statement of cash flows LO P1, P2, P3, A1 The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 87,500 $ 44,000 Accounts receivable, net 65,000 51,000 Inventory 63,800 86,500 Prepaid expenses 4,400 5,400 Total current assets 220,700 186,900 Equipment 124,000 115,000 Accum. depreciation—Equipment (27,000 ) (9,000 ) Total assets $ 317,700 $ 292,900 Liabilities and Equity Accounts payable $...
The income statement and additional data of Daily ?Plus, Inc.? follows: a. Acquisition of plant assets...
The income statement and additional data of Daily ?Plus, Inc.? follows: a. Acquisition of plant assets is $116,000. Of this? amount, $106,000 is paid in cash and $10,000 by signing a note payable. b. Cash receipt from sale of land totals $21,000.There was no gain or loss. c. Cash receipts from issuance of common stock total $34,000. d. Payment of note payable is $9,000. e. Payment of dividends is $12,000. f. From the balance? sheet: September 30 2018 2017 Cash...
Selected financial statement information and additional data for Doble Siete Inc. is presented below. Prepare a...
Selected financial statement information and additional data for Doble Siete Inc. is presented below. Prepare a statement of cash flows for the year ending December 31, 2012                                                                                                                                 December 31                                                                                                                 2011                                       2012 Cash..........................................................     $42,000                                 $75,000 Accounts receivable (net)...........................       84,000                                 144,200 Inventory..................................................     168,000                                 201,600 Land..........................................................       58,800                                   16,000 Equipment.................................................     504,000                                789,600 TOTAL............................................ $856,800                           $1,226,400 Accumulated depreciation..........................     $84,000                              $115,600 Accounts payable.......................................       50,400                                   86,000 Notes payable - Short-term........................       67,200                                   29,400 Notes payable - Long-term.........................     168,000                                 302,400 Common stock...........................................     420,000                                 487,200 Retained earnings......................................       67,200                                205,800 TOTAL............................................ $856,800                            $1,226,400 Additional data for 2012: 1.    Net income was $240,200. 2.    Depreciation was $31,600. 3.    Land was sold at its original...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2018 and 2017 2018 2017 Assets Cash $ 83,900 $ 50,000 Accounts receivable, net 74,000 57,000 Inventory 69,800 95,500 Prepaid expenses 5,000 6,600 Total current assets 232,700 209,100 Equipment 130,000 121,000 Accum. depreciation—Equipment (30,000 ) (12,000 ) Total assets $ 332,700 $ 318,100 Liabilities and Equity Accounts payable $ 31,000 $ 39,000 Wages payable 6,600 16,200 Income taxes payable 4,000 5,000 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 103,900 $ 50,000 Accounts receivable, net 74,000 57,000 Inventory 69,800 95,500 Prepaid expenses 5,000 6,600 Total current assets 252,700 209,100 Equipment 130,000 121,000 Accum. depreciation—Equipment (30,000 ) (12,000 ) Total assets $ 352,700 $ 318,100 Liabilities and Equity Accounts payable $ 31,000 $ 39,000 Wages payable 6,600 16,200 Income taxes payable 4,000 5,000 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 87,500 $ 44,000 Accounts receivable, net 65,000 51,000 Inventory 63,800 86,500 Prepaid expenses 4,400 5,400 Total current assets 220,700 186,900 Equipment 124,000 115,000 Accum. depreciation—Equipment (27,000 ) (9,000 ) Total assets $ 317,700 $ 292,900 Liabilities and Equity Accounts payable $ 25,000 $ 30,000 Wages payable 6,000 15,000 Income taxes payable 3,400 3,800 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 96,700 $ 62,000 Accounts receivable, net 92,000 69,000 Inventory 81,800 113,500 Prepaid expenses 6,200 9,000 Total current assets 276,700 253,500 Equipment 142,000 133,000 Accum. depreciation—Equipment (36,000 ) (18,000 ) Total assets $ 382,700 $ 368,500 Liabilities and Equity Accounts payable $ 43,000 $ 57,000 Wages payable 7,800 18,600 Income taxes payable 5,200 7,400 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2018 and 2017 2018 2017 Assets Cash $ 77,300 $ 61,000 Accounts receivable, net 90,500 68,000 Inventory 80,800 112,000 Prepaid expenses 6,100 8,800 Total current assets 254,700 249,800 Equipment 141,000 132,000 Accum. depreciation—Equipment (35,500 ) (17,500 ) Total assets $ 360,200 $ 364,300 Liabilities and Equity Accounts payable $ 42,000 $ 55,500 Wages payable 7,700 18,400 Income taxes payable 5,100 7,200 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets Cash $ 105,700 $ 47,000 Accounts receivable, net 69,500 54,000 Inventory 66,800 91,000 Prepaid expenses 4,700 6,000 Total current assets 246,700 198,000 Equipment 127,000 118,000 Accum. depreciation—Equipment (28,500 ) (10,500 ) Total assets $ 345,200 $ 305,500 Liabilities and Equity Accounts payable $ 28,000 $ 34,500 Wages payable 6,300 15,600 Income taxes payable 3,700 4,400 Total current liabilities...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30,...
The following financial statements and additional information are reported. IKIBAN INC. Comparative Balance Sheets June 30, 2017 and 2016 2017 2016 Assets Cash $ 103,300 $ 51,000 Accounts receivable, net 75,500 58,000 Inventory 70,800 97,000 Prepaid expenses 5,100 6,800 Total current assets 254,700 212,800 Equipment 131,000 122,000 Accum. depreciation—Equipment (30,500 ) (12,500 ) Total assets $ 355,200 $ 322,300 Liabilities and Equity Accounts payable $ 32,000 $ 40,500 Wages payable 6,700 16,400 Income taxes payable 4,100 5,200 Total current liabilities...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT