Reference no: EM131852066
High rated expert please answer this in excel please?
You are given the following information:
Baseline (last year or year 1) sales: $12.00 million
Sales growth rate for years 1-7: 45%
Sales growth rate for years 8-10: 25%
Sales growth rate for years 11-on: 8%
Profit margin for years 1-10: 35%
Profit margin for years 11-on: 18%
Discount rate or cost of capital: 30% during years 1-10; and 12% for years 11-on.
Answer the following questions:
What is the value of this company using the Fundamental Method of valuation?
For $3.0 million investment, what portion of the company should be given up?
Assume you are a financial consultant to the entrepreneur, and this entrepreneur has asked you to advise her regarding the $3.0 million financing. How will you go about advising your client? Outline your thought process in this regard.
Explain contingent liability-risk free rate-risk premium
: Define and explain contingent liability, risk free rate, risk premium, credit rating, present value, time value of money, and annuity.
|
Determining the group of transformations
: Show that a maximal invariant under G is (sgn(xn), x1/xn, ..., xn-1/xn), where sgn(x) is 1 or -1 as x is positive or negative.
|
Identify the threats to the organization
: Identify some of the strengths, weaknesses, opportunities, and threats to the organization as it considers its future business goals.
|
Show that the testing problem is invariant
: (a) Show that the testing problem is invariant under G. (b) Show that the one-sample two-sided t-test in §6.2.3 is a UMPI test.
|
Company using the fundamental method of valuation
: What is the value of this company using the Fundamental Method of valuation?
|
Would the outcome of her lawsuit for wrongful termination
: Provide your state's law or regulation relating to malpractice by physicians or pharmacists.Discuss the outcome of the case.
|
Invariant under the group of transformations
: For testing H0; ? = 1 versus ? > 1, show that the problem is invariant under the group of transformations gc(x1, x2) = (cx1, cx2), c > 0
|
Outstanding principal do you pay in interest each? month
: What percentage of the outstanding principal do you pay in interest each? month?
|
Describe differences in product offerings in two countries
: Describe the differences in product offerings in 2 countries compared to the company's product you are familiar with in your home country.
|