Coinsurance.xlsx

	A	B	C	D	E	F	G	I	J
1
2
3	Damages
4		RCV	$ 5,000,000.00
5		DEP	$ 450,000.00
6		ACV	$ 5,000,000.00
7
8		ONLY CHANGE THE YELLOW BOXES<			IF YOU WISH TO DO ADDITIONAL EDITS PLEASE
9					DOWNLOAD THE SPREADSHEET

10
11		CO-INSURANCE CALCULATOR			BUILDING
12		Please fill out the relevant areas in			sf of structure	new cost per sf	RCV
13		the yellow boxes ONLY.			6,262	$ 149.00	$ 933,038.00		A= AMOUNT PAYABLE -
14									C= AMOUNT OF COVERAGE PURCHASED
15		COVERAGE							R=PROPERTY VALUE *COINSURANCE PERCENTAGE
16		Stated Limits	$ 890,000.00		-	$ 149.00	$ 933,038.00		L=LOSS
17		Co-Insurance %	85		Total SF	`	TOTAL RCV		D=DEDUCTIBLE
18
19									A = ([C / R]) * L) - D
20		CO-INSURANCE CALCULATION
21				=	$ 300,000.00	Penalty of	25.00%
22				=	$ 400,000.00	Penalty of	25.00%	R=	$ 2,942,883.00
23
24		FORMULA
25				X		=	Gross Insurance Settlement
26				X		=	Gross Insurance Settlement
27
43
44		Gross Insurance Settlement
45				X	1	=	$0.75
46				X	1	=	$0.75
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115