Edelmar Corp. has prepared a preliminary cash budget for the third quarter as shown below:Cash BudgetBeginning cash balancePlus: Cash collectionsCash availableLess: Cash payments:Purchases of direct materialsJuly$36,000$56,00092,000Operating expensesCapital expendituresEnding cash balanceAug$17,000$52,000$69,00034,00041,0000$17,000Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $54,000 in July, $55,000 in August, and $44,000 inSeptember. Based on the new data, calculate the new projected cash balance at the end of JulySep$21,50047,800$69,3009,00030,5008,000$21,50010,00030,8007,700$20,800

Cash budget is an estimation of cash inflows and cash outflows over a period of time.it can be…

Cash Budget Beginning cash balance Plus: Cash collections Cash available Less: Cash payments: Purchases of direct materials July Aug Sep $21,500 $36,000 $17,000 $56,000 $52,000 47,800 92,000 $69,000 $69,300 34,000 41,000 0 $17,000 Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $54,000 in July, $55,000 in August, and $44,000 in September. Based on the new data, calculate the new projected cash balance at the end of July Operating expenses Capital expenditures Ending cash balance 9,000 30,500 8,000 $21,500 10,000 30,800 7,700 $20,800

Cash Budget Beginning cash balance Plus: Cash collections Cash available Less: Cash payments: Purchases of direct materials July Aug Sep $21,500 $36,000 $17,000 $56,000 $52,000 47,800 92,000 $69,000 $69,300 34,000 41,000 0 $17,000 Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $54,000 in July, $55,000 in August, and $44,000 in September. Based on the new data, calculate the new projected cash balance at the end of July Operating expenses Capital expenditures Ending cash balance 9,000 30,500 8,000 $21,500 10,000 30,800 7,700 $20,800

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

The subject is Managerial Accounting
subject - accounting
Accounting Consider the following third-quarter budget data for TAP & Brothers: TAP & Brothers Third-Quarter Budget Data July August September Credit Sales 256,167 262,962 282,872 Credit Purchases 97,465 111,565 137,292 Wages, Taxes, and Expenses 26,506 31,621 33,707 Interest 7,239 7,773 8,091 Equipment Purchases 54,832 61,271 0 The company predicts that 4% of its credit sales will never be collected, 30% of its sales will be collected in the month of the sale, and the remaining 66% will be collected in the following month. Credit purchases will be paid in the month following the purchase. In June, credit sales were $138,282, and credit purchases were $102,770 July’s beginning cash is $184,797 If TAP maintains a policy of always keeping a minimum cash balance of $75,000 as a buffer against uncertainty and forecasting errors, what is the cash surplus/deficit at the end of the quarter (i.e., end of…
Please don't give image format
! Required information [The following information applies to the questions displayed below.] Built-Tight is preparing its master budget. Budgeted sales and cash payments follow: July $ 56,000 August $ 72,000 September $ 56,000 Budgeted sales Budgeted cash payments for Direct materials 15,560 3,440 19,600 12,840 2,760 16,200 13,160 2,840 16,600 Direct labor Overhead Sales to customers are 20% cash and 80% on credit. Sales in June were $53,500. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances of $47,000 in cash and $4,400 in loans payable. A minimum cash balance of $47,000 is required. Loans are obtained at the end of any month when the preliminary cash balance is below $47,000. Interest is 1% per month based on the beginning-of-the-month loan balance and is paid at each month-end. Any preliminary cash balance above $47,000 is used to repay loans at month-end. Expenses are paid in the month incurred and consist of sales…
Beginning cash balance as on March 1, P80,000. Cash receipts from sales P400,000 Budgeted cash disbursements for purchases 250,000. Budgeted cash disbursements for salaries 90,000. Cash repayment of bank loan 30,000. Prepare a cash budget for the month ended on March 31 for Spars Corp.
RequiredPrepare cash budget, for the three month from October to December showing cash balance at the end of December .
A company's budgeted sales and cash payments for merchandise for the next two months follow. July August Budgeted sales $ 33,300 $ 42,300 Budgeted cash payments for merchandise purchases 20,510 17,540 Sales in June are $26,800. Sales are 40% cash and 60% on credit. All credit sales are collected in the month after the sale. The June 30 balance sheet includes $12,600 in cash and $2,100 in loans payable. The company requires a $12,600 minimum cash balance. The company takes loans as needed at month-end to meet this minimum balance. Interest of 1% month (based on the loan balance at the beginning of the month) is paid at each month-end. Preliminary cash balances above $12,600 at each month-end are used to repay any loans. Expenses include office salaries of $5,410 per month, rent of $3,310 per month, sales commissions at 10% of sales dollars, and shipping at 2% of sales dollars; these expenses are paid in the month incurred. Dividends of $1,160 will be paid in August. Prepare a schedule…
October November December Budgeted S&A Expenses Salary Expense 10,000 10,500 11,000 Sales Commissions 5% of Sales. 5,300 5,000 5,500 2,000 Insurance Expense 2,000 2,000 Rent 2,400 2,400 2,400 1,500 1,500 1,500 Depreciation on equipment Utilities 1,100 1,300 1,500 Total Operating Expenses 22,000 23, 200 23,700 Schedule of Cash Payments for S&A Expenses Salary Expense ? 10,500 ? 100% of Prior Month Sales 5,100 ? ? Commissions Insurance Expense 2,000 2,000 ? 2,000 2,400 Rent ? 100% of Prior Months Utilities 1,200 ? ? Expense Total Payments for S&A Expenses ? ? ? What is the total amount of S&A expenses for the fourth quarter that the company will report on its pro forma income statement? Multiple Choice $64,400 $68,900 $23,700 $63,900
The following information was used by the Long Corporation to prepare a cash budget for April: Cash balance beginning of April $ 16,000 Expected cash receipts in April 272,000 Sales salaries paid 62,000 Material purchases (all cash) 94,000 Depreciation charges 44,000 Other expenses (all cash) 96,000 What is the budgeted ending cash balance in April? Multiple Choice None of these. $36,000 $45,000 $22,000 $ (8,000)
please help with this budgeted income statement
bh.2