In: Accounting
| FINANCIAL STATEMENT PREPARATION - FINAL | |||||
| The following events occurred at MGR Company during its first year of business: | |||||
| a. | To establish the MGR, Merry and Mary each contributed a total of $50,000 in exchange for common stock. | ||||
| b. | MGR, or MerryGoRound is an Event Planning Company that specializes in high-end parties. The first year they conducted 94 events and revenue for the first year amounted to $470,000, of which 95% was to be paid by the date of the event and the remainder due within 30 days of the event. | ||||
| c. | Clients owe $15,000 at the end of the year from the services provided in December. | ||||
| d. | At the beginning of the year, a storage building was rented. The company was required to sign a two-year lease for $15,000 per year and make a $3,000 refundable security deposit. The first year’s lease payment and the security deposit were paid at the beginning of the year. | ||||
| e. | At the beginning of the year, the company purchased a full-size Merry-Go-Round at a cost of $100,000 as the signature theme piece of their company. The Merry-Go-Round is expected to be useful for fifteen years. The company paid 20% down in cash and signed a four-year note at the bank for the remainder (with 10% interest-only to be paid annually until maturity). Since each event includes the Merry-Go-Round, MGR also purchased a flatbed trailer to haul it with, for $8,000, also with an expected 15 year life. MGR must lease a large truck to haul the trailer for each event, which costs $1,000 per day. | ||||
| f. | Other operating expenses, including wages, deprecation on other equipment, utilities, and rent on the storage building noted in (d) and (e) above, totaled $136,000 for the first year. No expenses were accrued or unpaid at the end of the year. | ||||
| g | MGR purchased other equipment (tables & carts, ice machine, food heating trays and bags, helium tanks, music system, etc) for $10000 with an estimated life of 10 years and no salvage value. Salaries and wages for the year total $112,800 including payroll taxes. | ||||
| h | The company declared and paid a $50,000 cash dividend at the end of the first year. | ||||
| i | MGR is in the 35% corporate tax bracket. | ||||
| Required? | |||||
| Prepare a statement of cash flows for the first year using the direct method in the Operating Activities section. | |||||
| Complete vertical analysis of the Income statement. | |||||
| Compute, explain & analyze the following ratios: | |||||
| a | Gross Profit | ||||
| b | Operating Leverage ratio | ||||
| c | Return on common equity | ||||
| d | Current ratio | ||||
| e | Operating Cash flow to current liabilities | ||||
| f | Long-term debt to assets | ||||
| g | Interest coverage | ||||
| Cash Flow Statements | |
| Particulars | Amount | 
| Cash collection from clients | $ 4,55,000 | 
| Lease rent paid | $ -15,000 | 
| Salaries Paid | $ -1,12,800 | 
| Operating expenses paid | $ -1,12,800 | 
| Taxes paid | $ -74,620 | 
| Security Deposit paid | $ -3,000 | 
| Cash Flow from operation | $ 1,36,780 | 
| Purchase of mary go round | $ -1,00,000 | 
| Purchase of Flated Trailer | $ -8,000 | 
| Purchase of Equipments | $ -10,000 | 
| Cash Flow From Investing | $ -1,18,000 | 
| Issue of Common Stock | $ 1,00,000 | 
| Issue of 10% Bank Note | $ 80,000 | 
| Interest Paid | $ -8,000 | 
| Dividend Paid | $ -50,000 | 
| Cash Flow From Financing | $ 1,22,000 | 
| Net Change in cash | $ 1,40,780 | 
| Opening cash | $ - | 
| Closing cash | $ 1,40,780 | 
| Income Statement | |
| Particulars | |
| Revenue | $ 4,70,000 | 
| Other Operating Expenses | $ -1,12,800 | 
| Constribution | $ 3,57,200 | 
| Lease Rent | $ -15,000 | 
| Salaries | $ -1,12,800 | 
| Depreciation | $ -8,200 | 
| Operating Profit | $ 2,21,200 | 
| Interest expenses | $ -8,000 | 
| Profit Befor Tax | $ 2,13,200 | 
| Tax Expenses | $ -74,620 | 
| Net Income | $ 1,38,580 | 
| Compute Ratios | |
| Gross profit | 47.06% | 
| Operating Leverage | 1.61 | 
| Return on Common Equity | 138.58% | 
| Current Ratio | Can not be calculated as company does not have current Liabilities | 
| Operatin cash flow to current liabilities | Can not be calculated as company does not have current Liabilities | 
| Long-term debt to assets | 0.73 | 
| Interest Coverage | 27.65 |