| 1) Complete the vertical analysis on the balance sheet for the nursery for 2012. |
| Assets | Amount | Percent |
| Cash | $9,282 | _____% |
| Accounts Receivable | $7,623 | _____% |
| Merchandise Inventory | $18,374 | _____% |
| Total Assets | $35.28 | _____% |
| Liabilities |
| Accounts Payable | $10,070 | _____% |
| Wage Payable | $3,365 | _____% |
| Total Liability | $13,435 | _____% |
| Owners Equity |
| The Owner's Capital | $21,844 | _____% |
| Total Liabilities and Owner's Capital | $35,279 | _____% |
| 2) Extend the income statement for miss Muffins' Bakery to include a vertical analysis for 2010 and 2011. |
| | 2011 | Percent of net sales | 2010 |
| Gross sales | $35,589 | _____% | $32,348 | _____% |
| Returns and allowances | $342 | _____% | $296 | _____% |
| Net Sales | $35,247 | _____% | $32,052 | _____% |
| Cost of beginning inventory | $17,419 | _____% | $16,908 | _____% |
| Cost of purchases | $27,694 | _____% | $33,626 | _____% |
| Cost of ending inventory | $22,733 | _____% | $21,742 | _____% |
| Cost of goods sold | $22,380 | _____% | $28,792 | _____% |
| Gross profit | $12,867 | _____% | $3,260 | _____% |
| Total operating expenses | $3,249 | _____% | $1,871 | _____% |
| Net income | $9,618 | _____% | $1,389 | _____% |
| 3) Extend the income statement for Miss Muffins' Bakery to include the amounts of increase or decrease and the percents of increase or decrease and the percents of increase for a horizontal analysis. |
| Round to the nearest tenth as needed | 2011 | 2010 | Increase (Decrease amount) | Percentage increase (decrease) |
| Gross sales | $35,868 | 32,666 | ___ | ___% |
| Returns and allowances | 340 | 297 | ___ | ___% |
| Net Sales | 35,528 | 32,369 | ___ | ___% |
| Cost of beginning inventory | 17,050 | 16,433 | ___ | ___% |
| Cost of purchases | 27,738 | 33,824 | ___ | ___% |
| Cost of ending inventory | 22,620 | 21,657 | ___ | ___% |
| Cost of goods sold | 22,168 | 28,600 | ___ | ___% |
| Gross profit | 13,360 | 3,769 | ___ | ___% |
| Total operating expenses | 3,290 | 1,898 | ___ | ___% |
| Net income | 10,070 | 1,871 | ___ | ___% |
| 4) Complete the horizontal analysis showing differences in dollar amounts and percents on the comparitive balance sheet for the bakery. (Use parentheses to indicate decreases. Round all the percentaged to the nearest tenth. |
| | | | Increase (Decrease amount) |
| Assets | 2012 | 2011 | Amount | Percent |
| Cash | $1,923 | $1,739 | $___ | ___% |
| Accounts Receivable | 4,112 | 3,821 | ___ | ___% |
| Merchandise Inventory | 2,576 | 2,080 | ___ | ___% |
| Total Assets | $8,611 | $7,640 | ___ | ___% |
| Liabilities |
| Accounts Payable | $3,450 | $3,626 | $___ | ___% |
| Wages Payable | 1,895 | 1,415 | ___ | ___% |
| Total Liabilities | $5,345 | $5,041 | $___ | ___% |
| Owners Equity |
| The Owner's Capital | 3,266 | 2,599 | ___ | ___% |
| Total Liabilities and Owner's Equity | $8,611 | $7,640 | $___ | ___% |
| 5) A man needed money to buy lawn equipment. He borrowed $700 for eight months and paid $53.96 in interest. What was the rate of interest? The rate of interest per year was __%. |
| 6) Find the acid-test ration for a business if the balance sheet shows the following amounts: cash, $32,897; receivables, $12,038; marketable securities, $0; current liabilities, $21,227. |
| The acid-ration is approximately____. |
| 7) Find the gross profit margin ration if the The Premier Eatery had net sales of $392,574 and its cost of goods solds was $176,384. |
| The gross profit margin ration is ___to 1. |
sunshine1212
week4_q.xls
