Free Online Articles Directory
Home Page  Stephen L. Nelson, CPA |
|||||
 |
 
Stephen L. Nelson, CPA - ArticlesCPA Stephen L. Nelson
wrote the bestsellers Quicken for Dummies and QuickBooks for Dummies, which have together sold more than one million copies, and the popular downloadable do-it-yourself guides forming an S corp online , the forming an LLC and the incorporating a small business, web sites. Using the Interest Rate Add-in FunctionsMicrosoft Excel provides four add-in functions that allow people to make sophisticated interest rate calculations. The functions can be tricky to use, however, explains the author of the MBA's Guide to Microsoft Excel. Using the Excel's Advanced Future Value Add-in FunctionsMicrosoft Excel provides two special future value functions that most people never use. That's too bad. These two functions, FVSCHEDULE and RECEIVED, provide powerful and quick insights when performing investment analysis. Using the French Depreciation Add-in FunctionsMaking French depreciation calculations? Microsoft Excel can help. Excel supplies two add-in functions specifically for making these calculations. Using the Dollar Pricing Add-in FunctionsTrying to accurately convert security prices from fractional prices to dollar prices, or vice versa? Microsoft Excel can help. Excel supplies two add-in functions specifically for making these calculations. Using the Cumulative Interest and Principal Add-in FunctionsTrying 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. Using the Bond Coupon Dates Add-in FunctionsMaking bond coupon date calculations? Microsoft Excel can help. In total, Excel provides six functions that let you make coupon date calculations more easily Using Excel's Xirr and Xnpv Add-in FunctionsMaking 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 Duration Add-in FunctionsMaking bond duration calculations? Microsoft Excel can help. Excel provides two functions that help you with bond duration calculations. Using Microsoft Excel's Accrued Interest Add-in FunctionsMaking interest rate calculations? Microsoft Excel can help. Excel provides two functions that help you with accrued interest calculations for securities. Calculating Interest Rates With Microsoft ExcelMaking 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.
|
 |
|||
|
Article Categories
|
|
||||
|
|
|||||
