CT-student-Template - Ence 0 x Comments Data REVICH View Hep Tell me what you want to do Aurine 90 File Home Insert Page Layout Formula X Cut Peste ih copy. - 3 format Panter BIU - 2.0 A Font Sign in - Share Autobum - 47 0 . Normal Check Cell Bad Good E xplanatory... input Neutral Und Cell Cakulation Nute B e Tomar === Mange & Carrier - $ t.. % 248 Cordeonel Format Formatting Table Insert So find Fladet C D E F L M N O P Q R S T G II i TASK #1 PROJECTED BALANCE SHEET High-End Lifts, Inc. Projected Balance Sheet 12-31 Year 3 DIRECTIONS: COMPLETE ALL YELLOW CELLS Save the cash account for the end (the formula and a check figure are given below). Outsourcing Manufacturins 1,901,749 64.2% 564,000 19.09. 26.000 0.9 400.000 0.0% 551,000 26.000 0.01% 95.2% 3.9% ASSETS: A/R, Supplies and Prepaid Insurance remain the same. Raw materials inventory is estimated at $110,000, work-in-process inventory is estimated at $96,250, and finished goods inventory is estimated at $275,000. All prior merchandise inventory balances have been sold to customers (the balance in the merchandising inventory account, manufacturing column E10, is zero). Enter these amounts in the yellow cells. 10 0.0% PP&C (Selling, General & Administrative) remain sare, 12 13 14 15 16 17 0.0% 0.0% 1.0% 90.1% 6,300 2,898,049 0.2% 97.8% 6.300 596,300 Depreciation Total Deprec 3.8% 5.3% Assets Current Assets Cash A/ Suplies Merchandise Inventory Raw Materials inventory Work in Process Inventory Finished Goods Inventory Prepaid Insurance Total Current Assets PP&E (SG&A) Computers & Network (5 yr.life! Furniture & Fixtures (10 yr.life) Office Equipment 15 yr.lifel Vehicles 15 yr. life! PP&E (Production) Land Buildines (50 y.lifel Furniture & Fixtures (10 yr.life) CAD Computers, Network (5 yr.life) Machinery (15 yr.life) Forklift (10 yr.life AD Depreciation (3 years total) Total PPSE Total Assets Liabilities Gert Habillac Name and File Challenge 25,000 35,000 12.000 65.000 0.8% 1.796 0.4% 2.2% 25,000 35,000 12.000 65,000 PP&C (Production Assets) include the following new purchases at the beginning of the year in the manufacturing column only: Land, $125,000; Buildings, $750,000 (50 year life); Furniture & Fixtures, $15,000 (10 year useful lifel; CAD, Computers and Network, $50,000 (5 year useful life); Machinery, $350,000 (15 year useful life); and a Forklift, $75,000 (10 year useful life). Include the amounts in the manufacturing balance sheet and compute the annual depreciation amounts in cells H22 through H27 in yellow. Assume straight-line depreciation method (Cost/Lile), zero residual value. 3,500 2.400 13.000 1.3% 20 9.9% 23,90 21 22 25 0.08 0.0% 0.0% 0.01% 0.0% 0.0% 0.0% 0.0% 0.0% -10.0% 9.9% 100.0% LIABILITIES & EQUITY: Accounts payable equals $130,000. Wages payable equals $48,000. Interest payable remains unchanged. Income Taxes Payable is done for you (25% of the amount of income tax expense on the income statement (quarterly payments). Unearned Revenue, and Current Portion of Notes Payable account balances are unchanged. 26 27 28 29 30 31 171.709) 65.300 2.963.349 -7.1% 2.2% 100.0% (71,700) 65,300 661,600 Notes Payable and Common Stock account balances are unchanged. Task 115 Task #1 BS Task 1 unit cost and How - + 1005 143 PM /2010 Type here to search A 4 CT-student-Template - Ence 0 x Comments Data REVICH View Hep Tell me what you want to do Aurine 90 File Home Insert Page Layout Formula X Cut Peste ih copy. - 3 format Panter BIU - 2.0 A Font Sign in - Share Autobum - 47 0 . Normal Check Cell Bad Good E xplanatory... input Neutral Und Cell Cakulation Nute B e Tomar === Mange & Carrier - $ t.. % 248 Cordeonel Format Formatting Table Insert So find Fladet C D E F L M N O P Q R S T G II i TASK #1 PROJECTED BALANCE SHEET High-End Lifts, Inc. Projected Balance Sheet 12-31 Year 3 DIRECTIONS: COMPLETE ALL YELLOW CELLS Save the cash account for the end (the formula and a check figure are given below). Outsourcing Manufacturins 1,901,749 64.2% 564,000 19.09. 26.000 0.9 400.000 0.0% 551,000 26.000 0.01% 95.2% 3.9% ASSETS: A/R, Supplies and Prepaid Insurance remain the same. Raw materials inventory is estimated at $110,000, work-in-process inventory is estimated at $96,250, and finished goods inventory is estimated at $275,000. All prior merchandise inventory balances have been sold to customers (the balance in the merchandising inventory account, manufacturing column E10, is zero). Enter these amounts in the yellow cells. 10 0.0% PP&C (Selling, General & Administrative) remain sare, 12 13 14 15 16 17 0.0% 0.0% 1.0% 90.1% 6,300 2,898,049 0.2% 97.8% 6.300 596,300 Depreciation Total Deprec 3.8% 5.3% Assets Current Assets Cash A/ Suplies Merchandise Inventory Raw Materials inventory Work in Process Inventory Finished Goods Inventory Prepaid Insurance Total Current Assets PP&E (SG&A) Computers & Network (5 yr.life! Furniture & Fixtures (10 yr.life) Office Equipment 15 yr.lifel Vehicles 15 yr. life! PP&E (Production) Land Buildines (50 y.lifel Furniture & Fixtures (10 yr.life) CAD Computers, Network (5 yr.life) Machinery (15 yr.life) Forklift (10 yr.life AD Depreciation (3 years total) Total PPSE Total Assets Liabilities Gert Habillac Name and File Challenge 25,000 35,000 12.000 65.000 0.8% 1.796 0.4% 2.2% 25,000 35,000 12.000 65,000 PP&C (Production Assets) include the following new purchases at the beginning of the year in the manufacturing column only: Land, $125,000; Buildings, $750,000 (50 year life); Furniture & Fixtures, $15,000 (10 year useful lifel; CAD, Computers and Network, $50,000 (5 year useful life); Machinery, $350,000 (15 year useful life); and a Forklift, $75,000 (10 year useful life). Include the amounts in the manufacturing balance sheet and compute the annual depreciation amounts in cells H22 through H27 in yellow. Assume straight-line depreciation method (Cost/Lile), zero residual value. 3,500 2.400 13.000 1.3% 20 9.9% 23,90 21 22 25 0.08 0.0% 0.0% 0.01% 0.0% 0.0% 0.0% 0.0% 0.0% -10.0% 9.9% 100.0% LIABILITIES & EQUITY: Accounts payable equals $130,000. Wages payable equals $48,000. Interest payable remains unchanged. Income Taxes Payable is done for you (25% of the amount of income tax expense on the income statement (quarterly payments). Unearned Revenue, and Current Portion of Notes Payable account balances are unchanged. 26 27 28 29 30 31 171.709) 65.300 2.963.349 -7.1% 2.2% 100.0% (71,700) 65,300 661,600 Notes Payable and Common Stock account balances are unchanged. Task 115 Task #1 BS Task 1 unit cost and How - + 1005 143 PM /2010 Type here to search A 4