Solved] Require a) Prepare a spreadsheet using the accounting ... - Free Printable

Let’s go step by step to check if the totals at the bottom of the table are correct.

We’ll add up each column one by one:

---

1. Assets Column:

List of values:
- Jun-01: 50,000
- Jun-06: -10,000
- Jun-15: -5,000
- Jun-15: -1,000
- Jun-22: -200
- Jun-30: -13,000
- Jun-30: -15,000
- Jul-13: 35,000
- Jul-18: -1,500
- Jul-31: -13,000
- Jul-31: -13,500
- Aug-05: 28,000
- Aug-26: -5,000
- Aug-31: -13,000
- Aug-31: -17,000
- Aug-31: -1,000 (this is under Dividends — wait! Let’s double-check)

Wait — look carefully: The row “Aug-31” with “Dividend and Asset(Cash)” has -1,000 in Assets, and also -1,000 in Dividends. That’s okay — it’s a dividend payment, so cash (asset) goes down, and dividends are recorded separately.

Then next row: “Aug-31 Revenue and Asset(Cash)” → -3,000? Wait — that doesn’t make sense. Revenue should increase assets, not decrease. But let’s just follow the numbers as given for now.

Actually, looking again:

The last two rows on Aug-31:

- “Dividend and Asset(Cash)” → Assets: -1,000 | Dividends: -1,000
- “Revenue and Asset(Cash)” → Assets: -3,000? That seems wrong — revenue should be positive. But maybe it’s a typo or mislabeling? However, we’re checking the total as presented.

Also, there’s a final row: “1,800” under Assets — probably a correction or adjustment? And then totals below.

But actually, looking at the very bottom row:

It says:
Assets: 1,800
Paid up Capital: 50,000
Liabilities: 0
Income: 63,000
Expenses: -110,200
Dividends: -1,000

Wait — this looks like the *totals* row. So we need to verify if these totals match the sum of all entries above.

Let’s recalculate each column from top to bottom, ignoring the last “total” row for now.

---

Recalculating Assets column:

Start adding:

50,000 (Jun-01)
+ (-10,000) = 40,000
+ (-5,000) = 35,000
+ (-1,000) = 34,000
+ (-200) = 33,800
+ (-13,000) = 20,800
+ (-15,000) = 5,800
+ 35,000 = 40,800
+ (-1,500) = 39,300
+ (-13,000) = 26,300
+ (-13,500) = 12,800
+ 28,000 = 40,800
+ (-5,000) = 35,800
+ (-13,000) = 22,800
+ (-17,000) = 5,800
+ (-1,000) = 4,800 ← this is the dividend entry
+ (-3,000) = 1,800 ← this is the last revenue entry? But labeled as revenue yet negative? Hmm.

So total Assets = 1,800 → matches the total shown.

Okay, so even though some labels seem odd (like revenue being negative), the math adds up to 1,800.

---

Paid up Capital:

Only one entry: Jun-01 → 50,000
No other entries → Total = 50,000 → matches.

---

Liabilities:

All blank → Total = 0 → matches.

---

Income:

Entries:
- Jul-13: 35,000
- Aug-05: 28,000

Total = 35,000 + 28,000 = 63,000 → matches.

---

Expenses:

List:
- Jun-06: -10,000
- Jun-15: -5,000
- Jun-15: -1,000
- Jun-22: -200
- Jun-30: -13,000
- Jun-30: -15,000
- Jul-18: -1,500
- Jul-31: -13,000
- Jul-31: -13,500
- Aug-26: -5,000
- Aug-31: -13,000
- Aug-31: -17,000
- Aug-31: -3,000 ← this is the last “revenue” row but listed under expenses? Wait no — in the table, the last row before totals is:

“Aug-31 Revenue and Asset(Cash)” → Income: blank, Expenses: -3,000? That can’t be right — revenue shouldn’t be an expense.

Wait — let’s re-express the table clearly.

Looking back at original table structure:

Each row has:

Date | Nature | Assets | Paid up Capital | Liabilities | Income | Expenses | Dividends

For example:

Jun-06: Expenses and Asset(Fixed asset) → Assets: -10,000 | Expenses: -10,000 → makes sense: you spend cash (asset down) and record expense.

Similarly, Jul-13: Revenue and Asset(Cash) → Assets: +35,000 | Income: +35,000 → good.

But then Aug-31: “Revenue and Asset(Cash)” → Assets: -3,000? That must be a mistake in labeling — perhaps it’s meant to be an expense? Or maybe it’s a refund? But regardless, in the table, it’s entered as:

Assets: -3,000
Expenses: ??? Actually, looking again — in that row, only Assets and... wait, no:

In the row: “Aug-31 Revenue and Asset(Cash)” — the columns filled are:

Assets: -3,000
and nothing else? But in the total row, Expenses include -3,000? Let me check the expense list again.

From the table:

Expenses column entries:

