Budget Spreadsheet 33474 | Finanzplanung En

Partial file snippet.

Sheet 1: Title Sheet

	
	
		
 
	
	
	
		

	
	
		Financial Planning for Small and Medium-Sized Enterprises
	
	
		

	
	
		Liquidity Plan
	
	
		Plan – Balance Sheet
	
	
		Plan – Income Statement
	
	
		Ratios
	
	
		Plan – Cash Flow Statement Forecast
	
	
		Capital Expenditure Plan
	
	
		Budget Control
	



Sheet 2: Liquidity Plan

	
	
	
	
		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Liquidity Plan
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		Year
		

		January
		

		February
		

		March
		

		April
		

		May
		

		June
		

		July
		

		August
		

		September
		

		October
		

		November
		

		December
		

	
	
		

		

		Total target
		Total actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
		Target
		Actual
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash sales:
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Payments from accounts receivable:
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Other cash receipts:    a) Rent
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		b) Securities/interest income
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		c) ...
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		=
		Total receipts
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Purchase of goods and materials
		0
		0
		

		 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Salaries, wages, employee benefits
		0
		0
		

		 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Advertising
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Taxes, interest on capital
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Insurance
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Gen. office and administrative expenses
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Rent
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Misc. expenditure (energy, water, etc.)
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Value added tax
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		=
		Total expenditure
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		=
		Gross income/outgoings (payments in/out)
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Other receipts from sale of investments
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Other receipts (e.g. loans granted by third parties)
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Other receipts from advance payments by customers
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Private deposits/capital increase
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		-
		Other payments to acquire investments
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		-
		Other payments (e.g. loans granted to third parties)
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		-
		Other payments on account with suppliers
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		-
		Private withdrawals
		0
		0
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		=
		Net income/outgoings
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		+
		Cash, post office and bank account balances
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		=
		Cash surplus/shortfall
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash surplus used for:
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Cash shortfall met by:
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	



Sheet 3: Plan Balance Sheet

	
	
	
	
		
 
		
		

		

		

	
	
		

		

		

		

		

	
	
		

		Plan Balance Sheet
		

		

		

	
	
		

		

		

		

		

	
	
		

		Assets
		

		

		

	
	
		

		

		Year 1
		Year 2
		Year 3
	
	
		

		Current assets
		

		

		

	
	
		

		Cash & cash equivalents (cash, post office & bank accounts, securities that can be liquidated at short notice)
		

		

		

	
	
		

		Receivables
		

		

		

	
	
		

		Inventories (merchandise, stocks of materials)
		

		

		

	
	
		

		Finished goods, semi-finished goods, work in progress
		

		

		

	
	
		

		Prepaid expenses and deferred charges
		

		

		

	
	
		

		Total current assets
		0
		0
		0
	
	
		

		

		

		

		

	
	
		

		Fixed assets
		

		

		

	
	
		

		Financial investments: investments in companies
		

		

		

	
	
		

		Financial investments: long-term loans
		

		

		

	
	
		

		Plant and machinery, tools, production and warehousing equipment
		

		

		

	
	
		

		Office equipment, computer systems, communication systems, office furniture
		

		

		

	
	
		

		Vehicles
		

		

		

	
	
		

		Real estate (buildings and land)
		

		

		

	
	
		

		Intangible assets (patents, licenses, goodwill)
		

		

		

	
	
		

		Total long-term assets
		0
		0
		0
	
	
		

		Total assets
		0
		0
		0
	
	
		

		

		

		

		

	
	
		

		Liabilities and Shareholders' Equity
		

		

		

	
	
		

		

		Year 1
		Year 2
		Year 3
	
	
		

		Short-term liabilities
		

		

		

	
	
		

		Short-term liabilities from goods and services (trade and other payables)
		

		

		

	
	
		

		Short-term financial liabilities (bank debts, etc.)
		

		

		

	
	
		

		Other short-term liabilities (e.g. value added tax, dividends payable)
		

		

		

	
	
		

		Accrued expenses and deferred income and short-term provisions
		

		

		

	
	
		

		Total short-term liabilities
		0
		0
		0
	
	
		

		

		

		

		

	
	
		

		Long-term liabilities
		

		

		

	
	
		

		Long-term financial liabilities (long-term bank debt, lease obligations, mortgage debts)
		

		

		

	
	
		

		Other long-term liabilities
		

		

		

	
	
		

		Long-term provisions
		

		

		

	
	
		

		Total long-term liabilities
		0
		0
		0
	
	
		

		

		

		

		

	
	
		

		Shareholders' equity
		

		

		

	
	
		

		Equity/company capital/share capital
		

		

		

	
	
		

		Private (only for general and limited partnerships)
		

		

		

	
	
		

		Reserves, balance sheet (accumulated) profits
		

		

		

	
	
		

		Total shareholders' equity
		0
		0
		0
	
	
		

		Total liabilities and shareholders' equity
		0
		0
		0

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

