Excel Sheet Download 12034 | Ratios Calculator

Partial file snippet.

Sheet 1: Introduction

	
	
	
	
	
	
	
		
 
		
		Ratio Calculators
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		
 
		
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Choose period under evaluation (scroll down list)
		Monthly 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		METRIC
		 INPUT (In Dollar Amount)  
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Annual Sales: Your gross sales in dollar amount. Example: Total units sold during the period times the sales price per unit.
		 $100,000 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Annual Cost of Goods Sold: Your cost to produce the sale in dollar amount. Example: Total units sold times the direct cost of obtaining or producing each unit.
		 $20,000 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Annual Operating Expenses: Other expenses related to the overall operation of the business. Operating Expenses could include: rent, marketing, payroll, insurance, supplies, professional fees, among others. It excludes any non operational expenses such as interest expense.
		 $40,000 
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		DISCLAMER:
		

		

		

		

		

		

		

		

		

		

	
	
		

		1) This financial model template (the “Template”) is made available as a tool to illustrate your business projections.
		

		

		

		

		

		

		

		

		

		

	
	
		

		2) Popular is not responsible for any information included therein.
		

		

		

		

		

		

		

		

		

		

	
	
		

		3) This Template may not be used for tax or accounting purposes.
		

		

		

		

		

		

		

		

		

		

	
	
		

		4) Popular does not owe or accept any duty or responsibility to you or any recipient of the Template.
		

		

		

		

		

		

		

		

		

		

	
	
		

		5) The Template is not fully representative of the financial information needed in obtaining financing with Popular. Popular makes no warranties as to the accuracy of the information or work product provided by the Template.
		

		

		

		

		

		

		

		

		

		

	
	
		

		6) The use of this Template does not assure your success in obtaining financing nor does it guarantee that you will obtain credit from the StartUp Popular Financing Program.
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		© 2021 Popular 
		

		

		

		

		

		

		

		

		

		

	



Sheet 2: Gross Margin

	
	
	
	
	
	
	
	
	
	
		
 
		
		Gross Margin
		

		

		

		

		

		

		

		

		

		

		

	
	
		
 
		
		

		

		

	
	
		

		

		

	
	
		

		

		

	
	
		

		

		

		

	
	
		

		

		

		

	
	
		

		Monthly Sales
		

		

		Monthly Gross Profit ($)
		$80,000
		

		

		

		

	
	
		

		$100,000
		Your sales = The amount of revenue your business has generated. 
		

		Monthly Gross Profit Margin (%)
		80%
		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Monthly Cost of Goods Sold
		

		
 
		
		

		

		

	
	
		

		$20,000
		Total direct cost of the sales of the period = Your direct cost of producing the sales. 
		

		

		

	
	
		

		

		

		

		

		

	
	
		

		Monthly Gross Profit
		

		

		

		

	
	
		

		$80,000
		Your net sales of cost of goods sold = The amount of money that is left over to cover your other expenses. 
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		DISCLAMER:
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		1) This financial model template (the “Template”) is made available as a tool to illustrate your business projections.
		

		

		

		

		

		

	
	
		

		2) Popular is not responsible for any information included therein.
		

		

		

		

		

		

		

	
	
		

		3) This Template may not be used for tax or accounting purposes.
		

		

		

		

		

		

	
	
		

		4) Popular does not owe or accept any duty or responsibility to you or any recipient of the Template.
		

		

		

		

		

		

		

	
	
		

		5) The Template is not fully representative of the financial information needed in obtaining financing with Popular. Popular makes no warranties as to the accuracy of the information or work product provided by the Template.
		

		

		

		

		

		

		

	
	
		

		6) The use of this Template does not assure your success in obtaining financing nor does it guarantee that you will obtain credit from the StartUp Popular Financing Program.
		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		© 2021 Popular 
		

 
 
 
 


Sheet 3: Operating Margin

	
	
	
	
	
	
	
	
	
	
	
	
	
		
 
		
		Operating Margin
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		Monthly 
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Monthly Gross Profit ($)
		

		

		Monthly Operating Income ($)
		$40,000
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		$80,000
		Your net sales of cost of goods sold =  the amount of money that is left over to cover your other expenses. 
		

		Monthly Operating Margin (%)
		40%
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		
 
		
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Monthly Operating Expenses ($)
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		$40,000
		All costs associated with operating or running your business. 
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		DISCLAMER:
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		1) This financial model template (the “Template”) is made available as a tool to illustrate your business projections.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		2) Popular is not responsible for any information included therein.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		3) This Template may not be used for tax or accounting purposes.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		4) Popular does not owe or accept any duty or responsibility to you or any recipient of the Template.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		5) The Template is not fully representative of the financial information needed in obtaining financing with Popular. Popular makes no warranties as to the accuracy of the information or work product provided by the Template.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		6) The use of this Template does not assure your success in obtaining financing nor does it guarantee that you will obtain credit from the StartUp Popular Financing Program.
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		© 2021 Popular

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

...Sheet introduction ratio calculators choose period under evaluation scroll down list monthly metric input in dollar amount annual sales your gross example total units sold during the times price per unit cost of goods to produce sale direct obtaining or producing each operating expenses other related overall operation business could include rent marketing payroll insurance supplies professional fees among others it excludes any non operational such as interest expense disclamer this financial model template ldquo rdquo is made available a tool illustrate projections popular not responsible for information included therein may be used tax accounting purposes does owe accept duty responsibility you recipient fully representative needed financing with makes no warranties accuracy work product provided by use assure success nor guarantee that will obtain credit from startup program copy margin profit revenue has generated net money left over cover income all costs associated running...

Related files

Share

Help

Related files

Share

Share to social media

Help

Login Area