# Stephen L Nelson

Stephen L Nelson, CPA, State of Washington. Best-selling author of QuickBooks for Dummies (over 400,000 copies sold), of Quicken for Dummies (over 1,000,000 copies sold), and numerous other books about small business accounting, finance, project management, and technology.

back to homepage

# Stephen L Nelson Free Articles

### Using Microsoft Excel's Declining Balance Depreciation Function

Making financial forecasts or performing investment analyses that need to include depreciation? Microsoft Excel can help. Excel's DB, or declining balance, depreciation function lets you calculate fixed-declining balance depreciation.

### Using Microsoft Excel's Double Declining Balance Depreciation Function

Making financial forecasts or performing investment analyses that needs to include double declining balance depreciation? Microsoft Excel can help. Excel's DDB, or double declining balance, depreciation function lets you calculate 200% declining balance depreciation.

### Using Microsoft Excel's Straight-line and Sum-of-the-years Digits Depreciation Functions

Analyzing real estate investments? Making book depreciation calculations? Microsoft Excel can help. Excel's SLN, or straight-line depreciation, function lets you easily calculate standard straight-line depreciation amounts. And Excel's SYD, or sum-of-the-years-digits, function lets you easily calculate standard sum of the year's digits depreciation.

### Using Microsoft Excel's Variable Declining Balance Depreciation Function

Making tax accounting depreciation calculations for return preparation or tax planning purposes?? Microsoft Excel can help. Excel's VBD, or variable rate depreciation, function lets you easily calculate variable declining balance s depreciation amounts, including those based on the MACRS depreciation convention.

### Calculating the Time to Repay Loans

Trying to calculate how long a loan will take to repay? Microsoft Excel can help. Excel's NPER, or number of periods, function lets you easily calculate how long repaying a loan will take given the loan interest rate, its balance, and the payment made.

### Forecasting Future Values With Microsoft Excel

Making future value calculations, such as for investment analysis or retirement planning? Microsoft Excel can help. Excel's FV, or future value, function lets you easily calculate how an initial investment or regular payment grows over time because of compound interest.

### Calculating Present Values With Microsoft Excel

Making present value calculations, such as for loan analysis or investment planning? Microsoft Excel can help. Excel's PV, or present value, function lets you easily calculate the present, current day, value of a future cash flow or of a regular payment stream.

### Calculating Interest Rates With Microsoft Excel

Making interest rate calculations? Microsoft Excel can help. Excel's RATE, or interest rate, function lets you precisely calculate the implicit interest rate for a loan given the payment amount, loan amount, and number of payments.

### Using Microsoft Excel\\\'s Accrued Interest Add-in Functions

Making interest rate calculations? Microsoft Excel can help. Excel provides two functions that help you with accrued interest calculations for securities.

### Using the Bond Duration Add-in Functions

Making bond duration calculations? Microsoft Excel can help. Excel provides two functions that help you with bond duration calculations.

### Using Excel's Xirr and Xnpv Add-in Functions

Making internal rate of return or net present value calculations with Microsoft Excel? Make sure you aren't unnecessarily limiting your options. In addition to the well-know IRR and NPV financial functions, Microsoft Excel also supplies two powerful add-in functions, XIRR and XNPV, that can expand your analytical possibilities.

### Using the Bond Coupon Dates Add-in Functions

Making bond coupon date calculations? Microsoft Excel can help. In total, Excel provides six functions that let you make coupon date calculations more easily

### Using the Cumulative Interest and Principal Add-in Functions

Trying to accurately calculate cumulative interest and principal payments made for loans? Microsoft Excel can help. Excel supplies two functions specifically for calculating cumulative interest and principal payments on a loan.