Solar Panels For Homes

If youÂ’ve got Microsoft Excel (or just about any other popular spreadsheet program) running on your computer, you can use its FV function to forecast the future value of your 401(k) or 403(b) account.

The FV function calculates the future value of an investment given its interest rate, the number of payments, the payment, the present value of the investment, and, optionally, the type-of-annuity switch. (More about the type-of-annuity switch a little later.)

The function uses the following syntax:

=FV(rate,nper,pmt,pv,type)

This little pretty complicated, I grant you. But suppose you want to calculate the future value of a 401(k) or 403(b) account that’s already got $10,000 in it and to which you and your employer are contributing $200-a-month. Further suppose that you want to know the account balance—its future value—in 25 years and that you expect to earn 10% annual interest.

To calculate the future value of this account, you enter the following into a worksheet cell:

=FV(10%/12,25*12,-200,-10000,0)

The function returns the value 385936.13—roughly $386,000 dollars.

A handful of things to note: To convert the 10% annual interest to a monthly interest rate, the formula divides the annual interest rate by 12. Similarly, to convert the 25-year term to a term in months, the formula multiplies 25 by 12.

Also, notice that the monthly payment and initial present values show as negative amounts because they represent cash outflows. And the function returns the future value amount as a positive value because it reflects a cash inflow you ultimately receive.

That 0 at the end of the function is 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 (month in this case), following the annuity due convention. If you set the annuity switch to 0 or you omit the argument, Excel assumes payments occur at the end of the period following the ordinary annuity convention.

Curious about how much money you’ll accumulate in your 401(k) or 403(b) retirement plan? Just use Microsoft Excel to calculate a pretty good estimate says author and CPA Stephen L. Nelson.

LLC formation author Stephen L. Nelson has written more than 150 books. Formerly an adjunct tax professor at Golden Gate University—the nation’s largest graduate tax school—Nelson is also the author of QuickBooks for Dummies. He also edits the do-it-yourself s corp incorporation web site.

Excel Finance Trick #17: Amortization Table w x Column

Angry Birds: Knock On Wood Game $10.50 Angry Birds: Knock On Wood Game Angry Birds: Knock On Wood Game is action packed fun based on the best-selling phone game. Topple the structure with your Angry Birds attack. The classic fight between the egg stealing pigs and the angry birds goes on in a new version kids will love. Why You'll Love It: Bring those furious fowl to life. Age: 5 years and up Features Build, launch and...

Android 2.3 Tablet PC Cortex TM-A8 S5PV210 1.2GHz CPU 8 Inch / 4GB HDD/ 512MB DDR2/ Camera/ HDMI/ Black/ White $166.99 Operating System: Android 2.3 * Model: Samsung S5PV210 * Display Technology: 8 inch 800*600 resistive touch screen * CPU Type: ARM CoretexTM-A8 CPU Speed: 1.2GHz * RAM / Hard Drive: DDR2 512MB / 4GB NAND Flash * PCMCIA Expansion: T-FLASH(Support 32G MAX) Camera: 1.3MP * HDMI: 1080P OUTPUT * 3G: YES,external usb 3g moderm * G-Sensor: Four way * Audio: Built in stereo speakers/Built in Microphone *...