Required Budgets are as calculated below:
Particulars | Amount ($) |
Cash collections in October | |
Account Receivable (September) | 170,000 |
Cash Sales of October (35% of 640,000) | 224,000 |
Credit Sales of October (640,000*.65*.5) | 208,000 |
Total cash collections | 602,000 |
Particulars | Amount ($) |
Cost of goods sold (45% of 640,000) | 288,000 |
Add: Closing inventory (10%*45%*650,000) | 29,250 |
Less: Beginning inventory (288,000*.10) | -86,400 |
Merchandise Purchase | 230,850 |
Particulars | Amount ($) |
Cash payments in October | |
Accounts Payable (September) | 217,900 |
October purchases (230,850*.2) | 46,170 |
Total cash disbursement | 264,070 |
Income Statement | |
Particulars | Amount ($) |
Sales | 640,000 |
Less: Cost of goods sold | 288,000 |
Gross profit | 352,000 |
Less: expenses | |
Depreciation expense | 2,490 |
Selling and administration exp | 18,340 |
Net operating income | 331,170 |
Wheeling Company | |
Budgeted balance Sheet | |
Oct-31 | |
Assets | |
Cash (61,000+602,000-264,070-18,340) | 380,590 |
Accounts Receivable (640,000*.65*.5) | 208,000 |
Inventory | 29,250 |
Building and equipment Net of accumulated dep | 246,510 |
Total assets | 864,350 |
Liabilities and Stockholders' Equity | |
Accounts Payable (230,850*.8) | 184,680 |
Common Stock | 216,000 |
Retained earnings (132,500+331,170) | 463,670 |
Total liabilities and stockholders' equity | 864,350 |
Sipped Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 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 $ 69,400 166,000 83,700 257,000 $ 576,100 $ 246,600 216,000 113,500 $ 576,100 The company is in the process of preparing a budget for October and has assembled the...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below. Slapped Wheeling Company Balance Sheet September 30 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 $ 61,000 170,000 86.400 249,000 $566.400 ebook Relerences $ 217.900 216.000 132.500 $566,400 The company is in the process of preparing a budget for October and has assembled...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash $ 77,800 Accounts receivable 134,000 Inventory 62,100 Buildings and equipment, net of depreciation 284,000 Total assets $ 557,900 Liabilities and Stockholders’ Equity Accounts payable $ 225,900 Common stock 216,000 Retained earnings 116,000 Total liabilities and stockholders’ equity $ 557,900 The company is in the process of preparing a budget for October and has assembled the...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 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 $ 62,600 106,000 43,200 235,000 $ 446,800 $ 121,800 216,000 109,000 $ 446,800 The company is in the process of preparing a budget for October and has assembled the...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets 71,600 122,000 54,000 279,000 Cash Accounts receivable Inventory Buildings and equipment, net of depreciation $526,600 Total assets Liabilities and Stockholders' Equity Accounts payable Common stock 155,600 216,000 155,000 $526,600 Retained earnings Total liabilities and stockholders' equity The company is in the process of preparing a budget for October and has assembled the following data: 1. Sales...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 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 $ 59,000 90,000 32,480 214,000 $ 395,400 $ 73,000 216,000 106,400 $ 395,400 The company is in the process of preparing a budget for October and has assembled the...
Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash $ 62,600 Accounts receivable 106,000 Inventory 43,200 Buildings and equipment, net of depreciation 235,000 Total assets $ 446,800 Liabilities and Stockholders’ Equity Accounts payable $ 121,800 Common stock 216,000 Retained earnings 109,000 Total liabilities and stockholders’ equity $ 446,800 The company is in the process of preparing a budget for October and has assembled the...
Wheeling Company is a merchandiser that provided a balance sheet as of september 30 as shown below Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 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 $ 72,200 162.000 81,000 255,000 $570,200 $ 238,700 216.000 115,500 $570,200 The...
please answer question 2 (A-E) Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciati Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and stockholders' equity 59,000 90,000 32,400 214,000 $ 395,400 $ 73,000 216,000 106,400 $ 395,400 ter 8 Saved Help Save & Exit Submit The company is in...
pleasd answer question 1 (A-E) Wheeling Company is a merchandiser that provided a balance sheet as of September 30 as shown below: Wheeling Company Balance Sheet September 30 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 59,000 90,000 32,400 214,000 395,400 73,000 216,000 106,400 $ 395,400 The company is in the process of preparing a budget for October and has...