...Sheet title financial planning for small and mediumsized enterprises liquidity plan ndash balance income statement ratios cash flow forecast capital expenditure budget control year january february march april may june july august september october november december total target actual sales payments from accounts receivable other receipts a rent b securitiesinterest c purchase of goods materials salaries wages employee benefits advertising taxes interest on insurance gen office administrative expenses misc energy water etc value added tax gross incomeoutgoings inout sale investments eg loans granted by third parties advance customers private depositscapital increase to acquire account with suppliers withdrawals net post bank balances surplusshortfall surplus used shortfall met assets current amp equivalents securities that can be liquidated at short notice receivables inventories merchandise stocks finished semifinished work in progress prepaid deferred charges fixed companies longter...

Related files

Share

Help



	Liquidity Plan

		Year		January		February		March		April		May		June		July		August		September		October		November		December
		Total target	Total actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual	Target	Actual

	Cash sales:	0	0
+	Payments from accounts receivable:	0	0
+	Other cash receipts: a) Rent	0	0
+	b) Securities/interest income	0	0
+	c) ...	0	0
=	Total receipts	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

+	Purchase of goods and materials	0	0
+	Salaries, wages, employee benefits	0	0
+	Advertising	0	0
+	Taxes, interest on capital	0	0
+	Insurance	0	0
+	Gen. office and administrative expenses	0	0
+	Rent	0	0
+	Misc. expenditure (energy, water, etc.)	0	0
+	Value added tax	0	0
=	Total expenditure	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

=	Gross income/outgoings (payments in/out)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

+	Other receipts from sale of investments	0	0
+	Other receipts (e.g. loans granted by third parties)	0	0
+	Other receipts from advance payments by customers	0	0
+	Private deposits/capital increase	0	0
-	Other payments to acquire investments	0	0
-	Other payments (e.g. loans granted to third parties)	0	0
-	Other payments on account with suppliers	0	0
-	Private withdrawals	0	0

=	Net income/outgoings	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

+	Cash, post office and bank account balances	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
=	Cash surplus/shortfall	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

	Cash surplus used for:
	Cash shortfall met by:



Plan Balance Sheet

Assets
	Year 1	Year 2	Year 3
Current assets
Cash & cash equivalents (cash, post office & bank accounts, securities that can be liquidated at short notice)
Receivables
Inventories (merchandise, stocks of materials)
Finished goods, semi-finished goods, work in progress
Prepaid expenses and deferred charges
Total current assets	0	0	0

Fixed assets
Financial investments: investments in companies
Financial investments: long-term loans
Plant and machinery, tools, production and warehousing equipment
Office equipment, computer systems, communication systems, office furniture
Vehicles
Real estate (buildings and land)
Intangible assets (patents, licenses, goodwill)
Total long-term assets	0	0	0
Total assets	0	0	0

Liabilities and Shareholders' Equity
	Year 1	Year 2	Year 3
Short-term liabilities
Short-term liabilities from goods and services (trade and other payables)
Short-term financial liabilities (bank debts, etc.)
Other short-term liabilities (e.g. value added tax, dividends payable)
Accrued expenses and deferred income and short-term provisions
Total short-term liabilities	0	0	0

Long-term liabilities
Long-term financial liabilities (long-term bank debt, lease obligations, mortgage debts)
Other long-term liabilities
Long-term provisions
Total long-term liabilities	0	0	0

Shareholders' equity
Equity/company capital/share capital
Private (only for general and limited partnerships)
Reserves, balance sheet (accumulated) profits
Total shareholders' equity	0	0	0
Total liabilities and shareholders' equity	0	0	0

Related files

Share

Share to social media

Help

Login Area