I need a spread sheet where I can enter the:
Loan amount
Rate
Term in months
Note date
First payment date
and excel calculate:
monthly payment
APR
Is there any templets out there, I can't find one? The simplier the better.
Thanks
I need a spread sheet where I can enter the:
Loan amount
Rate
Term in months
Note date
First payment date
and excel calculate:
monthly payment
APR
Is there any templets out there, I can't find one? The simplier the better.
Thanks
Last edited by BOC; 09-18-2008 at 10:09 AM.
This link can probably help you out best. There is an additional link in there to download the templates.
http://office.microsoft.com/en-us/ex...346401033.aspx
I looked at that and it won't work for what I'm wanting.
First It ask for the annual percent rate when I have the rate of the loan, I want it to figure the annual percent rate.
Also the annual percent rate is effected by the first payment date from the original date. The first payment date may or may not be in 30 days.
Thanks
bump to the top
Help please
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks