Given the above information, the projected ending cash balance for February will be Use the following information for items 18 and 19Cooper Company'smanagement team is preparing a cash budget for the coming quarter. Thefollowing budgeted information is under review.January FebruaryMarchRevenueP700.000 P800,000 P500.000Inventory purchasesOther expenses350.000425,000225,000175,000150.000175.000The company expects to collect 40% of its monthly sales in the month of sale and 60% in the followingmonth. 50% of inventory purchases are paid in the month of purchase, and the other 50% in thefollowing month. All payments for other expenses are mado in the month incurred. Cooper forecaststhe following account balances at the beginning of the quarter.P100.000300.000CashAccounts receivableAccounts payable (Inventory)500,000

Cash budget is one of the budget which is being prepared in business. It shows expected cash…

Answered: Given the above information, the…

Business

Accounting

Given the above information, the projected ending cash balance for February will be

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $57,000.
You are preparing a cash budget for the month of September. how would you use information about sales in the preceding July?
Here is a forecast of sales by National Bromide for the first four months of 2019 (figures in $ thousands): Month 1 Month 2 Month 3 Month 4 Cash sales 17 26 20 16 Sales on credit 120 140 110 90 On the average 52% of credit sales are paid for in the current month, 32% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? (Do not round intermediate calculations. Enter your answers in thousands rounded to the nearest whole number.)
Prepare a direct materials budget for the first quarter of the financial year ending 30 September 2022. Prepare a cash budget for the first quarter of the financial year ending 30 September 2022 including any necessary schedules. Prepare a budgeted income statement for the first quarter of the financial year ending 30 September 2022.
A company is planning to prepare Budget for the year 2022. In the budgeting and planning process, which one of the following should be completed first? a. Cost management plan b. Financial budget C.Sales budget d. Strategic plan
j
Martin Clothing Company is a retail company that sells hiking and other outdoor gear specially made for the desert heat. It sells to individuals as well as local companies that coordinate adventure getaways in the desert for tourists. The following information is available for several months of the current year: Month May June July August Sales $ 99,000 118,000 135,000 132,000 Purchases $ 63,000 89,000 115,000 72,000 Required 1 Required 2 The majority of Martin's sales (65 percent) are cash, but a few of the excursion companies purchase on credit. Of the credit sales, 35 percent are collected in the month of sale and 65 percent are collected in the following month. All of Martin's purchases are on account with 55 percent paid in the month of purchase and 45 percent paid the following month. Required: 1. Determine budgeted cash collections for July and August. 2. Determine budgeted cash payments for July and August. Cash Expenses Paid $ 22,000 Complete this question by entering your…
Required:(a) The business needs to have a sense of its future cash flows and therefore requires thepreparation of the following:▪ A schedule of budgeted cash collections for trade receivables (sales on account) for each ofthe months January to March. ▪ A schedule of expected cash disbursements for accounts payable (purchases on account)for each of the months January to March. ▪ A cash budget, with a total column, for the quarter ending March 31, 2022, showing theexpected cash receipts and payments for each month and the ending cash balance for eachof the three months, given that no financing activities took place.
When gathering financial information, the entrepreneur should develop a budget that includes expected sales and expense figures for the first year. True or false
The controller of Optimum wishes to improve the company's control system by preparing a monthly cash budget. The following information relates to the month ending July 31, 2021: June 30, 2021, cash balance Dividends were declared on June 15* $130,000 44, 000 83,600 13,000 198,000 122,400 47,000 70, 000 Cash expenditures to be paid in July for operating expenses Depreciation expense Cash collections to be received Merchandise purchases to be paid in cash Equipment to be purchased for cash Optimum wishes to maintain a minimum cash balance of *Dividends are payable to shareholders of record on declaration date, 30 days after declaration. Required: 1. Prepare a cash budget for the month ending July 31, 2021, indicating how much, if anything, Optimum will need to borrow to meet its minimum cash requirement. (Leave no cells blank - enter "O" wherever required).
Develop a cash budget for the next three months using the information provided below. Monthly sales forecasts are $150,000, $180,000, and $60,000 (June, July, August) The current month's sales are $120,000 (May) Cost of goods sold equals 65% of sales Lease payment= 22,000 per month The company is required to pay an installment of $120,000 for a note (debt) The cash position at the end of the current month is $80,000 The target cash balance is $50,000 Assume that 60% of sales are collected in the month sold and the remaining collected in the following month.
Here is a forecast of sales by National Bromide for the first four months of 2022 (figures in $ thousands): Month 1 Month 2 Cash sales Sales on credit 16 110 25 130 Month 3 Month 4 19 100 15 80 On average, 51% of credit sales are paid for in the current month, 31% are paid in the next month, and the remainder are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4? Note: Do not round intermediate calculations. Enter your answers in thousands and rounded to one decimal place. Items Month 3 Month 4 Expected Cash Inflow from Operations (in $ thousands)