Questions
All analysis should be done in MS Excel, and a memo to your boss explaining the...

All analysis should be done in MS Excel, and a memo to your boss explaining the situation, your

analysis, and conclusion should be prepared in MS Word. You must upload both files to be graded.

You will only get full credit for the assignment if your analysis is correct, all calculations and/or formulas

use cell references, and your memo has the right content, flows well, and is properly formatted, and

grammatically correct. An example of a good memo, and an Excel template is provided for your benefit.

You can add or delete columns in the excel template as needed.

Playtan Corporation has a machine that either should be repaired or should be replaced soon.

You have recently been hired by Playtan and one of your assignments is to help decide whether

replacing the machine, or repairing it is in the best interest of your company.

Investment required for repairing the machine is only $500,000 and cost to replace the machine

is $3,000,000. Repairing the machine will cut down on the number of returns from customers

and increase cash flows, while replacing the machine may increase the number of units sold.

Playtan has evaluated and calculated additional cash flows that will be generated under the two

scenarios over the next five years as follows:

Year

Cash flow (if repaired)

Cash Flow (if replaced)

1

197,000

1,613,000

2

160,000

1,185,000

3

178,000

978,100

4

139,000

997,800

5

117,000

990,000

Playtan does not accept projects that will pay back in more than 3 years, or any projects that will not

maximize shareholder wealth. So, you will need to use all capital budgeting techniques you’ve learnt in

your Finance class to ensure that the right option is chosen.

Cost of capital for the project (repair or replacement) could be anywhere from 8% to 14%, so you will

conduct your analyses at various weighted average cost of capital (WACC) or Required rate of return

points including at least five at 8%, 9%, 11%, 13%, and 14% for both scenarios, and also draw an NPV

profile for both situation using your calculations.

Use your knowledge of capital budgeting and time value of money to decide which of the options is better

for Playtan. All analysis must be done in Excel. Your excel model should be such that it can be used by

Playtan or any other corporation for similar capital budgeting situations – so anyone can change any

numbers and use the model again. This would require all calculations to be using cell references and excel

functions. You must write a memo to your boss, explaining the situation, your analysis, and your

conclusion. You must also explain the drawbacks of your technique/s if there are any.

Make sure that all your submissions have your full name, class, and section number included.

In: Accounting

A major new client has requested your company to present an investment seminar to the municipal...

A major new client has requested your company to present an investment seminar to the municipal mayors of the represented Metros. As an investment specialist, you have been tasked to assist your company in preparing the presentation. To illustrate the common share valuation process, you have been asked to analyze Business Analytics, an employment agency that supplies word processor operators and computer programmers to businesses with temporarily heavy workloads. You are to answer the following:

2.1 Assume that Business Analytics has a beta coefficient of 1.2, that the risk-free rate ( the yield on T-bonds) is 3%, and that the required rate of return on the market is 8%. What is Business Analytic's required rate of return?

2.2 Assume that Business Analytics is a constant growth company whose last dividend (D0, which was paid yesterday) was R2.00 and whose dividend is expected to grow indefinitely at a 4% rate.

i. What is the company's expected dividend stream over the next 3 years?

ii. What is its current share price?

iii. What is the share's expected value 1 year from now?

2.3 now assume that the share is currently selling at R40.00. What is its expected rate of return?

2.4 What would the share price be if its dividends were expected to have zero growth?

2.5 Now assume that Business Analytics'dividend is expected to grow at 30% in the first year, 20% in the second year, 10% in the third year, and return to its long-run constant growth rate of 4%. What is the share's value under these conditions?

2.6 Suppose Business Analytics' is expected to experience zero growth during the first 3 years and then resume its steady-state growth of 4% in the fourth year. What would be its value then?

2.7 Finally, assume that Business Analytics' earnings and dividends are expected to decline at a constant rate of 4% per year, that is, g=-4%. Why would anyone be willing to buy such a share, and at what price should it sell?

2.8 suppose Business Analytics' embarked on an aggressive expansion that requires additional capital. Management decided to finance the expansion by borrowing R40 million and by halting dividend payments to increase retained earnings. Its WACC is now 7% and the projected free cash flows for the next three years are -R5 million, R10 million, and R20 million respectively. After Year 3, free cash flow is projected to grow at a constant 5%. What is Business Analytics' market value of operations? If it has 10 million shares, R40 million of debt and preferred share combined, and R5 million of non-operating assets, what is the price per share?

