Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Sales are expected to be $80,000 in January, $100,000 in February, and $105,000 in March. 2. All sales are on credit and it collects

image text in transcribed
1. Sales are expected to be $80,000 in January, $100,000 in February, and $105,000 in March. 2. All sales are on credit and it collects 20% of all sales in the month of the sale, the remaining 80% in the month after the sale. 3. The cost of goods sold is equal to 40% of sales. 4. The company likes to keep an ending inventory on hand equal to 15% of next month's cost of goods sold. 5. All purchases of inventory are on account, and the company pays for 60% of all purchases in the month of the purchase, 40% in the month after the purchase. 6. The company pays its sales force a commission equal to 3% of sales. 7. The company also believes that its miscellaneous expense is equal to $500 plus 2% of sales. 8. Rent is $2,000 per month, Supplies are $600 per month, and Depreciation is $1,800 per month. 9. On October 1 of last y, the company purchased an insurance policy covering 12 months for $14,400. 10. All selling and administrative expenses are paid in the month they are incurred except for commissions that are paid in the month after they are earned and the insurance which is paid as stated in #9. 11. The company purchased $40,000 of Land on January 18'\". They paid cash for the land. 12. Interest on long-term debt is equal to 1% of the beginning balance and is paid each month. The company must maintain a minimum balance in cash of $15,000 and will use any cash surplus to pay down long-term debt. The company borrows cash in $1,000 increments. 13. The company's Board Of Directors declared a cash dividend of $400 on January 4'\". The dividend will be paid on February 10'\". 14. The company had a beginning balance sheet (as of January 1) as follows: Assets Liabilities & Stockholder's Equity Current Assets Current Liabilities Cash $ 16,000 Accounts Payable $ 32,000 Accounts Receivable 33,000 Commissions Payable _5,M Prepaid Insurance 10,800 Total Current Liabilities $ 37,000 Inventory _20,@ Total Current Assets $ 79,800 LT Debt 3 80,000 Property, Plant & Equipment Equipment $ 95,000 Stockholder's Equity Land Common Stock $ 22,800 Accumulated Depreciation _(2_5,M) Retained Earnings J, Net PPE $ 70,000 Total Stockholder's Equity $ 32,800 Total Assets m,m Total Liab & SE m, Prepare the following budgets for January: 1. Sales budget 2. Purchases budget 3. Selling & Admin Expense budget 4. Cash Budget 5. Budget/Proforma Income Statement 6. Budget/Proforma Balance Sheet

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

Integrated Accounting For Windows

Authors: Dale Klooster

7th Edition

0538747978, 9780538747974

More Books

Students also viewed these Accounting questions

Question

2. What we can learn from the past

Answered: 1 week ago

Question

2. Develop a good and lasting relationship

Answered: 1 week ago