Please solve it on excel

e Group Ch.10 IC Ch.ll Needs 1 Coinurance Clause Amount of insurance carried Amount of insurance required Loss Amount of recovery Insurance to Full Value Number of Buildings Value of Each Building Total Losses Partial Losses Total Losses Paid Full TotalValue Pure Premium Rate per $100 Insurance to Half Value Number of Buildings Value of Each Building Total Losses Partial Losses Total Losses Paid Full Total Value Pure Premium Rate Per $100 Company c Total Losses Ch.ll Needs 2 $750,000.00 $250,000.00 3 40 3 40 100.00% 2,500 $350,000.00 $350,000.00 $70,000.00 $100.00 50.00% 2,500 $350,000.00 $350,000.00 $70,000.00 $100.00 Pro Rata $500,000.00 $250,000.00 $250,000.00