2.9 Suppose Business Analytics decided to issue preferred share that would pay an annual dividend of R5.00 and that the issue price was R100.00 per share. What would be the share's expected return? Would the expected rate f return be the same if the preferred share was a perpetual issue or if it had a 20-year maturity?

In: Finance

This assignment is the same for both Florida & non Florida students. This problem requires the...

This assignment is the same for both Florida & non Florida students. This problem requires the student to develop a simple budget. At the end of the course, the student will receive a STAR for completing this assignment. This assignment must be completed in either MS Excel or in with a MS Word table*

Budget Case Problem

Meadow Lake Elementary will receive 600 additional students next fiscal year. This increase in student enrollment will raise the school over the number needed for several additional staff. You are only concerned with the budget for the additional students.

Your school will be allocated an additional:

Description    Salary Costs

Assistant Principal $ 53,000

Guidance Counselor $ 48,000

4 six-hour Teacher Aides $  9,600 each

Regular Classroom Teachers $ 48,000 each

One ESE Classroom Teacher $ 48,000 each

One Speech/Language Teacher  $ 48,000 each

One ESOL Teacher $ 48,000 each

One Custodian     $ 20,000

Secretary Clerk    $ 14,000

Data Processor,   $ 16,000

The regular education student-teacher formula is 20:1

The school will also receive:

A.  $ 4 per student for administrative supplies

B.  $16 per student for classroom supplies for regular teacher

C.  $ 5 per student for custodial supplies

D.  $ 300 per classroom teacher (ALL teachers except speech/language) for textbooks

E.  $ 200 per ESE teacher for ESE supplies

F.  $ 200 per ESOL Teacher for ESOL supplies

G.  A computer package for making class presentations for each regular, ESE, and ESOL teacher (not Speech) (package includes laptop computer with LCD projector) - cost per package is $3,500 per teacher.

H.  Substitute budget for $ 5,000

Outline and total the school's additional budget resources based on the increased enrollment. Use State of Florida Function and Objectcodes (Redbook codes), and group the budgeted items by common function.

Use the following headers: (an Excel spreadsheet is available to assist with this assignment)

  FUNCTION  OBJECT     DESCRIPTION     EMP. CT.  SALARY  NON-SALARY

Using the following employee benefit costs, determine the TOTAL employee costs for the enrollment increase (Salary + Benefits)

  Variable Benefits  Fixed Benefits

  Retirement   10.40%     Health $ 7,500

  FICA     7.65%   Life $   125

  Work Comp    1.50%

  Total   19.55%      $ 7,625

  1. What are the Function & Object codes for each of the personnel items?  ā€“ (4 points, ½ point for each incorrect Function or Object code).

  2. What are the Employee Counts for each Function group? (2 points, ½ point for each incorrect employee count)

  3. What are the total non-Salary Costs, by Function and Object, for the non-salary items for these additional 600 students? (3 points, ½ points for each incorrect Function, Object, or total cost)

  4. What are the total variable and fixed employee benefit costs? (1 point, ½ point each)

In: Accounting

INFECTIOUS DISEASE CASE STUDY 17- Gram - Coccobacilli Three-year-old Michael is brought to the emergency room...

INFECTIOUS DISEASE CASE STUDY 17- Gram - Coccobacilli Three-year-old Michael is brought to the emergency room of a large metropolitan hospital by his parents. What began about a week ago as a seemingly mild cold has turned into a severe cough. Michael has experienced several ā€œfitsā€ of coughing in the past 24 hours. Each seems to become more violent. During the latest, he seemed unable to get air and had begun to turn blue in the hands, feet, nose, and lips. Between coughs, he noisily gasps for air. After a quick examination, the doctor readily admits him in respiratory isolation. Laboratory Diagnosis A nasopharyngeal swab is obtained and quickly sent to the laboratory for culturing in Bordet-Gengou medium containing fresh blood. After five days of incubation, tiny glistening colonies with a pearl-luster appearance were visible. A narrow zone of hemolysis is present around the colonies. Immunofluorescent staining revealed tiny coccobacilli.

