Spreadsheet For Expenses 33094

368x Filetype XLSX File size 0.03 MB Source: www.tdi.texas.gov

File: Spreadsheet For Expenses 33094 | Fin411peoprjtn

sheet 1 projected financial position applicant peo projected balance sheet yr 1 yr2 yr3 current assets cashcash equivalents 0 invested assets unaffiliated receiveables affiliated receivables prepaid expenses insurance receivables other ...

Filetype Excel XLSX | Posted on 09 Aug 2022 | 4 years ago

Download

Partial file snippet.

Sheet 1: PROJECTED FINANCIAL POSITION

	
	
	
	
	
	
	
	
	
		APPLICANT PEO:
		

		

		

		PROJECTED BALANCE SHEET
		

		

		

	
	
		

		

		

		YR 1
		

		YR2
		

		YR3
	
	
		CURRENT ASSETS:
		

		

		

		

		

		

		

	
	
		

		CASH/CASH EQUIVALENTS
		

		0
		

		

		

		

	
	
		

		INVESTED ASSETS
		

		

		

		

		

		

	
	
		

		UNAFFILIATED RECEIVEABLES
		

		

		

		

		

		

	
	
		

		AFFILIATED RECEIVABLES
		

		

		

		

		

		

	
	
		

		PREPAID EXPENSES
		

		

		

		

		

		

	
	
		

		INSURANCE RECEIVABLES
		

		

		

		

		

		

	
	
		

		OTHER ASSETS
		

		

		

		

		

		

	
	
		

		TOTAL ASSETS
		

		0
		

		0
		

		0
	
	
		

		

		

		

		

		

		

		

	
	
		LIABILITIES
		

		

		

		

		

		

		

	
	
		

		UPAID LOSSES (NET OF INSURANCE)
		

		

		

		

		

		

	
	
		

		UNPAID CLAIM ADJUSTMENT EXPENSE
		

		

		

		

		

		

	
	
		

		RESERVES (NET OF INSURANCE)
		

		0
		

		

		

		

	
	
		

		INSURANCE  PAYABLE
		

		0
		

		

		

		

	
	
		

		PREPAID CONTRIBUTIONS
		

		

		

		

		

		

	
	
		

		ACCRUED GENERAL ADMINISTRATIVE EXPENSE
		

		

		

		

		

		

	
	
		

		UNAFFILIATED PAYABLES
		

		

		

		

		

		

	
	
		

		AFFILIATED PAYABLES
		

		

		

		

		

		

	
	
		

		OTHER LIABILITIES
		

		

		

		

		

		

	
	
		

		TOTAL LIABILITIES
		

		0
		

		0
		

		0
	
	
		

		

		

		

		

		

		

		

	
	
		NET ASSETS
		

		

		

		

		

		

		

	
	
		

		TOTAL NET ASSETS
		

		0
		

		0
		

		0
	



