Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer once again to the International Expansion spreadsheet indxsll i, provided in the previous module. Take note of the nancial information provided in the Reven
Refer once again to the International Expansion spreadsheet indxsll i, provided in the previous module. Take note of the nancial information provided in the "Reven ue bv Location\" and "Support Cost bv Region ." Use the time value of money.r in your analysis to assess the pros and cons of each region. Also. experiment with discount ratesone high. middle, and low to understand the effect of cost of capital and risk. First: Calculate the mean revenue per location using the Revenue_Bv_Location worksheet lConstruct a decision tree that analvzes the possibility.r of achieving the mean revenue on an ongoing basis along with a correspo ndinglv high and low estimate. Use the following data to construct your decision tree: Region Average Rev. Est Low Est High Est Prob. High Prob. Average Prob. Low Next: Construct vour decision tree in Excel and calculate the expected value [refer to the readings and resources in this module to identih,r how to perform these tasks in Excelll. 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Mean UK1 $1,030,094.00 $611,661.00 $210,708.00 $1,199,730.00 $325,877.00 $263,582.00 $1,127,214.00 $155,700.00 $801,230.00 $1,587,618.00 $731,341.40 UK2 $1,450,747.00 $452,681.00 $446,783.00 $2,755,914.00 $630,900.00 $505,505.00 $2,750,123.00 $1,054,992.00 $1,428,129.00 $3,104,628.00 $1,458,040.20 EU1 $576,387.00 $941,397.00 $566,820.00 $789,254.00 $1,511,543.00 $884,805.00 $150,791.00 $1,316,447.00 $1,423, 756.00 $1, 750,083.00 $991,128.30 EU2 $660,130.00 $1,174,214.00 $512,098.00 $1,505,206.00 $100,045.00 $448,307.00 $1,237,341.00 $1,022,472.00 $843,317.00 $1, 781,111.00 $928,424.10 EU3 $186,746.00 $249,157.00 $822,398.00 $873,168.00 $1,249,729.00 $241,182.00 $1,174,970.00 $548,794.00 $192,171.00 $176,128.00 $571,444.30 $15,000,000.00 $16,100,000.00 $16,500,000.00 $16,850,000.00 $17,100,000.00 $17,250,000.00 $17,750,000.00 $18,201,000.00 $18,500,000.00 $18,750,000.00 $17,200,100.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started