Posts

AMORDEGRC function in Excel

-
Image
 AMORDEGRC function in Excel The Microsoft Excel AMORDEGRC function returns the linear depreciation of an asset for each accounting period, on a prorated basis. The AMORDEGRC function is a built-in function in Excel that is categorized as a  Financial Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AMORDEGRC function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the AMORDEGRC function in Microsoft Excel is: AMORDEGRC( cost, purchase_date, first_period, salvage, period, rate, [basis] ) Parameters or Arguments cost The cost of the asset. purchase_date The date that the asset was purchased. first_period The date of the end of the first period. salvage The salvage value after the asset has been fully depreciated. period The period in which to calculate the linear depreciation. rate The rate of depreciation. basis Optional. It is the type of year basis to use when calculating the depreciation. If this parame
Post a Comment
Read more

ACCRINTM Function in MS Excel

-
Image
  ACCRINTM Function in MS Excel What is the ACCRINTM Function? The ACCRINTM function in Excel is used to calculate the accrued interest for a security that pays interest at maturity. This function is typically used for bonds and similar financial instruments where interest is not paid periodically but is instead accumulated and paid at the maturity of the security.   Syntax The syntax for the ACCRINTM function in Microsoft Excel is: ACCRINTM( issue_date, maturity_date, rate, par, [basis] ) Parameters or Arguments issue_date The date that the security was issued. maturity_date The maturity date of the security. rate The annual coupon rate for the security. par The par value of the security. If this parameter is omitted, the ACCRINTM function will assume that the  par  is set to $1,000. basis Optional. It is the type of day count to use when calculating interest for the security. If this parameter is omitted, it assumes that the  basis  is set to 0. It can be any of the following value
Post a Comment
Read more

Format Under Stock and Debtor Account

-
Image
 Format Under Stock and Debtor Account 
Post a Comment
Read more

Journal Entries for Stock and Debtors Accounting

-
Important journal entries of this method are as follows:  Common Journals for both cost and invoice price transactions:   Transactions Journals For goods sent to branch. Branch Stock A/c… ................................ Dr. To Goods sent to branch A/c For cash sent to branch by H.O. Branch Cash A/c… ................................ Dr. To Bank A/c For cash sales at branch. Bank A/c… ................................ Dr. (Money remitted directly to H.O) Branch Cash A/c… ................................ Dr. (Money remitted through branch) To Branch Stock A/c For credit sale at branch. Branch Debtors A/c… ................................ Dr. To Branch Stock A/c When goods returned by the branch to the H.O. Goods sent to branch A/c… ......................
Post a Comment
Read more

What is Stock and Debtor System in Branch Accounting

-
 Stock and Debtor System in  Branch Accounting  Stock and Debtor for accounting of branch is used for exercising more detailed control over the working of a branch. Under this method several accounts are opened in the books of head office in place of one branch account. By opening detail accounts of several transactions greater supervision can be imposed on the financial activities of branch. Generally, following accounts are prepared for both cash price and invoice price transactions. (A)    Branch Stock Account. (either at cost price or invoice price) (B)    Branch Debtors Account. (C)    Branch Cash Account. (D)   Branch Expenses Account. (E)     Branch Profit / Loss Account. (F)     Abnormal loss Account. (G)   Goods sent to Branch Account. Etc. In case of invoice price transaction in addition to the above accounts an additional account is opened, called Branch Stock Adjustment Account, to reduce load o
Post a Comment
Read more