Sheet 2: PROJECTED PROFIT & LOSS

	
	
	
	
	
	
	
	
	
	
		APPLICANT PEO:
		

		

		

		

		P&L
		

		

		

	
	
		

		

		

		YR1
		

		YR2
		

		

		YR3
	
	
		REVENUES
		CONTRIBUTIONS
		

		

		

		

		

		

		

	
	
		

		INVESTMENT INCOME/CAPTIAL GAINS
		

		

		

		

		

		

		

	
	
		

		TOTAL INCOME
		

		0
		

		0
		

		

		0
	
	
		

		

		

		

		

		

		

		

		

	
	
		EXPENSES
		

		

		

		

		

		

		

		

	
	
		

		BENEFIT DISTRIBUTIONS (NET INSURANCE)
		

		

		

		

		

		

		

	
	
		

		TOTAL BENEFIT  EXPENSE
		

		#REF!
		

		

		

		

		

	
	
		NONBENEFIT DISTRIBUTIONS
		CLAIMS ADJUSTMENT EXPENSE
		

		

		

		

		

		

		

	
	
		

		INSURANCE PREMIUMS
		

		

		

		

		

		

		

	
	
		

		GENERAL ADMIN EXPENSE
		

		

		

		

		

		

		

	
	
		

		INVESTMENT LOSSES/CAPITAL LOSSES
		

		

		

		

		

		

		

	
	
		

		FENERAL INCOME TAXES
		

		

		

		

		

		

		

	
	
		

		OTHER EXPENSE
		

		

		

		

		

		

		

	
	
		

		TOTAL EXPENSES
		

		#REF!
		

		0
		

		

		0
	
	
		

		NET INCOME (LOSS)
		

		#REF!
		

		0
		

		

		0
	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		SOURCES/USES OF FUNDS
		

		

		

	
	
		

		

		

		YR1
		

		YR2
		

		

		YR3
	
	
		

		PRIOR YE NET ASSETS
		

		

		

		

		

		

		

	
	
		

		NET INCOME (NET LOSSES)
		

		

		

		

		

		

		

	
	
		

		SPONSORING PEO CONTRIBUTIONS
		

		

		

		

		

		

		

	
	
		

		UNREALIZED GAINS (LOSSES)
		

		

		

		

		

		

		

	
	
		

		OTHER INCREASES (DECREASES)
		

		

		

		

		

		

		

	
	
		

		YE NET ASSETS
		

		#REF!
		

		#REF!
		

		

		#REF!
	



Sheet 3: PROJECTED CASH FLOW

	
	
	
	
	
	
	
	
		APPLICANT PEO:
		

		

		

		

		CASH FLOW
		

		

	
	
		

		

		

		

		

		

		

		

	
	
		

		

		

		YR1
		

		YR2
		

		YR3
	
	
		CASH FROM OPERATIONS
		

		

		

		

		

		

		

	
	
		CONTRIBUTIONS COLLECTED NET OF INSURANCE
		

		

		

		

		

		

		

	
	
		BENEFITS PAID
		

		

		

		

		

		

		

	
	
		(INCREASE) DECREASE IN RECEIVABLES
		

		

		

		

		

		

		

	
	
		CLAIMS ADJUSTMENT EXPENSES PAID
		

		

		

		

		

		

		

	
	
		GENERAL ADMIN EXPENSES PAID
		

		

		

		

		

		

		

	
	
		OTHER CASH PAID
		

		

		

		

		

		

		

	
	
		INCOME TAXES PAID(RECOVERED)
		

		

		

		

		

		

		

	
	
		NET CASH FROM OPERATIONS
		

		

		0
		

		0
		

		0
	
	
		

		

		

		

		

		

		

		

	
	
		CASH FROM INVESMENTS
		

		

		

		

		

		

		

	
	
		PROCEEDS FROM SALE OF SECURITIES
		

		

		

		

		

		

		

	
	
		NET INVESTMENT INCOME 
		

		

		

		

		

		

		

	
	
		PURCHASE OF SECURITIES
		

		

		

		

		

		

		

	
	
		NET CASH FROM INVESTMENTS
		

		

		0
		

		0
		

		0
	
	
		

		

		

		

		

		

		

		

	
	
		CASH FROM FINANCING AND MISC SOURCES
		

		

		

		

		

		

		

	
	
		SPONSORING PEO CONTRIBUTION
		

		

		

		

		

		

		

	
	
		OTHER CASH PROVIDED
		

		

		

		

		

		

		

	
	
		OTHER CASH APPLIED
		

		

		

		

		

		

		

	
	
		NET CASH FROM FINANCING AND MISC SOURCES
		

		

		0
		

		0
		

		0
	
	
		

		

		

		

		

		

		

		

	
	
		NET INCREASE (DECREASE) IN CASH/CASH EQUIVALENTS
		

		

		0
		

		0
		

		0
	
	
		CASH/CASH EQUIVALENTS BEGINNING OF YR
		

		

		

		

		

		

		

	
	
		CASH/CASH EQUIVALENTS END OF YR
		

		

		0
		

		0
		

		0

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet projected financial position applicant peo balance yr current assets cashcash equivalents invested unaffiliated receiveables affiliated receivables prepaid expenses insurance other total liabilities upaid losses net of unpaid claim adjustment expense reserves payable contributions accrued general administrative payables profit amp loss p l revenues investment incomecaptial gains income benefit distributions ref nonbenefit claims premiums admin lossescapital feneral taxes sourcesuses funds prior ye sponsoring unrealized increases decreases cash flow from operations collected benefits paid increase decrease in recovered invesments proceeds sale securities purchase investments financing and misc sources contribution provided applied beginning end...

