jordan pas cher Use of Excel in Accounting - Educa

We have discussed [link widoczny dla zalogowanych] [link widoczny dla zalogowanych] a very few basic formulas till now. There are hundreds of more such formulas already stored in the memory of Microsoft Excel, which makes it nothing less [link widoczny dla zalogowanych] than a magical wand that can be used for making accounting a piece of cake for each and every person.
Below mentioned [link widoczny dla zalogowanych] are a few significant formulas, explaining their uses and applications:
DB is the fixed declining balance approach, which uses the formula DB(cost, salvage, life, period, month). Cost in the formula denotes the initial cost of the asset, where as salvage is the value of the asset realized at the end of depreciation, life is the period for which the asset is useful, period is the time period for which the calculations is being calculated [link widoczny dla zalogowanych] and month represents nothing but the number of months of the year of calculation.
DDB is the double-declining balance methodology, which can be gauged by DDB(cost, salvage, life, period, [link widoczny dla zalogowanych] factor). The only difference between [link widoczny dla zalogowanych] DDB and DB is the use of factor instead of month. The term factor denotes the rate at which the balance of the asset declines with time.
SLN is another, very commonly used depreciation rule, known as the straight-line depreciation. This is the easiest way of computing [link widoczny dla zalogowanych] depreciation and can be done on excel by the formula, SLN(cost, salvage, life).
-????????? Future Value (FV): Future value is nothing but the value of an asset, as recorded on a date in the future. This value can be easily calculated by the simple Excel formula of FV, which is denominated as FV(rate, nper, pmt, [pv], [type]). The rate is the rate of interest at which [link widoczny dla zalogowanych] the future value [link widoczny dla zalogowanych] is to [link widoczny dla zalogowanych] be calculated, nper is the number of periods, pmt is the amount paid in every period, pv is the present value and type indicates if the payment is due every time at the beginning [link widoczny dla zalogowanych] or the end of the period.
-????????? : There are numerous formulas that can be used for computing the depreciation.
-????????? Present Value (PV): Present Value is defined as the present value or cost associated to the cash flows that are going to take place sometime in the future. PV( rate, [link widoczny dla zalogowanych] nper, pmt, [fv], [type]) is the formula used for the calculation of present value in excel. fv denotes the future value and the other variables remain the same, as described above. These formulas [link widoczny dla zalogowanych] can even be incorporated for the determination of the future and present values of an annuity and perpetuity.
Microsoft Excel is a world-wide used spreadsheet software application, which is commonly used for a large number of applications. It finds use in several day-to-day activities and even has the ability of providing technical and mathematical assistance for different accounting purposes. There are numerous formulas and features that are in-built in [link widoczny dla zalogowanych] the software and hence can be extremely useful in making the work of an accountant easy. Right from doing simple mathematical additions to subtractions, Excel can be used for adding charts and diagrams.

The post has been approved 0 times