Year
01 2 3 4 5 6 7 8 9 10
US Inflation 4% 4% 4% 4% 4% 4% 4% 4% 4% 4%
Euro Inflation 2% 2% 2% 2% 2% 2% 2% 2% 2% 2%
Dollars per euro 1.4000 1.4275 1.4554 1.4840 1.5131 1.5427 1.5730 1.6038 1.6353 1.6673 1.7000
Retail Price per tank (dollars) 400 416 433 450 468 487 506 526 547 569
Cost per tank (euros) 238 243 248 253 258 263 268 273 279 284
Growth in demand 5% 4% 4% 3% 3% 3% 3% 3% 3%
tanks sold 15,000 15,750 16,380 17,035 17,546 18,073 18,615 19,173 19,748 20,341
All cash flows below are in euros
Revenue 4,203,297 4,501,731 4,775,436 5,065,783 5,322,111 5,591,410 5,874,335 6,171,577 6,483,858 6,811,942
Cost of goods sold 3,570,000 3,823,470 4,055,937 4,302,538 4,520,246 4,748,971 4,989,269 5,241,726 5,506,957 5,785,609
EBIT 633,297 678,261 719,499 763,245 801,865 842,439 885,067 929,851 976,901 1,026,333
NOPLAT @ 30% tax 443,308 474,783 503,649 534,271 561,305 589,707 619,547 650,896 683,831 718,433
Working Capital 420,330 450,173 477,544 506,578 532,211 559,141 587,434 617,158 648,386 681,194
Change in Working Capital 420,330 29,843 27,371 29,035 25,633 26,930 28,293 29,724 31,228 32,808