ScheduleH-ProForma5-YearFinancialForecastSingleApplication.xls

XLS spreadsheet 225 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

Single Project 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-2-ProForma5-YearFinancialForecastMULTIPLEApplications.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-1
	Pro Forma 5-Year Financial Forecast - Single Application
	Please Note:

There are three 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.

Existing & Project Income Stmt

Schedule H-1
Pro Forma 5-Year Financial Forecast - Single Application
Income Statement - Existing Operations and Community Connect 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 Revenues	- 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 - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
Depreciation - Other 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 - Single Application &C&P&R&A

Existing & Project Bal Sheet

	Schedule H-1
	Pro Forma 5-Year Financial Forecast - Single Application
	Balance Sheet - Existing Operations and Community Connect 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 - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Plant in Service - Other Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
	Accumulated Depreciation - Other 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 - Single Application &C&P&R&A

Existing & Project Cash Flow

		Schedule H-1
		Pro Forma 5-Year Financial Forecast - Single Application
		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 - Community Connect Project Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Depreciation - Other Assets	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Add: Amortization	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Less: Amortized Grant Revenues	- 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 Community Connect Project	- 0	- 0	- 0	- 0	- 0	- 0	- 0
		Capital Expenditures - Other	- 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 - Single Application &C&P&R&A

File details come from the government source that posted it.