Preparing balance sheet for Forgetful Insurance Company.
Background
This project provides a set of annual statements for Forgetful Insurance Company. These annual statements are based on statutory accounting principles. The account balances & results for the year are reported in column F. However, the figures reported in column F fail to take into account two transactions described below:
Transactions omitted:
1. On August 1, 2007, Forgetful underwrote a $150,000 one-year policy. Forgetful collected the premium in cash less a 18% commission.
By December 31 2007, $40,000 of losses and $5,000 of loss adjustment expenses were incurred but neither of these expenses were paid.
2. To minimize the company's risk and to gain surplus relief, the company ceded 75% of the policy described in transaction 1 to a reinsurer on August 1, 2007. The reinsurer's commission was 20%. Forgetful received the commission in cash. The reinsurance is a pro rata reinsurance contract.
Instructions
I. Adjust Forgetful Insurance Company's 2007 annual statements to reflect transaction 1 and report these adjusted results in column "I". Adjust the annual statements to reflect both transaction 1 and transaction 2 and report these adjusted results in column "K".
II. Compute each of the following ratios using the "unadjusted" data as provided in column "F". For additional practice, recompute the ratios using the data you generate for the other columns.
a. Capacity ratio
b. Liquidity ratio
c. Return on policyholders' surplus
d. Loss ratio
e. Pure loss ratio (refer to lecture notes for its definition)
f. Combined ratio (financial basis and trade basis)
g. Investment earnings ratio
III. In column "G", prepare a common-size income statement and common-size balance sheet based on the annual statement data provided in column "F".
Other information & data:
1. Assume the insurer is exempt from taxes.
2. Admitted assets at the start of 2007 totaled $1,675,000.
3. Invested assets' fair market value at year-end is $1,500,000.
4. Net premiums written, ignoring transactions 1 and 2 is $600,000.
|
|
|
|
Common-
|
SAP
|
SAP
|
|
|
|
|
size for
|
Adjusted
|
Adj'd for
|
|
Assets:
|
SAP
|
column J
|
for trans 1
|
trans 1 & 2
|
|
|
Investments
|
$1,200,000
|
|
|
|
|
|
Cash
|
150,000
|
|
|
|
|
|
Agents' balances
|
100,000
|
|
|
|
|
|
Deferred policy acquisition costs
|
0
|
|
|
|
|
|
Interest & dividend income receivable
|
10,000
|
|
|
|
|
|
Furniture and fixtures
|
0
|
|
|
|
|
|
Other assets
|
350,000
|
|
|
|
|
|
Total assets
|
$1,810,000
|
|
|
|
|
|
Liabilities:
|
|
|
|
|
|
|
Loss reserves
|
$750,000
|
|
|
|
|
|
Loss adjustment expense reserves
|
230,000
|
|
|
|
|
|
Unearned premiums
|
125,000
|
|
|
|
|
|
Other liabilities
|
135,000
|
|
|
|
|
|
Total liabilities
|
$1,240,000
|
|
|
|
|
|
Policyholders' surplus:
|
|
|
|
|
|
|
Common stock
|
$225,000
|
|
|
|
|
|
Gross paid-in capital & contribut'd capital
|
75,000
|
|
|
|
|
|
Unassigned funds
|
270,000
|
|
|
|
|
|
Policyholders' surplus
|
$570,000
|
|
|
|
|
|
Total liabilit. & policy. surplus
|
$1,810,000
|
|
|
|
|