1. Which of these is the most likely cause of Michael’s symptoms? (1 point) - Diphtheria - Pertussis - Tuberculosis - Pneumocystis carnii

2. What is the name of the microorganism that causes this infection? Type answer as two words, using appropriate capitalization and separating each word with one space. (1 point)

3. What is the common name of this infection? Type answer as two words, separated by one space and using lowercase letters. (1 point)

4. Explain why this infection was given this common name. Type answer as 1 or 2 short sentences in your own words and using correct spelling, grammar and punctuation. Copied and pasted answers may receive 0 credit. (2 points)

5. Most cases of this infection occur in what population? (1 point) - Children under 5 and older adults - children 4 years of age and under - Immunocompromised individuals - teenagers to young adults

6. The route of transmission for this infection is primarily through _______________. - Feces - Respiratory droplets - Bodily fluids - Parenteral injection

7. During the catarrhal stage of this infection, which of the following symptoms occur? Mark all that apply. - Whoop sound upon inhalation - sneezing - Nasal drainage - nasal congestion - Hacking cough - occasional cough

8. During the paroxysmal stage of this infection, which of the following symptoms occur? Mark all that apply. - Whoop sound upon inhalation - sneezing - Nasal drainage - nasal congestion - Hacking cough - occasional cough

9. What standard ā€œwell babyā€ immunization procedure has Michael likely missed? Be specific please

10. Knowing the immunization for this infection was likely missed, for what other diseases is Michael at risk? Explain. Be specific.

11. What is the prescribed treatment for this infection?

In: Biology

Part A: Rainbow City had the following transactions during the year. Required: Prepare the necessary journal...

Part A:

Rainbow City had the following transactions during the year.

Required: Prepare the necessary journal entries in the appropriate governmental fund general journal and the government-wide governmental activities general journal for each of the following Rainbow City transactions.

  1. The city received a donation of land that is to be used by Parks and Recreation to develop a public park. At the time of the donation, the land had an acquisition value of $4,800,000 and was recorded on the donor’s books at a historical cost of $3,800,000.
  2. The Public Works Department sold machinery with a historical cost of $35,100 and accumulated depreciation of $28,700 for $5,000. The machinery had originally been purchased with special revenue funds.
  3. A car was leased for the mayor’s use. The first payment was $800, and the present value of the remaining lease payments was $24,000. (Note: the initial cash payment was made by the General Fund.)
  4. During the current year, a Capital Projects Fund completed a new public safety building that was started in the prior year. The total cost of the project was $9,720,000. Financing for the project came from a $9,000,000 bond issue that was sold in the prior year and from a $720,000 federal capital grant received in the current year. Current expenditures for the project totaled $1,176,000. The full cost is attributed to the building because it was constructed on city-owned property.
  5. The city records a half year of straight-line depreciation on capital assets placed in service during the year. The building in Item 4 has an estimated 30-year life with no salvage value.
  6. Due to technological developments, the city determined that the service capacity of some of the technology equipment used by general government has been impaired. The calculated impairment loss due to technology obsolescence was $1,210,000.

Part B:

In the current year, the building occupied by Surf Beach City’s Culture and Recreation Department suffered severe structural damage as a result of a hurricane. It had been 48 years since a hurricane had hit the Rainbow City area, although hurricanes in Rainbow City’s geographic area are not uncommon. The building had been purchased 10 years earlier at a cost of $2,000,000 and had accumulated depreciation of $500,000 as of the date of the hurricane. Based on a restoration cost analysis, city engineers estimate the impairment loss at $230,000; however, the city expects during the next fiscal year to receive insurance recoveries of $120,000 for the damage.

Requirements:

  1. Should the estimated impairment loss be reported as an extraordinary item? Explain.
  2. Record the estimated impairment loss in the journal for governmental activities at the government-wide level.
  3. How should the insurance recovery be reported in the following fiscal year? (You do not need to provide journal entries.)
    • Submit your responses to Part A in Excel format. The answers to Part B can be included on the spreadsheet or be submitted in a Word document.
    • Show calculations for all questions.
    • Support writing portion of the assignment, with credible sources.
    • Use terms, evidence, and concepts from class readings, including professional business language.
    • Review the week’s CT Assignment grading rubric for more information on expectations and how you will be graded.

