Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, please provide balance sheet and cash flow statement. Thanks Credit TRIAL BALANCE For the Years Ended December 31, 2020 and December 31, 2021 2020

Hi, please provide balance sheet and cash flow statement. Thanks
image text in transcribed
image text in transcribed
image text in transcribed
Credit TRIAL BALANCE For the Years Ended December 31, 2020 and December 31, 2021 2020 2021 Debit Credit Debit Cash 173,000 Accounts Receivable 26,415 Inventory 32,160 Prepaid Expenses Building 275,000 Computers & Software 10,000 Furniture & Fixtures 25,000 Land 75,000 Machinery & Equipment Accumulated Depreciation 8,775 Accounts Payable 12,311 Payroll Tax Payable 136 Sales Tax Payable 22,135 Unearned Revenue Line of Credit 250,000 Notes Payable Peters, ... Capital 2,500 Peters, M., Capital 2,500 Retained Earnings 201,301 Custom Cabinet Sales Material & Supplies Sales 288,368 Small Tool Sales 35,972 Tool Rental Revenue 16,201 COGS: Custom Cabinets COGS: Material & Supplies 92,278 COGS: Small Tools 21,735 COGS: Wages 33,721 Depreciation Expense 8,950 Insurance Expense 6,426 Office Supplies Expense 1,464 Payroll Tax Expense 6,069 Postage Expense 347 Small Tool Expense 6,162 Interest Expense 7,500 Income Tax Expense 38,972 840,199 840,199 0 1. Sales will change as follows: a. Material & Supplies Sales will increase 5.0% b. Small Tool Sales will increase 4.0% c. Tool Rental Revenue will continue throughout the 2021 year. An average of 16 tools will be rented each week. The weekly rental per tool is $55. Assume that the average number of tools given will be rented for all 52 weeks. 2. Cost of sales for materials and supplies and small tools will increase proportionately based on their current percentage of sales, respectively. (HINT: You will need to use vertical analysis.) 3. Small tools, including blades and other items, is expected to total $7,300 in 2021. 4. Office supplies and postage are expected to increase by 9% during 2021. 5. On January 1st, the company will invest $122,000 in new equipment for its custom cabinet division a. This equipment will have a 5-year life and should be depreciated using the straight-line method. This purchase represents the only expected change to property, plant, and equipment. b. The company will finance the equipment purchased with a 5-year note at 3.50% interest. You will need to use an amortization schedule to find the principle and interest payment amounts. The loan is paid monthly. 6. In relation to #6 above, the custom cabinet sales division begins operations in 2021. The following assumptions must be used to project the impact on the financial statements. (Hint: You may need to add accounts to the trial balance.) a. Walnut Grove anticipates that it will sell 170 cabinets at an average selling price of $3,500. b. Direct materials per cabinet are $700 per unit. C. The direct labor per cabinet is 4 hours, and Walnut Grove pays $28.50/hour for this labor. d. Factory overhead is calculated at 50% of direct labor. 7. The building is being depreciated over a 39-year life, the computers and software are being depreciated over a 3-year life, and the furniture and fixtures are being depreciated over a 5-year life, all using straight-line depreciation. 8. Because of the new cabinet division, annual insurance costs will increase to $26,000, effective January 1. The company prepaid 2 years of this insurance and received a 3.2% discount for the 2-year prepayment. 9. On January 1, a new cabinet division manager will be hired at a cost of $60,000. In additional to the new cabinet division manager, 3 new employees will be hired at an average wage of $22.50 per hour, employees work an average of 40 hours per week. Payroll taxes and benefits should be calculated at 20% of wages. 10. With 20 weeks remaining in the year, 3 additional employees will be hired at a rate of $17.50 per hour, based on an average of 35 hours per week. 11. The income tax rate is 25%. 12. At the end of the year, Walnut Grove will have $32,000 in ending inventory 13. In relation #13, purchases are made evenly throughout the year and are paid in full in the month following purchase. 14. Sales are collected in full the month following the sale. During the month of December, invoiced sales totaled $135,000 15. The sales tax rate is 6.5%. 16. At the end of the year, Walnut Grove has received full payment for 15 custom cabinet orders that will be completed in January 2022

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

Management Accounting For Decision Makers

Authors: Dr Peter Atrill, Eddie McLaney

6th Edition

0273731521, 9780273731528

More Books

Students also viewed these Accounting questions