GradePack

    • Home
    • Blog
Skip to content
bg
bg
bg
bg

GradePack

Select all the accounts that should be included in the cash…

Select all the accounts that should be included in the cash flow from operations on the statement of cash flows.

Read Details

Use 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 Details

Use 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 Details

Now 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

A person sometimes fakes suicide attempts by making superfic…

A person sometimes fakes suicide attempts by making superficial cuts to their wrists with a razor blade in an attempt to get attention from family and friends. This type of behavior would defined as

Read Details

Which of the following is NOT a factor that differentiates m…

Which of the following is NOT a factor that differentiates major depressive disorder (MDD) from ‘normal depression’?

Read Details

Consider the cell with the following pair of electrodes to a…

Consider the cell with the following pair of electrodes to answer the question below: Zn(s) | Zn2+(aq, 0.0014M) ; Eocell=-0.76V; Fe(s) | Fe2+(aq, 1.4M);  Eocell=-0.447V; Use Nernst equation to calculate Ecell in volts.  To receive full credit (3 pts for answer and 3 pts for showing work), submit a picture of your work to the Exam 4 Solutions, Extra Credit and Partial Credit assignment AFTER SUBMITTING COMPLETED Midterm

Read Details

A joint manipulator has the following constraints:

A joint manipulator has the following constraints:

Read Details

n a DC motor the toque developed by the motor is:

n a DC motor the toque developed by the motor is:

Read Details

A client with a history of cirrhosis is admitted to the emer…

A client with a history of cirrhosis is admitted to the emergency department with hematemesis and is diagnosed with bleeding esophageal varices. Which nursing action takes priority? 

Read Details

Posts pagination

Newer posts 1 … 35,067 35,068 35,069 35,070 35,071 … 85,625 Older posts

GradePack

  • Privacy Policy
  • Terms of Service
Top