In: Accounting

Henrys mother has been observing her 18 year old songs behavior, and is concerned that something...

Henrys mother has been observing her 18 year old songs behavior, and is concerned that something is not right. of late, she has caught him in lies on several occasions and just found out that he killed the family cat and buried it in the backyar.d when confronted about it, he seemed to feel no remorse over his behavior. Hnerys mother is afriad that her son is suffering from ..
-oppositional defiance disorder
-antisocial personality
-Psychotic personality
-DIssasociative disorder

Carolina has recently realized that her 3 month old son sleeps easily when she lays him close to him and rubs him. this is most likely an example of
Imprinting
secure attachment
contact comfort
Stranger anxiety

When a child is able to describe what someone sitting on the opposite side of a doll house can see, the child is in the _________ Stage
-sensori-operational
-pre-operational
-concrete operational
formal operational

Toree recently learned the word dog. now he calls all four legged animals dogs- what process did toree use?

-Assimilation
Object permanence
accomodation
mental representation

Kendras toddler tommy, does not undertsand that when kendra hids a toy under a blanket the toy is till there. what skill has tommy not aquired?
-Assimilation
object permanece
accomodation
mental representation

Mary, a 30. year old maried women was experiencing rapid heart poounding. difficulty breathing and feelings oof unreality tingling in her fingers. Whenever she experienced those symptoms she thought she was having a heart attack, instead of psychoteraphy. she was adviced to have medcation- what medication should she use?
Benzodiazepines
anticonvulsant med
mood stabilizer
antidepresent

Peter is afriad of mice, During conseling session his therapist asked peter to imagine a mouse running through his basement, then a mouse trunning through his living room and a him holding the mouse. The technique used by his therapost is known as-
exposure therapy
systemic desensitization
Habituation
person-centered therapy

Ji's parents expect her to be home at a reasonalbe time. when she is late her mother wants her to s tay home for the rest of the week. Ji never listens to her monther because her mother never enforces the rule she set. What parenting style? Permissive, authoratiatrian, Authoritative, Uninvolved.

Lolani was diagnosed with bulimia, but also has met the DSM-Vs criteria for anxiety and depression. this is an example of__________> Prevalence, the categorical model, the dimensional model, comorbitiy.

Peper is currently in her senior year of college and is about to graduate. she has been eagerly applying for jobs and has recently been offered interviews for five companies. When pepper is trying to pick the company thats best fit for her she is most likely engaging into,,
behavioral control,
cognitive control,
decisional control,
emotional control.

In: Psychology

Company XYZ owns a social network web site dedicated for wind surfers. They plan to launch...

Company XYZ owns a social network web site dedicated for wind surfers. They plan to launch a new online ad delivery and management service web site that will be coupled with their existing social network platform. The online ad management service will enable them to accept online orders for online ads from advertisers. The system will also deliver the ads to the main social network site. The ads will be displayed on the social network site but the content of the ads (the images and/or text objects containing the ad message) will be served by the new web site server. The company forecasts that the web site will receive an average of 10,000 visits from potential or current advertisers and 600 online ad purchase orders per week. They expect to have 30,000 registered online advertisers during the first month of the launch of the web site. Company XYZ dedicate a separate server and database for the new online service. The users of the ad management site and the users of the social network will be managed separately. The data of the two groups will be stored on separate databases. Similarly, web ad management site content and the social network site content will be hosted on separate servers. Company XYZ prefers to manage those two sites separately. The social network site will pull online ads from the database of the online ad management system. The users will experience a seamless presentation of ads within the social network pages without noticing the ads are fed from a different server.

Company XYZ awarded a contract to your company (Company ABC) to develop the web site, web service, and the database that will provide the capability of the online ad delivery and management service. You are the project manager of this project. Your task is to manage a team of three (one graphic designer, one database developer, and one software developer). As the project manager you are required to answer the following questions that provide insight about the project plan. Please respond to each question. There may be missing information. This is intentional. If you feel that there is missing information in any question, you are expected to make assumptions. Please state your assumptions clearly. You can use library and/or online information resources to address the questions. List all the information sources you use (use APA format for listing the references).

Using the drawing feature of Word or other software, create a site map of the online ad delivery service and management web site and the ad delivery web service. Show the hierarchy of pages and relationships between them. Include the database infrastructure in your depiction of your website. Explain each element. You can make any assumption about the specifics of the web site. Show the links between the social network site and the online ad management site that you will develop.

In: Computer Science

41. Which term refers to many markets that are worldwide and are served by international or...

41.

Which term refers to many markets that are worldwide and are served by international or multinational corporations?

Group of answer choices

industrialization

transnational

localization

globalization

42.

Shari, who works in Copenhagen; Darnell, who works in Chicago; and Montel, who works in Montreal convene for a teleconference each Tuesday morning to discuss the status of their project for their New York-based employer. These coworkers are part of a(n)

Group of answer choices

localization strategy.

groupthink

advising group.

virtual team.

43.

In the economic approach to organizational change, the change is driven

Group of answer choices

from the top-down.

from the bottom-up.

along parallel lines.

from within.

44.

A successful change approach would

Group of answer choices

create a readiness for change.

cancel momentum for change.

accept resistance to change.

focus only on the future state of change.

45.

Joyce, a recent College of Business graduate, has been working several months as a sales person for a small manufacturer of computers. However, her sales manager is concerned about her performance. He is aware that Joyce wants very much to have high sales in order to participate in the company’s generous incentive bonus plan. She has expressed her satisfaction with the way the plan operates, and was clearly in agreement that there is a booming demand for computers and word processors in the market area. He is puzzled, therefore, by her poor performance. He should take which of the following actions?

Group of answer choices

Talk with Joyce, stressing how she can benefit financially from increased sales.

Post sales performance results in the office so everyone can see sales persons’ performance.

Tell Joyce that unless she reaches her quota within the next three months, she will be terminated from employment.

Do nothing. Her performance should soon be improving.

Ask Joyce to accompany him on sales calls to several new customers.

46

Lewin’s three-stage model and Kotter’s eight-stage model are used by organizations to

Group of answer choices

create an organizational hierarchy.

collect raw data.

implement planned change.

demonstrate organizational resistance.

47.

Kotter’s model suggests a stage of empowering others to act on the vision. This is comparable to the ____ stage in Lewin’s model.

Group of answer choices

moving

unfreezing

refreezing

holding

48.

Susan is highly frustrated with the negative inequity (under-rewarded) she perceives at work. Which of these can help her reduce inequity?

Group of answer choices

Exert less effort

Conclude that the comparison other works harder

All of these

Ask for a raise

49.

After which stage of a group's development has the group formed a common set of expectations of member behaviors?

Group of answer choices

storming

norming

performing

forming

50.

The ________ element of motivation describes how hard a person tries.

Group of answer choices

intensity

persistence

direction

intelligence

In: Operations Management

Brief the following case using the IRAC method. Issue: Rule: Application: Conclusion: During the finale of...

Brief the following case using the IRAC method.

Issue:

Rule:

Application:

Conclusion:

During the finale of the Super Bowl XXXVIII halftime show, entertainers Justin Timberlake and Janet Jackson performed a song and dance routine to Timberlake’s song ā€œRock Your Body.ā€ As Timberlake ended the duet by sing- ing ā€œgonna have you naked by the end of this song,ā€ he tore away a portion of Jackson’s bustier, momentarily re- vealing her breast. The performers subsequently strained the credulity of the public by terming the episode a ā€œward- robe malfunction.ā€

The Federal Communications Commission issued an or- der fining CBS $550,000 for broadcasting the nudity. The agency explained that the incident violated the FCC pol- icy against broadcasting indecent material, such as nu- dity and expletives, during the hours when children are most likely to watch television. The Third Circuit vacated the order, finding that it violated the Administrative Procedure Act as ā€œarbitrary and capriciousā€ agency action. The court held that the FCC’s order represented an unex- plained departure from the agency’s longstanding policy of excusing the broadcast of fleeting moments of indecency. 663 F. 3d 122 (2011).

I am not so sure. As we recently explained in FCC v. Fox Television Stations, Inc., the FCC’s general policy is to conduct a context-specific examination of each allegedly

2 FEDERAL COMMUNICATIONS COMMISSION v. CBS CORPORATION