Related files

Share

Help

APPLICANT PEO:			PROJECTED BALANCE SHEET
		YR 1		YR2	YR3
CURRENT ASSETS:
	CASH/CASH EQUIVALENTS	0
	INVESTED ASSETS
	UNAFFILIATED RECEIVEABLES
	AFFILIATED RECEIVABLES
	PREPAID EXPENSES
	INSURANCE RECEIVABLES
	OTHER ASSETS
	TOTAL ASSETS	0		0	0

LIABILITIES
	UPAID LOSSES (NET OF INSURANCE)
	UNPAID CLAIM ADJUSTMENT EXPENSE
	RESERVES (NET OF INSURANCE)	0
	INSURANCE PAYABLE	0
	PREPAID CONTRIBUTIONS
	ACCRUED GENERAL ADMINISTRATIVE EXPENSE
	UNAFFILIATED PAYABLES
	AFFILIATED PAYABLES
	OTHER LIABILITIES
	TOTAL LIABILITIES	0		0	0

NET ASSETS
	TOTAL NET ASSETS	0		0	0

APPLICANT PEO:			P&L
		YR1	YR2	YR3
REVENUES	CONTRIBUTIONS
	INVESTMENT INCOME/CAPTIAL GAINS
	TOTAL INCOME	0	0	0

EXPENSES
	BENEFIT DISTRIBUTIONS (NET INSURANCE)
	TOTAL BENEFIT EXPENSE	#REF!
NONBENEFIT DISTRIBUTIONS	CLAIMS ADJUSTMENT EXPENSE
	INSURANCE PREMIUMS
	GENERAL ADMIN EXPENSE
	INVESTMENT LOSSES/CAPITAL LOSSES
	FENERAL INCOME TAXES
	OTHER EXPENSE
	TOTAL EXPENSES	#REF!	0	0
	NET INCOME (LOSS)	#REF!	0	0


			SOURCES/USES OF FUNDS
		YR1	YR2	YR3
	PRIOR YE NET ASSETS
	NET INCOME (NET LOSSES)
	SPONSORING PEO CONTRIBUTIONS
	UNREALIZED GAINS (LOSSES)
	OTHER INCREASES (DECREASES)
	YE NET ASSETS	#REF!	#REF!	#REF!

APPLICANT PEO:		CASH FLOW

	YR1	YR2	YR3
CASH FROM OPERATIONS
CONTRIBUTIONS COLLECTED NET OF INSURANCE
BENEFITS PAID
(INCREASE) DECREASE IN RECEIVABLES
CLAIMS ADJUSTMENT EXPENSES PAID
GENERAL ADMIN EXPENSES PAID
OTHER CASH PAID
INCOME TAXES PAID(RECOVERED)
NET CASH FROM OPERATIONS	0	0	0

CASH FROM INVESMENTS
PROCEEDS FROM SALE OF SECURITIES
NET INVESTMENT INCOME
PURCHASE OF SECURITIES
NET CASH FROM INVESTMENTS	0	0	0

CASH FROM FINANCING AND MISC SOURCES
SPONSORING PEO CONTRIBUTION
OTHER CASH PROVIDED
OTHER CASH APPLIED
NET CASH FROM FINANCING AND MISC SOURCES	0	0	0

NET INCREASE (DECREASE) IN CASH/CASH EQUIVALENTS	0	0	0
CASH/CASH EQUIVALENTS BEGINNING OF YR
CASH/CASH EQUIVALENTS END OF YR	0	0	0

Related files

Share

Share to social media

Help

Login Area