Import-Export Assignment Spreadsheet

Spain Italy Greece American Dollar $1 $1 $1 National Currency 0.9367 0.9367 0.9367 Currency Converstion

Tunisia Chile Turkey $1 $1 $1 3.14347 884.829 26.9972

Effective Gross Income (EGI) PGI - YIE + ASI = Yearly Operative Expenses YOE/6 = Net Operating Income EGI - YOE = American Dollar Spain Forecasting Growth of Inventory NOI x .07 = NOI x .03 = Total Growth of Inventory (GI) PG - CAG = National Currency Forecasting Growth of Inventory NOI x .07 = NOI x .03 = Total Growth of Inventory (GI) PG - CAG = American Dollar Forecasting Cost from Growth YOE x .02 = YIE x .03 = Total Cost of Growth National Currency Forecasting Cost from Growth YOE x .02 = YIE x .03 = Total Cost of Growth American Dollar Forecasting Revenue from Growth PGI x .09 = Annual Sales Increase Total Income from Growth National Currency Forecasting Revenue from Growth PGI x .09 = Annual Sales Increase Total Income from Growth Projected Growth (PG) 7% Current Access to Growth (CAG) 3% Projected Growth (PG) 7% Current Access to Growth (CAG) 3% Operating Expense 2% Import Expense (IE) 3% Operating Expense 2% Import Expense (IE) 3% Income Growth (IG) 9% Income Growth (IG) 9% Total Forecasting Profit from Growth in American Dollar

Reflection Questions: 1. How does forcasting Projected Growth demonstrate the increasing reve 2. Why do expenses continue to increase from Year 1 to Year 6? 3. What information does the Forecasting Growth of Inventory demonstra 4. Why is Forecasting Growth Important? 5. Why does the Cost from Growth continue to increase from Year 1 to Yea 6. Why does the Revenue from Growth continue to increase from Year 1 to 7. Which Country's Trade Contract due to it's Currency Converstion should 8. Which Country's Trade Contract due to it's Currency Converstion should

12,412,197 20,991,116 9,361,915 75,651.80 75,651.80 75,651.80 12,336,546 20,915,464 9,286,263 Year 1 Year 2 Year 3 13958792 14935907.44 15981420.9608 13436968 13840077.04 14255279.3512 521824 1095830.4 1726141.6096 Year 1 Year 2 Year 3 13200104.22 14124111.5154 15112799.321478 13596107.3466 14003990.566998 14424110.2840079 -396003.126599999 120120.948402001 688689.037470061 Year 1 Year 2 Year 3 81600 83232 84896.64 185400 190962 196690.86 267000 274194 281587.5 Year 1 Year 2 Year 3 77164.836 78708.13272 80282.2953744 175323.51 350647.05 361166.4615 252488.346 429355.18272 430929.3453744 Year 1 Year 2 Year 3 12949200 14114628 15384944.52 1,425,600 1,425,600 1,452,600 14374800 15,540,228 16,810,544 Year 1 Year 2 Year 3 12245384.82 13347469.4538 14548741.704642 1,348,116 1,348,116 1,348,116 13,535,211 14,632,570 15,828,691 14,374,800 15,540,228 16,810,544

enues from year to year? ate? ar 6? o Year 6? d be retained? Why? d be canceled? Why?

21,212,271 3,610,432,073 14,076,934,736 252,726 71,253,840 2,190,008 20,927,954 3,539,178,233 14,074,744,728 Year 4 Year 5 Year 6 17100120.428056 18297128.8580199 19577927.8780813 14682937.731736 15123425.8636881 15136640.5076466 2417182.69632 3173702.99433184 4441287.37043467 Year 4 Year 5 Year 6 16170695.2739815 17302643.9431602 18513829.0191814 14856833.5925282 15302538.600304 15761614.7583131 1313861.68145328 2000105.34285614 2752214.26086823 Year 4 Year 5 Year 6 86594.5728 88326.464256 90092.99354112 202591.5858 208669.333374 214929.41337522 289186.1586 296995.79763 296995.79763 Year 4 Year 5 Year 6 81887.941281888 83525.7001075258 85196.2141096763 372001.455345 372326.50516035 383496.300315161 453889.396626888 455852.205267876 468692.514424837 Year 4 Year 5 Year 6 16769589.5268 18278852.584212 19923949.3167911 1,452,600 1,425,600 1425600 18,195,189 19704452 21,349,549 Year 4 Year 5 Year 6 15858128.4580598 17285360.0192852 18841042.4210208 1,348,116 1,348,116 1,348,116 17,132,463 18,695,686 20,257,488 18,195,189 19,704,452 21,349,549