ROBERTS, C. J., concurring

indecent broadcast in order to determine whether it should be censured. 556 U. S. 502, 508 (2009). Until 2004, the FCC made a limited exception to this general policy for fleeting expletives. Ibid. But the agency never stated that the exception applied to fleeting images as well, and there was good reason to believe that it did not. As every schoolchild knows, a picture is worth a thousand words, and CBS broadcast this particular picture to mil- lions of impressionable children.

I nonetheless concur in the Court’s denial of certiorari. Even if the Third Circuit is wrong that sanctioning the Super Bowl broadcast constituted an unexplained depar- ture from the FCC’s prior indecency policy, that error has been rendered moot going forward. The FCC has made clear that it has abandoned its exception for fleeting exple- tives. Id., at 509–510. Looking ahead, it makes no dif- ference as a matter of administrative law whether the FCC’s fleeting expletive policy applies to allegedly fleeting images, because the FCC no longer adheres to the fleeting expletive policy. It is now clear that the brevity of an indecent broadcast—be it word or image—cannot immun- ize it from FCC censure. See, e.g., In re Young Broad- casting of San Francisco, Inc., 19 FCC Rcd. 1751 (2004) (censuring a broadcast despite the ā€œfleetingā€ nature of the nudity involved). Any future ā€œwardrobe malfunctionsā€ will not be protected on the ground relied on by the court below.

In: Operations Management

2018 Apr. 15 Sold 1,000 shares of Johnson & Johnson at $23.50 per share less a...

2018

Apr. 15 Sold 1,000 shares of Johnson & Johnson at $23.50 per share less a $525 commission.
July 5 Sold 1,500 shares of Mattel at $23.90 per share less a $235 commission.
July 22 Purchased 600 shares of Sara Lee at $22.50 per share plus a $480 commission.
Aug. 19 Purchased 900 shares of Eastman Kodak at $17 per share plus a $198 commission.
Dec. 31 Per share fair values for stocks in the portfolio are: Kodak, $19.25; Sara Lee, $20.00; and Sony, $35.00.


2019

Feb. 27 Purchased 2,400 shares of Microsoft at $67.00 per share plus a $525 commission.
June 21 Sold 1,200 shares of Sony at $48.00 per share less an $880 commission.
June 30 Purchased 1,400 shares of Black & Decker at $36.00 per share plus a $435 commission.
Aug. 3 Sold 600 shares of Sara Lee at $16.25 per share less a $435 commission.
Nov. 1 Sold 900 shares of Eastman Kodak at $22.75 per share less a $625 commission.
Dec. 31 Per share fair values for stocks in the portfolio are: Black & Decker, $39.00; and Microsoft, $69.00.

Required:
1. Prepare journal entries to record these transactions and events and any year-end fair value adjustments to the portfolio of long-term available-for-sale securities. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Do not round your intermediate calculations.)

********Word Choices for Journal Entry************

  • No journal entry required
  • Accounts receivable
  • Cash
  • Dividend revenue
  • Earnings from investment
  • Earnings from long-term investment
  • Fair value adjustment—AFS (LT)
  • Fair value adjustment—Available-for-sale (ST)
  • Fair value adjustment—Trading
  • Foreign exchange gain
  • Foreign exchange loss
  • Gain on sale of investments
  • Interest receivable
  • Interest revenue
  • Long-term investments—AFS (Black & Decker)
  • Long-term investments—AFS (Eastman Kodak)
  • Long-term investments—AFS (J&J)
  • Long-term investments—AFS (Mattel)
  • Long-term investments—AFS (Microsoft)
  • Long-term investments—AFS (Sara Lee)
  • Long-term investments—AFS (Sony)
  • Loss on sale of investments
  • Sales
  • Short-term investments—AFS (Black & Decker)
  • Short-term investments—AFS (Eastman Kodak)
  • Short-term investments—AFS (J&J)
  • Short-term investments—AFS (Mattel)
  • Short-term investments—AFS (Microsoft)
  • Short-term investments—AFS (Sara Lee)
  • Short-term investments—AFS (Sony)
  • Unrealized gain—Equity
  • Unrealized gain—Income
  • Unrealized loss—Equity
  • Unrealized loss—Income

In: Accounting