a. As of Dec. 31 (the end of the prior quarter), the company\'sgeneral ledger sh

Question

a. As of Dec. 31 (the end of the prior quarter), the company'sgeneral ledger showed the following account balances: Debit Credit Cash 26000 Accounts Receivable 50000 Inventory 86400 Building and Equipment (net) 80000 Accounts Payable 102000 Capital Stock 45000 Retained Earnings 95400 242400 242400
b. Actual sales for December and budgeted sales for the next fourmonths are as follows: December (actual) 200000 January 240000 February 250000 March 275000 April 260000 c. Sales are 75% for cash and 25% on credit. All payments oncredit sales are collected in the month following sale. Theaccounts receivable at December 31 are a result of December creditsales. d. The company's gross margin is 40% of sales. (In otherwords, cost of goods sold is 60% of sales). e. Monthly expenses are budgeted as follows: salaries andwages, $14000 per month: advertising, $25000 per month; shipping,5% of slaes; other expense, 15% of sales. Depreciation will be$8000 for the quarter. f. Each month's ending inventory should equal 60% of thefollowing month's cost of goods sold. g. 30% of a month's inventory purchaes is paid for in themonth of purchase; the remainder is paid for in the followingmonth h. during Feb, the company will purchase land for $8000 cash.During March, land will be purchased for cahs at a cost of2000. i. During Jan, the company will declare and pay 30000 in cashdividends. j. Managment wants to maintain a minimum cash balace of 5000.The company has an agreement with a local bank that allows thecompany to borrow in increments of $1000 at the beginning of eachmonth, up to a total loan balance of $20000. The interest rate onthese loans is 1% per month. For simplicity, we will assume thatthe interest is not compounded. The company will, as far as it isable, repay the loan plus accumulated interest at the end of thequarter. Using the above data, complete the statement and schedules forthe first quarter. G) Prepare a balance sheet as of march 31 a. As of Dec. 31 (the end of the prior quarter), the company'sgeneral ledger showed the following account balances: Debit Credit Cash 26000 Accounts Receivable 50000 Inventory 86400 Building and Equipment (net) 80000 Accounts Payable 102000 Capital Stock 45000 Retained Earnings 95400 242400 242400 Debit Credit Cash 26000 Accounts Receivable 50000 Inventory 86400 Building and Equipment (net) 80000 Accounts Payable 102000 Capital Stock 45000 Retained Earnings 95400 242400 242400
b. Actual sales for December and budgeted sales for the next fourmonths are as follows: December (actual) 200000 January 240000 February 250000 March 275000 April 260000 c. Sales are 75% for cash and 25% on credit. All payments oncredit sales are collected in the month following sale. Theaccounts receivable at December 31 are a result of December creditsales. d. The company's gross margin is 40% of sales. (In otherwords, cost of goods sold is 60% of sales). e. Monthly expenses are budgeted as follows: salaries andwages, $14000 per month: advertising, $25000 per month; shipping,5% of slaes; other expense, 15% of sales. Depreciation will be$8000 for the quarter. f. Each month's ending inventory should equal 60% of thefollowing month's cost of goods sold. g. 30% of a month's inventory purchaes is paid for in themonth of purchase; the remainder is paid for in the followingmonth h. during Feb, the company will purchase land for $8000 cash.During March, land will be purchased for cahs at a cost of2000. i. During Jan, the company will declare and pay 30000 in cashdividends. j. Managment wants to maintain a minimum cash balace of 5000.The company has an agreement with a local bank that allows thecompany to borrow in increments of $1000 at the beginning of eachmonth, up to a total loan balance of $20000. The interest rate onthese loans is 1% per month. For simplicity, we will assume thatthe interest is not compounded. The company will, as far as it isable, repay the loan plus accumulated interest at the end of thequarter. Using the above data, complete the statement and schedules forthe first quarter. G) Prepare a balance sheet as of march 31 Debit Credit Cash 26000 Accounts Receivable 50000 Inventory 86400 Building and Equipment (net) 80000 Accounts Payable 102000 Capital Stock 45000 Retained Earnings 95400 242400 242400

Explanation / Answer

1 Quarter

INCOME STATEMENT

G BUDGETED BALANCESHEET

1 Quarter

Current Assets: Cash 5,590 Receivables 68,750 Inventories 93,600 Building and Equipment 80,000 less: Depreciation (8,000) 72,000 Land 10,000 Total Assets 249,940 Liabilities: Accounts Payable 111,720 (159,600 * 70%) Capital stock 45,000 Retained Earnings:          Beginning 95,400 Add: Net income 27,740 less: Cash dividend (30,000) 93,140 Total Liabilities 249,860 F

INCOME STATEMENT

Sales 765,000 less: cost of goods sold (459,000)     Gross Profit 306,000 Expenses: Selling & administrative expenses 270,000 Depreciation 8,000 Interest expense 260 (278,260) Net Income 27,740 I send you the answer of F part also .In the G respose the difference of $80 is coming in balancesheet, I try so many times and checked thatbut didn't get it. So once you check the figure or therelated item or any missing figure, it willhelpful to us to short out the difference.If any let us know. thanks michelle

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.