FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Cash | $ 152,000 | Liabilities | |||
1,308,720 | Accounts payable | $ 763,800 | |||
Raw materials inventory | 374,300 | Loan payable | 12,000 | ||
Finished goods inventory | 1,237,052 | Long-term note payable | 1,900,000 | $ 2,675,800 | |
Equipment | $ 2,280,000 | Equity | |||
Less: |
570,000 | 1,710,000 | Common stock | 1,273,000 | |
833,272 | 2,106,272 | ||||
Total assets | $ 4,782,072 | Total liabilities and equity | $ 4,782,072 |
To prepare a
- Sales for March total 77,900 units. Budgeted sales in units follow: April, 77,900; May, 74,100; June, 76,000; and July, 77,900. The product’s selling price is $24.00 per unit and its total product cost is $19.85 per unit.
- Raw materials inventory consists solely of direct materials that cost $20 per pound. Company policy calls for a given month’s ending materials inventory to equal 50% of the next month’s direct materials requirements. The March 31 raw materials inventory is 18,715 pounds. The budgeted June 30 ending raw materials inventory is 15,200 pounds. Each finished unit requires 0.50 pound of direct materials.
- Company policy calls for a given month’s ending finished goods inventory to equal 80% of the next month’s budgeted unit sales. The March 31 finished goods inventory is 62,320 units.
- Each finished unit requires 0.50 hour of direct labor at a rate of $15 per hour.
- The predetermined variable
overhead rate is $2.70 per direct labor hour. Depreciation of $76,000 per month is the only fixed factory overhead item. - Sales commissions of 8% of sales are paid in the month of the sales. The sales manager’s monthly salary is $11,400.
- Monthly general and administrative expenses include $45,600 for administrative salaries and 0.9% monthly interest on the long-term note payable.
- The company budgets 30% of sales to be for cash and the remaining 70% on credit. Credit sales are collected in full in the month following the sale (no credit sales are collected in the month of sale).
- All raw materials purchases are on credit, and accounts payable are solely tied to raw materials purchases. Raw materials purchases are fully paid in the next month (none are paid in the month of purchase).
- The minimum ending cash balance for all months is $152,000. If necessary, the company borrows enough cash using a loan to reach the minimum. Loans require an interest payment of 1% at each month-end (before any repayment). If the month-end preliminary cash balance exceeds the minimum, the excess will be used to repay any loans.
- Dividends of $38,000 are budgeted to be declared and paid in May.
- No cash payments for income taxes are budgeted in the second calendar quarter. Income tax will be assessed at 35% in the quarter and budgeted to be paid in the third calendar quarter.
- Equipment purchases of $380,000 are budgeted for the last day of June.
Required:
8. Schedule of cash receipts.
9. Schedule of cash payments for direct materials.
10. Cash budget.
Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Enter $0 when applicable. Do not leave cells blank
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 9 images
Knowledge Booster
Similar questions
- Financial Balance Sheet cash Account Receivable Inventories Investment Depreciable assets Accumulated depreciation Account Payable Capital Stock Retained Earnings Unappropriated Beginning of Year $41,200 65,000 40,000 10,000 198,000 (20,000) 30,000 150,000 154,200 End of Year ? $35,700 53,062 45,000 10,000 208,000 (40,000) 35,000 150,000arrow_forwardеBook Problem Walk-Through Lloyd Inc. has sales of $700,000, a net income of $70,000, and the following balance sheet: Cash $147,630 Accounts payable $118,370 Receivables 231,420 Notes payable to bank 95,760 Inventories 678,300 Total current liabilities $214,130 Total current assets $1,057,350 Long-term debt 232,750 Net fixed assets 272,650 Common equity 883,120 Total assets $1,330,000 Total liabilities and equity $1,330,000 The new owner thinks that inventories are excessive and can be lowered to the point where the current ratio is equal to the industry average, 2x, without affecting sales or net income. If inventories are sold and not replaced (thus reducing the current ratio to 2x); if the funds generated are used to reduce common equity (stock can be repurchased at book value); and if no other changes occur, by how much will the ROE change? Do not round intermediate calculations. Round your answer to two decimal places. % What will be the firm's new quick ratio? Do not round…arrow_forwardEnd of Year Beginning of Year Cash and cash equivalents $810 $79 Accounts receivable (net) 2,070 1,890 Inventory 880 910 Other current assets 490 401 Total current assets $4,250 $3,280 Total current liabilities $2,040 $1,630 For the year, net credit sales were $8,258 million, cost of goods sold was $5,328 million, and net cash provided by operating activities was $1,251 million. Compute the current ratio, accounts receivable turnover, average collection period, inventory turnover, and days in inventory for the current year. (Round current ratio to 2 decimal places, e.g. 1.83 and all other answers to 1 decimal place, e.g. 1.8. Use 365 days for calculation.) Current ratio Accounts receivable turnover Average collection period Inventory turnover Days in inventory :1 times days times daysarrow_forward
- Privett Company Accounts payable $ 30,000 Accounts receivable 35,000 Accrued liabilities 7,000 Cash 25,000 Intangible assets 40,000 Inventory 72,000 Long-term investments 100,000 Long-term liabilities 75,000 Marketable securities 36,000 Notes payable (short-term) 20,000 Property, plant, and equipment 400,000 Prepaid expenses 2,000 Based on the data for Privett Company, what is the amount of working capital? Question 26 options: $213,000 $113,000 $153,000 $39,000arrow_forwardAccounts payable $ 30,000 Accounts receivable 35,000 Accrued liabilities 7,000 Cash 25,000 Intangible assets 40,000 Inventory 72,000 Long-term investments 100,000 Long-term liabilities 75,000 Marketable securities 36,000 Notes payable (short-term) 20,000 Property, plant, and equipment 400,000 Prepaid expenses 2,000 Based on the above data, what is the quick ratio, rounded to one decimal point? O 1.0arrow_forwardPrivett Company Accounts payable $30,000 Accounts receivable 35,000 Accrued liabilities 7,000 Cash 25,000 Intangible assets 40,000 Inventory 72,000 Long-term investments 100,000 Long-term liabilities 75,000 Marketable securities 36,000 Notes payable (short-term) 20,000 Property, plant, and equipment 400,000 Prepaid expenses 2,000 Based on the data for Privett Company, what is the amount of quick assets? Oa. $96.000 Ob. $60,000 Oc. $61.000 Od. $168,000arrow_forward
- Use the following table: Case X Case Y Case Z Cash $ 940 $ 1,470 $ 1,940 Short-term investments 0 0 780 Receivables 0 1,690 1,360 Inventory 3,400 1,560 6,520 Prepaid expenses 2,600 1,020 1,460 Total current assets $ 6,940 $ 5,740 $ 12,060 Current liabilities $ 3,600 $ 1,800 $ 5,750 Required:Calculate the quick ratio in each of the above cases and select the case which is in the best position to meet short-term obligations most easily. (Round your answers to 2 decimal places.)arrow_forwardnku.9arrow_forwardCABOT CORPORATIONBalance SheetDecember 31 Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 19,500 Short-term investments 8,000 Accrued wages payable 3,400 Accounts receivable, net 33,600 Income taxes payable 2,900 Merchandise inventory 42,150 Long-term note payable, secured by mortgage on plant assets 66,400 Prepaid expenses 2,800 Common stock 83,000 Plant assets, net 147,300 Retained earnings 68,650 Total assets $ 243,850 Total liabilities and equity $ 243,850 Required:Compute the following: (1) current ratio, (2) acid-test ratio, (3) days' sales uncollected, (4) inventory turnover, (5) days' sales in inventory, (6) debt-to-equity ratio, (7) times interest earned, (8) profit margin ratio, (9) total asset turnover, (10) return on total assets, and (11) return on common stockholders' equity. (Do not round intermediate calculations.)arrow_forward
- Accounts payable 919 Accounts receivable 631 Accumulated depreciation 1,813 Cash 729 Common stock 1,387 Cost of goods sold 7,578 Current portion of long-term debt 24 Depreciation expense 108 Dividends 13 Goodwill and other long-term assets 2,627 Income tax expense 24 Income taxes payable 12 Interest expense 54 Interest revenue 11 Inventories 930 Long-term liabilities 1,585 Prepaid expenses and other current assets 65 Property and equipment 2,389 Retained earnings 825 Sales 9,710 Selling, general, and administrative expenses 2,276 Unearned revenue 990 Wages payable 148 Prepare two closing journal entriesarrow_forwardInstructions This assignment is designed for practicing both the retailer/merchandiser accounting cycle and your basic excel skills. Below are select sales transactions for two companies. You will need to enter the missing pieces of each transaction on the journal entry tab. Each missing piece of information is highlighted in yellow. The only cell where an actual number is to be input is on the journal entries worksheet. Please note: not every yellow cell requires input (it could be left blank if appropriate). After completing the journal entries, you must then complete the missing pieces of the T accounts, trial balance, and statements highlighted in yellow. Only excel functions may be used to calculate the appropriate cell value on these pages. DO NOT INPUT THE ACTUAL NUMBER INTO THE T ACCOUNTS, TRIAL BALANCE, OR STATEMENTS. Use excel functions (such as making a cell equal another from the journal entry page, summing numbers together, or using the plus or minus symbols to help you…arrow_forwardAlpesharrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education