Question

In: Accounting

Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a...

Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a cash budget for the four months ending 30 April 2016.

Actual Sales

$

November 2015

60000

December 2015

64000

Forcast sales:

January 2016

65000

Feb 2016

70000

March 2016

72500

April 2016

76250

May 2016

80000

(i) The following sales figures are for the months of November 2015 to June 2016. The figures from January 2016 onward are estimated:

Half the sales are normally paid for in the month in which they occur and the customers are rewarded with a 5% cash discount. The remaining sales are paid for net in the month following the sale.

(ii) Goods are sold at a mark-up of 25% on the goods purchased one month before sale. Half of the purchases are paid for in the month of purchase and a 4% prompt settlement discount is received. The remainder is paid in full in the following month.

(iii) Wages of $12000 per month are paid in the month in which they are earned. It is expected that the wages will be increased by 10% from 1 March 2016.

(iv) Rent will cost $60000 per annum payable three monthly in advance in January, April, July and December each year.

(v) The directors have arranged a bank loan of $60000 which would be credited to company’s current account in February 2016.

(vi) The half-yearly interest on 200000, 8% debentures of $1 each is due to be paid on 15 January 2016.

(vii) The ordinary dividend of $12000 for the year 2015 will be paid in March 2016.

(viii) The bank balance at 31 December 2015 is $12000.

Required: 1) Prepare a cash budget for the four months ended 30 April 2016. Round off to the nearest $.

Please be precise as to how to calculate purhcases (I am very confused as to how this is calculated)

Solutions

Expert Solution


Related Solutions

Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a...
Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a cash budget for the four months ending 30 April 2016. (i) The following sales figures are for the months of November 2015 to June 2016. The figures from January 2016 onward are estimated: Actual Sales $ November 2015 60,000 December 2015 64,000 Forecasted Sales: January 2016 65,000 Feb 2016 70,000 march 2016 72,500 April 2016 76,250 May 2016 80,000 June 2016 78,750 Half the...
Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a...
Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a cash budget for the four months ending 30 April 2016. Actual Sales $ November 2015 60000 December 2015 64000 Forcast sales: January 2016 65000 Feb 2016 70000 March 2016 72500 April 2016 76250 May 2016 80000 (i) The following sales figures are for the months of November 2015 to June 2016. The figures from January 2016 onward are estimated: Half the sales are normally...
Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a...
Management at Caribo Limited were monitoring their cash flow. They requested their accountant to prepare a cash budget for the four months ending 30 April 2016. Actual Sales $ November 2015 60000 December 2015 64000 Forcast sales: January 2016 65000 Feb 2016 70000 March 2016 72500 April 2016 76250 May 2016 80000 (i) The following sales figures are for the months of November 2015 to June 2016. The figures from January 2016 onward are estimated: Half the sales are normally...
LFJ Manufacturing requested the company cost accountant to prepare a cash budget for the four months...
LFJ Manufacturing requested the company cost accountant to prepare a cash budget for the four months ending 30 April 2018. The following sales figures are for the months of November 2017 to June 2018. The figures from January 2018 onward are estimated: Actual Sales for 2017 November...............60,000 December................64,000 Sales Forecast for 2018 January.............65,000 February............70,000 March...................72,500 April..................76,250 May.................80,000 June................78,750 50% of the sales are usually paid for in the month in which they occur, while the remaining sales are paid for...
The following cash flow statement of Friedrich Limited is presented to you: Friedrich Limited Cash flow...
The following cash flow statement of Friedrich Limited is presented to you: Friedrich Limited Cash flow statement for the year ended 31 June 2019 R Cash flow from operating activities (255 000) Operating loss (280 000) Adjustments Depreciation 100 000 Profit before working capital changes ( 180 000) Working capital changes 55 000 Increase in inventory (200 000) Increase in receivables (175 000) Increase/decrease in payables ? Dividends paid (60 000) Interest paid (70 000) Cash flow from investing activities...
A cash budget/ Cash flow statement is requested Any useful report with the information at hand...
A cash budget/ Cash flow statement is requested Any useful report with the information at hand that can assist management one way or the other
8. You are the manager in charge of monitoring cash flow at a company that makes...
8. You are the manager in charge of monitoring cash flow at a company that makes photography equipment. Traditional photography equipment comprises 80 percent of your revenues, which grow about 2 percent annually. You recently received a preliminary report that suggests consumers take three times more digital photographs than photos with traditional film, and that the cross-price elasticity of demand between digital and disposable cameras is -0.2. In 2009, your company earned about $400 million from sales of digital cameras...
PREPARE A CASH FLOW USING THE DIRECT METHOD
DIRECT Method RichCorp Income Statement FYE 12/31/19 Revenues    445,000.00 Cost of Goods Sold    (232,500.00) Operating Expenses    (110,500.00) Interest Expense        (6,000.00) Loss on sale of equipment        (1,000.00) (350,000.00) Income before income taxes      95,000.00 Income tax expense    (32,500.00) Net Income      62,500.00 COMPARATIVE BALANCE SHEET 12/31/2019 12/31/2018 Cash 27,000     18,500.00 Accounts Receivable 34,000     13,000.00 Inventory 27,000                  -   Prepaid Insurance 2,000       3,000.00 Land 22,500     35,000.00 Buildings 100,000 100,000.00 Equipment 96,500     34,000.00 309,000 203,500.00 Accumulated Depreciation, Buildings 10,500       5,500.00 Accumulated Depreciation, Equipment 14,000       5,000.00 Accounts...
Prepare the 2018 cash flow statement for XYZ Corp. Assume no dividends were paid. Financial Statements...
Prepare the 2018 cash flow statement for XYZ Corp. Assume no dividends were paid. Financial Statements for XYZ Corp. Balance Sheet for Period Ending December 31. Assets 2017 2018 Cash and Marketable Securities 40 15 Accounts Receivable 160 80 Inventories 250 370 Total Current Assets 450 465 Gross Plant and Equipment 675 855 less: Accumulated Depreciation 250 300 Net Plant and Equipment 425 555 Total Assets 875 1020 Liabilities and Equity Accounts Payable 15 30 Short-term Bank Loans 35 40...
In order to prepare the Statement of Cash Flows for Egnab Corporation for 2019, the accountant...
In order to prepare the Statement of Cash Flows for Egnab Corporation for 2019, the accountant has compiled the following data regarding cash flows: Cash paid to acquiremarketablesecurities....................... $380,000 Proceeds from sale ofmarketablesecurities....................... $17,500 Proceeds from issuance ofcapitalstock............................. $250,000 Proceeds from issuance ofbondspayable........................... $55,000 Payments to settleshort-termdebt......................................... $32,500 Interest anddividendsreceived............................................... $10,000 Dividendspaid............................................................................ $130,000 Cash paid to suppliersandemployees............................. $1,030,000 Interestpaid.................................................................................. $25,000 Incometaxespaid........................................................................ $70,000 Cash and cash equivalents, January1,2019........................ $43,000 Cash and cash equivalents, December31,2019.................. $63,000 Using the above information, classifythe transactions...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT