|
DCF-Financial Statements/Budget and Assessment Value |
|||||||||||||
|
Year |
ENTER |
1999 |
2000 |
2001 |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
2008 |
8 |
Spezial |
|
Sales Motel Season |
|
44,000 |
44,000 |
44,000 |
44,000 |
44,000 |
44,000 |
44,000 |
44,000 |
44,000 |
44,000 |
|
|
|
Sales Motel Mid Season |
|
46,000 |
48,000 |
48,000 |
52,000 |
30,000 |
32,000 |
47,000 |
48,000 |
49,000 |
48,000 |
|
|
|
Sales Motel Off-Season |
|
105,000 |
108,000 |
108,000 |
112,000 |
88,000 |
92,000 |
106,000 |
108,000 |
110,000 |
108,000 |
|
|
|
Sales Wing 3 (Room 31/32) |
|
0 |
0 |
0 |
0 |
10,000 |
25,000 |
28,500 |
30,000 |
30,000 |
30,000 |
|
|
|
Coin Loundry |
|
4,000 |
4,000 |
4,000 |
4,000 |
4,000 |
4,000 |
4,000 |
4,000 |
4,000 |
4,000 |
|
|
|
Sales Shop/Store |
|
18,000 |
18,000 |
18,000 |
18,000 |
18,000 |
18,000 |
18,000 |
18,000 |
18,000 |
18,000 |
|
|
|
Various |
|
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
2,000 |
|
|
|
Gross Success 1 |
|
219,000 |
224,000 |
224,000 |
232,000 |
196,000 |
217,000 |
249,500 |
254,000 |
257,000 |
254,000 |
|
|
|
Salary Staff (wages) |
|
-7,400 |
-7,400 |
-7,400 |
-7,400 |
-7,400 |
-7,400 |
-7,400 |
-8,000 |
-8,000 |
-8,000 |
|
|
|
Gross Success 2 |
|
211,600 |
216,600 |
216,600 |
224,600 |
188,600 |
209,600 |
242,100 |
246,000 |
249,000 |
246,000 |
|
|
|
Energy (Power/Oil) |
|
-9,500 |
-9,500 |
-9,500 |
-9,500 |
-9,500 |
-9,500 |
-9,500 |
-9,500 |
-9,500 |
-9,500 |
|
|
|
Advertising |
|
-4,000 |
-4,000 |
-4,000 |
-4,000 |
-4,000 |
-4,000 |
-4,000 |
-4,000 |
-4,000 |
-4,000 |
|
|
|
Maintenance/Rep./Buys/Exch. |
|
-8,000 |
-8,000 |
-8,000 |
-4,000 |
-4,500 |
-6,500 |
-8,000 |
-8,000 |
-8,000 |
-8,000 |
|
|
|
Taxes,Revenue, Fees etc |
|
-6,000 |
-6,000 |
-6,000 |
-6,000 |
-6,000 |
-6,000 |
-6,000 |
-6,000 |
-6,000 |
-6,000 |
|
|
|
Communications (Tel,Fax,TV, Internet etc |
|
-2,500 |
-2,500 |
-2,500 |
-2,500 |
-2,500 |
-2,500 |
-2,500 |
-2,500 |
-2,500 |
-2,500 |
|
|
|
Various expenses |
|
-4,500 |
-4,500 |
-4,500 |
-4,500 |
-4,500 |
-4,500 |
-4,500 |
-4,500 |
-4,500 |
-4,500 |
|
|
|
Cash Flow 1 |
|
177,100 |
182,100 |
182,100 |
194,100 |
157,600 |
176,600 |
207,600 |
211,500 |
214,500 |
211,500 |
|
|
|
Salary owner |
|
-18,350 |
-18,350 |
-18,350 |
-18,350 |
-19,500 |
-19,500 |
-20,500 |
-20,500 |
-24,000 |
-24,000 |
|
|
|
Cash Flow 2 |
|
158,750 |
163,750 |
163,750 |
175,750 |
138,100 |
157,100 |
187,100 |
191,000 |
190,500 |
187,500 |
|
|
|
Interest working capital etc |
|
-400 |
-400 |
-400 |
-400 |
-400 |
-400 |
-400 |
-400 |
-400 |
-400 |
|
|
|
Cash Flow 3 |
|
158,350 |
163,350 |
163,350 |
175,350 |
137,700 |
156,700 |
186,700 |
190,600 |
190,100 |
187,100 |
|
|
|
Rental value owner residence |
|
1,500 |
1,500 |
1,500 |
1,500 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
1,000 |
|
|
|
Rental value business |
12% |
19,002 |
19,602 |
21,042 |
21,042 |
16,524 |
18,804 |
22,404 |
22,872 |
22,812 |
22,452 |
|
|
|
Rental value Cafe/Restaurant |
|
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
500 |
|
|
|
Total Rental Value |
|
21,002 |
21,602 |
23,042 |
23,042 |
18,024 |
20,304 |
23,904 |
24,372 |
24,312 |
23,952 |
24,000 |
|
|
Cashflow, bzw. Cashloss |
|
200,354 |
206,554 |
209,434 |
221,434 |
173,748 |
197,308 |
234,508 |
239,344 |
238,724 |
235,004 |
235,004 |
|
|
Productive value, capitalized with |
|
|
|
|
|
|
|
|
|
|
|
5.00% |
|
|
Extra Building Lot for Extension |
100,000.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Factor |
0 |
|
|
|
|
|
|
|
|
|
|
2 |
|
|
Exit value |
|
|
|
|
|
|
|
|
|
|
|
960000.00 |
|
|
Discuonted cash flow |
100,000 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
960,000 |
|
|
DCF-Sum Assessment Value |
|
|
|
|
|
|
|
|
|
|
1,060,000 |
#NAME? |
|