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?
Distinguish between firm’s debts and partner’s private debts.
What is a Realisation Account?
On dissolution, how will you deal with partner’s loan if it appears on the
(a) assets side of the balance sheet, (b) liabilities side of balance sheet.
State the difference between dissolution of partnership and dissolution of partnership firm.
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 it is necessary to ascertain new profit sharing ratio even for old partners when a new partner is admitted?
What is subscription? How is it calculated?
Reena and Raman are partners with capitals of Rs. 3,00,000 and Rs. 1,00,000 respectively. The profit for the year ended March 31, 2017 was Rs. 1,80,000, before paying rent for her personal building to be used as godown for firm to Reena payable at Rs. 5000 per month. Interest on capital is to be allowed at 6% p.a. Raman was entitled to a salary of Rs. 30,000 p.a. The drawings of partners were Rs. 30,000 and 20,000. The interest on drawings to be charged to Reena was Rs. 1,000 and to Raman, Rs. 500.
Assuming that Reena and Raman are equal partners. State their share of profit after necessary appropriations.
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?
Illustrate how interest on drawings will be calculated under various situations.