PROBLEM 6-13 Given (refer to problem 6-12): Balance Sheet 2015 Cash and Marketable Securities 500 Accounts Receivable 6,000 Inventories 9,500 Current Assets 16,000 Net Property Plant & Equipment 17,000 Total 33,000 Solution Legend - Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output 0.00% Accounts Payable Short-term Debt Current Liabilities Long-term Debt Total Liabilities Total Owners' Equity Total Liabilities and Owners' Equity 7,200 6,800 14,000 7,000 21,000 12,000 33,000 S 0.00% 100.00% Income Statement Revenues Cost of Goods Sold Gross Profit Operating Expenses Net Operating income Interest Expense Earnings before Taxes Taxes Net Income 2015 30,000 (20,000 10,000 (8,000 2,000 (900) 1.100 (400 700 S Projected growth rate in revenues Tax rate 20% 40% Given (refer to problem 6-12): 2016 Pro forma Income Statement Sales Cost of Goods Sold Gross Profit Operating Expenses PROBLEM 6-13 Given (refer to problem 6-12): Balance Sheet 2015 Cash and Marketable Securities 500 Accounts Receivable 6,000 Inventories 9,500 Current Assets 16,000 Net Property Plant & Equipment 17,000 Total 33,000 Solution Legend - Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output 0.00% Accounts Payable Short-term Debt Current Liabilities Long-term Debt Total Liabilities Total Owners' Equity Total Liabilities and Owners' Equity 7,200 6,800 14,000 7,000 21,000 12,000 33,000 S 0.00% 100.00% Income Statement Revenues Cost of Goods Sold Gross Profit Operating Expenses Net Operating income Interest Expense Earnings before Taxes Taxes Net Income 2015 30,000 (20,000 10,000 (8,000 2,000 (900) 1.100 (400 700 S Projected growth rate in revenues Tax rate 20% 40% Given (refer to problem 6-12): 2016 Pro forma Income Statement Sales Cost of Goods Sold Gross Profit Operating Expenses
