In: Accounting
A family friend, Mr. Burn Out availed of the early retirement scheme offered by his employer. He said that he was already tired of the same routine of spending eight full hours in an office doing the same thing for the last twenty years.
Mr. Burn Out plans to get into the field of entrepreneurship. He would invest part of his retirement pay in a business that would deal with the sale of medical supplies to local clinics and hospitals.
When Mr. Burn Out learned that you are an accountant, he confessed that he is excited with his planned investment project, but very much afraid because he cannot afford to fail and lose his hard-earned retirement pay.
You advised that a Feasibility Study be prepared for his planned investment project. The study, you said, would determine the viability of his proposed business undertaking. it would cover key areas, such as marketing, production or purchasing, and finance, among others. You emphasized that the financial aspect is the most critical of them all.
Mr. Burn Out requested you to prepare a feasibility study for his proposed business. You immediately started and gathered the following relevant data.
1. Projected sales for the first year of operations are $288,000, spread evenly during the year. All sales will be on account with an average collection period of one month.
2. The cost ratio will be 60% of sales.
3. At the end of the first year, the acid-test ratio will be 1:1, while the current ratio will be 2:1.
4. Once the business is underway, purchases will replace the stock sold each month. The average payment period for accounts payable arising from the purchases of merchandise will be two (2) months.
5. Mr. Burn Out will open an account with the nearest bank and deposit $260,000 to start the business.
6. Various fixed assets will be acquired for cash at a total cost of $240,000. These fixed assets will be depreciated at the rate of 10% per year using the straight-line method.
7. Operating expenses, other than depreciation, are estimated at $70,000 per year. There will be no accruals and prepayment at year-end.
8. Mr. Burn Out will make drawings in excess of the amount necessary to meet the above plans.
Question: The projected balance sheet as of the end of the first year of operations will show an owners' equity balance of?
Question: The projected balance sheet as of the end of the first year of operations will show an owners' equity balance of?
Computation:
Step 1: Compute for the Payment of Purchases
Cost of goods sold | $172,800 |
Add: Ending inventory | 28,800 |
Total Purchases | 201,600 |
Less: Ending accounts payable | 28,800 |
Payment of purchases | 172,800 |
Step 2: Compute the drawings.
Initial Investment | $260,000 | |
Add: Collection of AR (288,000 - 24,000) | 264,000 | |
Total cash available | 524,000 | |
Less Disbursements: | ||
Acquisition of fixed assets | 240,000 | |
Payment of purchases | 172,800 | |
Cash Expenses | 70,000 | |
Ending cash balance | 4,800 | 487,600 |
Drawings | $36,400 |
Step 3: Compute the owners' equity balance
Initial investment | 260,000 |
Add: Income | 21,200 |
Total | 281,200 |
Less: drawings | 36,400 |
Owners' equity balance | $244,800 |
The projected balance sheet as of the end of the first year of operations will show an owners' equity balance of $244,800.