Please select a subject first
Advertisements
Advertisements
Which function results can be displayed in Auto Calculate?
Concept: Basic Concepts of Spreadsheet >> Functions
When navigating in a workbook, which command is used to move to the beginning of the current row?
Concept: Basic Concepts of Spreadsheet
The syntax of PMT Function is ______.
Concept: Useful Functions > Financial Functions
Explain the use of ‘Conditional Formatting’.
Concept: Data Formatting
C and D are the partner in a firm sharing profits in the ratio of 4:1. On 31.3.2016 their Balance Sheet was as follows :
| Balance Sheet of C and D As on 31.3.2016 |
|||
| Liabilities | Rs | Assets | Rs |
|
Sundry Creditors Provision for Bad debts Outstanding Salary General Reserve
Capitals C 1,20,000 D 80,000 |
40,000 4,000 6,000 10,000
2,00,000 |
Cash Debtors Stock Furniture Plant and Machinery
|
24,000 36,000 40,000 80,000 80,000
|
| 2,60,000 | 2,60,000 | ||
On the above date, E was admitted for 1/4 th share in the profits on the following terms:
1) E will bring 1, 00,000 as his capital and 20,000 for his share of goodwill premium half of which will be withdrawn by C and D.
2) Debtors 2,000 will be written off as bad debts and a provision of 4% will be created on debtors for bad debts and doubtful debts
3) The stock will be reduced by Rs 2,000, furniture will be depreciated by Rs 4,000 and 10% depreciation will be charged on plant and machinery
4) Investments of 7,000 not shown in the Balance Sheet will be taken into account.
5) There was an outstanding repairs bill of Rs 2,300 which will be recorded in the books.
Pass necessary journal entries for the above transactions in the books of the firm on E’s admission.
Concept: Statement of Profit and Loss
| Balance Sheet of Sameer, Yasmin and Saloni as at 31.3.2016 | |||||
| Liabilities | Amount (₹) | Amount (₹) | Assets | Amount (₹) | Amount (₹) |
| Creditors | 1,10,000 | Cash | 80,000 | ||
| General Reserve | 60,000 | Debtors | 90,000 | 80,000 | |
| Capitals: | 7,00,000 | Less: Provision | 10,000 | ||
| Sameer | 3,00,000 | Stock | 1,00,000 | ||
| Yasmin | 2,50,000 | Machinery | 3,00,000 | ||
| Saloni | 1,50,000 | Building | 2,00,000 | ||
| Patents | 60,000 | ||||
| Profit and Loss Account | 50,000 | ||||
| 8,70,000 | 8,70,000 | ||||
On the above date, Sameer retired and it was agreed that:
- Debtors of 4,000 will be written off as bad debts and a provision of 5% on debtors for bad and doubtful debts will be maintained.
- An unrecorded creditor of 20,000 will be recorded.
- Patents will be completely written off and 5% depreciation will be charged on stock, machinery and building.
- Yasmin and Saloni will share future profits in the ratio of 3 : 2.
- Goodwill of the firm on Sameer’s retirement was valued at ₹ 5,40,000.
Pass necessary journal entries for the above transactions in the books of the firm on Sameer’s retirement.
Concept: Statement of Profit and Loss
From the following Balance Sheet as SRS Ltd and the additional information as in 31.3.2016, prepare a Cash Flow Statements :
| Balance Sheet of SRS Ltd as at 31-3-2016 | |||
| Particulars | Note No. |
31-03-2016 Rs |
31-03-2015 Rs |
|
I. Equity and Liabilities 1. Shareholder’s Funds (a) Share Capital (b) Reserve and Surplus 2. Non - Current Liabilities (a) Long-term borrowings 3. Current Liabilities (a) Short-term borrowings (b) Short-term provisions |
1
2
3 4 |
4,50,000 1,25,000
2,25,000
75,000 1,00,000 |
3,50,000 50,000
1,75,000
37,500 62,500 |
| Total | 9,75,000 | 6,75,000 | |
|
II. Assets 1. Non – Current Assets (a) Fixed Assets Tangible assets Intangible (b) Non – Current Investments 2. Current Assets (a) Current Investments (b) Inventories (c) Cash and Cash
|
5 6
7
|
7,32,500 50,000 75,000
20,000 61,000 36,500 |
4,52,500 75,000 50,000
35,000 36,000 26,500 |
| Total | 9,75,000 | 6,75,000 | |
| Note No | Particulars |
31-3-2016 Rs |
31-3-2015 Rs |
|
1
|
Reserve and Surplus (Surplus i.e. Balance in Statement of Profit and Loss) |
1,25,000
|
50,000
|
| 1,25,000 | 50,000 | ||
|
2
|
Long term borrowings : 12 % Debentures |
2,25,000 |
1,75,000 |
| 2,25,000 | 1,75,000 | ||
|
3
|
Short-term borrowings : Bank Overdraft |
75,000 |
37,500 |
| 75,000 | 37,500 | ||
|
4
|
Short-term provisions Provisions for tax |
1,00,000 |
62,500 |
| 1,00,000 | 62,500 | ||
|
5
|
Tangible Assets Machinery Accumulated Depreciation |
8,37,500 (1,05,000) |
5,22,500 (70,000) |
| 7,32,500 | 4,52,500 | ||
|
6
|
Intangible Assets Goodwill |
50,000 |
75,000 |
| 50,000 | 75,000 | ||
|
7
|
Inventories Stock in trade |
61,000 |
36,000 |
| 61,000 | 36,000 |
Additional Information:
1) Rs 50,000, 12% debentures were issued on 31.3.2016
2) During the year a piece of machinery costing Rs40,000 on which accumulated depreciation was Rs 20,000 was sold at a loss of Rs 5,000.
Concept: Statement of Profit and Loss
'Good Blankets Ltd.' are the manufacturers of woollen blankets. Blankets of the company are exported to many countries. The company decided to distribute blankets free of cost to five villages of Kashmir Valley destroyed by the recent floods. It also decided to employ 100 young persons from these villages in their newly established factory at Solan in Himachal Pradesh. To meet the requirements of funds for starting its new factory, the company issued 50,000 equity shares of Rs 10 each and 2,000 8% debentures of Rs 100 each to the vendors of machinery purchased for Rs 7,00,000. Pass necessary journal entries for the above transactions in the books of the company. Also, identify anyone value which the company wants to communicate to the society.
Concept: Concept of Financial Statements
Following is the Balance Sheets of Solar Power Ltd as at 31.3.2014 :
| Solar Power Ltd. Balance Sheet |
|||
| Particulars | Note No. |
31-3-2014 Rs |
31-3-2014 Rs |
|
I. Equity and Liabilities 1. Shareholder’s Funds a. Share Capital b. Reserve and Surplus 2. Non - Current Liabilities a. Long-term borrowings 3. Current Liabilities a. Trade Payables b. Short Term Provisions |
24,00,000 6,00,000
4,80,000
3,58,000 1,00,000 |
22,00,000 4,00,000
3,40,000
4,08,000 1,54,000 |
|
| Total | 39,38,000 | 35,02,000 | |
|
II. Assets 1. Non – Current Assets a) Fixed Assets (i) Tangible assets (ii) Intangible b) Non – Current Investments 2. Current Assets a) Current Investment b) Inventories c) Trade Receivables d)Cash and Cash |
21,40,000 80,000
4,80,000 2,58,000 3,40,000 6,40,000 |
17,00,000 2,24,000
3,00,000 2,42,000 2,86,000 7,50,000 |
|
| Total | 39,38,000 | 35,02,000 | |
Notes to Accounts
| Note No |
Particulars | As On 31-3-2014 |
As On 31-3-2013 |
|
1
|
Reserve and Surplus (Surplus i.e. Balance in Statement of Profit and Loss) |
6,00,000
|
4,00,000
|
|
2
|
Tangible Assets Machinery Less: Accumulated Depreciation |
25,40,000 (4,00,000) |
20,00,000 (3,00,000) |
|
3
|
Intangible Assets Goodwill |
80,000 |
2,24,0000 |
Additional Information:-
During the year a piece of machinery, costing Rs 48,000 on which accumulated depreciation was Rs 32,000, was sold at Rs 12,000.
Prepare Cash Flow Statement.
Concept: Statement of Profit and Loss
State any one limitation of Financial Statement Analysis’
Concept: Concept of Financial Statements
Prepare common size statement of profit and loss from the following information:
| Particulars | Note No. | 2017-18 | 2016-17 |
| Revenue from operations | ₹ 16,00,000 | ₹ 8,00,000 | |
| Cost of material consumed | |||
| (% of revenue from operations) | 60% | 50% | |
| Operating expenses | ₹ 80,000 | ₹ 40,000 | |
| Income tax rate | 40% | 30% |
Concept: Common-Size Statement
Which of the following are not tools of Financial Analysis?
- Cash Flow Statement
- Income Statement
- Balance Sheet
- Ratio Analysis
Concept: Concept of Financial Statement Analysis
From the following details obtained from the financial statements of JN Ltd. calculate 'interest coverage ratio'. Net profit after tax Rs.2, 00,000; 12% Long-Term Debt Rs.40, 00,000; Rate of tax 40%.
Concept: Solvency Ratios >> Interest Coverage Ratio
From the following information calculate inventory turnover ratio; Revenue from operations Rs.16,00,000; Average Inventory Rs.2,20,000; Gross Loss Ratio 5%.
Concept: Activity Ratios >> Inventory Turnover Ratio
From the Following information , compute Debt-Equity Ratio:
Rs.
Long Term Borrowings 2,00,000
Long Term Provision 1,00,000
Current Liabilities 50,000
Non-Current-Assets 3,60,000
Current -Assets 90,000
Concept: Solvency Ratios >> Debt to Equity Ratio
The quick ratio of a company is 1.5: 1. A state with reason which of the following transactions would
i. increase:
ii. decrease or
iii. not change the ratio
a. Paid rent Rs 3,000 in advance.
b. Trade receivables included a debtor Shri Ashok who paid his entire amount due Rs 9,700.
Concept: Activity Ratios >> Inventory Turnover Ratio
From the following information, calculate the value of opening and closing inventory:
Inventory Turnover Ratio - 4 times.
Gross Profit = 20% on Revenue from Operations.
Revenue from Operations = ₹ 10,00,000.
Opening inventory is 25% of the inventory at the end.
Concept: Activity Ratios >> Inventory Turnover Ratio
Debt-Equity Ratio of Z Ltd. is 2: 1. State with reason whether the following transactions will improve, decline or will not change the debt-equity ratio:
- Conversion of ₹ 3,00,000, 9% debentures into equity shares.
- Cash received from debtors ₹ 1,00,000.
- Redemption of ₹ 10,00,000, 11% debenture.
- Purchase of goods on credit ₹ 4,00,000.
Concept: Solvency Ratios >> Debt to Equity Ratio
Vikas, Vishal and Vaibhav were partners in a firm sharing profits in the ratio of 2:2:1. The firm closes its books 31st March every year. On 31-12-2015 Vaibhav died. On that date his Capital account showed a credit balance of Rs. 3, 80,000 and Goodwill of the firm was valued at 1, 20,000. There was a debit balance of Rs. 50,000 in the profit and loss account. Vaibhav's share of profit in the year of his death was to be calculated on the basis of the average profit of last five years. The average profit of last five years was Rs. 75,000.
Pass necessary journal entries in the books of the firm on Vaibhav's death.
Concept: Methods of Valuation of Goodwill
Kumar, Gupta and Kavita were partners in the firm sharing profits and losses equally. The firm was engaged in the storage and distribution of canned juice and its godowns were located at three different places in the city. Each godown was being managed individually by Kumar, Gupta and Kavita. Because of increase in business activities at the godown managed by Gupta, he had devoted more time. Gupta demanded that his share in the profits of the firm be increased, to which Kumar and Kavita agreed. The new profit sharing ratio was agreed to be 1: 2: 1. For this purpose, the goodwill of the firm was valued at two years purchase of the average profits of last five years. The profits of the last five years were as follows :
| Years |
Profit Rs |
|
| I | 4,00,000 | |
| II | 4,80,000 | |
| II | 7,33,000 | |
| IV | Loss | 33,000 |
| V | 2,20,000 |
You are required to:
1) Calculate the goodwill of the firm
2) Pass necessary Journal Entry for the treatment of goodwill on the change in profit sharing ratio of Kumar, Gupta and Kavita.
Concept: Methods of Valuation of Goodwill
