"Grd" wrote:
How can I do an amortization schedule that gives
me the interest as its being paid off?
Is there a function that can help.

You are asking two very different questions. Some people
have tried to answer the second question. The first question
cannot be answered completely because you fail to state the
frequency of the amortization that you want in your table --
for example, per payment or annually.

In any case, you might want to look at Mortgage Amortization
template. It might provide you with some good ideas, if it is
not in fact exactly what you are looking for.

One way to find the Mortgate Amortization template ....

First, be sure that your Help search mode is set for online by
doing the following. Click Help and Microsoft Help, then click
Online Content Settings under See Also. If Show Content
from Microsoft Office Online is not check-marked, click to add
a check-mark, click Okay and exit and restart Excel.

Then, click Help and Microsoft Help, then click the Excel Help
toolbar and click Search Results. Under Search, select
Template from the pull-down list, type "mortgage" in the
search window, and press Enter. Scroll through the search
results and select Mortgage Amortization Schedule.