Schedule M-4A

Schedule M-4A - Pro Forma 5-Year Financial Forecast.xls

7 CFR 1738, Rural Broadband Loan and Loan Guarantee Program

Schedule M-4A

OMB: 0572-0130

Document [xlsx]
Download: xlsx | pdf

Overview

Income Statement
Balance Sheet
Stmt of Cash Flows


Sheet 1: Income Statement

Schedule M-4A - Income Statement


APPLICANT NAME













Historical Forecast Period

3 Years' Prior 2 Years' Prior 1 Year Prior Year 1 Year 2 Year 3 Year 4 Year 5
REVENUES
















Network Services Revenues:







Local Voice Service $- $- $- $- $- $- $- $-
Broadband Data Service - - - - - - - -
Video Service - - - - - - - -
Middle Mile Revenues - - - - - - - -
Network Access Service Revenues - - - - - - - -
Universal Service Fund - - - - - - - -
Toll Service/Long Distance Voice - - - - - - - -
Installation Revenues - - - - - - - -
Amortized Grant Revenue - BIP - - - - - - - -
Other Operating Revenues - - - - - - - -
Uncollectible Revenues - - - - - - - -


















Total Revenues $- $- $- $- $- $- $- $-









EXPENSES
















Backhaul - - - - - - - -
IP/Interconnection - - - - - - - -
Video Content (if applicable) - - - - - - - -
Spectrum (if applicable) - - - - - - - -
Network Maintenance/Monitoring - - - - - - - -
Utilities - - - - - - - -
Sales/Marketing - - - - - - - -
Customer Care - - - - - - - -
Corporate G&A - - - - - - - -
Property Tax - - - - - - - -
Other Operating Expense - - - - - - - -


















Total Expenses $- $- $- $- $- $- $- $-









EBITDA $- $- $- $- $- $- $- $-









Depreciation - Project Assets - - - - - - - -
Depreciation - Other Assets - - - - - - - -
Amortization - - - - - - - -









Interest Expense - Project Loan - - - - - - - -
Interest Expense - Other Debt - - - - - - - -
Interest Income - - - - - - - -









Income Taxes - - - - - - - -









Net Income (Loss) $- $- $- $- $- $- $- $-
TIER - - - - - - - -










Sheet 2: Balance Sheet


Schedule M-4A - Balance Sheet












APPLICANT NAME















Historical Forecast Period
ASSETS
3 Years' Prior 2 Years' Prior 1 Year Prior Year 1 Year 2 Year 3 Year 4 Year 5
Current Assets









Cash $- $- $- $- $- $- $- $-

Marketable Securities - - - - - - - -

Accounts Receivable - - - - - - - -

Inventory








Other Current Assets - - - - - - - -


- - - - - - - -

Total Current Assets - - - - - - - -
Non-Current Assets









Amortizable Asset (Net) - - - - - - - -

Plant in Service - Project Assets








Accumulated Depreciation - Project Assets








Plant in Service - Other Assets - - - - - - - -

Accumulated Depreciation - Other Assets - - - - - - - -

Other Non-Current Assets - - - - - - - -











Total Non-Current Assets - - - - - - - -











Total Assets $- $- $- $- $- $- $- $-










LIABILITIES AND EQUITY
3 Years' Prior 2 Years' Prior 1 Year Prior Year 1 Year 2 Year 3 Year 4 Year 5










Current Liabilities









Accounts Payable $- $- $- $- $- $- $- $-

Current Portion - Project Debt - - - - - - - -

Current Portion - Other Debt








Current Portion - Deferred Grant Revenue BIP - - - - - - - -

Other Current Liabilities - - - - - - - -


- - - - - - - -

Total Current Liabilities - - - - - - - -










Non-Current Liabilities









New Project Debt - - - - - - - -

Existing Other Debt








Deferred Grant Revenue BIP - - - - - - - -

Other Non-Current Liabilities - - - - - - - -


- - - - - - - -

Total Non-Current Liabilities - - - - - - - -

Total Liabilities $- $- $- $- $- $- $- $-










Equity









Capital Stock - - - - - - - -

Additional Paid-In Capital - - - - - - - -

Patronage Capital Credits - - - - - - - -

Retained Earnings - - - - - - - -


- - - - - - - -

Total Equity $- $- $- $- $- $- $- $-











Total Liabilities and Equity $- $- $- $- $- $- $- $-

Sheet 3: Stmt of Cash Flows


Schedule M-4A - Statement of Cash Flows














APPLICANT NAME















Historical Forecast Period


3 Years' Prior 2 Years' Prior 1 Year Prior Year 1 Year 2 Year 3 Year 4 Year 5











Beginning Cash $- $- $- $- $- $- $- $-











CASH FLOWS FROM OPERATING ACTIVITIES








Net Income (Loss) - - - - - - - -

Adjustments to Reconcile Net Income (Loss)








to Net Cash From Operating Activities: - - - - - - - -

Add: Depreciation Project Assets - - - - - - - -

Add: Depreciation Other Assets - - - - - - - -

Add: Amortization - - - - - - - -

Less: Amortized Grant Revenue BIP - - - - - - - -

Changes in Assets and Liabilities: - - - - - - - -

Accounts Receivable - - - - - - - -

Inventory








Other Current Assets - - - - - - - -

Other Non-Current Assets - - - - - - - -

Accounts Payable - - - - - - - -

Other Current Liabilities - - - - - - - -

Other Non-Current Liabilities - - - - - - - -





















Net Cash From Operating Activities $- $- $- $- $- $- $- $-











CASH FLOWS FROM FINANCING ACTIVITIES








Proceeds from Sale of Equity - - - - - - - -

Proceeds from Project Loan - - - - - - - -

Proceeds from Other Debt - - - - - - - -

Proceeds from BIP Grant - - - - - - - -

Repayments of Project Loan - - - - - - - -

Repayments of Other Debt - - - - - - - -

Payments of Patronage Capital Credits - - - - - - - -

Payments of Dividends - - - - - - - -





















Net Cash From Financing Activities $- $- $- $- $- $- $- $-











CASH FLOWS FROM INVESTING ACTIVITIES








Capital Expenditures Project Operations - - - - - - - -

Capital Expenditures Other Operations - - - - - - - -

Additions to Amortizable Assets - - - - - - - -

Change in Marketable Securities (Net) - - - - - - - -





















Net Cash From Investing Activities $- $- $- $- $- $- $- $-











Increase (Decrease) in Cash - - - - - - - -











Ending Cash $- $- $- $- $- $- $- $-
File Typeapplication/vnd.ms-excel
File Modified2010-12-17
File Created2010-01-28

© 2025 OMB.report | Privacy Policy