Excel Forum
Similar Content
Performing Calculations in Excel - Order of Operations Explained
Tutorial: In this tutorial I am going to cover how to perform calculations in Excel. Calculations in...
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...



Excel Finance Trick #12: SLN & DDB Depreciation functions


See how to use the SLN & DDB Depreciation functions. The non-cash depreciation expenses are important for finance cash flow analysis. This video shows you the SLN & DDB functions.

In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!!

The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks!

Excel Formula





Got a Question? Ask it Here in the Forum.