Title Insurance Premium Calculation

asharma1180

New Member
Joined
Jul 27, 2022
Messages
5
Office Version
  1. 365
Platform
  1. Windows
Hello

Can anyone help me with an excel formula to calculate title insurance premiums on Excel spreadsheets for Florida.

The rates are as follow:
up to 100,000 - 5.75
Over 100,000 up to 1,000,000 - 5.00
Over 1,000,000 up to 5,000,000 - 2.50

Thank you,
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
no this does not - I am looking to calculate the premium with a loan amount and then a owners premium - as it is calculated on a CD
 
Upvote 0
so lets say I have a loan amount 334112.00 and I have to calculate the loan premium and the primary calculation and owners premium. On a CD if there is a loan then the full amount of the premium is applied based on the loan amount and balance used as the owners premium
 
Upvote 0
so lets say I have a loan amount 334112.00 and I have to calculate the loan premium and the primary calculation and owners premium. On a CD if there is a loan then the full amount of the premium is applied based on the loan amount and balance used as the owners premium
So show us the amount you expect to see for a loan of 334112.00 (it is not clear to me whether those numbers of 5.75, 5.00, and 2.50 are flat dollar amounts or percentages).
And what happens to amounts over 5,000,000?

Don't assume that we know are familiar with Title Insurance Premium Calculations, so show us how they work, through an example.
 
Upvote 0
This is my best guess regarding what you are after.

If it is a matter of:
- charging 5.75% on the first 100,000
- charging 5.00% on the next 900,000 (from 100,000 to 1,000,000)
- charging 0.25% on the next 4,000,000 (from 1,000,000 to 5,000,000)
- charging 0% on anything over 5,000,000

Then you could use a formula like this for an amount in cell A1:
Rich (BB code):
=(MIN(MAX(A1,0),100000)*0.0575)+(MIN(MAX(A1-100000,0),900000)*0.05)+(MIN(MAX(A1-1000000,0),4000000)*0.025)
 
Upvote 0
I apologize -

So for a loan amount of $335,854.00 the premium on the CD comes to $1,754.50 ------ with a sale price of $342,050.00 the owners premium calculates to $306.00

The Title Insurance rates in Florida are as follow:
up to 100,000 (of loan amount or sales price) - $5.75/$1000
Over 100,000 up to 1,000,000(of loan amount or sales price) - $5.00/$1000
Over 1,000,000 up to 5,000,000(of loan amount or sales price) - $2.50/$1000

As an example - an $100,000 loan amount or sales price would have a premium of $575.00
 
Upvote 0
So for a loan amount of $335,854.00 the premium on the CD comes to $1,754.50 ------ with a sale price of $342,050.00 the owners premium calculates to $306.00
Can you break it down, and walk through this example step-by-step to show us exactly how you arrived at those specific values for this example?
 
Upvote 0
Can you break it down, and walk through this example step-by-step to show us exactly how you arrived at those specific values for this example?
Our system closing software calculates it automatically but here is how it is calculated mannualy:

335,854.00 is rounded up to 335,900
take the first 100,000 of above amount = 575.00
then balance 235,900 *5.00/1000 = 1179.50
so the total of 2 numbers above is = 1754.50

but then on the Closing Disclosure the Owners Policy premium comes to 306.00

Plus endorsement of 90.00 and 175.45 = 265.45
 
Upvote 0
OK, so there was the key detail you were leaving out.

In your original post, you said:
The rates are as follow:
up to 100,000 - 5.75
Over 100,000 up to 1,000,000 - 5.00
Over 1,000,000 up to 5,000,000 - 2.50

And then in your second post, you said:
The Title Insurance rates in Florida are as follow:
up to 100,000 (of loan amount or sales price) - $5.75/$1000
Over 100,000 up to 1,000,000(of loan amount or sales price) - $5.00/$1000
Over 1,000,000 up to 5,000,000(of loan amount or sales price) - $2.50/$1000

So the amounts of 5.75, 5.00. and 2.50 are not percentages, they are per $1000 (which you did not mention originally).
So they actually are a kind of percentage, just ten times lower, i.e. 0.575%, 0.5%, and 0.25%.

Then you would just need to take the formula I gave you and add an extra 0 before all those factors, i.e.
Excel Formula:
=(MIN(MAX(A1,0),100000)*0.00575)+(MIN(MAX(A1-100000,0),900000)*0.005)+(MIN(MAX(A1-1000000,0),4000000)*0.0025)
 
Upvote 0

Forum statistics

Threads
1,224,521
Messages
6,179,289
Members
452,902
Latest member
Knuddeluff

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top