Profit/Loss Forecast - Financial section |
Profit/Loss Forecast
Indicator name | Units | 1 Month. | 2 Month. | 3 Month. | 4 Month. | 5 Month. | 6 Month. | In all |
1. Revenue from services rendered | Euro | 22255,10 | 22694,10 | 22694,10 | 23131,95 | 23461,20 | 24008,80 | 138245,25 |
2. Cost of the sold goods | Euro | 17618,30 | 15783,30 | 15918,60 | 15635,60 | 15767,60 | 16002,60 | 96726,00 |
3. Gross profit | Euro | 4636,80 | 6910,80 | 6775,50 | 7496,35 | 7693,60 | 8006,20 | 41519,25 |
4. Operating expenses | Euro | 12898,97 | 11024,80 | 11023,83 | 11076,26 | 11170,64 | 11298,11 | 68493,66 |
5. Taxable profit | Euro | -8262,17 | -4114,00 | -4248,33 | -3579,91 | -3477,04 | -3291,91 | -26973,36 |
6. Profit tax (5%) | Euro | - | - | - | - | - | - | - |
7. Net profit | Euro | -8262,17 | -4114,00 | -4248,33 | -3579,91 | -3477,04 | -3291,91 | -26973,36 |
8. Adjusted net profit | Euro | 268,00 | ||||||
9. Adjusted net profit | Euro | -27241,36 |
To calculate sales revenue, it is necessary to determine the sales price excluding VAT (only with markup). The company has chosen to set a 50 percent markup for haircuts and makeup. The price of a haircut excluding VAT is EURO 21.95, and for makeup – EURO 32.81. Sales revenue is calculated according to the formula:
Haircut price excluding VAT * production scale + Makeup price excluding VAT * production scale.
The cost of goods sold is calculated in Table 12. Gross profit is calculated using the formula:
Revenue from services provided – cost of goods sold.
Operating expenses are taken from Table 13.
Taxable profit was calculated using the formula:
Total profit – operating expenses.
However, since our company operated at a loss for the first six months, no corporate income tax is payable.
Net profit is calculated by deducting corporate income tax from taxable profit.
The adjustment to net profit is derived from the first table—specifically, expenses related to the owners. Adjusted net profit was obtained by deducting this adjustment from the net profit.
|
No comments:
Post a Comment