"Steve" wrote:
> Looking for a calculator for estimating insurance
> premium financing payments. Here are my "variables"
> Premium payment amount = $75,000
> Downpayment amount= 25%
> Financing Rate= 3.27%
> Number of annual payments = 9
> First Payment Due Date= 1/1/10
> Last Payment Due Date= 9/1/10
Correct...
Thread: Special Financing Calculator Help Please in microsoft.public.excel.misc  |
|||||||||||||
|
Started 1 month, 2 weeks ago by Steve
Looking for a calculator for estimating insurance premium financing payments.
Here are my "variables"
Premium payment amount = $75,000
Downpayment amount= 25%
Financing Rate= 3.27%
Number of annual payments = 9
First Payment Due Date= 1/1/10
Last Payment Due Date= 9/1/10
Thanks!!...
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
Joe User replied 1 month, 2 weeks ago
Size: 1,785 bytes
Customize: 
Joe User replied 1 month, 2 weeks ago
PS.....
I wrote:
> "Steve" wrote:
> > Financing Rate= 3.27%
> [....]
> =PMT(B3/12, B4, -B1*(1-B2))
> [....]
> =PMT(B3, B4, -B1*(1-B2))
I ass-u-me-d that the "financing rate" is the annual interest rate.
However, US law only requires a lender to disclose the APR, not(!) the simple
annual or ...
Size: 3,559 bytes
Customize:
Joe User replied 1 month, 2 weeks ago
PS....
I wrote:
> "Steve" wrote:
> > Financing Rate= 3.27%
> [....]
> =PMT(B3/12, B4, -B1*(1-B2))
The PMT formulas assume that the "financing rate" is the annual interest
rate, the rate used to detemine the amount of periodic interest.
But US law only requires lenders to disclose the APR, a rate that ...
Size: 3,779 bytes
Customize:
Steve replied 1 month, 2 weeks ago
Joe- thanks
"Joe User" wrote:
> "Steve" wrote:
> > Looking for a calculator for estimating insurance
> > premium financing payments. Here are my "variables"
> > Premium payment amount = $75,000
> > Downpayment amount= 25%
> > Financing Rate= 3.27%
> > Number of annual payments = 9
> > First Payment Due ...
Size: 2,023 bytes
Customize:
|
Top contributing authorsRelated threads on "Discussions in microsoft.public.excel.misc":Related threads on other sites: |
||||||||||||
Thread profile page for "Special Financing Calculator Help Please in microsoft.public.excel.misc" on http://www.microsoft.com/communities/newsgroups....
This report page is a snippet summary view from a single thread "Special Financing Calculator Help Please in microsoft.public.excel.misc", located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.