software

Hello,

I have found the Loan Amoritization Excel SS template from Microsoft but it
does not work the way I want it.

I bought a new car and the loan came on my account on 02/02/06 and the next
payment date is 03/15/06. When I use the template...I put in 02/02/06 and
the first payment date is 03/02/06. I want to put in 02/02/06 as when the
loan came on the account then use the first payment date as 03/15/06 and
calculate the interest based on the period of 02/02/06 to 03/15/06 then have
the next payment date as 04/15/06.

If you have this type of spreadsheet available for me...please let me know.
I would love to get a copy of it. I would like to have this for my records.

Chris

A simple workaround would be to enter the loan as of 02/15/06, but add 13 days
interest to the loan amount. Then it should amortize properly.

--
Regards,
Fredquot;anonymousquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I have found the Loan Amoritization Excel SS template from Microsoft but it
gt; does not work the way I want it.
gt;
gt; I bought a new car and the loan came on my account on 02/02/06 and the next
gt; payment date is 03/15/06. When I use the template...I put in 02/02/06 and
gt; the first payment date is 03/02/06. I want to put in 02/02/06 as when the
gt; loan came on the account then use the first payment date as 03/15/06 and
gt; calculate the interest based on the period of 02/02/06 to 03/15/06 then have
gt; the next payment date as 04/15/06.
gt;
gt; If you have this type of spreadsheet available for me...please let me know.
gt; I would love to get a copy of it. I would like to have this for my records.
gt;
gt; Chris
However, I am not able to modify the original template provided by Microsoft
so I was looking for a template which has been modified for the situation I
am encountering.

Chris.

quot;Fred Smithquot; wrote:

gt; A simple workaround would be to enter the loan as of 02/15/06, but add 13 days
gt; interest to the loan amount. Then it should amortize properly.
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;anonymousquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I have found the Loan Amoritization Excel SS template from Microsoft but it
gt; gt; does not work the way I want it.
gt; gt;
gt; gt; I bought a new car and the loan came on my account on 02/02/06 and the next
gt; gt; payment date is 03/15/06. When I use the template...I put in 02/02/06 and
gt; gt; the first payment date is 03/02/06. I want to put in 02/02/06 as when the
gt; gt; loan came on the account then use the first payment date as 03/15/06 and
gt; gt; calculate the interest based on the period of 02/02/06 to 03/15/06 then have
gt; gt; the next payment date as 04/15/06.
gt; gt;
gt; gt; If you have this type of spreadsheet available for me...please let me know.
gt; gt; I would love to get a copy of it. I would like to have this for my records.
gt; gt;
gt; gt; Chris
gt;
gt;
gt;

You don't have to modify the spreadsheet. Assume you borrowed the money on Feb
15th. Manually add 13 days interest to the loan amount (loan * rate / 365 * 13),
and it will amortize properly.

--
Regards,
Fredquot;anonymousquot; gt; wrote in message
...
gt; However, I am not able to modify the original template provided by Microsoft
gt; so I was looking for a template which has been modified for the situation I
gt; am encountering.
gt;
gt; Chris.
gt;
gt; quot;Fred Smithquot; wrote:
gt;
gt;gt; A simple workaround would be to enter the loan as of 02/15/06, but add 13
gt;gt; days
gt;gt; interest to the loan amount. Then it should amortize properly.
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt; Fred
gt;gt;
gt;gt;
gt;gt; quot;anonymousquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello,
gt;gt; gt;
gt;gt; gt; I have found the Loan Amoritization Excel SS template from Microsoft but it
gt;gt; gt; does not work the way I want it.
gt;gt; gt;
gt;gt; gt; I bought a new car and the loan came on my account on 02/02/06 and the next
gt;gt; gt; payment date is 03/15/06. When I use the template...I put in 02/02/06 and
gt;gt; gt; the first payment date is 03/02/06. I want to put in 02/02/06 as when the
gt;gt; gt; loan came on the account then use the first payment date as 03/15/06 and
gt;gt; gt; calculate the interest based on the period of 02/02/06 to 03/15/06 then
gt;gt; gt; have
gt;gt; gt; the next payment date as 04/15/06.
gt;gt; gt;
gt;gt; gt; If you have this type of spreadsheet available for me...please let me know.
gt;gt; gt; I would love to get a copy of it. I would like to have this for my
gt;gt; gt; records.
gt;gt; gt;
gt;gt; gt; Chris
gt;gt;
gt;gt;
gt;gt;