software

Hi,

How can I do an amortization schedule that gives me the interest as its
being paid off?

Is there a function that can help.

Thanks in Advance
Any help greatly appreciated

Regards
Janet

Hi Janet,

There is a family of financial functions that address this and similar
problems: RATE(), NPV(), FV(), PMT(), NPER() etc.
In Analysis Toolpak (Toolsgt;Add-ins, check Analysis Toolpak if not done
already) there is a family for irregular payments.
See HELP for details; post again in this thread if you still have problems.

--
Kind regards,

Niek Otten

quot;Grdquot; gt; wrote in message
...
gt; Hi,
gt;
gt; How can I do an amortization schedule that gives me the interest as its
gt; being paid off?
gt;
gt; Is there a function that can help.
gt;
gt; Thanks in Advance
gt; Any help greatly appreciated
gt;
gt; Regards
gt; Janet
Hi,

Use IPMT function. If you don't have the toolpack installed, you can use
the following formula:

The interest due in the Nth month is,

L*R*(1 R/1200)^(N-1) - P*((1 R/1200)^(N-1)-1)

where L is the initial loan amount, R is the annual percent interest rate,
and P is the monthly payment made. When you enter the formula in Excel,
reference the cells containing the appropriate information for L, R, N, and P
(or hardwire their values), and remember to start the formula with an quot;=quot;
sign.

Regards,
B. R. Ramachandran

quot;Grdquot; wrote:

gt; Hi,
gt;
gt; How can I do an amortization schedule that gives me the interest as its
gt; being paid off?
gt;
gt; Is there a function that can help.
gt;
gt; Thanks in Advance
gt; Any help greatly appreciated
gt;
gt; Regards
gt; Janet

quot;Grdquot; wrote:
gt; How can I do an amortization schedule that gives
gt; me the interest as its being paid off?
gt; 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 quot;mortgagequot; in the
search window, and press Enter. Scroll through the search
results and select Mortgage Amortization Schedule.Hi,

Thanks I located this and its very helpful

Janet

quot; wrote:

gt; quot;Grdquot; wrote:
gt; gt; How can I do an amortization schedule that gives
gt; gt; me the interest as its being paid off?
gt; gt; Is there a function that can help.
gt;
gt; You are asking two very different questions. Some people
gt; have tried to answer the second question. The first question
gt; cannot be answered completely because you fail to state the
gt; frequency of the amortization that you want in your table --
gt; for example, per payment or annually.
gt;
gt; In any case, you might want to look at Mortgage Amortization
gt; template. It might provide you with some good ideas, if it is
gt; not in fact exactly what you are looking for.
gt;
gt; One way to find the Mortgate Amortization template ....
gt;
gt; First, be sure that your Help search mode is set for online by
gt; doing the following. Click Help and Microsoft Help, then click
gt; Online Content Settings under See Also. If Show Content
gt; from Microsoft Office Online is not check-marked, click to add
gt; a check-mark, click Okay and exit and restart Excel.
gt;
gt; Then, click Help and Microsoft Help, then click the Excel Help
gt; toolbar and click Search Results. Under Search, select
gt; Template from the pull-down list, type quot;mortgagequot; in the
gt; search window, and press Enter. Scroll through the search
gt; results and select Mortgage Amortization Schedule.
gt;

Thanks

The IPMT function looks like the candidate. I will experiment with it.

Janet

quot;B. R.Ramachandranquot; wrote:

gt; Hi,
gt;
gt; Use IPMT function. If you don't have the toolpack installed, you can use
gt; the following formula:
gt;
gt; The interest due in the Nth month is,
gt;
gt; L*R*(1 R/1200)^(N-1) - P*((1 R/1200)^(N-1)-1)
gt;
gt; where L is the initial loan amount, R is the annual percent interest rate,
gt; and P is the monthly payment made. When you enter the formula in Excel,
gt; reference the cells containing the appropriate information for L, R, N, and P
gt; (or hardwire their values), and remember to start the formula with an quot;=quot;
gt; sign.
gt;
gt; Regards,
gt; B. R. Ramachandran
gt;
gt; quot;Grdquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; How can I do an amortization schedule that gives me the interest as its
gt; gt; being paid off?
gt; gt;
gt; gt; Is there a function that can help.
gt; gt;
gt; gt; Thanks in Advance
gt; gt; Any help greatly appreciated
gt; gt;
gt; gt; Regards
gt; gt; Janet

Thanks for pointing me in the right direction

J

quot;Niek Ottenquot; wrote:

gt; Hi Janet,
gt;
gt; There is a family of financial functions that address this and similar
gt; problems: RATE(), NPV(), FV(), PMT(), NPER() etc.
gt; In Analysis Toolpak (Toolsgt;Add-ins, check Analysis Toolpak if not done
gt; already) there is a family for irregular payments.
gt; See HELP for details; post again in this thread if you still have problems.
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Grdquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; How can I do an amortization schedule that gives me the interest as its
gt; gt; being paid off?
gt; gt;
gt; gt; Is there a function that can help.
gt; gt;
gt; gt; Thanks in Advance
gt; gt; Any help greatly appreciated
gt; gt;
gt; gt; Regards
gt; gt; Janet
gt;
gt;
gt;

Actually none of the functions will produce an amortization schedule.
They can be used to produce one, but the easy way is to download one
from he

office.microsoft.com/en-us/te...CT011377171033

Pieter VandenbergGrd gt; wrote:
: Thanks for pointing me in the right direction

: J

: quot;Niek Ottenquot; wrote:

:gt; Hi Janet,
:gt;
:gt; There is a family of financial functions that address this and similar
:gt; problems: RATE(), NPV(), FV(), PMT(), NPER() etc.
:gt; In Analysis Toolpak (Toolsgt;Add-ins, check Analysis Toolpak if not done
:gt; already) there is a family for irregular payments.
:gt; See HELP for details; post again in this thread if you still have problems.
:gt;
:gt; --
:gt; Kind regards,
:gt;
:gt; Niek Otten
:gt;
:gt; quot;Grdquot; gt; wrote in message
:gt; ...
:gt; gt; Hi,
:gt; gt;
:gt; gt; How can I do an amortization schedule that gives me the interest as its
:gt; gt; being paid off?
:gt; gt;
:gt; gt; Is there a function that can help.
:gt; gt;
:gt; gt; Thanks in Advance
:gt; gt; Any help greatly appreciated
:gt; gt;
:gt; gt; Regards
:gt; gt; Janet
:gt;
:gt;
:gt;