does anyone have one?
does anyone have one?
Go to MS Office site and download an excel template
--
Regards,
Peo Sjoblom
"payment amount loan calculator" <payment amount loan
[email protected]> wrote in message
news:[email protected]...
> does anyone have one?
I can't find a template that you can plug the payment amount as a fixed
amount and then ihave it calculate the number of payments or the interest
rate...Have you seen one of those?
Ann
"Peo Sjoblom" wrote:
> Go to MS Office site and download an excel template
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "payment amount loan calculator" <payment amount loan
> [email protected]> wrote in message
> news:[email protected]...
> > does anyone have one?
>
>
This file might be a help:
http://www.bygsoftware.com/examples/...Calculator.zip
It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
This workbook includes two worksheets that can help you calculate the likely
repayments you will have to make on mortgages and personal loans (including
HP and conditional sale agreements).
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"payment amount loan calculator" <payment amount loan
[email protected]> wrote in message
news:[email protected]...
> I can't find a template that you can plug the payment amount as a fixed
> amount and then ihave it calculate the number of payments or the interest
> rate...Have you seen one of those?
> Ann
>
> "Peo Sjoblom" wrote:
>
> > Go to MS Office site and download an excel template
> >
> > --
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> > "payment amount loan calculator" <payment amount loan
> > [email protected]> wrote in message
> > news:[email protected]...
> > > does anyone have one?
> >
> >
Thank you Andy, but that one and all other loan calculators that I can find
require Principal, Rate and Time to calculate the payment amount. I want one
that requires the Principal, Rate and Payment amount to calculate the number
of payments...any ideas?
"Andy Wiggins" wrote:
> This file might be a help:
> http://www.bygsoftware.com/examples/...Calculator.zip
> It's in the "Accountants" section on page:
> http://www.bygsoftware.com/examples/examples.htm
>
> This workbook includes two worksheets that can help you calculate the likely
> repayments you will have to make on mortgages and personal loans (including
> HP and conditional sale agreements).
>
>
> --
> Andy Wiggins FCCA
> www.BygSoftware.com
> Excel, Access and VBA Consultancy
> -
>
> "payment amount loan calculator" <payment amount loan
> [email protected]> wrote in message
> news:[email protected]...
> > I can't find a template that you can plug the payment amount as a fixed
> > amount and then ihave it calculate the number of payments or the interest
> > rate...Have you seen one of those?
> > Ann
> >
> > "Peo Sjoblom" wrote:
> >
> > > Go to MS Office site and download an excel template
> > >
> > > --
> > > Regards,
> > >
> > > Peo Sjoblom
> > >
> > >
> > > "payment amount loan calculator" <payment amount loan
> > > [email protected]> wrote in message
> > > news:[email protected]...
> > > > does anyone have one?
> > >
> > >
>
>
>
Periods = (Payment * 12)/(Principal * Rate%)
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-
"payment amount loan calculator"
<[email protected]> wrote in message
news:[email protected]...
> Thank you Andy, but that one and all other loan calculators that I can
find
> require Principal, Rate and Time to calculate the payment amount. I want
one
> that requires the Principal, Rate and Payment amount to calculate the
number
> of payments...any ideas?
>
> "Andy Wiggins" wrote:
>
> > This file might be a help:
> > http://www.bygsoftware.com/examples/...Calculator.zip
> > It's in the "Accountants" section on page:
> > http://www.bygsoftware.com/examples/examples.htm
> >
> > This workbook includes two worksheets that can help you calculate the
likely
> > repayments you will have to make on mortgages and personal loans
(including
> > HP and conditional sale agreements).
> >
> >
> > --
> > Andy Wiggins FCCA
> > www.BygSoftware.com
> > Excel, Access and VBA Consultancy
> > -
> >
> > "payment amount loan calculator" <payment amount loan
> > [email protected]> wrote in message
> > news:[email protected]...
> > > I can't find a template that you can plug the payment amount as a
fixed
> > > amount and then ihave it calculate the number of payments or the
interest
> > > rate...Have you seen one of those?
> > > Ann
> > >
> > > "Peo Sjoblom" wrote:
> > >
> > > > Go to MS Office site and download an excel template
> > > >
> > > > --
> > > > Regards,
> > > >
> > > > Peo Sjoblom
> > > >
> > > >
> > > > "payment amount loan calculator" <payment amount loan
> > > > [email protected]> wrote in message
> > > > news:[email protected]...
> > > > > does anyone have one?
> > > >
> > > >
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks