ScheduleH-2-ProForma5-YearFinancialForecastMULTIPLEApplications.xls

XLS spreadsheet 612 KB Posted Jan 7, 2015

Attached to: Community Connect Grant Program Federal grant opportunity
Opportunity number: RDRUS-CC-2015
Issued by: Department of Agriculture

About this file

From the source

Multiple Application Pro-Forma Workbook

View the file

Other files for this federal grant opportunity

Other files attached to Community Connect Grant Program, newest first.
File	Type	Posted
ScheduleH-2-ProForma5-YearFinancialForecastMULTIPLEApplications.xls	XLS spreadsheet	Jan 7, 2015
ScheduleH-ProForma5-YearFinancialForecastSingleApplication.xls	XLS spreadsheet	Jan 7, 2015
ScheduleH-ProForma5-YearFinancialForecastSingleApplication.xls	XLS spreadsheet	Jan 7, 2015

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Schedule H-2
	Pro Forma 5-Year Financial Forecast - Multiple Applications
	Please Note:

There are nine tabs in this spreadsheet. Please review the Application Guide for more information. Each required tab should be filled out completely. Failing to complete all required tabs could delay RUS' review or affect the final decision.

Instructions:

1. The first set of tabs (Income Statement, Balance Sheet, & Statement of Cash Flows) must reflect the projections of your existing operations EXCLUSIVELY.

2. The second set of tabs must reflect your existing operations with ONLY THIS project's projections also included.

3. The third set of tabs must reflect your existing operations with ALL your submitted projects also included.

Existing Ops Income Stmt

Schedule H-2
Pro Forma 5-Year Financial Forecast - Multiple Applications
Income Statement - Existing Operations
	Historical		Forecast Period
	2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
REVENUES
Network Services Revenues:
Local Voice Service	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Broadband Data Service	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Video Service	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Middle Mile Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Access Service Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Universal Service Fund	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Toll Service/Long Distance Voice	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Installation Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Amortized Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other Operating Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Uncollectible Revenues
Total Revenues	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
EXPENSES
Backhaul	- 0	- 0	- 0	- 0	- 0	- 0	- 0
IP/Interconnection	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Video Content If Applicable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Spectrum If Applicable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Maintenance/Monitoring	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Utilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sales/Marketing	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Customer Care	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Corporate G&A	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Property Tax	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other Operating Expense	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
EBITDA	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Depreciation Non-CC Grant Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Depreciation CC Grant Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Amortization	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Expense - Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Expense - New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Income	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Income Taxes	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Net Income (Loss)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing Ops Balance Sheet

	Schedule H-2
	Pro Forma 5-Year Financial Forecast - Multiple Applications
	Balance Sheet - Existing Operations
		Historical		Forecast Period
ASSETS		2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
Current Assets
	Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Marketable Securities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accounts Receivable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Non-Current Assets
	Amortizable Asset - Net	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Plant in Service - Non-Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Non-Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Plant in Service - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Assets	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
LIABILITIES AND EQUITY		2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
Current Liabilities
	Accounts Payable	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Current Portion - Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Current Portion - New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Current Portion - Deferred Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Non-Current Liabilities
	Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Deferred Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Liabilities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equity
	Capital Stock	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Additional Paid-In Capital	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Patronage Capital Credits	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Retained Earnings	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Equity	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total Liabilities and Equity	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing Ops Cash Flow

		Schedule H-2
		Pro Forma 5-Year Financial Forecast - Multiple Applications
		Cash Flows - Existing Operations
			Historical		Forecast Period
			2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
		Beginning Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM OPERATING ACTIVITIES
		Net Income (Loss)	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Adjustments to Reconcile Net Income (Loss) to Net Cash From
Operating Activities:	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Depreciation Non-Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Depreciation Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Amortization	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Less: Amortized Grant Revenue BIP	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Changes in Assets and Liabilities:	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Accounts Receivable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Accounts Payable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Operations
		Net Cash From Operating Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM FINANCING ACTIVITIES
		Proceeds from Sale of Equity	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from Community Connect Grant	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Repayments of Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Repayments of New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Payments of Patronage Capital Credits	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Payments of Dividends	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Financing
		Net Cash From Financing Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM INVESTING ACTIVITIES
		Capital Expenditures Non-Community Connect Project	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Capital Expenditures Community Connect Project	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Additions to Amortizable Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Change in Marketable Securities- Net	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Investing
		Net Cash From Investing Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Increase (Decrease) in Cash	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Ending Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing & Project Income Stmt

Schedule H-2
Pro Forma 5-Year Financial Forecast - Multiple Applications
Income Statement - Existing Operations and Community Connect Grant Project
	Historical		Forecast Period
	2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
REVENUES
Network Services Revenues:
Local Voice Service	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Broadband Data Service	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Video Service	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Middle Mile Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Access Service Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Universal Service Fund	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Toll Service/Long Distance Voice	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Installation Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Amortized Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other Operating Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Uncollectible Revenues
Total Revenues	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
EXPENSES
Backhaul	- 0	- 0	- 0	- 0	- 0	- 0	- 0
IP/Interconnection	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Video Content If Applicable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Spectrum If Applicable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Maintenance/Monitoring	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Utilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sales/Marketing	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Customer Care	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Corporate G&A	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Property Tax	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other Operating Expense	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
EBITDA	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Depreciation Non-CC Grant Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Depreciation CC Grant Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Amortization	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Expense - Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Expense - New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Income	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Income Taxes	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Net Income (Loss)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing & Project Bal Sheet

	Schedule H-2
	Pro Forma 5-Year Financial Forecast - Multiple Applications
	Balance Sheet - Existing Operations and Community Connect Grant Project
		Historical		Forecast Period
ASSETS		2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
Current Assets
	Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Marketable Securities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accounts Receivable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Non-Current Assets
	Amortizable Asset - Net	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Plant in Service - Non-Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Non-Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Plant in Service - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Assets	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
LIABILITIES AND EQUITY		2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
Current Liabilities
	Accounts Payable	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Current Portion - Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Current Portion - New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Current Portion - Deferred Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Non-Current Liabilities
	Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Deferred Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Liabilities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equity
	Capital Stock	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Additional Paid-In Capital	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Patronage Capital Credits	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Retained Earnings	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Equity	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total Liabilities and Equity	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing & Project Cash Flow

		Schedule H-2
		Pro Forma 5-Year Financial Forecast - Multiple Applications
		Cash Flows - Existing Operations and Community Connect Grant Project
			Historical		Forecast Period
			2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
		Beginning Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM OPERATING ACTIVITIES
		Net Income (Loss)	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Adjustments to Reconcile Net Income (Loss) to Net Cash From
Operating Activities:	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Depreciation Non-Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Depreciation Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Amortization	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Less: Amortized Grant Revenue BIP	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Changes in Assets and Liabilities:	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Accounts Receivable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Accounts Payable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Operations
		Net Cash From Operating Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM FINANCING ACTIVITIES
		Proceeds from Sale of Equity	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from Community Connect Grant	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Repayments of Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Repayments of New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Payments of Patronage Capital Credits	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Payments of Dividends	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Financing
		Net Cash From Financing Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM INVESTING ACTIVITIES
		Capital Expenditures Non-Community Connect Project	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Capital Expenditures Community Connect Project	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Additions to Amortizable Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Change in Marketable Securities- Net	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Investing
		Net Cash From Investing Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Increase (Decrease) in Cash	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Ending Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing & All Proj Income Stmt

Schedule H-2
Pro Forma 5-Year Financial Forecast - Multiple Applications
Income Statement - Existing Operations and All Proposed Community Connect Grant Projects
	Historical		Forecast Period
	2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
REVENUES
Network Services Revenues:
Local Voice Service	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Broadband Data Service	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Video Service	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Middle Mile Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Access Service Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Universal Service Fund	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Toll Service/Long Distance Voice	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Installation Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Amortized Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other Operating Revenues	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Uncollectible Revenues
Total Revenues	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
EXPENSES
Backhaul	- 0	- 0	- 0	- 0	- 0	- 0	- 0
IP/Interconnection	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Video Content If Applicable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Spectrum If Applicable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Network Maintenance/Monitoring	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Utilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Sales/Marketing	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Customer Care	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Corporate G&A	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Property Tax	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Other Operating Expense	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Total Expenses	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
EBITDA	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Depreciation Non-CC Grant Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Depreciation CC Grant Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Amortization	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Expense - Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Expense - New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Interest Income	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Income Taxes	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Net Income (Loss)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing & All Proj Bal Sheet

	Schedule H-2
	Pro Forma 5-Year Financial Forecast - Multiple Applications
	Balance Sheet - Existing Operations and All Proposed Community Connect Grant Projects
		Historical		Forecast Period
ASSETS		2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
Current Assets
	Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Marketable Securities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accounts Receivable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Non-Current Assets
	Amortizable Asset - Net	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Plant in Service - Non-Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Non-Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Plant in Service - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Assets	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
LIABILITIES AND EQUITY		2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
Current Liabilities
	Accounts Payable	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Current Portion - Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Current Portion - New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Current Portion - Deferred Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Non-Current Liabilities
	Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Deferred Grant Revenue	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Other Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Liabilities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Equity
	Capital Stock	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Additional Paid-In Capital	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Patronage Capital Credits	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Retained Earnings	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Total Equity	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Total Liabilities and Equity	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

Existing & All Proj Cash Flow

		Schedule H-2
		Pro Forma 5-Year Financial Forecast - Multiple Applications
		Cash Flows - Existing Operations and All Proposed Community Connect Grant Projects
			Historical		Forecast Period
			2 Years' Prior	1 Year Prior	Year 1	Year 2	Year 3	Year 4	Year 5
		Beginning Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM OPERATING ACTIVITIES
		Net Income (Loss)	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Adjustments to Reconcile Net Income (Loss) to Net Cash From
Operating Activities:	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Depreciation Non-Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Depreciation Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Amortization	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Less: Amortized Grant Revenue BIP	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Changes in Assets and Liabilities:	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Accounts Receivable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Non-Current Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Accounts Payable	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Non-Current Liabilities	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Operations
		Net Cash From Operating Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM FINANCING ACTIVITIES
		Proceeds from Sale of Equity	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from Community Connect Grant	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Proceeds from New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Repayments of Existing Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Repayments of New Debt	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Payments of Patronage Capital Credits	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Payments of Dividends	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Financing
		Net Cash From Financing Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		CASH FLOWS FROM INVESTING ACTIVITIES
		Capital Expenditures Non-Community Connect Project	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Capital Expenditures Community Connect Project	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Additions to Amortizable Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Change in Marketable Securities- Net	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Other Cash Flows from Investing
		Net Cash From Investing Activities	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Increase (Decrease) in Cash	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Ending Cash	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

&LUSDA RUS Community Connect Grant Program&RPro Forma 5-Year Financial Forecast - Multiple Applications &C&P&R&A

File details come from the government source that posted it. Updated Nov 14, 2017.