Stephen L Nelson

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More

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

Read More

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.

Read More

Using the Excel's Advanced Future Value Add-in Functions

Microsoft Excel provides two special future value functions that most people never use. These two functions, FVSCHEDULE and RECEIVED, provide quick insights when performing investment analysis.

Read More

Using the French Depreciation Add-in Functions

Making French depreciation calculations? Microsoft Excel can help. Excel supplies two add-in functions specifically for making these calculations.

Read More