Explain the following formatting tools with example :
(i) Number formatting
(ii) Currency
(iii) Percentage
(iv) Dates
(i) Number Formatting: This feature allows you to format a cell or range based on certain criteria. It changes the appearance of data and makes it easier to read and understand important numeric information.
(ii) Currency: Excel is equipped to incorporate various currency signs in pictorial form for dollar it uses $ similarly for other currencies also. If the user instructs the use of the format it will assign a currency format along with entry.
(iii) Percentage: If we enter a value representing a percentage as a whole number followed by the percentage sign without any decimal places, Excel assigns to the cell the percentage format that follows the pattern along with the entry.
(iv) Dates: If we enter a date (dates are values, too) that follows one of the built in excel formats, such as 11-12-2017 or 11-Dec-2017 the program assigns a date format that follows the pattern of the date.
What is Capital Fund? How is it calculated?
What is sacrificing ratio? Why is it calculated?
If a fixed amount is withdrawn on the first day of every quarter, for what period the interest on total amount withdrawn will be calculated?
Why there is need for the revaluation of assets and liabilities on the admission of a partner?
What is subscription? How is it calculated?
List the items which may be debited or credited in capital accounts of the partners when:
(i) Capitals are fixed.
(ii) Capital are fluctuating.
Why is Profit and Loss Adjustment Account prepared? Explain.
If some goodwill already exists in the books and the new partner brings in his share of goodwill in cash, how will you deal with existing amount of goodwill?
Why it is considered desirable to make the partnership agreement in writing.
On what occasions sacrificing ratio is used?
State the order of settlement of accounts on dissolution.
Illustrate how interest on drawings will be calculated under various situations.
How deficiency of crditors is paid off at the time of dissolution of firm.
Give two circumstances under which the fixed capitals of partners may change.
Define Partnership Deed.
Why is Profit and Loss Adjustment Account prepared? Explain.
What is meant by partnership? Explain its chief characteristics? Explain.
Priya and Kajal are partners in a firm, sharing profits and losses in the ratio of 5:3. The balance in their fixed capital accounts, on April 1, 2016 were: Priya, Rs. 6,00,000 and Kajal, Rs. 8,00,000. The profit of the firm for the year ended March 31, 2017 was Rs, 1,26,000. Calculate their shares of profits: (a) when there is no agreement in respect of interest on capital, and (b) when there is an agreement that the interest on capital will be allowed @ 12% p.a.
What is a Realisation Account?
List the items which may be debited or credited in capital accounts of the partners when:
(i) Capitals are fixed.
(ii) Capital are fluctuating.