The image you've provided is a
Personal Income & Expense Template in Excel for
September 2021, prepared by "AR Multimedia Computer". It shows a detailed breakdown of income and expenses for the month, along with a final balance.
Let’s analyze and solve the problem step by step:
---
🔹 Step 1: Understand the Data
####
Income (Left Side)
| Serial No | Detail of Income | Amount |
|----------|---------------------------|--------|
| 1 | YouTube Channel | 35,500 |
| 2 | Content Writing | 15,900 |
| 3 | Website Development | 46,200 |
| 4 | Teaching | 26,000 |
| 5 | Computer Sales | 19,800 |
| 6 | Graphics Design | 23,500 |
| 7 | Business Card Design | 7,800 |
>
✔ Total Income = 174,700
####
Expenses (Right Side)
| Serial No | Detail of Expense | Amount |
|----------|----------------------------------------|--------|
| 1 | House Rent | 14,500 |
| 2 | Travel | 7,600 |
| 3 | Shipping | 3,000 |
| 4 | Personal Loan | 6,000 |
| 5 | Internet Bill | 1,250 |
| 6 | Telephone & Mobile Bill | 1,870 |
| 7 | Electricity Bill | 1,560 |
| 8 | House Expenses (Food) | 3,000 |
| 9 | Gift Giving | 2,000 |
| 10 | Send to Bank for Saving | 2,000 |
| 11 | Health Expenses | 6,500 |
| 12 | Entertainment | 10,000 |
| 13 | Staff Salary | 26,000 |
>
✔ Total Expenses = 85,280
---
🔹 Step 2: Calculate Net Profit / Surplus
We use the formula:
>
Net Profit = Total Income – Total Expenses
$$
\text{Net Profit} = 174,700 - 85,280 = 89,420
$$
✔ The
Balance shown at the top-right corner is
89,420, which matches our calculation.
---
🔹 Step 3: Interpretation & Summary
-
Total Income: ₹174,700
-
Total Expenses: ₹85,280
-
Net Surplus (Profit): ₹89,420
This means that after all expenses, there is a
positive cash flow of ₹89,420 for September 2021.
---
🔹 Key Observations
1.
Top Income Source:
→
Website Development (₹46,200) is the highest income source.
2.
Top Expense:
→
Staff Salary (₹26,000) is the largest expense.
3.
Savings:
→ ₹2,000 was specifically allocated to “Send to Bank for Saving”, indicating financial discipline.
4.
High-Income Activities:
→ Freelance work (YouTube, content writing, design, teaching) contributes significantly.
5.
Fixed Costs:
→ Rent (₹14,500), Salary (₹26,000), and personal loan (₹6,000) are major fixed costs.
---
✔ Final Answer
>
The net surplus for September 2021 is ₹89,420.
> This is calculated as:
> $$
> \text{Total Income (₹174,700)} - \text{Total Expenses (₹85,280)} = ₹89,420
> $$
This balance is correctly displayed in the template.
---
💡 Recommendation (Optional)
To improve financial health:
- Consider increasing savings beyond ₹2,000.
- Monitor variable expenses like entertainment and travel.
- Evaluate if staff salary can be optimized or outsourced based on workload.
Let me know if you'd like this converted into an actual Excel formula-based template!
Parent Tip: Review the logic above to help your child master the concept of income expense worksheet.
