1. You are the strategy and expansion manager for Econ Electric Scooter. You are evaluating whether to...
Question:
1. You are the strategy and expansion manager for Econ Electric Scooter. You are evaluating whether to develop a new electric scooter line Bangladesh or to export (scooters produced at headquarters in the USA). The new scooter line in Bangladesh would be developed based on local customer preferences. The existing scooter made in the USA, that you would export, does not align well with local customer preferences. The CFO states the current weighted average cost of capital (WACC) is 10%.
A. The CEO asks for you to determine if the options are financially feasible and which one is best.Analyze quantitatively (CEO uses evidence-based decision-making strategies, not hunches).
Option 1 - Expand a new scooter line in Bangladesh through a cross-border acquisition.
WACC (cost of capital) =10%
-Initial Investment - $50,000,000
-Forecasted profits:
Year 1=1,00,000
Year 2=5,250,000
Year 3 =5,500,000
Year 4 =6,000,000
Year 5 = 7,000,000
Year 6=8,000,000
Year 7 =13,000,000
Year 8 =15,000,000
Year 9=15,000,000
Year 10=15,000,000
Option 2 - Expanding offerings of an existing product (made in USA) to Bangladesh (export strategy).
-Initial Investment = 0
-Forecasted profits:
Year 1= 500,000
Year 2=600,000
Year 3=750,000
Year 4=800,000
Year 5=800,000
Year 6=800,000
Year 7=900,000
Year 8 =900,000
Year 9=1,000,000
Year 10=1,000,000
Please explain how to achieve this via Excel?
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr