Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below:AssetsCash.Accounts receivableInventoryBuildings and equipment, net of depreciationTotal assetsLiabilities and Stockholders' EquityAccounts payableCommon stockRetained earningsTotal liabilities and stockholders' equityWheeling CompanyBalance SheetSeptember 30$ 59,00090,00032,400214,000$395,400$ 73,000216,000106,400$395,400The company is in the process of preparing a budget for October and has assembled the following data:1. Sales are budgeted at $240,000 for October and $250,000 for November. Of these sales, 35% will be for cash; the remainder will be credit sales. Forty percent of a month's creditsales are collected in the month the sales are made, and the remaining 60% is collected in the following month. All of the September 30 accounts receivable will be collected inOctober.2. The budgeted cost of goods sold is always 45% of sales and the ending merchandise inventory is always 30% of the following month's cost of goods sold.3. All merchandise purchases are on account. Thirty percent of all purchases are paid for in the month of purchase and 70% are paid for in the following month. All of the September 30accounts payable to suppliers will be paid during October.4. Selling and administrative expenses for October are budgeted at $78,000, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,000 for themonth. Required:1. Using the information provided, calculate or prepare the following:a. The budgeted cash collections for October.b. The budgeted merchandise purchases for October.c. The budgeted cash disbursements for merchandise purchases for October.d. The budgeted net operating income for October.e. A budgeted balance sheet at October 31.2. Assume the following changes to the underlying budgeting assumptions: (1) 50% of a month's credit sales are collected in the month the sales are made and the page 390remaining 50% is collected in the following month, (2) the ending merchandise inventory is always 10% of the following month's cost of goods sold, and (3) 20% of allpurchases are paid for in the month of purchase and 80% are paid for in the following month. Using these new assumptions, calculate or prepare the following:a. The budgeted cash collections for October.b. The budgeted merchandise purchases for October.c. The budgeted cash disbursements for merchandise purchases for October.d. Net operating income for the month of October.e. A budgeted balance sheet at October 31.3. Compare your answers in requirement 1 to those that you obtained in requirement 2. If Wheeling Company is able to achieve the budgeted projections described in requirement 2, willit improve the company's financial performance relative to the projections that you derived in requirement 1?

Comment - Multiple Questions Asked Cash Budget - A projected cash input and outflow over the…

Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Wheeling Company Balance Sheet September 30 paring a budget for October and has assembled the following data: $ 59,000 90,000 32,400 214,000 $395,400 $ 73,000 216,000 106,400 $395,400

Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity Wheeling Company Balance Sheet September 30 paring a budget for October and has assembled the following data: $ 59,000 90,000 32,400 214,000 $395,400 $ 73,000 216,000 106,400 $395,400

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

Dog
Required Information TES-417 Inc. is a retailer. Its accountants are preparing the company's 2nd quarter master budget. The company has the following balance sheet as of March 31. TES-417 Inc. Balance Sheet March 31 Assets Cash $82,000 Accounts receivable Inventory 52,5ee 217,000 Plant and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable 78,000 Common stock 347.000 55,500 Retained earnings Total liabilities and stockholders' equity TES-417 accountants have made the following estimates: 1. Sales for April, May, June, and July will be $280,000, $300.000, $290,000, and $310,000, respectively. 2. All sales are on credit. Each month's credit sales are collected 35% in the month of sale and 65% in the month following the sale. All of the accounts receivable at March 31 will be collected in April. 3. Each month's ending inventory must equal 25% of next month's cost of goods sold. The cost of goods sold is 75% of sales. The company pays for 40%…
Knowledge Check 01 For the budget period ending December 31 of the current year, Aaron Corporation estimates its ending balances for cash as $4,000, accounts receivable as $16,000, finished goods Inventory as $12,000, and raw materials Inventory as $8,000. Invoices relating to raw materials in the amount of $14,000 are expected to be unpaid as of December 31. What is the amount of total current assets that will be reported on the budgeted balance sheet? O $20,000 O $26.000 O $32,000 O $40,000
Schedule of Cash Payments Select Physical Therapy Inc. is planning its cash payments for operations for the third quarter (July-September), 2017. The Accrued Expenses Payable balance on July 1 is $31,700. The budgeted expenses for the next three months are as follows: July August September Salaries $72,900 $88,800 $98,300 Utilities 6,000 6,700 7,900 Other operating expenses 55,400 60,400 66,500 Total $134,300 $155,900 $172,700 Other operating expenses include $4,000 of monthly depreciation expense and $900 of monthly insurance expense that was prepaid for the year on March 1 of the current year. Of the remaining expenses, 75% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on July 1 relates to the expenses incurred in June. Prepare a schedule of cash payments for operations for July, August, and September. Select Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months…
KAYAK COMPANYCash Budget JanuaryFebruaryMarchBeginning cash balance$30,000 $30,000 Add: Cash receipts525,000 400,000 450,000 Total cash available555,000 430,000 Less: Cash payments for All items excluding interest Interest on loan Total cash payments0 0 0 Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan balanceLoan balance - Beginning of month Additional loan (loan repayment) Loan balance, end of month$0 $0 $0
Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Cash Assets Balance Sheet March 31 Liabilities and Stockholders' Equity $ 2,525 Merchandise purchases payable 2,040 3,400 $2,400 710 Dividends payable Stockholders' equity 8,005 Accounts receivable Inventory Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected months in the upcoming year are as follows: Month (in thousands) Sales Revenue January February March April May June July August $2,600 2,700 3,000 3,600 3,800 3,500 3,200 4,000 Monthly operating expenses are as follows: Wages and salaries $750 Depreciation 75 Advertising Other costs 55 350 Cash dividends for the store of $710 thousand are declared during the third month of each quarter and are paid during the first month of the following quarter. Operating expenses,…
Minden Company Balance Sheet April 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Note payable Common stock Retained earnings Total liabilities and stockholders' equity $ 12,700 66,500 48,500 229,000 $ 356,700 $ 67,500 19,100 180,000 90,100 $ 356,700 The company is in the process of preparing a budget for May and has assembled the following data: a. Sales are budgeted at $262,000 for May. Of these sales, $78,600 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder is collected in the following month. All of the April 30 accounts receivable will be collected in May. b. Purchases of inventory are expected to total $196,000 during May. These purchases will all be on account. Forty percent of all purchases are paid for in the month of purchase; the remainder are paid in the…
How do I solve the chart?
Subject: acounting
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.
Schedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows: January February March Salaries $60,300 $73,400 $81,200 Utilities 5,000 5,500 6,600 Other operating expenses 46,400 50,600 $5,700 Total $111,700 $129,500 $143,500 Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for…
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