Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ASSETS Current Assets Cash Accounts Receivable Prepaid Insurance Inventory Total Current Assets Durance neer As of June 30, 2020 LIABILITIES & STOCKHOLDERS' EQUITY Current Liabilities

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

ASSETS Current Assets Cash Accounts Receivable Prepaid Insurance Inventory Total Current Assets Durance neer As of June 30, 2020 LIABILITIES & STOCKHOLDERS' EQUITY Current Liabilities $ 5,000 Accounts Payable $ 11,000 15,000 Commissions Payable 1,300 Income Taxes Payable 3,500 1,600 Dividends Payable 21,600 Total Current Liabilities 15,800 Long-term debt 70,000 Property Plant & Equipment Land Equipment Accumulated Depreciation Net PP & E 49,200 60,400 85,000 (22,000) 123,400 Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity 10,000 59,200 Total Assets $ 145,000 Total Liabilities & SE S 145,000 1. Expected sales are $50,000, $64,000, and $72,000, respectively in July, August, and September. All sales are on credit. 2. The company collects 75% of sales in the month of the sale and 25% in the month after the sale. 3. The cost of goods sold is equal to 55% of sales. 4. The company desires an ending inventory equal to 20% of the next month's cost of goods sold. 5. All purchases of inventory are on credit. The company pays for 80% of its purchases in the month of the purchase and 20% in the month after the purchase. 6. The company pays a 3% sales commission to its sales staff that is paid in the month after it is earned 7. The company also incurs a utilities expense that is equal to $300 plus 1% of sales. This expense is paid in the month it is incurred. 8. Other Selling and Administrative Expenses, paid in the month they are incurred, include Advertising $1,100 per month, Salaries $1,400 per month and Depreciation $900 per month. 9. On July 1 the company purchased an insurance policy covering 24 months for $12,000. 10. The company pays interest on its long-term debt at the end of each month. Interest is equal to 1% of the balance of long-term debt at the beginning of the month. 11. On August 10 the company will pay cash for Land, costing $6,500. 12. On July 27 the company will declare a cash dividend of $5,000 and will pay it in August. 13. The company requires a minimum cash balance of $5,000 and will use any cash surplus to pay down long-term debt. The company borrows cash in $1,000 increments. Bengals Company Sales Budget S&A Expenses Budget July August September July August Variable Selling & Admin Expenses Sales Commissions Credit Sales $ 50,000 $ 64,000 $ 72,000 (4 ) Utilities Total Variable S&A Expenses 2,000 25,600 Cash Receipts: From Current Month Sales From Prior Month Sales Fixed Selling & Admin Expenses Utilities Total Cash Receipts (1) $ 60,500 Advertising 1,100 1,100 Salaries 1,400 1,400 Inventory Purchases Budget Depreciation 900 900 July August September Insurance (5) 4,200 Total Fixed S&A Expenses 4,200 COGS $ 35,200 $ 39,600 Cash Payments for S&A Expenses Sales Commissions Desired Ending Inventory Total Inventory Needed Beginning Inventory Inventory Purchases Utilities 800 940 (2) $ 36,080 Advertising 1,100 1,100 Salaries 1,400 1,400 Cash Payments for Purchases Depreciation (6) For Current Month Purchases $ 26,352 Insurance (7) For Prior Month Purchases 11,000 Total Payments for S&A Expenses $ 16,600 $ 4,940 Total Cash Payments $ 37,352 (3) Cash Budget Income Statement July August July August Beginning Balance Sales S 50,000 $ 64,000 Cash Receipts 60,500 Less: Variable costs Total Cash Available 57,500 COGS Variable S&A Expenses Contribution Margin Cash Payments: (11) For Inventory Purchases 37,352 Less: Fixed Costs Contribution Margin (11) 37,352 Less: Fixed Costs Cash Payments: For Inventory Purchases For S&A Expenses For Interest Fixed S&A Expenses (8) Interest Expense For Stock Investment Pre-tax Income $ 15,600 21,280 For Land Less: Income Taxes 3,900 5,320 For Dividends Net Income $ 11,700 $ 15,960 For Taxes Total cash payments 58,152 (9) 9,296 Surplus/ (Deficit) New Borrowing / (Repayment) Ending Cash Balance 6,000 (10) 5,000 Balance Sheet July August July August ASSETS LIABILITIES & STOCKHOLDERS EQUITY Current Liabilities Current Assets Cash (12) $ 6,588 (18) 12,500 (13) (19) Accounts Receivable Prepaid Insurance Inventory Accounts Payable Commissions Payable Income Taxes Payable Dividends Payable (14) (15) (20) Total Current Assets Total Current Liabilities Property Plant & Equipment Long term debt (21) Stock Investment Land (16) Stockholders' Equity 85,000 85,000 Common Stock 49,200 49,200 Equipment Accumulated Depreciation (17) (22) Retained Earnings Total Stockholders Equity Total PP &E TOTAL ASSETS $ 158,888 $ 168,020 TOTAL LIABILITIES & STOCKHOLDERS EQUITY $ 158,888 $ 168,020 5. What is Total Insurance Expense for July? $12,000 $ 0 $ 500 $1,000 $1,500 6. What is the Total Cash Payment for Depreciation Expense for July? $ 22,000 $1,800 $ 0 $21,100 $ 900 7. What is Total Cash Payment for Insurance Expense for August? $12,000 $ 1,000 $0 $ 1,500 $ 500 8. What is Total Interest Expense for July? $ 700 $2,100 $ 0 $7,000 $1,400

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions