Stephen L. Nelson is a CPA specializing in S corporations and the author of many bestselling books including the MBA's Guide to Microsoft Excel from which this article is adapted. Nelson also edits the popular Forming an s corporation, the Incorporating a business and the forming an LLC web sites.
Using The Bond Coupon Dates Add-in Functions Investing in bonds? Analyzing related fixed-income investments? You'll want to know this bit of trivia: Excel provides six functions that let you make bond coupon date calculations more easily:COUPDAYBS,COUPDAYS,COUPDAYSNC,COUPNCD,COUPNUM, andCOUPPCD.Some Background Info on the Bond Coupon Date FunctionsAll six coupon date functions use four standard arguments: the settlement date, the...... Similar Editorial : Coupon Mountain Facilities Shopping by Muna wa Wanjiru. | Source : Banking Services
Microsoft Money How Do I Handle Debit Card Transactions? Debit card transactions work exactly like checks. The only difference really is that you don't have a check form, but rather a bundle of electronic, digital information that runs from the store's debit card machine to your bank's computer. This mechanical difference is transparent to Money, so when you want to record a debit card transaction, follow the same steps as those for writing a...... Similar Editorial : New Debit Card Features by Kyle Newton. | Source : Card College Credit Debt In Student
How Do I Use Money For Payroll And Tax Returns? How do I do payroll?Payroll accounting represents the most complicated record keeping and bookkeeping task that small businesses do. The only other activity that even comes close is preparing a corporate tax return.Payroll accounting and recording requirements are extremely onerous. When you do your own payroll, you have to meet certain federal requirements for categorizing, tracking, and...... Similar Editorial : Payroll New York by Charles Read. | Source : Property Tax History
Changing Moneys Investment Record Keeping Procedures Microsoft Money's Options dialog box (choose the Tools menu's Options command) includes an Investments tab. The boxes and buttons on the Investments tab let you make changesto the way in which Money's investment record keeping works.Setting the Investment OptionsThe Investment Options box on the Investments tab has two check boxes. The first lets you specify whether Money requires a transfer...... Similar Editorial : Getting Your Moneys Worth by Richard A. Hall. | Source : Growth Investing
Using The Cumulative Interest And Principal Add-in Functions Excel supplies two functions specifically for calculating cumulative interest and principalpayments on a loan: CUMIPMT, which calculates the cumulative interest payments on a bond or note, and CUMPRINC, which calculates the cumulate principal payments on a bond or note.Some Background Info on the Cumulative Interest and Principal Add-in FunctionsBoth functions use the same set of arguments,...... Similar Editorial : Pretend Interest by Sue and Chuck DeFiore. | Source : Lost Premium Bonds
Using The Interest Rate Add-in Functions Excel provides four add-in functions that let you make sophisticated interest rate calculations: DISC, EFFECT, INTRATE, and NOMINAL.Some Background Info on the Interest Rate Add-in FunctionsThe DISC and INTRATE functions, which are related, work from the same basic set ofarguments: the settlement date, the maturity date, the redemption value, the price, the frequency, and the basis.The settlement...... Similar Editorial : Military Interest Rate Cap by John B Mayall. | Source : Lost Premium Bonds
Using The Dollar Pricing Add-in Functions Excel's DOLLARDE and DOLLARFR functions let you easily convert security dollar prices from decimal prices to fractional prices or from fractional prices to decimal prices. But note: In order to use either of these useful functions, you need to have first installed Excel's add-in functions. (To install the Add-in functions, choose the Tools menu's Add-Ins command, check the Analysis Tookpak box,...... Similar Editorial : Pricing Your Products by Marc Singer . | Source : Budgeting And Planning
How Do I Record An Account Transfer? To record an account transfer, you record the transfer in one of the accounts involvedin the transfer. For example, if you are moving money from your checking account toyour savings account, you record the transfer in either the checking or savings account.Predictably, all a transfer transaction really does is name the transfer amount andidentify the two accounts.Recording transfers between...... Similar Editorial : Record Pools by jaci_rae. | Source : Accounting Tips
How Does Account Reconciliation Work? Balancing, or reconciling, your bank accounts represents an important financial management task. By regularly reconciling your records with those of the bank, you improve the accuracy of your bookkeeping, you assure that bank errors haven't been made, and you also reduce the chance that you aren't the victim of fraudulent transactions, such as those perpetrated by a forger.The problem when...... Similar Editorial : The Wow Alliance Account by Clint Jhonson. | Source : Accounting Tips
What Should I Look For In A Small Business Accounting Program? A small business accounting program should accomplish three tasks: track income and expenses, generate business forms, and keep detailed records for other assets and liabilities.Tracking Income and ExpensesThe task of tracking a business's income and expense is really the most important job of an accounting system. If you own or manage a small business, obviously, you need some tool for...... Similar Editorial : Small Business Accounting Software by Eric Morris. | Source : Advanced Accounting
How Do I Set Up A Mutual Fund Account? Before you can begin keeping records for a mutual fund investment using Money, you need to first set up a mutual fund investment account. To do this, take the following steps:1. Display the list of accounts.Click the Investing link at the top of the screen, and then select Investing Center. Money displays the Manage Your Investments And Savings window.2. Tell Money you want to set up a new account...... Similar Editorial : The Perfect Mutual Fund by Charles M. O'Melia. | Source : Advanced Accounting
Do I Need To Upgrade The Money Software Each Year? So here's a question that individuals and small businesses have to ask themselves every year: Do I need to upgrade the Microsoft Money software again?Should you upgrade Microsoft Money every year?This is a good question. Every fall, the corporations that make and sell personal finance and small business software-Microsoft and Intuit-release a new version of their software programsMoney and...... Similar Editorial : How to upgrade CPU by Michael Cottier. | Source : Active Data Recovery Software
How Do I Record A Bond Sale? You record the sale of a bond in almost the same way that you record the sale of a stock.One tricky feature of a bond sale, however, concerns accrued interest. Even in the case of a bond that periodically pays interest, you need to accrue any interest earned since the last interest payment date. (Although in the case of a zero coupon bond, you have to accrue interest earned only since the last...... Similar Editorial : What Is Bond Market by sayush. | Source : Increase Retail Sales
How Do I Record The Sale Of Mutual Fund Shares? You can record the sale of mutual fund shares using a set of steps that closely resemblethose used to purchase shares. Specifically, take the following steps:1. Display the investment account register.Click the Accounts & Bills link, and then select Account List so that Money dis-plays the Pick An Account To Use window. Then click the investment account.Money displays the account register for the...... Similar Editorial : The Perfect Mutual Fund by Charles M. O'Melia. | Source : Increase Retail Sales
Calculating The Time To Repay Loans The NPER function calculates the term, or number of regular payments, on a loan or for an investment annuity given its interest rate, the payments, present value (or loan balance),future value (or balloon payment), and, optionally, the type-of-annuity switch. If you set the type-of-annuity switch to 1, Excel assumes payments occur at the beginning of the period, following the annuity due...... Similar Editorial : Calculating your Post by . | Source : Graduate Student Loans
