Create an investment planning model based on the assumptions given above. How much would the investments in common stock be worth at the end of the 5 years?

Based on your answer to question 1, what should the annual investment be if the company's goal were to reach $500,000 at the end of the 5 years? HINT: Use Goal Seek in Excel (Review Appendix A if needed).

Once you developed the above model, you began to think of these questions:

Are net sales growth rates truly expected to be the same every year?

Is it reasonable to expect a flat portfolio growth rate increase each year? We know that financial markets vary widely over time, so you are now thinking that a flat growth rate is not reasonable.

Based on your analysis and taking into consideration the above questions, you decide to create a simulation model that accounts for the following:

Net sales growth rate per year from 1% to 6%

Annual portfolio growth rate on average 8% with a standard deviation of 5%

Run the simulation model you created one time. What would be the value of the investments in common stock at the end of the 5 years?

Based on your answer to question 3, what should the annual investment rate need to be if the goal were to reach approximately $500,000 at the end of year 5? HINT: Use Goal Seek.

Discuss how the investment planning model you developed can be used as a template to develop other investment models for businesses and individuals alike.

QUESTION 1 Using this information what can you say about the trade balance of the country A Exports Imports Country A 7000 8000 O 1000 trade surplus 1000 trade deficit 1000 trade balance Not enough information is given to answer the question QUESTION 2 A trade that does not involve money is called (Select all that apply) Trade feedback Counter trade Barter Trade balanceQuestion 4: Suppose that Canada imports apple, but the government decides to produce it itself instead of importing apple anymore. Therefore, it provides incentives to large amounts of domestic producers. After a certain period, domestic producers reach a level to compete with the world's biggest apple exporting countries. Canada even becomes the country that sells with the lowest price in the world. Can it be said that the Canada now has a comparative advantage in terms of apple? Why or why not? What are the consequences for Canadian economy?Question 3 30 points Save Answer Perform a benefit /cost (B/C) analysis between the following two direct benefit projects having the same life time of 9 years and interest = 4%% by finding the difference in BC (Le. incremental B/C) between the two projects having the following details, all calculated in PW form: Project X : benefits = $5,222, cost -$2,832 and disbenefits -$778 Project Y : benefits = $2,290, cost =$2,171 and disbenefits =$641 Write only the last number you obtain from this comparison in the answer box. Moving to another question will save this response. Question Jof $ 5(2 points) 8. Based on the value of the September 2014 futures contract, does the market expect the USD to appreciate or depreciate against the EUR in the spot market? (2 points) 9. If interest rates go up in Canada, do we expect the CAD to appreciate or depreciate against the USD in the spot market? (2 points) 10. If the government of Germany falls, do we expect the EUR to appreciate or depreciate against the USD in the spot market? (2 points) 11. If the Japanese government decides to ease its monetary policy, do we expect the JPY to appreciate or depreciate against the USD in the spot market? (2 points) 12. If the German government fell, would we expect EUR futures contracts to become more volatile or less volatile? (2 points)In New York, state-released results of an online education survey revealed that 71% of the 10,500 respondents had positive feedback about the new Common Core state standards.: (a) This survey is an example of which of the following? O experiment observational study (b) The number 71% Is which of the following? O parameter O statistic O population O sample