Q.Calculate the Depreciation by using Straight Line Method (SLN) in MS Excel.
Spreadsheet (columns A, B):
Row 1: Description | Data
Row 2: Cost | Rs. 26,450
Row 3: Salvage | Rs. 1,450
Row 4: Useful life | 5 years
Row 5: Depreciation | ?
🔒You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.
🔒 Start your 14-day free trial to unlock the full solution →Concept understanding — Meaning Of Financial Statements
Let’s begin with something you already know. Suppose you run a small tuck shop in your school. At the end of the month, you want to know: Did I make a profit? How much cash do I have? How much do I owe my supplier? To answer these questions, you need a summary of your shop’s financial affairs — that summary is what accountants call financial statements.
Everyday Intuition
Think of financial statements as a report card for a business. Just as your report card shows your marks in each subject, financial statements show the business’s performance (profit or loss) and its financial position (what it owns and what it owes). Without them, you’d be guessing — and guessing is dangerous when real money is involved.
Precise Meaning (as per NCERT Class 12 Accountancy)
Financial statements are the final output of the accounting process. They are prepared at the end of an accounting period (usually a year) to present the financial results and position of a business in a structured, standardised way.
The two main financial statements for a sole proprietorship or partnership are:
- Trading and Profit & Loss Account – shows the gross profit/loss from trading and the net profit/loss for the period.
- Balance Sheet – shows the assets, liabilities, and capital of the business on a specific date.
For a company, financial statements also include a Statement of Profit and Loss (instead of a simple P&L) and a Balance Sheet in the format prescribed by the Companies Act. But for Class 12, you focus on the sole proprietorship/partnership format.
Why It Matters
Financial statements are not just a formality. They serve several critical purposes:
- For the owner – to know whether the business is making money and how much capital is safe.
- For lenders and creditors – to decide whether to give a loan or extend credit.
- For tax authorities – to verify income and tax payable.
- For comparison – to see if the business is improving year after year.
In short, financial statements are the language of business. Without them, no one can understand the financial health of an enterprise.
Accounting Treatment: How They Are Prepared
Financial statements are not journal entries. They are summaries drawn from the ledger accounts. So there is no “debit/credit” for the statements themselves. Instead, you transfer balances from ledger accounts into the statements.
Here’s the step-by-step process:
-
Close all revenue and expense accounts to the Trading and Profit & Loss Account.
- Debit all expenses and losses, credit all incomes and gains.
- The balancing figure is Net Profit (credit side bigger) or Net Loss (debit side bigger).
-
Transfer the Net Profit/Loss to the Capital Account (for sole proprietorship) or to the Partners’ Capital Accounts (for partnership).
-
Prepare the Balance Sheet by listing all assets (debit balances) on one side and all liabilities + capital (credit balances) on the other side. The two sides must always be equal.
A common mistake: students think financial statements are “accounts” that are debited/credited. They are not. They are statements — you don’t journalise them. You only journalise the closing entries that feed into them.
Format: Trading and Profit & Loss Account (as per NCERT)
Here is the standard format for a sole proprietorship. Note that the Trading Account is the top part, and the Profit & Loss Account is the bottom part — but they are often combined in one statement.
| Trading and Profit & Loss Account of [Business Name] for the year ended [Date] | ||
|---|---|---|
| Particulars | Amount (₹) | Particulars |
| To Opening Stock | xxx | By Sales |
| To Purchases | xxx | Less: Sales Returns |
| Less: Purchase Returns | (xxx) | By Closing Stock |
| To Direct Expenses (Wages, Carriage, etc.) | xxx | |
| To Gross Profit c/d | xxx | |
| Total | xxx | Total |
| To Salaries | xxx | By Gross Profit b/d |
| To Rent & Taxes | xxx | By Commission Received |
| To Depreciation | xxx | By Discount Received |
| To Interest on Loan | xxx | By Miscellaneous Income |
| To Net Profit (transferred to Capital A/c) | xxx | |
| Total | xxx | Total |
Use the Excel SLN function with cost, salvage and life: Depreciation = (Cost - Salvage) / Life. …
=SLN(B2,B3,B4) gives Rs 5,000 per year.
The Excel SLN function computes straight-line depreciation as (Cost - Salvage) / Life.
Formula entered in cell B5: =SLN(B2,B3,B4) …
Showing the 12 most recent of 88 on this concept.
- CBSE 2026Set ANNUAL1 markQ.State whether True or False: Financial statements are prepared on a particular date.
›Reveal solutionSolution
The statement is True in respect of the Balance Sheet.
The Balance Sheet is a statement of assets, liabilities and capital as on a particular date (the last day of the accounting period). In this sense financial statements are prepared on a particular date. (The Statement of Profit & Loss …
- CBSE 2026Set ANNUAL1 markQ.Answer in one word/sentence: Financial statements ignores which aspect?
›Reveal solutionSolution
Answer: Qualitative (non-monetary) aspects.
Financial statements record only those facts that can be expressed in money (money-measurement concept). They ignore qualitative or non-monetary factors - such as the skill of management, employee morale, and customer s …
- CBSE 2026Set ANNUAL1 markMCQQ.Which of the following is not a salient feature of a computerised accounting system?(a) Simple and integrated(b) Accuracy and speed(c) Complex(d) Transparent(a) Simple and integrated(b) Accuracy and speed(c) Complex(d) Transparent
›Reveal solutionSolution
'Complex' is NOT a salient feature of a Computerised Accounting System.
A Computerised Accounting System (CAS) is designed to make accounting work easier, faster, and more reliable than manual bookkeeping. Its genuine salient features include:
- Simple and Integrated — a single data entry (voucher) automatically updates all related books of account (ledger, trial balance, financial statements) — this is INTEGRATION, and the system is meant to be simple to operate, not complicated.
- Accuracy and Speed — computations (totals, balances, ratios) are done by the software itself, eliminating manual calculation errors and producing reports quickly.
- Transparency — any authorised user can view/verify any transaction and trace it to its source, improving reliability and audit-readiness. …
- CBSE 2026Set ANNUAL1 markMCQQ.Which command reverses the last action performed in the spreadsheet?(a) CUT(b) UNDO(c) REDO(d) DELETE(a) CUT(b) UNDO(c) REDO(d) DELETE
›Reveal solutionSolution
UNDO reverses the last action performed in a spreadsheet.
In an electronic spreadsheet (such as MS Excel), several edit commands help manage changes made to a worksheet:
- UNDO (Ctrl+Z) — reverses/cancels the most recently performed action, restoring the worksheet to its state just before that action. Most spreadsheet programs allow undoing multiple recent steps, not just one.
- REDO (Ctrl+Y) — reverses an UNDO, i.e. re-applies the action that was just undone.
- CUT (Ctrl+X) — removes the selected content from its current location and places it on the clipboard, for pasting elsewhere. …
- CBSE 2026Set ANNUAL1 markQ.What is the shortcut key to select the entire worksheet?
›Reveal solutionSolution
Ctrl + A selects the entire worksheet.
In electronic spreadsheet software (such as MS Excel), several keyboard shortcuts speed up selection and navigation. To select the ENTIRE worksheet (every cell currently in use, or the whole sheet if pressed from an empty area):
Shortcut: Ctrl + A
- If the active cell is within a continuous range of data, pressing Ctrl+A once selects that entire data range (a 'Select All' within the contiguous block); pressing it a second time extends the selection to the whole worksheet. …
- CBSE 2026Set ANNUAL1 markQ.Which function is used to calculate depreciation using the straight line method in Excel?
›Reveal solutionSolution
The SLN() function calculates straight-line depreciation in Excel.
Spreadsheet programs such as MS Excel provide built-in financial functions to calculate depreciation using different methods. For the straight-line method (where the same amount of depreciation is charged every year over the asset's useful life), the function used is:
SLN(cost, salvage, life)
where:
cost= the original purchase cost of the assetsalvage= the estimated value of the asset at the end of its useful life (scrap/residual value)life= the number of periods (years) over which the asset is being depreciated
The function computes a constant annual depreciation = (cost − salvage) / life, and returns the same value for every period.
…
- CBSE 2026Set ANNUAL1 markMCQQ.Or. Which of the following statements shows the financial position of a company?(a) Income statement(b) Cash flow statement(c) Balance Sheet(d) All of the above
›Reveal solutionSolution
The Balance Sheet alone shows a company's financial position (assets, liabilities, and equity as on a date) — the Income Statement shows performance, and the Cash Flow Statement shows cash movement, neither of which is "position."
Each financial statement serves a distinct purpose:
- Income Statement (Statement of Profit & Loss) — shows the financial performance/results of operations over a period of time (revenue earned, expenses incurred, net profit or loss).
- Cash Flow Statement — shows the movement of cash (inflows and outflows) over a period of time, classified into operating, investing, and financing activities. …
- CBSE 2026Set ANNUAL1 markQ.State one limitation of financial statement of a company.
›Reveal solutionSolution
Financial statements show only monetary facts, so they cannot capture important non-monetary/qualitative aspects of a business.
Financial statements (the Balance Sheet and Statement of Profit & Loss) are prepared strictly on the money measurement concept — only those transactions and events that can be expressed in terms of money are recorded. This gives rise to several genuine limitations; one important one is:
Ignore Qualitative Elements: Financial statements completely leave out important factors that have no direct monetary measure but can significantly affect the firm's real worth and future performance — for example:
- the skill, efficiency, and morale of employees and management,
- the quality of customer relationships and brand reputation,
- market conditions and competitive position,
- the loyalty and satisfaction of customers.
A company could have excellent financial ratios on paper while its management is weak or its workforce is demoralised — and the financial statements alone would never reveal this.
…
- CBSE 2025Set 67/4/11 markMCQQ.(a) The tool of 'Analysis of Financial Statements' which indicates the trend and direction of financial position and operating results is : (A) Ratio Analysis (B) Cash Flow Analysis (C) Common Size Statements (D) Comparative Statements(OR)(b) While preparing Common Size Statement of Profit and Loss of a company, each item is expressed as a percentage of _________. (A) Revenue from operations (B) Total liabilities (C) Total expenses (D) Total assets
›Reveal solutionSolution
Part (a): (D) Comparative Statements. Part (b): (A) Revenue from operations.
Part (a)
Comparative statements set out each item for two or more periods with the absolute and percentage change, revealing the trend and direction of both financial position (Balance Sheet) and operating results (Statement of Profit & Loss). Ratio analysis, cash flow analysis and common-size statements each serve other purposes and do not, on their own, show period-over-period trend and direction. …
- CBSE 2025Set MARCH1 markMCQQ.Which of the following is not required to be prepared under the Companies Act?(a) a) Fund flow statement(b) b) Balance sheet(c) c) Report of directors and auditors(d) d) Statement of profit and loss
›Reveal solutionSolution
A Fund Flow Statement is NOT required under the Companies Act. Correct option: (a).
Under the Companies Act, 2013 every company must prepare and present a Balance Sheet, a Statement of Profit and Loss, and the Board of Directors' report along with the Auditors' report; a Cash Flow Statement is also required for most companies. A Fund Flow St …
- CBSE 2025Set MARCH1 markQ.Cash flow statement also helps in ________ of cash flows.
›Reveal solutionSolution
A cash flow statement helps in PLANNING of cash flows (short-term financial planning).
By classifying cash movements into operating, investing and financing activities, the cash flow statement reveals where cash came from and where it went. This makes it a powerful tool for short-term financial planning: management can forecast future inflows and outflows, a …
- CBSE 2025Set ANNUAL1 markMCQQ.An annual report is issued by a company for (A) Directors (B) Management (C) Shareholders (D) Auditors
›Reveal solutionSolution
A company's annual report communicates its yearly performance and financial position to the owners of the company, who are the shareholders. Hence the answer is (C) Shareholders.
The annual report contains the financial statements (Balance Sheet and Statement of Profit and Loss), the directors' report, the auditor's report and other disclosures. For the BSEB Inter / Bihar Class-12 Accountancy syllabus:
- The shareholders own the company but do not run it day to day; management runs it on their behalf. …
🎓Unlock everything free for 14 days
- ✓Full step-by-step solutions
- ✓Concept-first explanations
- ✓Methods, shortcuts & mistakes
- ✓PYQ mapping + timed mock tests
Full access for 14 days. No credit card required.