- Jun-06: -10,000
- Jun-15: -5,000
- Jun-15: -1,000
- Jun-22: -200
- Jun-30: -13,000
- Jun-30: -15,000
- Jul-18: -1,500
- Jul-31: -13,000
- Jul-31: -13,500
- Aug-26: -5,000
- Aug-31: -13,000
- Aug-31: -17,000
- Aug-31: -3,000 ← this is from the last “Revenue” row? But why is it in expenses?

Actually, looking at the row: “Aug-31 Revenue and Asset(Cash)” — in the table, under Expenses, it’s blank? No — wait, in the user’s image description, the last few rows are:

...

Aug-31 | Dividend and Asset(Cash) | -1,000 | | | | | -1,000
Aug-31 | Revenue and Asset(Cash) | -3,000 | | | | |
[then total row]

But in the total row, Expenses = -110,200

So let’s sum all the Expense entries explicitly listed:

From the table:

Expenses column:

- Jun-06: -10,000
- Jun-15: -5,000
- Jun-15: -1,000
- Jun-22: -200
- Jun-30: -13,000
- Jun-30: -15,000
- Jul-18: -1,500
- Jul-31: -13,000
- Jul-31: -13,500
- Aug-26: -5,000
- Aug-31: -13,000
- Aug-31: -17,000
- And then the last row “Revenue and Asset(Cash)” — does it have an expense entry? In the text provided, it shows:

“Aug-31 Revenue and Asset(Cash) | -3,000 | ... ” — but which column is -3,000 in? Looking at alignment:

In the initial table dump:

After “Aug-31 Dividend...” row:

Next line: “Aug-31 Revenue and Asset(Cash) | -3,000 | ... ” — and then the total row starts with “1,800” under Assets.

Actually, rereading the user’s input:

The lines are:

...

Aug-31 | Dividend and Asset(Cash) | -1,000 | | | | | -1,000
Aug-31 | Revenue and Asset(Cash) | -3,000 | | | | |
[blank?]
1,800 | 50,000 | 0 | 63,000 | -110,200 | -1,000

Ah — I see. The “-3,000” is under Assets for that row, and no expense is recorded there. But then where does the -3,000 come from in expenses? It doesn’t.

Wait — let’s list ALL expense values from the table as written:

From the "Expenses" column:

Row Jun-06: -10,000
Jun-15: -5,000
Jun-15: -1,000
Jun-22: -200
Jun-30: -13,000
Jun-30: -15,000
Jul-18: -1,500
Jul-31: -13,000
Jul-31: -13,500
Aug-26: -5,000
Aug-31: -13,000
Aug-31: -17,000
And then — is there another? The last “Revenue” row has no expense entry.

But in the total, it’s -110,200.

Let’s add what we have:

Start:

-10,000
-5,000 → -15,000
-1,000 → -16,000
-200 → -16,200
-13,000 → -29,200
-15,000 → -44,200
-1,500 → -45,700
-13,000 → -58,700
-13,500 → -72,200
-5,000 → -77,200
-13,000 → -90,200
-17,000 → -107,200

That’s only -107,200. But the total says -110,200. Missing -3,000.

Ah — probably the last row “Aug-31 Revenue and Asset(Cash)” with Assets: -3,000 — but if it’s labeled “Revenue”, it should be income, not expense. However, in the table, perhaps it was mistakenly put in expenses? Or maybe it’s an expense mislabeled.

Looking back at the user’s text:

The row is: “Aug-31 Revenue and Asset(Cash) | -3,000 | ... ” — and in the context, since Assets is -3,000, and if it’s revenue, it should be positive income. But here, it’s likely that this is actually an expense, and the label is wrong. Because otherwise, the totals don’t match.

Moreover, in the total row, Expenses = -110,200, and our sum without this is -107,200, so we need to add -3,000 more.

Therefore, it’s safe to assume that the -3,000 in that row is intended to be an expense, even though labeled “Revenue”. Perhaps a typo in the problem.

So including that:

-107,200 + (-3,000) = -110,200 → matches.

---

Dividends:

Only one entry: Aug-31 → -1,000 → total = -1,000 → matches.

---

Now, let’s verify the accounting equation:

Assets = Liabilities + Equity

Equity = Paid up Capital + Retained Earnings

Retained Earnings = Income - Expenses - Dividends

So:

Income = 63,000
Expenses = -110,200 → so net loss = 63,000 - 110,200 = -47,200
Dividends = -1,000 → so retained earnings change = -47,200 - 1,000 = -48,200

Initial equity: Paid up Capital = 50,000
Final equity = 50,000 + (-48,200) = 1,800

Assets = 1,800
Liabilities = 0
So Assets = Liabilities + Equity → 1,800 = 0 + 1,800 → Correct!

Perfect.

---

Final Answer:
The totals provided in the table are correct:
Assets = 1,800
Paid up Capital = 50,000
Liabilities = 0
Income = 63,000
Expenses = -110,200
Dividends = -1,000

And they satisfy the accounting equation: Assets = Liabilities + Equity.