Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please prepare a projected income statement and balance sheet of a cow farm for three years similar to photos above. thank you Profit and Loss
please prepare a projected income statement and balance sheet of a cow farm for three years similar to photos above. thank you
Profit and Loss Statem ents ($000's) 1993 1994 1995 $ 161.2 $ 3033 $ 320.4 $ $ $ 82.4 64.6 104.2 862 193 209.7 93.6 99.1 64.6 42.0 205.7 114.7 $ $ 147.0 14.2 $ $ $ $ $ $ un 16.4 10.4 16.7 10.0 14.5 3.9 Sales Cost of sales: Materials Labor Freight Total cost of sales Gross profit Operating, administrative, and selling costs: Depreciation Payroll taxes Repair and maintenance Rent Utilities Salaries Insurance Office expense General tax, legal, accounting Selling, travel automobile Telephone Sales taxes Miscellaneous Total operating, administrative, and selling costs Operating profit Income - legal Interest expense IN et income 15.9 6.4 113 13.3 13.2 13.0 19.6 15.7 18.0 20.9 3.6 0.5 4.3 3.2 3.8 3.4 - 1.8 2.9 99.8 E $ $ S (85.6 98.6 (5.0) an 10.1 11.8 S (1920) (19.5) ates) December 1, 1995 1993 1994 1995 $ 26.7 10.5 37.2 22.7 14.7 37.4 6.7 12.8 7.7 27.2 $ $ Assets Current assets: Cash in bank Accounts in bank Inventory Total current assets Property and equipment: Equipment Leasehold improvements Less: accumu la ted depreciation Net property and equipment Total assets $ 87.2 $ $ (52.8) 78.5 5.5 (36.1) 47.9 85.3 78.5 5.5 (19.8) 64.2 91.43 S $71.6 $ $ 36.1 $ 28.2 25.0 85.0 38.9 16.4 85.1 59.0 11.8 s $ $ Liabilities and Stockholders' Equity Current Liabilities: Accounts pay a b le Current long-term debt Notes paya b le A ceru als Total current liabilities Lont-term debt Total liabilities Stockholders' equity Common stock Added paid-in capital Accum u lated d e fic it Totalstockholders' equity Total liabilities and stockholders' eq uity 143.6 91.0 234.6 155.6 80.0 235.6 $ $ 96.5 222.6 $ $ un $ 16.7 (180.7) (163.0) $ $ $ (150.3) 85.3 (131.2) in Profit and Loss Sheets 1996 ($000's) Months February January March $ 30.0 $ 34.7 $ 31.0 $ $ 8.9 10.4 3.6 10.4 4.0 0.1 3.8 2.0 (8.9) 8.7 4.6 0.6 5.7 2.8 (6.8). 15.6 15.4 3.0 (8.7) 21.9 12.8 $ $ $ $ $ 18.6 $ 2.0 US $ 1.8 1.6 2.1 0.8 Sales Cost of sales: Beginning inventory Purchased materials Miscellaneous supplies Direct Labor Freight Less ending inventory Total cost of sales Gross profit Operating, admin is tra tive, and selling costs: Payro il taxes Repair and maintenance Rent Utilities Sa laries Insurance Office expense General tax, legal, accounting Selling (travel and auto ) expenses Telephone Interest Sa les taxes Miscellaneous (loan principal) Total operating, administrative, and selling costs Net income 0.6 1.1 1.3 0.6 0.3 1.9 13 0.6 0.6 0.2 0.8 0.4 $ S 5.9 6.3 19.0 (0.4) $ in S tes) Profit and Loss Statem ents ($000's) 1993 1994 1995 $ 161.2 $ 3033 $ 320.4 $ $ $ 82.4 64.6 104.2 862 193 209.7 93.6 99.1 64.6 42.0 205.7 114.7 $ $ 147.0 14.2 $ $ $ $ $ $ un 16.4 10.4 16.7 10.0 14.5 3.9 Sales Cost of sales: Materials Labor Freight Total cost of sales Gross profit Operating, administrative, and selling costs: Depreciation Payroll taxes Repair and maintenance Rent Utilities Salaries Insurance Office expense General tax, legal, accounting Selling, travel automobile Telephone Sales taxes Miscellaneous Total operating, administrative, and selling costs Operating profit Income - legal Interest expense IN et income 15.9 6.4 113 13.3 13.2 13.0 19.6 15.7 18.0 20.9 3.6 0.5 4.3 3.2 3.8 3.4 - 1.8 2.9 99.8 E $ $ S (85.6 98.6 (5.0) an 10.1 11.8 S (1920) (19.5) ates) December 1, 1995 1993 1994 1995 $ 26.7 10.5 37.2 22.7 14.7 37.4 6.7 12.8 7.7 27.2 $ $ Assets Current assets: Cash in bank Accounts in bank Inventory Total current assets Property and equipment: Equipment Leasehold improvements Less: accumu la ted depreciation Net property and equipment Total assets $ 87.2 $ $ (52.8) 78.5 5.5 (36.1) 47.9 85.3 78.5 5.5 (19.8) 64.2 91.43 S $71.6 $ $ 36.1 $ 28.2 25.0 85.0 38.9 16.4 85.1 59.0 11.8 s $ $ Liabilities and Stockholders' Equity Current Liabilities: Accounts pay a b le Current long-term debt Notes paya b le A ceru als Total current liabilities Lont-term debt Total liabilities Stockholders' equity Common stock Added paid-in capital Accum u lated d e fic it Totalstockholders' equity Total liabilities and stockholders' eq uity 143.6 91.0 234.6 155.6 80.0 235.6 $ $ 96.5 222.6 $ $ un $ 16.7 (180.7) (163.0) $ $ $ (150.3) 85.3 (131.2) in Profit and Loss Sheets 1996 ($000's) Months February January March $ 30.0 $ 34.7 $ 31.0 $ $ 8.9 10.4 3.6 10.4 4.0 0.1 3.8 2.0 (8.9) 8.7 4.6 0.6 5.7 2.8 (6.8). 15.6 15.4 3.0 (8.7) 21.9 12.8 $ $ $ $ $ 18.6 $ 2.0 US $ 1.8 1.6 2.1 0.8 Sales Cost of sales: Beginning inventory Purchased materials Miscellaneous supplies Direct Labor Freight Less ending inventory Total cost of sales Gross profit Operating, admin is tra tive, and selling costs: Payro il taxes Repair and maintenance Rent Utilities Sa laries Insurance Office expense General tax, legal, accounting Selling (travel and auto ) expenses Telephone Interest Sa les taxes Miscellaneous (loan principal) Total operating, administrative, and selling costs Net income 0.6 1.1 1.3 0.6 0.3 1.9 13 0.6 0.6 0.2 0.8 0.4 $ S 5.9 6.3 19.0 (0.4) $ in S tes)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started