i already looked around but couldnt find anything....

I am trying to create a loan amortization schedule that will show the
monthly payments for the term of the loan. how do i create it so that excel
automatically adds a cell for each month. Basically i am trying to set it up
so all i do is type in the loan amount, interest rate, term, and start date.
i know i can do it by dragging the auto fill button down and it will
automatically fill in the months but i dont want to have to do that everytime
i change the term. any help would be appreciated.

hi
loan amortization template
http://office.microsoft.com/en-us/te...197771033.aspx

haven't used it myselft but worth a look.

Regards
FSt1

"nldilch" wrote:

i already looked around but couldnt find anything....

I am trying to create a loan amortization schedule that will show the
monthly payments for the term of the loan. how do i create it so that excel
automatically adds a cell for each month. Basically i am trying to set it up
so all i do is type in the loan amount, interest rate, term, and start date.
i know i can do it by dragging the auto fill button down and it will
automatically fill in the months but i dont want to have to do that everytime
i change the term. any help would be appreciated.

Here, this should get you going:
http://www.vertex42.com/ExcelTemplat...readsheet.html

Regards,
Ryan---

--
RyGuy


"nldilch" wrote:

i already looked around but couldnt find anything....

I am trying to create a loan amortization schedule that will show the
monthly payments for the term of the loan. how do i create it so that excel
automatically adds a cell for each month. Basically i am trying to set it up
so all i do is type in the loan amount, interest rate, term, and start date.
i know i can do it by dragging the auto fill button down and it will
automatically fill in the months but i dont want to have to do that everytime
i change the term. any help would be appreciated.

thanks man. that shows, and does, exactly what i wanted to do.

"ryguy7272" wrote:

Here, this should get you going:
http://www.vertex42.com/ExcelTemplat...readsheet.html

Regards,
Ryan---

--
RyGuy


"nldilch" wrote:

i already looked around but couldnt find anything....

I am trying to create a loan amortization schedule that will show the
monthly payments for the term of the loan. how do i create it so that excel
automatically adds a cell for each month. Basically i am trying to set it up
so all i do is type in the loan amount, interest rate, term, and start date.
i know i can do it by dragging the auto fill button down and it will
automatically fill in the months but i dont want to have to do that everytime
i change the term. any help would be appreciated.

You want to know your credit balance. This is the amount of income you will need the full amount. You can estimate your rights, when you have a renewable energy loans and even car debt. You only need your assets in the current market value estimate. When you subtract from the market value of the equity you have your loan balance.