Respond to the following in English. Be specific. (3 pts) 1)…
Respond to the following in English. Be specific. (3 pts) 1) What might be found in the center of a small town in France that would probably not be found in the center of a small town in America? Why? 2) Name something you might do at the mairie. 3) Why is a monument aux morts found in most towns and villages of France?
Read DetailsWhat are these people doing according to the clue given? Com…
What are these people doing according to the clue given? Complete the sentence using the correct verb faire or jouer in the present tense plus a logical activity from the table. du bricolage du jardinage du saxophone une randonnée au tennis aux échecs Moi avec un instrument=> Je [faire/jouer] ____________________________.
Read DetailsUse the “Solver” spreadsheet in your exam template as the nu…
Use the “Solver” spreadsheet in your exam template as the numbers below are already hardcoded in template. Your company is trying to choose the best combination of projects to undertake this year. The five possibilities are as follows: Investment Square Feet Employee Hours NPV Apple $ 42.00 8,000 1,090 $ 12.38 Bacardi $ 450.00 24,000 8,750 $ 88.94 Chicago $ 152.00 12,250 1,850 $ 23.82 Dannon $ 680.00 38,000 11,000 $ 129.50 Evanston $ 155.00 22,500 3,850 $ 43.25 You know that you are limited to the amount of capital, manufacturing space, and employee hours you have. Constraints Capital ($) $ 1,000.00 Square Feet 60,000 Employee Hours 16,000 Use Solver to find the optimal choice of projects. What is the NPV of the optimal choice of projects? (Format as $XXX.XX, example $28.58.) If solver does not work or you cannot set it up, manually try to choose optimal mix.
Read DetailsUse the “Balance” spreadsheet to show how you would balance…
Use the “Balance” spreadsheet to show how you would balance DHG using the line of credit and marketable securities. First, set up a circuit breaker to help in case you “break” the balancing. Next you will have to input a formula for net interest. The rate on marketable securities is 2%, on the line of credit is 8%, and on long-term debt is 12%. Use average balance for the balance sheet items for calculation of interest. Next, as you solve for the line of credit and marketable securities balances, ensure that the model is set up to update with changes in numbers. Keep in mind that your ending cash from the statement of cash flows needs to equal your ending cash on the balance sheet if everything is set up correctly. What it the balance of your marketable securities and line of credit in 2020?
Read DetailsNow you are going to create a scenario analysis in your Echo…
Now you are going to create a scenario analysis in your Echolab solution, so first copy your initial valuation to a new sheet and name it “Scenario”. You will create a table to model the following scenarios to the right of the model inputs: United States: Sales Year 1 of $27.5 million, Variable Costs of 28%, initial Revenue Growth of 12.5%, and SG&A of $500,000, $550,000 and $600,000 as indicated in initial problem Slovakia: Sales year 1 of $25 million, Variable Costs of 25%, Initial Revenue Growth of 15%, and SG&A of $300,000, $325,000, and $350,000 France: Sales year 1 of $30 million, Variable Costs of 30%, Initial Revenue Growth of 10%, and SG&A of $400,000, $450,000, and $500,000 Make sure to have a dropdown menu for your audience to choose the different scenarios. You should use each of the following at least once each in your model: match, index, offset, and lookup. Which scenario would you tell the company to choose?
Read Details