Question: table [ [ income statement, 2 0 2 4 , 2 0 2 3 , 2 0 2 2 ] , [ REVENUES ,

\table[[income statement,2024,2023,2022],[REVENUES,,,],[Commissions and fees,$4,705,$4,199,$3,563],[Investment income,93,52,7],[Other income, net,7,6,3],[Total revenues,4,805,4,257,3,573],[EXPENSES],[Employee compensation and benefits,2,406,2,187,1,817],[Other operating expenses,710,650,597],[Gain on disposal,-31,-143,-5],[Amortization,178,166,147],[Depreciation,44,40,39],[Interest,193,190,141],[Change in estimated acquisition earn-out payables,2,21,-39],[Total expenses,3,502,3,111,2,697],[Income before income taxes,1,303,1,146,876],[Income taxes,301,275,204],[Net income before non-controlling interests,1,002,871,672],[Less: Net income attributable to non-controlling interests,9,,],[Net income attributable to the Company,$993,$871,$672],[Net income per share:],[Basic,$3.48,$3.07,$2.38],[Diluted,$3.46,$3.05,$2.37]]
balance sheetCurrent Assets:Cash and cash equivalentsFiduciary cashShort-term investmentsCommission, fees and other receivablesFiduciary receivablesReinsurance recoverablePrepaid reinsurance premiumsOther current assetsTotal current assetsFixed assets, netOperating lease assetsGoodwilIAmortizable intangible assets, netInvestmentsOther assetsTotal assetsCurrent Liabilities:Fiduciary liabilitiesLosses and loss adjustment reserveUnearned premiumsAccounts payableAccrued expenses and other liabilitiesCurrent portion of long-term debtTotal current liabilitiesLong-term debt less unamortized discount and debt issuanceOperating lease liabilitiesDeferred income taxes, netOther liabilitiesShareholders' Equity:Common stock, par value $0.10 per share; authorized 560 shaAdditional paid-in capitalTreasury stock, at cost 20 shares at 2024 and 2023Accumulated other comprehensive lossNon-controlling interestsRetained earningsTotal shareholders' equityTotal liabilities and shareholders' equity2024$6751,827108951,1161,5275203546,9243192007,9701,8141936617,6122,9431,5435773736532256,3143,599189711362311,118176,1286,437$17,612-748-1092023$7001,603117901,1251254623145,1302701997,3411,6212130114,8832,7271314624596085694,9563,227179616326301,027-7485,2895,579$ 14,88-19
Cash flows from operating activities:Net income before non-controlling interestsAdjustments to reconcile net income before non-controlling interests to net cash provided by operating activities:AmortizationDepreciationNon-cash stock-based compensationChange in estimated acquisition earn-out payablesDeferred incomne taxesNet gain on sales/disposals of investments, businesses, fixed assets and customer accountsPayments on acquisition earn-outs in excess of original estimated payablesOtherChanges in operating assets and liabilities, net of effect from acquisitions and divestitures:Commissions, fees and other receivables (increase) decreaseReinsurance recoverable (increase) decreasePrepaid reinsurance premiums (increase) decreaseOther assets (increase) decreaseLosses and loss adjustment reserve increase (decrease)Unearned premiums increase (decrease)Accounts payable increase (decrease)Accrued expenses and other liabilities increase (decrease)Other liabilities increase (decrease)Net cash provided by operating activitiesCash flows from investing activities:Additions to fixed assetsPayments for businesses acquired, net of cash acquiredcash tlowProceeds from sales of businesses, fixed assets and customer accountsPurchases of investmentsProceeds from sales of investmentsNet cash used in investing activitiesCash flows from financing activities:Fiduciary receivables and liabilities, netPayments on acquisition earn-outsProceeds from long-term debtPayments on long-term debtDeferred debt issuance costsBorrowings on revolving credit facilityPayments on revolving credit facilitiesIssuances of common stock for employee stock benefit plansRepurchase shares to fund tax withholdings for non-cash stock-based compensationPurchase of treasury stockCash dividends paidOther financing activitiesNet cash (used in) provided by financing activitiesEffect of foreign exchange rate changes on cash and cash equivalents inclusive of fiduciary cashNet increase in cash and cash equivalents inclusive of fiduciary cashCash and cash equivalents inclusive of fiduciary cash at beginning of periodCash and cash equivalents inclusive of fiduciary cash at end of period2024$1,00217844102131,411115-1,40235331,1747011191599500199-2944$2,50237-94-89058982,303-47-82-117-8987-7195-350-55-15464-132023S87116408921125706260-1405088107-10643-1171,010-71013270189$2,303420-29406316834-587-832,033697-90251320-13540-1872022S6721473986643377820124378812,000350381.72652-1,92860563-397-1913-30$2,033611,470768-12718-7661232504974-120131Make a 3 statement model upto 5 estimated years by using excel
\ table [ [ income statement, 2 0 2 4 , 2 0 2 3 ,

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!