communication partner
FINANCIAL PLANNING
|
projected income statement for 20xx1 |
||||||
|
Year ending December 31 |
||||||
|
|
||||||
|
20xx1 |
|
|||||
|
Scenario |
1 |
2 |
3 |
4 |
5 |
|
|
SALES |
|
|||||
|
Local revenues |
$33.000.000 |
$33.000.000 |
$33.000.000 |
$33.000.000 |
$33.000.000 |
|
|
Foreign Revenues |
24.235.200 |
24.724.800 |
24.480.000 |
24.724.800 |
24.724.800 |
|
|
Total revenues |
57.235.200 |
57.724.800 |
57.480.000 |
57.724.800 |
57.724.800 |
|
|
|
||||||
|
EXPENSES |
|
|||||
|
Fuel (Diesel) |
15.589.350 |
15.589.350 |
15.589.350 |
15.589.350 |
15.650.488 |
|
|
Wages and salaries |
9.000.000 |
9.000.000 |
9.000.000 |
9.000.000 |
9.000.000 |
|
|
Interest expense |
|
|||||
|
Short-term |
2.121.000 |
2.100.000 |
2.079.000 |
2.121.000 |
2.129.318 |
|
|
Long-term |
8.075.000 |
8.075.000 |
8.075.000 |
8.075.000 |
8.075.000 |
|
|
Advertising |
1.200.000 |
1.200.000 |
1.200.000 |
1.200.000 |
1.200.000 |
|
|
Rent and Insurance |
8.000.000 |
8.000.000 |
8.000.000 |
8.000.000 |
8.000.000 |
|
|
Total expenses |
43.985.350 |
43.964.350 |
43.943.350 |
43.985.350 |
44.054.806 |
|
|
|
||||||
|
Net income from operations |
13.249.850 |
13.760.450 |
13.536.650 |
13.739.450 |
13.669.994 |
|
|
Taxes |
5.299.940 |
5.504.180 |
5.414.660 |
5.495.780 |
5.467.998 |
|
|
NET INCOME |
$7.949.910 |
$8.256.270 |
$8.121.990 |
$8.243.670 |
$8.201.996 |
|
|
|
||||||
|
Return on Equity (ROE)(a) |
10,20% |
10,59% |
10,42% |
10,58% |
10,52% |
|
|
Change in ROE(b) |
|
-3,07% |
0,66% |
-0,98% |
0,51% |
0,00% |
|
(a) |
= Net Income / Equity, Dec 31, 20xx0 |
|||||
|
(b) |
= (ROE2 - ROE1) / ROE1 |
|||||