A20 Depree on equipment G 1 M M N P R S 1 V Balance Sheet At December 31, 2012 Retained Earning for the year onded Dec 31, 2007 2400 8200 900 3000 Beginning Retained Earings Plus Net Income Minus Dividends Pald 23200 19600 0 Ending Retained Earnings 42800 14500 A D E 1 2 Larry's Landscaping 3 Income Statement 4 For the year ended Dec 31, 2012 5 6 Revenues 7 Design revenue 50000 8 Installation Revenue 140000 9 Total Revenue 190000 10 11 Operating Expenses 12 Selling Expenses 13 Advertising expenses 3100 Rent expense for sales autos 9000 15 Commissions expense 8600 16 Total Selling expenses 20700 7 8 8 General and Admin Expenses 9 Deprec on buildings 2500 Deprec on equipment 1200 Insurance expense 2000 Salaries and Wages-installat 110000 Salaries and Wages - office 11000 Total General and Admin Expenses 126700 Total Operating Expenses 147400 Current Assets Cash Accts Receivable Office supplies Prepaid rent Total Current Assets Property, plant, and equipment Land Buildings less Accum Depreciation Equipment less Accum Depreciation Total property, plant and equip Total Assets 100000 55000 80000 25000 68000 15000 53000 208000 222500 Current liabilities accts payable Income taxes payable Interest payable Total current liabilities Long-term notes payable, due 12/31/25 Total Liabilities 6500 2200 1000 9700 120000 129700 42600 Income from Operations Other revenues and expenses Interest revenue Interest expense Total Other revenues/expenses 2000 12000 -10000 Contributed Capital Capital Stock, $ipar, 10,000 shares Paid in capital in excess of par value total contributed capital Retained Earnings Total stockholders equity 10000 40000 50000 42800 nicome before income taxes ncome tax expense Het Income 32600 13000 19600 92800 Total liabilities and stockholders equity 222500 Question 1 3 pts ia 1 What is the amount of the Net Sales revenue for the most recent year? What is the amount of the Net Sales revenue for the prior year? 1a What is the amount of the Net Sales revenue for the 2nd prior year? Question 2 3 pts 2 What is the amount of "Net income foss) attributable to CBI" for the most recent year? If negative, use brackets (X) 2 What is the amount of "Net income attributable to CBI" for the prior year? 2 What is the amount of "Net income attributable to CBF for the 2nd prior year? Question 3 3 pts 3 Using Net Income (loss) Attributable to CBI and Net Sales, what is Constellation Brands profit margin percentage for the most recent year? Remember to multiply by 100 to get a %, then round to keep your answer to 2 decimal points. If negative, use brackets (xx). 3 Using Net Income Attributable to CBI and Net Sales, what is constellation Brands profit margin percentage for the prior year? Remember to multiply by 100 to get a %, then round to keep your answer to 2 decimal points. 3 Using Net Income Attributable to CBI and Net Sales, what is Constellation Brands' profit margin percentage for the 2nd prior year? Remember to multiply by 100 to get a %, then round to keep your answer to 2 decimal points. Question 4 1 pts 4 Show that Constellation Brands' balance sheet is in balance by presenting the accounting equation at the end of their most recent fiscal year. Enter numeric values for the variables in the accounting equation Equal Plus Question 5 2 pts 5. What percentage of Constellation Brands assets were provided by CREDITORS for the most recent year? Remember to multiply by 100 to get a %, then round to keep answer to 2 decimal Question 5 2 pts 5. What percentage of Constellation Brands assets were provided by CREDITORS for the most recent year? Remember to multiply by 100 to get a X then round to keep answer to 2 decimal points What percentage of their assets were provided by OWNERS? Round to keep answer to 2 decimal points Question 6 2 pts 6. Looking only at Investing and Financing Activities on the Cash Flow Statement, what were the 2 largest sources of cash for Constellation Brands in their most recent year? Unrealized net gain on securities and Investment in equity method investees and securities Proceeds from Issuance of long-term debt and proceeds from sale of business O Deferred tax provision and Depreciation Purchase of property, plant and equipment and Investments in equity method investees and securities Question 7 2 pts 7. Looking only at Investing and Financing Activities, what were the two largest uses of cash for Constellation Brands during the most recent year? Unrealized net gain on securities measured at fair value and Investments in equity method investees and Securities Purchase of property and equipment and principal payments of long-term debt Deferred tax provision and Depreciation O Proceeds from Issuance of long-term debt and proceeds from sale of unconsolidated investment Question 8 2 pts 8. Calculate the companies Working Capital for the most recent year Calculate the companies Current Ratio for the most recent year. Round to keep you answer to 2 decimal points and only enter the first part of the ratio represented by x X.XX1 the companies Lurrent Ratio for the most recent year. Round to keep you answer to 2 decimal points and only enter the first part of the ratio represented by x X.XX1 Question 9 2 pts What do Working Capital and Current Ratio tell you about the company? No answer text provided. They tell me Constellation Brands is profitable, they have enough income to pay dividends and grow the company They tell me Constellation Brands' long term debt is more than their short-term debl which is good position to be in. They tell me Constellation Brands is Liquid, which means they should be able to pay their debts as they come due Quiz saved at 5.24pm Submit Quiz A20 Depree on equipment G 1 M M N P R S 1 V Balance Sheet At December 31, 2012 Retained Earning for the year onded Dec 31, 2007 2400 8200 900 3000 Beginning Retained Earings Plus Net Income Minus Dividends Pald 23200 19600 0 Ending Retained Earnings 42800 14500 A D E 1 2 Larry's Landscaping 3 Income Statement 4 For the year ended Dec 31, 2012 5 6 Revenues 7 Design revenue 50000 8 Installation Revenue 140000 9 Total Revenue 190000 10 11 Operating Expenses 12 Selling Expenses 13 Advertising expenses 3100 Rent expense for sales autos 9000 15 Commissions expense 8600 16 Total Selling expenses 20700 7 8 8 General and Admin Expenses 9 Deprec on buildings 2500 Deprec on equipment 1200 Insurance expense 2000 Salaries and Wages-installat 110000 Salaries and Wages - office 11000 Total General and Admin Expenses 126700 Total Operating Expenses 147400 Current Assets Cash Accts Receivable Office supplies Prepaid rent Total Current Assets Property, plant, and equipment Land Buildings less Accum Depreciation Equipment less Accum Depreciation Total property, plant and equip Total Assets 100000 55000 80000 25000 68000 15000 53000 208000 222500 Current liabilities accts payable Income taxes payable Interest payable Total current liabilities Long-term notes payable, due 12/31/25 Total Liabilities 6500 2200 1000 9700 120000 129700 42600 Income from Operations Other revenues and expenses Interest revenue Interest expense Total Other revenues/expenses 2000 12000 -10000 Contributed Capital Capital Stock, $ipar, 10,000 shares Paid in capital in excess of par value total contributed capital Retained Earnings Total stockholders equity 10000 40000 50000 42800 nicome before income taxes ncome tax expense Het Income 32600 13000 19600 92800 Total liabilities and stockholders equity 222500 Question 1 3 pts ia 1 What is the amount of the Net Sales revenue for the most recent year? What is the amount of the Net Sales revenue for the prior year? 1a What is the amount of the Net Sales revenue for the 2nd prior year? Question 2 3 pts 2 What is the amount of "Net income foss) attributable to CBI" for the most recent year? If negative, use brackets (X) 2 What is the amount of "Net income attributable to CBI" for the prior year? 2 What is the amount of "Net income attributable to CBF for the 2nd prior year? Question 3 3 pts 3 Using Net Income (loss) Attributable to CBI and Net Sales, what is Constellation Brands profit margin percentage for the most recent year? Remember to multiply by 100 to get a %, then round to keep your answer to 2 decimal points. If negative, use brackets (xx). 3 Using Net Income Attributable to CBI and Net Sales, what is constellation Brands profit margin percentage for the prior year? Remember to multiply by 100 to get a %, then round to keep your answer to 2 decimal points. 3 Using Net Income Attributable to CBI and Net Sales, what is Constellation Brands' profit margin percentage for the 2nd prior year? Remember to multiply by 100 to get a %, then round to keep your answer to 2 decimal points. Question 4 1 pts 4 Show that Constellation Brands' balance sheet is in balance by presenting the accounting equation at the end of their most recent fiscal year. Enter numeric values for the variables in the accounting equation Equal Plus Question 5 2 pts 5. What percentage of Constellation Brands assets were provided by CREDITORS for the most recent year? Remember to multiply by 100 to get a %, then round to keep answer to 2 decimal Question 5 2 pts 5. What percentage of Constellation Brands assets were provided by CREDITORS for the most recent year? Remember to multiply by 100 to get a X then round to keep answer to 2 decimal points What percentage of their assets were provided by OWNERS? Round to keep answer to 2 decimal points Question 6 2 pts 6. Looking only at Investing and Financing Activities on the Cash Flow Statement, what were the 2 largest sources of cash for Constellation Brands in their most recent year? Unrealized net gain on securities and Investment in equity method investees and securities Proceeds from Issuance of long-term debt and proceeds from sale of business O Deferred tax provision and Depreciation Purchase of property, plant and equipment and Investments in equity method investees and securities Question 7 2 pts 7. Looking only at Investing and Financing Activities, what were the two largest uses of cash for Constellation Brands during the most recent year? Unrealized net gain on securities measured at fair value and Investments in equity method investees and Securities Purchase of property and equipment and principal payments of long-term debt Deferred tax provision and Depreciation O Proceeds from Issuance of long-term debt and proceeds from sale of unconsolidated investment Question 8 2 pts 8. Calculate the companies Working Capital for the most recent year Calculate the companies Current Ratio for the most recent year. Round to keep you answer to 2 decimal points and only enter the first part of the ratio represented by x X.XX1 the companies Lurrent Ratio for the most recent year. Round to keep you answer to 2 decimal points and only enter the first part of the ratio represented by x X.XX1 Question 9 2 pts What do Working Capital and Current Ratio tell you about the company? No answer text provided. They tell me Constellation Brands is profitable, they have enough income to pay dividends and grow the company They tell me Constellation Brands' long term debt is more than their short-term debl which is good position to be in. They tell me Constellation Brands is Liquid, which means they should be able to pay their debts as they come due Quiz saved at 5.24pm Submit Quiz