Welcome to Our Career Site
- How to be successful at entry level Accounting jobs
- How to be successful as a Staff Accountant
- How to be a successful auditor
- How to be a successful Forensic Accountant
- How to be a successful Management Accountant
- How to be a successful Tax Accountant
- How to integrate Technology in Accounting
- How to integrate AI in Accounting
- Top 100 Accounting Questions for Entry level
- Excel formula for Accounting-part 1
- Excel formula for Accounting-part 2
- Excel formula for Accounting-part 3
- Excel formula for Accounting-part 4
- Excel formula for Accounting-part 5
Job Listings
Explore the latest requirement for accounting jobs.
Click on the links to the left to learn more about specific aspects of accounting jobs.
Important Excel Formulae for Accounting-Part 5
Set 11: Depreciation Functions
SLN: Returns the straight-line depreciation of an asset for one period.
SYD: Returns the sum-of-years' digits depreciation of an asset for a specified period.
DDB: Returns the double-declining balance depreciation of an asset for a specified period.
DB: Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
Set 12: Investment Analysis Functions
XNPV: Returns the net present value for a schedule of cash flows that are not necessarily periodic.
XIRR: Returns the internal rate of return for a schedule of cash flows that are not necessarily periodic.
MIRR: Returns the modified internal rate of return for a series of periodic cash flows, considering both the cost of investment and the interest received on reinvestment.
CUMIPMT: Returns the cumulative interest paid between two periods.