The following information was extracted from NOVO cash budget for July 2019. The following data are as follows: Excess of cash available over disbursements is P700; cash balance as of July 1, 2019 is P 5,000 and a total cash disbursement for July is P22,500. The business can only borrow in round figures of P1,000 amounts. If the business is required to maintain a minimum cash balance of P100,000, how much money should be borrowed in July?

The following information was extracted from NOVO cash budget for July 2019. The following data are as follows: Excess of cash available over disbursements is P700; cash balance as of July 1, 2019 is P 5,000 and a total cash disbursement for July is P22,500. The business can only borrow in round figures of P1,000 amounts. If the business is required to maintain a minimum cash balance of P100,000, how much money should be borrowed in July?

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 13EA: What is the amount of budgeted cash payments if purchases are budgeted for $420,000 and the...

See similar textbooks

Similar questions

What is the amount of budgeted cash payments if purchases are budgeted for $420,000 and the beginning and ending balances of accounts payable are $95,000 and $92,000, respectively?
(a) For the current year, Encor Ltd. had net sales of $450,000 and paid $260,000 for the cost of goods sold. They had average receivables of $130,000, average payables of $57,000, and an average inventory of $90,000. Calculate the Operating cycle and Cash cycle for Encor Ltd. Interpret the results. (b) Prepare a Cash Budget based on the info below for the year 2020 for the months of January, February, March, and April. - Encor Ltd., anticipates sales of $18,000 in January 2020, with anticipated growth of 10% per month; - Credit sales are paid 50% the same month and 50% the following month (credit sales for December 2019 was $14,000) - Credit purchases are paid 35% of sales; paid in the month they are incurred - Wages and expenses are 30% of sales every month; paid in the month they are incurred - In February, the company pays $27,000 cash for new equipment - The beginning cash balance is $13,000
If Service World has $1,950 cash, $400 of government Treasury bills purchased last month with a six-week maturity, and $940 of cash set aside for legal reasons, how much will the company report on the balance sheet as “Cash and Cash Equivalents”?
USE THE FOLLOWING INFORMATION TO ANSWER QUESTIONS 4 TO 6. Whittle Ltd is preparing a cash budget for the first six months of the coming year, 2024. The company’s financial manager has pulled all the cash sales and income from the past year (2023) and adjusted them for the expected growth in the coming year already and calculated net cash flows for each month, except for collections from credit sales. The system however does not do credit collection estimates, however an ageing report has been generated. Credit sales over the last four months of 2023 were as follows: September October November December R10 000 R12 000 R15 000 R45 000 Credit sales for the first 6 months of 2024 were estimated as follows: January February March April May June R5 000 R10 000 R12 000 R14 000 R18 000 R25 000 The ageing analysis indicates that on credit sales, payments are usually made as follows for any given month’s sales: 1 month 2 months 3…
Chung Limited is applying for additional bank overdraft finance to enable the company to make the plant and machinery purchase described below. The directors have has asked you to draw up a cash budget for the 6 months to 30 June 2020 to prove to the bank that that overdraft finance will be repaid by 30 June 2020. The company provides you with the following financial information: Month Sales Purchases Wages Overheads £ £ £ £ November 2019 (actual) 45,800 18,400 9,600 6,000 December 2019 (actual) 34,600 13,900 9,800 14,000 January 2020 (budgeted) 42,200 16,800 10,500 7,000 February 2020 (budgeted) 44,000 17,600 11,200 7,500 March 2020 (budgeted) 54,000 21,600 13,500 18,800 April 2020 (budgeted) 57,600 23,000 14,400 8,000 May 2020 (budgeted) 61,800 24,700 15,300 9,200 June 2020 (budgeted) 63,700 25,500 15,900 9,800 Notes: The bank balance at 1 January 2020…
The management of Rain co which was manufacturing rain coats was preparing a cash budget for the month of June 2021. Opening cash balance=P20,000 Cash anticipated for collection=P75,000 Cash anticipated for disbursement=P100,250 To maintain P5,000 as cash balance what amount needs to be borrowed for June month 2021.
NanaKay Company must maintain a minimum cash balance of GH¢25,000. At the beginning of June, the company’s cash balance was GH¢17,000. Budgeted cash receipts for June are GH¢150,000, and budgeted cash disbursements are GH¢201,000. Budgeted net income for July totals GH¢11,000. How much will NanaKay Company need to borrow by the end of June?
During 2021, its first year of operations, Pave Construction provides services on account of $156,000. By the end of 2021, cash collections on these accounts total $108,000. Pave estimates that 20% of the uncollected accounts will be uncollectible, In 2022, the company writes off uncollectible accounts of $8,640. 2-a. Record the write-off of accounts receivable in 2022. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.)
gop.2 During May of 2019, XYZ Inc had an opening cash balance of $500,000, budgeted cash receipts of $400,000 and budgeted cash disbursements of $450,000. The company wishes to maintain a cash balance of $500,000 at the start of each month. Any surplus cash is promptly repaid to the bank while funds are borrowed at the start of each month to cover any anticipated shortfall. XYZ is subject to an annual interest rate of 6% per year (0.5% per month. How much interest expense did XYZ Inc. incur during May 2019? Select one: a. $150 b. $300 c. $250 d. Nil.
QUESTION 2 REQUIRED Prepare the Cash Budget for January, February and March 2021. (Provide separate monetary columns for each month.) INFORMATION Ricoh Limited is planning the business activities of Project Haz for the first three months of 2021. Some of the items in the Statement of Financial Position as at 31 December 2020 are expected to be as fallows: Current assets Debtors/Accounts receivable R 600 000 20 000 Bank Current liabilities Creditors (for material purchases) 100 000 Additional information The following forecasts have been made by Ricoh Limited for the first three months of 2021: 1. Direct materials The costs of production include the following: R26 per unit Direct labour R22 per unit 2. The sales manager anticipates the following sales volumes at a constant price of R160 per unit: January February March 2 300 units 2 500 units 3 400 units All the sales are on credit and debtors pay their accounts in the month after the sale. 3. The purchases manager expects to purchase…
Use the information given below to prepare the following for Altech Limited for July and August 2021:1.1 Debtors Collection Schedule 1.2 Cash Budget Note: Provide separate monetary columns for each month. Where applicable, round off amounts to the nearest Rand.Information:Extract of Statement of Comprehensive Income for the month ended 30 June 2021RSales 200 000Cost of sales 100 000Rent income 8 000Advertising 4 000Salaries and wages 10 000Rates and taxes 1 200Electricity 3 000Other operating expenses 9 000Additional information:1. The business uses a fixed mark-up of 100% on cost.2. Sales are expected to increase by 10% each month.3. Thirty percent (30%) of the sales are for cash and the balance is on credit. Collections from credit sales are as follows: 40% in the month of the sale, and these customers are entitled to a 2% discount; 55% one month after the sale. The balance is usually written off as bad debts.4. Closing Inventories are kept at a constant level. 50% of purchases…
Sheridan Company provided the following information for the month of October: Beginning cash balance=$34700 Cash receipts=459600 Cas disbursements=486000 Sheridan's policy is to keep a minimum end-of-the-month cash balance of $29300. How much will Sheridan need to borrow during October? $21000 $26400 $8300 $0