Problem Set 3. Cash Budget Cash Budget Danielle Stone is the manager of an airport gift shop. From the following data, Mr. Stone wants as cash budget showing expected cash receipts and disbursements for the month of April, and the cash balance expected as of April 30, 2019. a. Planned cash balance as of March 31, 2019: P100,000 b. Accounts Receivables as of March 31, 2019; P530,000, total where P80,000 form February sales, P450,000 March sales c. Accounts payable, March 31,2019: P460,000 d. Merchandise purchase for April: P450,000 e. Other expenses for April, payable in June, P7500 f. Depreciation for April, P2, 100 g. Insurance policy, P1,500 h. Sales for April, P1,000,000, half collected in month of sale, 40% in the next month, 10% in the third month 39. Compute the total cash available. 40. Compute the total disbursement. 41. How much is the cash balance for the month of April 30, 2019?

Problem Set 3. Cash Budget Cash Budget Danielle Stone is the manager of an airport gift shop. From the following data, Mr. Stone wants as cash budget showing expected cash receipts and disbursements for the month of April, and the cash balance expected as of April 30, 2019. a. Planned cash balance as of March 31, 2019: P100,000 b. Accounts Receivables as of March 31, 2019; P530,000, total where P80,000 form February sales, P450,000 March sales c. Accounts payable, March 31,2019: P460,000 d. Merchandise purchase for April: P450,000 e. Other expenses for April, payable in June, P7500 f. Depreciation for April, P2, 100 g. Insurance policy, P1,500 h. Sales for April, P1,000,000, half collected in month of sale, 40% in the next month, 10% in the third month 39. Compute the total cash available. 40. Compute the total disbursement. 41. How much is the cash balance for the month of April 30, 2019?

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter6: Managing Cash Flow

Section: Chapter Questions

Problem 1EP

See similar textbooks

Similar questions

CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2019 and 2020: Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depreciation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2019. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal, and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if all financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain.
ONLY ANSWER QUESTION (B) the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade…
You are required to prepare the cash budget for the two months of January and February 2021. The following is the projected information: December 2020 January 2021 February 2021 Cash sales R221,866 R239,058 R249,441 Receivables collection R188,565 R194,354 R206,276 Cash purchases R8,949 R10,443 R13,354 Operating expenses R47,858 R54,026 R66,970 Credit purchases R76,504 R82,520 R94,445 Operating expenses are paid in the month they are incurred and credit purchases are paid within 30 days of purchase (ie. in the following month). The bank balance on 1 January 2021 is expected to be R62,819 favourable. Equipment to the value of R239,357 is to be purchased on credit in January 2021 and will be paid for in 8 equal instalments, commencing on 1 February 2021. The expected payments total for February 2021 will be:
Use the information provided by Tech Talk to prepare the following for March and April 2024: 1.1 Cash Budget 1.2 Debtors Collection Schedule INFORMATION The following information was provided by Tech Talk: 1. Tech Talk expects to have a favourable bank balance of R70 000 on 28 February 2024. 2. Budgeted sales figures for 2024 are as follows: January R420 000 R470 000 3. 4. 5. 6. 7. Cash sales Credit sales 9. February R470 000 R490 000 Total purchases March R610 000 R620 000 Thirty percent (40%) of the cash sales is to informal traders who are entitled to a discount of 20%. Collections from debtors are usually as follows: • 80% is collected in the month after the sale. 20% is collected two months after the sale. Purchases of inventory are expected to be as follows: January R310 000 February R360 000 April R650 000 R600 000 March R300 000 Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance is purchased on credit. Creditors are paid two…
the task of preparing the cash budget for the business for the quarter ending September 30, 2022. Your data collection has yielded the following:i) Extracts from the sales and purchases budgets are as follows:Month CashSales SalesOn Account CashPurchases PurchasesOn AccountMay $75,000 $480,000 $390,000June $135,000 $600,000 $36,000 $360,000July $86,800 $720,000 $61,700 $450,000August $105,600 $640,000 $68,800 $400,000September $112,500 $800,000 $77,250 $500,000ii) An analysis of the records shows that trade receivables (accounts receivable)…
You are required to prepare the cash budget for the two months of January and February 2021. The following is the projected information: January 2021 February 2021 Cash sales R280,336 R305,132 Receivables collection R69,602 R70,277 Cash purchases R34,997 R36,515 Rent payment R7,545 R7,545 The bank balance on 1 January 2021 is expected to be R201,806 favourable. A fixed deposit for R113,959 is expected to mature on 25 January 2021. Equipment to the value of R142,119 is to be purchased on credit in January 2021 and will be paid in full on 28 February 2021. The expected closing bank balance on 31 January 2021 will be R _________ .
Preparing a financial budget—schedule of cash receipts and schedule of cash payments</b></p><p>Agua Cool is a distributor of bottled water. For each of the items, compute the number of cash receipts or payments Agua Cool will budget for September. The solution to one item may depend on the answer to an earlier item. Management expects to sell equipment that cost $14,000 at a gain of $7,000. Accumulated depreciation on this equipment is $55,000. Management expects to sell 7,100 cases of water in August and 9,000 cases in September. Each case sells for $14. Cash sales average 20% of total sales, and credit sales make up the rest. Three-fourths of credit sales are collected in the month of the sale, with the balance collected the following month. The company pays rent and property taxes of $4,500 each month. Commissions and other selling expenses average 30% of sales. Agua Cool pays one—half of the commissions and other selling expenses in the month incurred, with the…
Current Attempt in Progress Adam S, managing director of "Summer Breeze", a swimsuit manufacturing company, has requested you to prepare a cash budget for the months of January and February 2020. To assist in this task, they have provided the following information: • Cash balance at the end of December 2019 is $64,400; • Each swimsuit is sold for $12 each and actual sale for November and December 2019 and projected sale for January and February 2020 are as follows: Cash Sales (Quantity) Credit Sales (Quantity) Total Sales November 4,600 units 5,600 units 10,200 units December 7,000 units 8,500 units 15,500 units January 6,100 units 8,100 units 14,200 units February 4,400 units 5,600 units 10,000 units
Hello. Help me to solve sub part (d) and (e) from this question
Styles Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages ( OMR) Over heads (OMR) (OMR) (OMR) August September October 20000 10200 3800 1900 21000 10000 3800 2100 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1.. Sales /Debtors 10% sales are on Cash, 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors- materials 2 months Wages 1 month -1 month Overheads 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1* December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax to be received in December RO.5000
MAKE A CASH BUDGET
A. Prepare Cash Budget for the period of 6 months from July to December 2020. B. Explain the advantages and disadvantages of cash budgeting.