Outstanding Balance based on today in Excel amortization chart?

You did not state which version of MS-Excel you are using, so I will assume it to be 2003 or earlier (though the same basic information is valid for 2007).

First of all, you may wish to get familiar with specific Functions that are used in such calculations:

• PMT

• PV

• RATE

• NPER

And this can be done by using the "fx" right beside the Formula Bar, and selecting any of the above Functions. Further details can then be seen by clicking the "Help on this function" link in the lower left-hand corner of the dialog window. (There will be examples as well.)

Another Function that is quite useful is the TODAY function (which has no parameter values to enter, just the open and close parenthesis). It will give you the current date of your computer.

One thing to understand, MS-Excel treats dates and times just like ordinary numbers. The way that a time or date is displayed on a worksheet depends on the Number Format applied to the cell. When you type a date or time that Excel recognizes, the cell’s format changes from the General number format to a built-in date or time format. By default, dates and times are right-aligned in a cell. If Excel cannot recognize the date or time format, the date or time is entered as text, which is left-aligned in the cell.

Dates/Times can be added, subtracted, and included in other calculations. So adding the value of “7” to a date would increase the date by one week (seven days). And adding “0.25” to a date/time would increase the current date/time by six hours, since 0.25 is one-fourth of a 24-hour day. To use two dates/times in a formula, enter the date/time as text enclosed in double-quotation marks, or as a reference to a cell containing a date/time value. For example, the following formulas would all display a difference of 68:

= “05/12/2006” - “03/05/2006”

= “05/12/2006” - B3 . . . . . . . ( where B3 = 03/05/2006 )

.

style here headings first A1=establishing stability B1=Installment fee C1=activity D1=Capital reimbursement E1=last stability placed the hollow stability in A2 and the installment fee in B2 In C2, compute the activity Eg =(A1*12%)/12 =========> If month-to-month D2 = B2-C2 E2=A2-D2 then A3 =E2 this is it. Now you will desire to reproduction down those formulation