5th Year Profit

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 7

Profit Calculator

The Profit Calculator helps you to estimate if your business is profitable. Will your earnings with products or service
and fixed costs. Knowing if your business is profitable is a critical success factor. It tells you if you need to make chan

Tips for use


Tip: You can use the Profit Calculator by yourself but may need somebody from your financial department (if you ha

How to use
The Profit Calculator helps you to understand the profitability of your company. It may support you in your decision
calculations you need to make some estimations.

Period
Determine for which period you want to calculate the profit of your business. You can calculate the profit for a week
how longer the period, the less reliable the result will be.

Item
To be able to calculate your profit you need to think about how you earn money. What are the products or services
The item can be a product, but also a service. Write down these items for your business.

Numbers sold
For each item estimate how many of them will be sold in your selected period. Write down how many times the pro

Price
Write down the price of one item. Determine how much money you will charge the customer for one product or on
have package deals as well? If so make a different category and write down the item, numbers sold and price catego

Variable cost

How much does it cost to make one product or deliver a service once? Determine the costs for creating just one item
costs that only exist when a product or service is being made and sold. Think of materials, handling, production or la

Fixed costs
What are the costs regardless of the number of products made and sold? Determine the fixed costs of your business
phones. Fixed costs are costs that occur independently of the number of products made. These are costs for people
additional fixed costs items.

The results
The Profit Calculator will give you three results: total revenues, total costs and the profit. The total costs are the sum
subtracting the total costs from the total revenue.

Remember that the Profit Calculator only provides an estimation of your company’s profits. It simply shows if you co
Profit Calculator you can play with prices, costs and sales volumes to see how much you need to sell to make a profi
Profit calculator name

2,000,000 ₫ 12,000,000 ₫
TOTAL REVENUE 1,800,000 ₫
1,600,000 ₫ 10,000,000 ₫

10,579,300.24 ₫ 1,400,000 ₫
1,200,000 ₫
8,000,000 ₫
TOTAL EXPENSES 1,000,000 ₫ 6,000,000 ₫
800,000 ₫
8,733,016.75 ₫ 600,000 ₫ 4,000,000 ₫

400,000 ₫
PROFIT 2,000,000 ₫
200,000 ₫

1,846,283.49 ₫ 0₫ 0₫

Profit
PERIOD Year

Revenues Variable expenses


PRODUCT SOLD PRICE TOTAL PRODUCT COST
Frozen Fresh Noodles 80,704 62.25 ₫ 5,023,853.04 ₫ Cost per frozen fresh noodles 16.57 ₫
Noodles Soup 97,603 35.00 ₫ 3,416,108.85 ₫ Cost per noodles soup 9.19 ₫
Fresh Noodles 45,518 47.00 ₫ 2,139,338.36 ₫ Cost per fresh noodles 12.32 ₫
- ₫ Cost per
- ₫ Cost per
- ₫ Cost per
- ₫ Cost per
- ₫ Cost per
- ₫ Cost per
- ₫ Cost per
date
Nuddo(5th years)

00 ₫

00 ₫

00 ₫

00 ₫

00 ₫

00 ₫

0₫

Income Expences

Fixed expences
AMOUNT AMOUNT
1,337,273.3 ₫ Payroll 3,472,565.69 ₫
896,794.5 ₫ Marketing & Growth 1,316,086.92 ₫
560,718.9 ₫ Rent 655,000.00 ₫
- ₫ Other Expenses & Commission 104,816.97 ₫
- ₫ CAPEX 389,760.44 ₫
- ₫
- ₫
- ₫
- ₫
- ₫
Profit calculator name Aircare systems

TOTAL REVENUE €120,000 €600,000

€ 531,659 €100,000 €500,000

TOTAL EXPENSES €80,000 €400,000

€60,000 €300,000
€ 434,815 €40,000 €200,000
PROFIT
€20,000 €100,000

€ 96,844 €0 €0

Profit Income Expenses


PERIOD Year

Revenues Variable Expenses Fixed Expenses


ITEM NUMBER SOLD PRICE AMOUNT ITEM Cost AMOUNT ITEM AMOUNT
Air freshener dispenser 2200 € 64.99 € 142,978.00 Cost per air freshener dispenser € 24.00 € 52,800.00 People € 150,000.00
Multi-phasing air freshener 1230 € 79.99 € 98,387.70 Cost per multi-phasing air freshener € 32.00 € 39,360.00 Rent € 10,800.00
Automatic fragrance dispenser 1870 € 54.99 € 102,831.30 Cost per automatic fragrance dispenser € 19.00 € 35,530.00 Services € 1,700.00
Fragrance refills 3450 € 12.99 € 44,815.50 Cost per fragrance refills € 4.00 € 13,800.00 Telecom € 595.00
Air freshener refills 4630 € 14.99 € 69,403.70 Cost per air freshener refills € 5.00 € 23,150.00 Machines € 50,000.00
Automatic ozone generator 450 € 149.99 € 67,495.50 Cost per automatic ozone generator € 46.00 € 20,700.00 R&D € 35,000.00
Fragrance aerosols 230 € 24.99 € 5,747.70 Cost per fragrance aerosols € 6.00 € 1,380.00
€ - Cost per € -
€ - Cost per € -
€ - Cost per € -

date 18 October 2018

You might also like