jagomart
digital resources
picture1_Spreadsheet For Expenses 41303 | P&l Templates


 186x       Filetype XLSX       File size 0.18 MB       Source: s3.amazonaws.com


File: Spreadsheet For Expenses 41303 | P&l Templates
sheet 1 12 month p amp l profit and loss projection 12 months enter your company name here fiscal year begins jan08 ind jan08 ba feb08 mar08 apr08 may08 jun08 ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago

Related files



picture_Spreadsheet For Expenses 40762 | Chart Of Accounts Operating Expenses 2022 03 01
Spreadsheet For Expenses 40762 | Chart Of Accounts...
picture_Spreadsheet For Expenses 41022 | Exptypesubcode
Spreadsheet For Expenses 41022 | Exptypesubcode
picture_Microsoft Excel Learning Pdf 46076 | Example Enterprise Spreadsheet
Microsoft Excel Learning Pdf 46076 | Example Enterprise...
picture_Car Payment Formula Excel 46082 | Monthly Budget Gs
Car Payment Formula Excel 46082 | Monthly Budget Gs
picture_Spreadsheet For Expenses 33553 | 2016 17 Quater 4 Published Data
Spreadsheet For Expenses 33553 | 2016 17 Quater 4...
picture_Spreadsheet For Expenses 32837 | Fs Taxi Business
Spreadsheet For Expenses 32837 | Fs Taxi Business
Partial file snippet. 
Sheet 1: 12 Month P&L


	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Profit and Loss Projection (12 Months)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Enter your Company Name here
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Fiscal Year Begins
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Jan-08
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		

		 IND. %
		Jan-08
		% B/A
		Feb-08
		  %
		Mar-08
		  %
		Apr-08
		  %
		May-08
		  %
		Jun-08
		  %
		Jul-08
		  %
		Aug-08
		  %
		Sep-08
		  %
		Oct-08
		  %
		Nov-08
		  %
		Dec-08
		  %
		YEARLY
		   %
		

		

		

		

		

		

		

		

		

	

	

		Revenue (Sales)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Category 1
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 2
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 3
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 4
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 5
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 6
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 7
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Total Revenue (Sales)
		

		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.0
		0
		0.0
		0
		0.0
		0
		0.0
		0
		0.0
		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Cost of Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Category 1
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 2
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 3
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 4
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 5
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 6
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Category 7
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Total Cost of Sales
		

		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Gross Profit
		

		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Expenses
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		
		Sales people, office & others.
		Salary expenses 
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		
		Taxes, etc.
		Payroll expenses 
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Outside services
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Supplies (office and operating)
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Repairs and maintenance
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Advertising
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Car, delivery and travel
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Accounting and legal
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Rent & Related Costs
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Telephone
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Utilities
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Insurance
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Taxes (real estate, etc.)
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Interest
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Depreciation
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Other expenses (specify)
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Other expenses (specify)
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Other expenses (specify)
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Misc. (unspecified)
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		Total Expenses
		

		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		

		

		

		

		

		

		

		

		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Net Profit Before Taxes
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Income Taxes
		

		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		-
		

		

		

		

		

		

		

		

		

	

	

		Net Operating Income
		

		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		0
		-
		

		

		

		

		

		

		

		

		

	



 
 





Sheet 2: 12 Month Cash Flow


	
	
	
	
	
	
	

		
 
				
		

	

		

	

		

		Pre-Startup EST
		Jan-17
		Feb-17
		Mar-17
		Apr-17
		May-17
		Jun-17
		Jul-17
		Aug-17
		Sep-17
		Oct-17
		Nov-17
		Dec-17
		Total Item EST
		

	

	

		Cash on Hand (beginning of month)
		

		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		CASH RECEIPTS
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Cash Sales
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Collections fm CR accounts
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Loan/ other cash inj.
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		TOTAL CASH RECEIPTS
		
		Totals are calculated automatically.
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		

	

	

		Total Cash Available (before cash out)
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		CASH PAID OUT
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Purchases (merchandise)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Purchases (specify)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Purchases (specify)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Gross wages (exact withdrawal)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Payroll expenses (taxes, etc.)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Outside services
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Supplies (office & oper.)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Repairs & maintenance
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Advertising
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Car, delivery & travel
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Accounting & legal
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Rent
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Telephone
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Utilities
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Insurance
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Taxes (real estate, etc.)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Interest
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Other expenses (specify)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Other (specify)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Other (specify)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Miscellaneous
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		SUBTOTAL
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		

	

	

		Loan principal payment
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Capital purchase (specify)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Other startup costs
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Reserve and/or Escrow
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Owners' Withdrawal
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		TOTAL CASH PAID OUT
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		

	

	

		Cash Position (end of month)
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		0
		

	

	

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		ESSENTIAL OPERATING DATA (non cash flow information)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Sales Volume (dollars)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Accounts Receivable
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Bad Debt (end of month)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Inventory on hand (eom)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

		Accounts Payable (eom)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	

	

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

...Sheet month p amp l profit and loss projection months enter your company name here fiscal year begins jan ind ba feb mar apr may jun jul aug sep oct nov dec yearly revenue sales category total cost of gross expenses people office others salary taxes etc payroll outside services supplies operating repairs maintenance advertising car delivery travel accounting legal rent related costs telephone utilities insurance real estate interest depreciation other specify misc unspecified net before income...

Share

https://contohsurat.jagomart.net/item/43311/pl-templates

no reviews yet
Please Login to review.

Category: Uncategorized / Uncategorized
Posted on: 15 Aug 2022 | 3 years ago
Tag: download xlsx, templates,
Filetype: XLSX
File size: 0.18 MB
Views: 186x
Link recommended: filekonstruksi.com