Melody lane music company was started by john ross early in 2016. Initial capita
ID: 2419358 • Letter: M
Question
Melody lane music company was started by john ross early in 2016. Initial capital was acquired by issuing shares of common stock to various investors and by obtaining a loan. The company operates a retail store that sells records, tapes, and compact discs. Business was so good during the first year of operations that john is considering opening a second store on the other side of town. The funds neccesarry for expansion will come from a new bank loan. In order to approve the loan the bank requires financial statements. John asks for your help in prepareing the balance sheet and presents you with the following information for the year ending December 31 2016:
Cash receipts consist of the following,
From costumers $360,000
From issue of common stock 100,00
From bank loan 100,000
Cash disbursements were as follows:
Purchase of inventory 300,000
Rent 15,000
Salaries 30,000
Utilities 5,000
Insurance 3,000
Purchase of equipment and furniture 40,000
The bank loan was made on march 31 2016 a note was signed requiring payment of interest and principle on march 31 2017. The interest rate is 12%
The equipment and furniture were purchased on January 3 2016 and have an estimated useful life of 10 years with no anticipated salvage value. Depreciation per year is 4,000
Inventories on hand at the end of the year cost 100,000
Amounts owed at December 31, 2016 were as follows
To supliers of inventory $20,000
To the utility company $1,000
Rent on the store building is 1,000 per month. On Dec 1, 2016 four months rent was paid in advance.
Net income for the year was $76,000. Assume that the company is not subject to federal state or local income tax.
One hundred thousand shares of no par common stock are authorized, of which 20,000 shares were issued and are outstanding
Required: prepare a balance sheet at December 31, 2016.
Explanation / Answer
The balance sheet is given as follows:
__________
Notes:
1) Total cash balance at 31st December 2016 is the difference between the value of cash receipts and disbursements.
2) The rent paid in advance will be treated as prepaid for the remaining 3 months as at 31st December 2016.
3) Inventory at hand will be recorded at cost as at 31st December 2016.
4) The total amount owed to suppliers and utility company will be treated as accounts payable.
5) The interest on loan will be due for 9 months (1st April 2016 to 31st December 2016).
6) Net income of $76,000 will be transferred to retained earnings at the end of the year.
Melody Lane Music Company Balance Sheet At December 31, 2016 Assets Current Assets Cash (360,000 + 100,000 + 100,000 – 300,000 – 15,000 – 30,000 – 5,000 – 3,000 – 40,000) 167,000 Inventories 100,000 Prepaid Rent (4*1,000 – 1*1000) 3,000 Total Current Assets (A) 270,000 Property Plant and Equipment Equipment and Furniture 40,000 Less Accumulated Depreciation 4,000 Net Property Plant and Equipment (B) 36,000 Total Assets (A+B) $306,000 Liabilities and Shareholder's Equity Current Liabilities Accounts Payable (20,000 + 1,000) 21,000 Interest Payable (100,000*9%*9/12) 9,000 Loan Payable 100,000 Total Current Liabilities (C) 130,000 Shareholder's Equity Common Stock 100,000 Retained Earnings (same as Net Income) 76,000 Total Shareholder's Equity (D) 176,000 Total Liabilities and Shareholder's Equity (C+D) $306,000