Gupta Sons Accounts
**Problem Statement:**
Prepare the Trading Account, Profit & Loss Account, and Balance Sheet for Gupta & Sons as at December 31, 2018, from the provided Trial Balance with additional adjustments.
**Step 1: Prepare Trading Account**
1. Trading Account shows gross profit by comparing sales and cost of goods sold (COGS).
2. Sales = Rs. 10,00,000; Sales Returns = Rs. 25,000; Net Sales = 10,00,000 - 25,000 = Rs. 9,75,000.
3. Opening Inventory = Rs. 60,000
4. Purchases = Rs. 5,00,000; Purchases Returns = Rs. 15,000; Net Purchases = 5,00,000 - 15,000 = Rs. 4,85,000
5. Add Carriage Inwards = Rs. 10,000
6. Goods Available for Sale = Opening Inventory + Net Purchases + Carriage Inwards = 60,000 + 4,85,000 + 10,000 = Rs. 5,55,000
7. Closing Inventory = Rs. 1,00,000 (given)
8. Cost of Goods Sold (COGS) = Goods Available for Sale - Closing Inventory = 5,55,000 - 1,00,000 = Rs. 4,55,000
9. Gross Profit = Net Sales - COGS = 9,75,000 - 4,55,000 = Rs. 5,20,000
**Step 2: Prepare Profit & Loss Account**
1. Start with Gross Profit = Rs. 5,20,000.
2. List expenses:
- Wages = Rs. 50,000 + Rs. 4,000 (outstanding) = Rs. 54,000
- Salaries = Rs. 40,000 + Rs. 3,000 (outstanding) = Rs. 43,000
- Carriage Outwards = Rs. 5,000
- General Expenses = Rs. 20,000
- Rent & Rates = Rs. 10,000 - 1/4 prepaid (2,500) = Rs. 7,500
- Bad Debts = Rs. 5,000
- Discount = Rs. 4,500
- Interest on Bank Overdraft = Rs. 500
- Deduct Interest on Investments = Rs. 5,000 + Rs. 1,000 (outstanding) = Rs. 6,000 (Income)
3. Calculate Provision for Bad Debts:
- Debtors = Rs. 1,50,000
- Provision required = 5% of 1,50,000 = Rs. 7,500
- Current provision = Rs. 7,000
- Additional provision required = 7,500 - 7,000 = Rs. 500 (expense)
4. Total expenses = 54,000 + 43,000 + 5,000 + 20,000 + 7,500 + 5,000 + 4,500 + 500 + 500 = Rs. 1,39,000
5. Net Profit = Gross Profit - Total Expenses + Interest on Investments = 5,20,000 - 1,39,000 + 6,000 = Rs. 3,87,000
**Step 3: Prepare Balance Sheet as on December 31, 2018**
*Assets*:
- Land & Buildings = 4,00,000 - 5% depreciation = 4,00,000 - 20,000 = Rs. 3,80,000
- Plant & Machinery = 3,00,000 - 50,000 depreciation = Rs. 2,50,000
- Furniture = 1,00,000 - 10% depreciation = 1,00,000 - 10,000 = Rs. 90,000
- Investments = Rs. 50,000
- Debtors = Rs. 1,50,000 - Provision for Bad Debts Rs. 7,500 = Rs. 1,42,500
- Bills Receivable = Rs. 40,000
- Cash in Hand = Rs. 50,000
- Inventory (Closing) = Rs. 1,00,000
- Acceptances = Rs. 10,000
- Rent & Rates prepaid (1/4 of 10,000) = Rs. 2,500
- Interest on Investments (accrued) = Rs. 1,000
*Liabilities*:
- Capital = Rs. 5,00,000
- Add: Net Profit = Rs. 3,87,000
- Less: Drawings (not provided, assume zero)
- Capital after profit = 5,00,000 + 3,87,000 = Rs. 8,87,000
- Loan = Rs. 2,60,000
- Creditors = Rs. 70,000
- Provision for Bad Debts = Rs. 7,500
- Outstanding Wages = Rs. 4,000
- Outstanding Salaries = Rs. 3,000
- Bank Overdraft = Rs. 10,000
- Rent received in advance = Rs. 2,000
**Step 4: Final Check**
- Total Assets = Sum all assets above
- Total Liabilities = Sum all liabilities + capital
- Ensure that Total Assets = Total Liabilities (balance sheet balances)
**Final answers:**
- Trading Account shows Gross Profit Rs. 5,20,000
- Profit & Loss Account shows Net Profit Rs. 3,87,000
- Balance Sheet presents adjusted asset values and liabilities as detailed above.