journal entries, t account, balance sheet, income statement

THE CRIMSON PRESS CURRICULUM CENTER THE CRIMSON GROUP, INC. Jupiter Insurance Company Felipe Estrella, the newly-hired Claims Manager of the Automobile Division of Jupiter Insurance Company, was puzzled. On his desk lay two documents. One was the monthly Claims Paid. Report for March (Exhibit 1), which showed the total claims paid to beneficiaries for the month by Jupiter's recently-established Automobile Division. The other was the division's March income statement (Ex- hibit 2), which showed claims expenses. For some reason, the claims expenses shown on the income statement were much greater than total claims paid on the Claims Paid Report. As far as Mr. Estrella was concerned, however, the payment of a claim was an expense, so there should be no difference between the two numbers. Yet there it was. He was certain he would be asked about the difference at the monthly meeting of division man agers, and resolved to figure it out as best he could before the meeting. As part of his analysis, Mr. Estrella had his secretary bring him a detailed listing of claims. This in- formation is shown in Exhibit 3. Assignment 1 Reconcile the differences between the Claims Paid Report and the income statement. Try to do so using T accounts to record the various items in summary form. Some of these T accounts will be income statement accounts and some will be balance sheet accounts. 2. What should Mr. Estrella say at the meeting if he is asked about the difference between the two amounts? As part of your analysis, be sure to comment on the two notes at the bottom of Exhibit 2, as well as the accounting principles that are at work at Jupiter. JUPITER INSURANCE COMPANY Exhibit 1. Claims Paid Report for the Automobile Division For the Month of March Claim # Date Received 930250 February 16 930253 February 17 930254 February 18 930255 February 19 930256 February 19 930257 February 20 930258 February 24 930259 February 27 930301 March 3 930302 March 5 930303 March 8 930304 March 8 930305 March 9 930306 March 11 930307 March 14 930308 March 15 930309 March 15 930310 March 17 Total claims paid Date Paid March 1 March 3 March 4 March 5 March 6 March 7 March 10 March 13 March 17 March 19 March 22 March 23 March 22 March 23 March 28 March 29 March 30 March 30 Amount $3,000 800 1,900 1,800 300 1,500 1,400 1,350 3,000 6,500 1,200 500 700 5,600 400 .800 2,300 300 $33,350 Exhibit 2. Income Statement for March for the Automobile Division $195,000 72.000 $123,000 Premium revenue (1) Less: Claims expenses (2) Gross margin Less operating expenses: Salaries and wages 30.000 Depreciation 1,000 Rent and utilities 7.000 Total operating expenses Operating income Less: interest expense Income before taxes Less: provision for income taxes Net income 38.000 $85.000 5.000 $80,000 32.000 $48,000 Notes: 1. Most clients pay their automobile insurance in January for the entire year. Some clients pay in three installments. Oth- ers pay on a monthly basis. The amount of premium revenue shown on this line represents the revenue earned for the month of March. Ordinarily, the premium revenue earned is 1/12 of the annual premium, regardless of the timing of the payments. 2 Includes $21,300 of claims received and paid, $34,700 of claims received but not paid, and $16,000 of claims that the actuarial department estimated were incurred during March, but that Jupiter had not received because they had not yet been reported to the company by its beneficiaries. Page 2 of 3 JUPITER INSURANCE COMPANY Exhibit 3. Claim Details for the Automobile Division for Marc Date Paid March 1 March 3 March 4 Amount $3,000 Subtotal Claim # 930250 930253 930254 930255 930256 930257 930258 930259 February Subtotal Date Received February 16 February 17 February 18 February 19 February 19 February 20 February 24 February 27 March 5 March 6 March 7 March 10 March 13 800 1,900 1,800 300 1,500 1,400 1.350 $12,050 930301 March 3 930302 March 5 930303 March 8 930304 March 8 930305 March 9 930306 March 11 930307 March 14 930308 March 15 930309 March 15 930310 March 17 March subtotal-paid March 17 March 19 March 22 March 23 March 22 March 23 March 28 March 29 March 30 March 30 $3,000 6,500 1,200 500 700 5,600 400 800 2,300 300 21,300 930311 March 18 930312 March 20 930313 March 22 930314 March 22 930315 March 23 930316 March 24 930317 March 25 930318 March 27 930319 March 28 930320 March 29 930321 March 30 930322 March 31 March subtotal- unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid $ 4,000 6,500 3,300 2,000 700 1,100 500 4,100 2,200 3,700 900 5.700 34,700 THE CRIMSON PRESS CURRICULUM CENTER THE CRIMSON GROUP, INC. Jupiter Insurance Company Felipe Estrella, the newly-hired Claims Manager of the Automobile Division of Jupiter Insurance Company, was puzzled. On his desk lay two documents. One was the monthly Claims Paid. Report for March (Exhibit 1), which showed the total claims paid to beneficiaries for the month by Jupiter's recently-established Automobile Division. The other was the division's March income statement (Ex- hibit 2), which showed claims expenses. For some reason, the claims expenses shown on the income statement were much greater than total claims paid on the Claims Paid Report. As far as Mr. Estrella was concerned, however, the payment of a claim was an expense, so there should be no difference between the two numbers. Yet there it was. He was certain he would be asked about the difference at the monthly meeting of division man agers, and resolved to figure it out as best he could before the meeting. As part of his analysis, Mr. Estrella had his secretary bring him a detailed listing of claims. This in- formation is shown in Exhibit 3. Assignment 1 Reconcile the differences between the Claims Paid Report and the income statement. Try to do so using T accounts to record the various items in summary form. Some of these T accounts will be income statement accounts and some will be balance sheet accounts. 2. What should Mr. Estrella say at the meeting if he is asked about the difference between the two amounts? As part of your analysis, be sure to comment on the two notes at the bottom of Exhibit 2, as well as the accounting principles that are at work at Jupiter. JUPITER INSURANCE COMPANY Exhibit 1. Claims Paid Report for the Automobile Division For the Month of March Claim # Date Received 930250 February 16 930253 February 17 930254 February 18 930255 February 19 930256 February 19 930257 February 20 930258 February 24 930259 February 27 930301 March 3 930302 March 5 930303 March 8 930304 March 8 930305 March 9 930306 March 11 930307 March 14 930308 March 15 930309 March 15 930310 March 17 Total claims paid Date Paid March 1 March 3 March 4 March 5 March 6 March 7 March 10 March 13 March 17 March 19 March 22 March 23 March 22 March 23 March 28 March 29 March 30 March 30 Amount $3,000 800 1,900 1,800 300 1,500 1,400 1,350 3,000 6,500 1,200 500 700 5,600 400 .800 2,300 300 $33,350 Exhibit 2. Income Statement for March for the Automobile Division $195,000 72.000 $123,000 Premium revenue (1) Less: Claims expenses (2) Gross margin Less operating expenses: Salaries and wages 30.000 Depreciation 1,000 Rent and utilities 7.000 Total operating expenses Operating income Less: interest expense Income before taxes Less: provision for income taxes Net income 38.000 $85.000 5.000 $80,000 32.000 $48,000 Notes: 1. Most clients pay their automobile insurance in January for the entire year. Some clients pay in three installments. Oth- ers pay on a monthly basis. The amount of premium revenue shown on this line represents the revenue earned for the month of March. Ordinarily, the premium revenue earned is 1/12 of the annual premium, regardless of the timing of the payments. 2 Includes $21,300 of claims received and paid, $34,700 of claims received but not paid, and $16,000 of claims that the actuarial department estimated were incurred during March, but that Jupiter had not received because they had not yet been reported to the company by its beneficiaries. Page 2 of 3 JUPITER INSURANCE COMPANY Exhibit 3. Claim Details for the Automobile Division for Marc Date Paid March 1 March 3 March 4 Amount $3,000 Subtotal Claim # 930250 930253 930254 930255 930256 930257 930258 930259 February Subtotal Date Received February 16 February 17 February 18 February 19 February 19 February 20 February 24 February 27 March 5 March 6 March 7 March 10 March 13 800 1,900 1,800 300 1,500 1,400 1.350 $12,050 930301 March 3 930302 March 5 930303 March 8 930304 March 8 930305 March 9 930306 March 11 930307 March 14 930308 March 15 930309 March 15 930310 March 17 March subtotal-paid March 17 March 19 March 22 March 23 March 22 March 23 March 28 March 29 March 30 March 30 $3,000 6,500 1,200 500 700 5,600 400 800 2,300 300 21,300 930311 March 18 930312 March 20 930313 March 22 930314 March 22 930315 March 23 930316 March 24 930317 March 25 930318 March 27 930319 March 28 930320 March 29 930321 March 30 930322 March 31 March subtotal- unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid Unpaid $ 4,000 6,500 3,300 2,000 700 1,100 500 4,100 2,200 3,700 900 5.700 34,700