Questions Uploads

Please-answer-the-following-12-questions-in-excel-

Please answer all questions and show work in excel. Thank you.

1. Federated Investors’ beta is 1.25, and it has paid a $1.00 dividend for many years. If its current price is $26.52, is it over or under valued?

2. Use the information below to find Connecticut Water’s intrinsic value. If its current price is $57.00, is it over or under valued?

Beta

0.65

2017 dividend

$2.20

Growth rate

0.045

3. Use the information below to find Connecticut Water’s intrinsic value. Forecast its cash flows for 2018 to 2020. If its current price is $57.00, is it over or under valued?

2017

2016

2015

2014

EPS

$2.20

DPO

0.53

0.54

0.54

ROE

0.11

Beta

0.65

P/E

23.3

17.6

17.5

4. Use the two-stage growth model and the information below to determine whether Brooks Automation is over or under valued if its current price is $20.88. Forecast the company’s cash flows for 2018 to 2020.

2017

2018

2019+

Beta

1.20

ROE

0.13

0.12

DPO

0.36

0.37

Dividend

$0.40

5. Federated Investors’ has a 2017 EPS of $2.00. Its most recent P/Es are 14.5, 20.0, and 20.8. Use the P/E as an earnings multiplier model to find the stock’s intrinsic value. If it is currently selling for $26.52, is it under or over valued?

6. Federated Investors has a beta of 1.25, and it has paid a $1.00 dividend for many years. If its current P/E is 13.1, is it over or under valued?

7. Connecticut Water’s beta is 0.65, its DPO is 0.54, and it has a 0.045 growth rate. If it has a variable dividend and its current P/E is 25.9, is it over or under valued?

8. Valuing Bonds: Microhard has issued a bond with the following characteristics:

Par: $1,000

Time to maturity: 23 years

Coupon Rate: 7 percent

Semiannual payments

Calculate the price of this bond if the YTM is:

a. 7 percent

b. 9 percent

c. 5 percent

9. Bond Yields: Skolits Corp. issued 15-year bonds two years ago at a coupon rate of 5.1 percent. The bonds make semiannual payments. If these bonds currently sell for 105 percent of par value, what is the YTM?

10. Valuing Bonds: Even though most corporate bonds in the United States make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company has a bond outstanding with a par value of €1,000, 16 years to maturity, and a coupon rate of 4.7 percent paid annually. If the yield to maturity is 3.4 percent, what is the current price of the bond?

11. Even though most corporate bonds in the united states make coupon payments semiannually, bonds issued elsewhere often have annual coupon payments. Suppose a German company issues a bond with a par value of €1,000, 16 years to maturity, and a coupon rate of 4.7 percent paid annually. If the yield maturity 3.4%, what is the current price of the bond?

12. Bond Yields: Bonino Software has 6.4% coupon bonds on the market with 11 years to maturity. The bonds make semiannual payments and currently sell for 108 percent of par. What is the current yield on the bonds? The YTM? The effective annual yield?

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

schema-project-music-Festival

I want to use Music Festival as entity for this paper, such as Ultra Music Festival, EDC Music Festival.

Define a set of entities, articulate a motivating purpose for describing them, and then outline a structure of attributes and associated values to systematically represent your entities as metadata. You will use your schema to create metadata for five varied instances of entities in your set.

Assignment details

First, you will define a group of entities to describe. This could be anything. Some examples could be:

• Spoons.

• Knitting patterns.

• Web comics.

• Yoga poses.

• Intellectual movements in literary criticism.

When defining your class of entities, give a sense of the range of possible instances that would fit into your set. For example, is a restaurant with only one vegan dish an acceptable instance of a vegan-friendly restaurant? Is a spork a spoon? Thinking about border cases will help you create attributes that apply equally to all members of your set of entities.

Next, you will articulate a purpose and associated target audience to motivate your description. For example, you might want to share your new comics book acquisitions with your comic book club, or you might want to advance a feminist interpretation of comics to the scholarly world. You might want to help novice knitters find patterns that make nice gifts, or you might want to create a vegan-eating guide for people who grew up in, and are well-acquainted with. You can see how each situation might suggest a different set of attributes for the same entity set.

You will then articulate a set of 10-15 attributes to define your entities in support of the purpose. You will label and describe each attribute in sufficient detail so that an “outside indexer” (that is, someone who is merely given your schema and its documentation) could assign values for entities of the type that you have described. For each attribute, you will set parameters for acceptable values and provide guidelines that show how values should be expressed.

Once you have sufficiently defined your attributes, use the structure that you have developed to preliminarily describe five instances to represent both central and border cases of your entity set. If there are cases where you are unable to satisfactorily describe an instance, use this as an opportunity to revise the schema and clarify your attribute definitions. (You might even need to clarify the boundaries of your group of entities and sharpen its description.) Then use your revised schema to create five final descriptions for your entity instances.

Finally, write a brief critical reflection on your design process and resulting product. You might discuss questions such as the following:

• As you designed your initial attribute set, how did you ensure that your attributes contributed to your defined purpose for description? If this process was difficult, what made it so?

• How did your schema change, if at all, following the initial test? What necessitated the changes, and why weren’t you able to anticipate these issues in advance?

• Did your perception of your group of entities change after attempting to describe the five instances? How did your conception of this set change, and what caused your perspective to shift?

• Do you feel like your final schema represents the group of entities well? Why or why not?

• What was difficult about this design project?

• What might you keep in mind for subsequent metadata design projects?

These are examples of questions that you might discuss. To create a concise yet cohesive paper, you will need to concentrate on a few design issues of particular relevance to your project. Do not merely answer the questions here.

Note that the point of this reflective essay is not to justify why your schema is work effectively. Instead, the goal of this essay is to explore and critique how the practical experience of designing a schema provokes insight onto the conceptual foundations of information organization.

Deliverables

Your final assignment should include:

• A set of instructions for an outside indexer to use in adding descriptions of new instances to the set of records that you have already created. These instructions should include the following two elements: o A few paragraphs to describe your group of entities, your purpose for describing them, and how your defined attributes work to facilitate the purpose.

o Your attribute descriptions, value parameters, and associated guidelines for using the schema to describe the entities. The description for each attribute should follow a consistent format. (You can use something similar to the standard for Dublin Core metadata elements or devise your own format. You may use tables if you wish.)

• Your descriptions of five instances. Use a consistent format for each record (perhaps a table for each instance).

• Your critical reflection. This should be written in narrative form, as a cohesive paper of 750-1000 words.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

Corporate-Profile-Part-1-Buyer-Profile-business-and-finance-homework-help

For this paper, you will research and construct a corporate profile for a publicly-traded company which operates in cyberspace and therefore has a need for cybersecurity products and services. A list of approved companies appears at the end of this assignment description. If you wish to use a company not on the approved list you must first obtain the approval of your instructor.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"

See-below-

Complete the following exercises and problems in Excel:

  • P11-26A
  • P11-27A
  • P14-30A
  • P14-31A
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"