Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the income statement in Excel 2016 begin{tabular}{|c|c|c|c|c|} hline Breakdown & TTM & 6/29/2022 & 6/29/2021 & 6/29/2020 hline Total Revenue & 22,811,000 &

image text in transcribedCalculate the income statement in Excel 2016

\begin{tabular}{|c|c|c|c|c|} \hline Breakdown & TTM & 6/29/2022 & 6/29/2021 & 6/29/2020 \\ \hline Total Revenue & 22,811,000 & 21,043,000 & 18,962,000 & 16,422,000 \\ \hline Total Premiums Earned & 21,978,000 & 20,169,000 & 18,020,000 & 16,121,000 \\ \hline Net Premiums Written & 23,136,000 & 21,190,000 & 18,881,000 & 16,543,000 \\ \hline Gross Premiums Written & 25,522,000 & 23,504,000 & 20,539,000 & 17,317,000 \\ \hline Ceded Premiums & 2,386,000 & 2,314,000 & 1,658,000 & 774,000 \\ \hline Increase Decrease in Net Une... & 1,158,000 & 1,021,000 & 861,000 & 422,000 \\ \hline Net Investment income & 130,000 & 113,000 & 404,000 & 441,000 \\ \hline Net Realized Gain Loss on Inves- & - & 0 & -6.000 & - \\ \hline Interest Income & 848,000 & 661,000 & 485,000 & 710,000 \\ \hline Total Expenses & 18,956,000 & 18,312,000 & 14,601,000 & 13,585,000 \\ \hline Policy Acquisition Expense & - & 292,000 & 10,000 & . \\ \hline Fees \& Commission Expense & - & 11,000 & 9,000 & 51,000 \\ \hline Selling General and Administr... & 2,380,000 & 2,066,000 & 1,787,000 & 1,806,000 \\ \hline General \& Administrative Exp. & . & 196,000 & 162,000 & 198,000 \\ \hline Selling \& Marketing Expense & - & 1,870,000 & 1,625,000 & 1,608,000 \\ \hline Depreciation \& amortization & - & 184,000 & 156,000 & 135,000 \\ \hline Depreciation & - & 155,000 & 156,000 & 125,000 \\ \hline Amortization & - & 29,000 & 6,000 & 10,000 \\ \hline Net Non Operating Interest I... & 402,000 & 14,000 & 68,000 & 80,000 \\ \hline Interest Expense Non Operati... & 402,000 & 14,000 & 68,000 & 80,000 \\ \hline Income from Associates \& Othe... & 44,000 & 27,000 & 1,207,000 & 259.000 \\ \hline Special Income Charges & 93,000 & 36,000 & 7,000 & 1,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline Breakdown & TTM & 6/29/2022 & 6/29/2021 & 6/29/2020 \\ \hline Total Revenue & 22,811,000 & 21,043,000 & 18,962,000 & 16,422,000 \\ \hline Total Premiums Earned & 21,978,000 & 20,169,000 & 18,020,000 & 16,121,000 \\ \hline Net Premiums Written & 23,136,000 & 21,190,000 & 18,881,000 & 16,543,000 \\ \hline Gross Premiums Written & 25,522,000 & 23,504,000 & 20,539,000 & 17,317,000 \\ \hline Ceded Premiums & 2,386,000 & 2,314,000 & 1,658,000 & 774,000 \\ \hline Increase Decrease in Net Une... & 1,158,000 & 1,021,000 & 861,000 & 422,000 \\ \hline Net Investment income & 130,000 & 113,000 & 404,000 & 441,000 \\ \hline Net Realized Gain Loss on Inves- & - & 0 & -6.000 & - \\ \hline Interest Income & 848,000 & 661,000 & 485,000 & 710,000 \\ \hline Total Expenses & 18,956,000 & 18,312,000 & 14,601,000 & 13,585,000 \\ \hline Policy Acquisition Expense & - & 292,000 & 10,000 & . \\ \hline Fees \& Commission Expense & - & 11,000 & 9,000 & 51,000 \\ \hline Selling General and Administr... & 2,380,000 & 2,066,000 & 1,787,000 & 1,806,000 \\ \hline General \& Administrative Exp. & . & 196,000 & 162,000 & 198,000 \\ \hline Selling \& Marketing Expense & - & 1,870,000 & 1,625,000 & 1,608,000 \\ \hline Depreciation \& amortization & - & 184,000 & 156,000 & 135,000 \\ \hline Depreciation & - & 155,000 & 156,000 & 125,000 \\ \hline Amortization & - & 29,000 & 6,000 & 10,000 \\ \hline Net Non Operating Interest I... & 402,000 & 14,000 & 68,000 & 80,000 \\ \hline Interest Expense Non Operati... & 402,000 & 14,000 & 68,000 & 80,000 \\ \hline Income from Associates \& Othe... & 44,000 & 27,000 & 1,207,000 & 259.000 \\ \hline Special Income Charges & 93,000 & 36,000 & 7,000 & 1,000 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Theory And Risk Management

Authors: Steven Peterson

1st Edition

9781118129593

More Books

Students also viewed these Accounting questions

Question

What property does the correlation coefficient measure?

Answered: 1 week ago

Question

9. How are they similar to you? (specifically)

Answered: 1 week ago

Question

13. What are their tastes? (refined, middle class, or subsistence)

Answered: 1 week ago