M2 Assignment 2: The Time Value of Money—Preparing for Home Ownership

/in /by

 

Assignment 2: The Time Value of Money—Preparing for Home Ownership

Upon graduating from Argosy University with a degree in Finance, John Simple found a great job as a banking officer with Capital Two Bank in Dallas. Although he and his partner Joan had several college loans that required payments, their goal was to set aside funds for the next five years so that they could get out of the small apartment in Irving, Texas. After reviewing the listings in the areas surrounding DFW and speaking to their bosses about possible transfers, John and Joan decided upon Plano as their desired future location for a home.

Based on house prices they received from a local realtor, they determined that the home they needed currently costs around $178,000 which includes 2% closing costs. To avoid paying Private Mortgage Insurance, John and Joan need to make a down payment of 20%. Since they are saving for the potential purchase, it will be five years before they buy the home. This gives them time to save for the down payment, moving, and furniture costs, which they estimate will be 10% more than the required down payment. They also expect home prices in Plano to continue to increase each year at 2.5% per annum rate as presented by their realtor.

John, being the finance graduate, wanted to adequately prepare for their future purchase and told Joan that he would take all this information and present an overview of how much would be required once their estimated purchase date became a reality. In addition, John would show how much money they needed to save each month in their house investment account at E-Trade, which averages 5% annual return.

Tasks:

Write a 2–3-page paper where you answer the questions above. Make sure you identify the question and then respond showing all calculations using math or Excel functions.

  1. What is the estimated purchase price of the home in 5 years?
  2. How much would need to be saved for the down payment?
  3. How much would need to be saved for closing, moving, and furniture costs?
  4. Considering that they have $10,000 already saved (half of which was provided by Joan’s parents as a wedding gift), how much money do they need to save each month to reach their goal? 
  5. Suppose John could change investment plans at E-Trade and earn an additional 1.5% per annum without additional risk, how much money do they need to save each month to reach their goal? How much in investment dollars would they save by increasing their investment percentage?

Submission Details:

If you use Microsoft Excel, please attach a copy of your worksheet so your instructor can review the work. In addition, explain the theory used in solving this case using no less than 2 outside references. Apply APA standards to citation of sources.

  • By the due date assigned, save your report as M2_A2_lastname_firstinitial.doc and upload it to the Submissions Area. For example, if your name is John Smith, your document will be named SmithJ_M2_A2.doc.

Assignment 2 Grading CriteriaMaximum PointsEffectively analyzed and then reported the findings relative to the case and all 5 case questions. Submitted the 2–3-page paper and included an Excel worksheet with appropriate calculations.44Appropriate financial theory was explained and included at least 2 outside references.24Articulated key points in a clear, logical, and professional manner, with supporting evidence wherever required.12Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; displayed accurate spelling, grammar, and punctuation.20Total:100 

Discussion board #1 with 2 responses

/in /by

Guided Response (due Monday, Day 7): Respond substantively (150 to 175 words) to at least two classmates who chose different actors or different categories than you did. In your responses, reference your initial post and show how your ideas relate to those of your peers, extending the discussion. Provide support for your position. Substantive responses use theory, research, experience, and/or examples to support ideas and elaborate on the discussion topic.

Please respond to both discussion answering the following question above.

Hello Class,

     The film I chose is Moonlight. The actors in this film that I chose to write about are Alex Hibbert, who played the younger version of Chiron, Jharrel Jerome, who played Kevin at the age of 16, and Mahershala Ali, who played Juan. The style of Alex Hibbert in this film is a vulnerable, scared little boy who is lost, trying to find who he was and his identity in this world. He was bullied throughout his life and felt alone, trying to fit in, in different phases of his life. Jharrel Jerome style in this film was a confident, tough, and fearless teenager who shared an intimate relationship with the main character (Chiron). Mahershala Ali played a drug dealer who became a father figure for Chiron, a wise, caring man with a strong character. Relating their performance to other films, they all play important roles in other films, using the platform for change and opening sympathy through films, relating to real-life situations that can impact other people’s life to spread awareness of it. For example, Alex Hibbert played in The Chi, also trying to find his identity and trying to do the right thing, Jharrel Jerome played in When they see us, as one of the young teenagers who got falsely accused of a crime, showing his strength, courage, and determination throughout the film. Each of the actors played realistic acting, showing genuine human action and reaction, allowing the audience to feel and understand real-life events. Each of the actor’s choices impacted the development of each character because each stage of growing up required a different version of each character, and the actor’s fit well in the sense of showing vulnerability, fitting in as teenagers, and trying to figure out the world around them, acting tough, or scared to defend themselves.

( This scene is realistic acting when Mahershala Ali (Juan) actually teaching Alex Hibbert (Little Chiron) how to swim in real life. )

moonlight-2016.jpg 

I consider Jharell Jerome Character as typecast, the clips below show similarities in his performance from different films.

(9) When They See Us 2019 S01¦ Episode 04 ¦ Scene Prison – YouTube (Links to an external site.)

(9) Moonlight (2016) – “Fight Scene” – YouTube (Links to an external site.)

Reference:

Game of Clips. (2019, June 10). When They See Us 2019 S01: Episode 4: Scene Prison. [Video]. (9) When They See Us 2019 S01¦ Episode 04 ¦ Scene Prison – YouTube (Links to an external site.)

Lewis Perez (2017, February 27). Moonlight (2016) “Fight Scene”. [Video].(9) Moonlight (2016) – “Fight Scene” – YouTube (Links to an external site.)

Moonlight. Cinetheek. (2016). [Photograph]. Moonlight (2016) | Cinetheek

The movie I chose is Saving Private Ryan. This movie had an excellent cast line up including Tom Hanks, Matt Damen, and Vin Deisel. In this film, Tom Hanks is the strong leader, a role he plays in most of his movies. Some other examples are Apollo 13 and Captain Phillips. Matt Damen is usually a wise older man in the body of a baby-faced young male. A great example is Good Will Hunting. Finally, Vin Deisel following in his usual role of a tough, big-muscled, non-listening character who tends to do what he wants no matter the consequences. Their casting fits well as we are used to the characters having similar roles, and as viewers, we know what to expect from their casted part.

The costuming and makeup in the film are realistic and accurate to the period the movie is taking place. In addition, all of the actors have very similar attire as they are all soldiers with the same uniforms, other than their specif rank markings. Each character may have an extra item or short an item depending on their personality and what they would have brought with them during the travel. This costume approach also helps us get to know the characters without them even speaking and shows that even the slightest change in attire can change our view of the characters.

Vin Deisel sticks out as a type-casted actor. He is a big guy who is strong, with large muscles, and can typically beat up anyone who gets in his way. As stated before, almost all of his characters’ roles tend to break the rules and do their own thing. Other movie examples include the Fast and the Furious series, xXx, and The Chronicles of Riddick.

Vin Diesel Clips:

Matt Damon – Good Will Hunting (Links to an external site.) 

Quick Books

/in /by

 Module 05 Written Assignment – Payroll Transactions

QB Cloud has become quite successful over the past months, so you’ve decided to hire two part-time employees to assist you with sales and office duties. In researching your computerized accounting program, you’ve found that it doesn’t include the options to perform payroll calculations and print paychecks. To computerize the payroll calculations and assist you in drafting the journal entries, you decide to use Microsoft Excel for the necessary payroll functions.

Complete the following using the Module 05 Payroll Transactions template Click for more options

  1. Calculate payroll for Karen Rodriguez and Adam Seyd for the June 14th and June 28th payrolls. These employees are paid bi-weekly, meaning every other week.
  2. Journalize the transactions necessary to record the payroll.
    • Address the following questions:
    • What is the total cost to the company of having these two employees for the month of June?
    • What additional costs would be associated with adding one more employee for 10 hours per week at $15 per hour? Would it be more beneficial to add an additional part time employee or distribute the additional hours needed to the current part time employees? Explain.

The following information will be necessary in your calculations:

Employee Information:

Karen Rodriguez

Hourly Rate

$18/hour

June 14

24 hours worked

June 28

22 hours worked

Adam Seyd

Hourly Rate

$16/hour

June 14

15 hours worked

June 28

20 hours worked

Additional Tax and Withholding Information:

Federal Income Tax

Employee Responsibility

10% of gross pay

Employer Responsibility

none

State Income Tax

Employee Responsibility

5% of gross pay

Employer Responsibility

none

FICA Tax

Employee Responsibility

7.65% of gross pay

Employer Responsibility

7.65% of gross pay

State Unemployment

Employee Responsibility

none

Employer Responsibility

2% of gross pay

Federal Unemployment

Employee Responsibility

none

Employer Responsibility

0.8% of gross pay

student response. ONLY Paragraph in length

/in /by

 

All parties in America have a central element and that is their ability to attract thousands of small contributions through mass mailings to likely party supporters, Hershey(75). Hershey then points out that this ability allowed the national party an independent financial base. (75) Then in the 1960s the two parties wanted to increase every aspect of their parties from contributions to finding the most qualified candidates.

The first was the service party path followed first by the RNC. The foundation of this strategy was implemented in the 1960s by RNC chair Ray Bliss and was continued later by chairman Brock until the 1970s as a means to reviving the party post water-gate. (75) There were two keys to success in performing this new service role: money and campaign technology. (76) The republicans used direct-mail appeals that brought in larger levels of income. The example the book provides is that the RNC fund-raising jumped from $29 million to $105.9 million within the next few years.(76) This strategy offered a broad array of services from candidates to local party organizations. State and local party leaders were glad to accept the help since the party worked closely to identify with the business community. A great example of this strategy was the 1980 presidential election. The republicans suffered huge losses in the house and senate after water-gate and eventually cost them the White House. After only four years the republicans were able to take back the White House in the 1980 election largely due to the service party path.

         Like the service party the democrats came up with there own plan to grow and expand their parties role in the 1960s. The democrats had a larger problem due to the diversity within their own party. You had reformers supporting the civil rights and opposing American involvement in Vietnam pushing the democratic party to change their view on these issues. This strategy was an effort to more “democratic” in the nominating process and in particular more representative of people like themselves such as: blacks, women, and young people.(76) The 1968 election was the first of the series of reforms which limited the autonomy of state parties and more authority to the national party for reason in my previous sentence. This change was not limited to democrats due to key court decisions that upheld these actions in certain states. State legislatures passed bills that implemented these reforms that applied to all parties within that state. By the 1970s the problems with this strategy became evident with several democrats staying home during conventions for the reason of feeling alienated. A great example would be the elections of 1980. After gaining large majorities in the house and senate the democrats lose control of the senate. Part of this was due to the republicans raising large sums of money and allowing the state parties use it in ways they deem necessary. The other part was have divided the democratic party was over their new Procedural-reform path. Democrats having the White House and both chambers of congress and not accomplishing much didn’t help either. The democratic party eventually adopted the service path.

Its pretty evident to which path worked. The service path allowed the state and local party to have something to say in decisions, while the procedural-reform path put the majority of the decisions in the hands of the national party. Who knows best in state and local elections? Who knows more about the way people think and behave? The people that are there, the people that are closer and on the ground. The service path offered support to local and state elections. The procedural-reform path offered solutions, but what works in one area of the country will not work in another. Todays elections require more money than ever to be raised and the service path proved that it was better at raising money. I believe results speak for themselves, and the democrats adopted their own form of the service party strategy.  

Oral Language Development or Phonemic Awareness Lesson Plan

/in /by

 

Special education teachers must be well versed in using performance data to identify students whose literacy skills are below grade level. Gaining insight into students’ academic strengths and needs will help educators plan appropriate instruction to assist students in making positive academic growth.

Using the “Class Profile,” identify a group of 3-4 elementary students who would benefit from an oral language development or phonemic awareness lesson. Determine a K-2 grade level for your group of fictional students, select an ELA standard from your state related to Oral Language Development or Phonemic Awareness, and then select a corresponding grade-level text appropriate for use in a lesson plan for the determined group. You may use Appendix B of the Common Core English Language Arts Standards to help you determine an appropriate text for the lesson.

With your choices in mind, use the “COE Lesson Plan Template” to design a lesson on oral language development or phonemic awareness, utilizing storytelling, dramatic play, or a read-aloud as an instructional strategy. Thoroughly script the “Multiple Means of Engagement” section, emphasizing the use of questions to access student’s background knowledge and abilities to build new skills and develop common understanding through shared, concrete experiences.

Upon completion of your lesson plan, compose a 250-500 word summary, rationalizing how your instructional decisions help your group students to flourish in the classroom, as opposed to just survive. Be sure to address how you will use your findings in your future professional practice.

346 AAssignmentsPacific Island Adaptation

/in /by

 

This assignment is comprised of watching two videos about climate adaptation in the Pacific Island Nations. These videos provide different perspectives on the issues surrounding climate change, the first is about a government led initiative and the second is produced by an independent journalist. The second video is also produced 5 years after the first, and 7 years after the official climate change adaptation program was established. 

Part A. Watch the evideo: Adapting to Climate Change in the Smaller Pacific Island States.” produced by Larry Thomas, Secretariat of the Pacific Community (Organization), 2013. Alexander Street, be sure to watch both parts 1 and 2 (43 minutes total).

 

Answer the following questions: (If a question is worth 5 points rather than one or two, you should provide more detailed information.)

  1. (4 pts) What are the adaptation efforts in Pacific Island Nations focusing on? Name at least 4 different concerns for the nations of Kiribas, Micronesia and Tuvalu. Which of these concerns are the most critical to address now? Why?
  2. (3 pts) What actions are being taken to address the climate-related health concerns on the Cook Islands? How does their climate health adaptation plan work? What are the co-benefits?
  3. (1 pts) What kinds of approaches are taken to raise awareness about climate change, and to spur community action?

 Part B. Watch a second documentary video produced years later on Kiribati “A Drowning Paradise” from 2017, available at this link: 

 

4. (2 pts) How have conditions changed in Kiribati in the 5 years after the Pacific Island Adaptation program began and the (UW evideo) official adaptation program documentary was produced?

5. (3 pts) What are the challenges they face now? What are people doing to address these problems? How do solutions and problems differ on different atolls?

6. (2 pts) What are specific human rights issues related to the problems faced by people in Kiribati?

need a new resume

/in /by

 I have years of experience in the following fields: Case Management, House Parenting, House Management, Parent Educator, Life Coach., Requiting, Clerical and etc.Add a headline or summaryWilling to relocate: AnywhereAuthorized to work in the US for any employerWork ExperienceSr . Case WorkerBig Brothers and Sister of Chattahoochee Valley – Columbus, GAFebruary 2014 to August 2017Assessed clients specific needs and created fundraising programs that would assist them in meeting their goals.  Researched possible grants and then created proposals to submit along with grant applications.  Uncovered opportunities for volunteer program improvement by soliciting staff feedback and evaluating volunteer performance.  Tracked volunteer applications and conducted background checks to facilitate participation in Big Brother Big Sister’s volunteering programs.  Supervised and promoted volunteers into permanent roles based on staff feedback.  Recruited and trained new volunteers on volunteer program goals and objectives  Interviewed and evaluated clients, including conducting safety and risk assessments.   Assessed clients for abuse and neglect and compiled documentation for court reports.  Wrote reports and case summaries and compiled work records, including required statistics.  Investigated suspected cases of child abuse, neglect and exploitation.  Collaborated with court, law enforcement and community providers.  Delivered comprehensive therapeutic services to children, adolescents and adults involved with child welfare and prevention services.  Referred clients to social services agencies.  Spearheaded and conducted community outreach efforts. Caseworker/internshipHope Harbor – Columbus, GAOctober 2013 to January 2017Complete and maintain professional records and reports regarding the patients histories, progress notes, group notes, collateral contacts, treatment team notes and other required documentation Provide clear and concise documentation.Worked with Homeless women and Children   Participate in interdisciplinary treatment team Conduct Individual and Family Sessions as required Completed intakes with all clients and clients who abused drug use.  Analyzed departmental documents for appropriate distribution and filing.  Helped each patient understand his or her illness and the contributing personal, social and economic factors.  Taught patients how to apply for insurance and prescription programs.  Counseled individuals and families regarding mental health, substance abuse, physical abuse and rehabilitation issues.  Interviewed and evaluated clients, including conducting safety and risk assessments.  Testified at custody hearings regarding patient’s history and present behavior.  Assessed clients for abuse and neglect and compiled documentation for court reports.  Investigated suspected cases of child abuse, neglect and exploitation.  Delivered comprehensive therapeutic services to children, adolescents and adults involved with child welfare and prevention services.  Offered therapeutic services and crises intervention to emotionally disturbed children and adolescents.  Wrote reports and case summaries and compiled work records, including required statistics.  Collaborated with court, law enforcement and community providers.  Collaborated with the program director to determine and reduce the risk of self-harm and suicide.  Referred patients to psychiatric and medical examinations, as well as to family assessment planning teams.  Testified under oath to help the court make custody decisions. Parent Educator SpecialistFamily Guidance Center – Montgomery, ALFebruary 2016 to September 2016Assessments and Diagnostic Assessment Forms Schedule, conduct and document regular home visitation sessions with participating parents and their children to deliver a curriculum designed to teach basic parenting skills and child development.  Provide classroom instruction and community education related to program.  Promote community awareness of programs through presentations to community, church, civic and school groups and through use of local media.   Collaborate with community partner agencies to access services for participating families.   Attend any required meetings planned by grant giving agencies. Evaluate program effectiveness. Counseled individuals and families regarding mental health, substance abuse, physical abuse and rehabilitation issues. Spearheaded and conducted community outreach efforts.  Referred patients to psychiatric and medical examinations, as well as to family assessment planning teams.  Testified under oath to help the court make custody decisions.  Offered therapeutic services and crises intervention to emotionally disturbed children and adolescents.  Referred clients to social services agencies.  Solicited advice and guidance from senior personnel and other experts when difficult or atypical situations developed.  Completed case plans for clients goals House- Manger Assistant/ House ParentTwin Cedars Second Chance – Columbus, GAJune 2008 to January 2011Supervision of residents of facility, ages 14- 21 (teen pregnancy).  Coordination of appointments with physicians and community agencies.  Budget bills and spending of the resident and throughout the company.  Maintains supplies inventory by checking stock to determine inventory level duties.  Running errands and performing necessary tasks. Supervision of other household staff, such as housekeepers and etc.  Administered prescribed medication in pill, liquid and shot format.  Modeled appropriate activities and positive behavior management.  Participated in home visits, parent meetings and developmental screenings.  Set up children’s play areas, bookshelves and nap time areas daily.  Repaired office equipment and children’s play area toys. Administered medication and minor first aid to sick and injured students.  Updated records of contact, medical and progress information.  Promoted good behavior by using the positive reinforcement method. Houseparent/ Night ReceptionistFoundation Group Home – Bremen, GAOctober 2007 to June 2008Administered medication and minor first aid to sick and injured students.  Engaged with children individually to meet their emotional and physical needs.  Repaired office equipment and children’s play area toys.  Updated records of contact, medical and progress information.  Reported parent complaints and comments to managers.  Promoted good behavior by using the positive reinforcement method.  Screened and prepared children for enrollment.  Maintained daily records of children’s individual activities, behaviors, meals and naps.  Maintained accurate and detailed records of enrollments, attendance, health and safety, emergency contact information and incident reports.  Used constructive problem-solving techniques to resolve parent disputes. Clerk/ InternshipGlen County DFCS – Brunswick, GAJanuary 2006 to August 2007Met with clients to update them on progress of cases.  Handled understaffing, disputes, terminating employees and administering disciplinary procedures.  Resolved employment-related disputes through proactive communication.  Administered compensation, benefits and performance management systems and safety and recreation programs.  Analyzed and modified compensation and benefits policies to establish competitive programs and ensure compliance with legal requirements.  Coordinated work activities of subordinates and staff relating to employment, compensation, labor relations and employee relations.  Represented organization at personnel-related hearings and investigations.  Edited job position announcements before authorizing a post.  Updated presentation documents for the compensation committee to review.  Evaluated timecards for accuracy on the regular and overtime hours. EducationBachelor of Science in Human Services/Family and Child ServicesUniversity of Phoenix Columbus – Columbus, GAOctober 2016Associate of ArtsUniversity of Phoenix Columbus – Columbus, GAAugust 2013Certificate in Business Office TechnologyContinental Academy – Brunswick, GAAugust 2007SkillsFILING (2 years), RECEPTIONIST (2 years), TELEPHONE (7 years), 30 WPM (Less than 1 year), BILLING (2 years)Certifications/LicensesAdd your certificationsAdditional Information  Skills  Typing – 45 wpm  Filing and data entry  Multi-line telephone use  Bookkeeping experience Microsoft Word, Excel, PowerPoint Billing Excellent customer service skills Troubleshooting skills  

Case Study: Starbucks JC

/in /by

Read the three articles noted below about an actual union-organizing effort involving Starbucks in New York City:

After reading all the articles and considering additional research, address the following questions (feel free to use supplemental authoritative resources in your response):

  • Do you think the administrative law judge and the National Labor Relations Board (NLRB) went too far in overruling Starbucks? Why or why not?
  • How much leeway should an employer have in setting standards for conduct, customer interaction, and attire in the workplace?
  • Does the NLRB decision unfairly limit Starbucks in the management of the stores? Why or why not?
  • What is your view of the court’s decision?

Requirements of submission: Short paper assignments must follow these formatting guidelines: 1-2 pages, double spacing, 12-point Times New Roman font, one-inch margins, and discipline-appropriate citations.

Critical Elements

Exemplary (100%)

Proficient (85%)

Needs Improvement (55%)

Not Evident (0%)

Value

Main Elements

Includes all of the main elements and requirements and cites additional information to illustrate each element

Includes all of the main elements and requirements

Includes some of the main elements and requirements

Includes few or none of the main elements and requirements

25

Inquiry and Analysis

Provides in-depth analysis that demonstrates complete understanding of all concepts

Provides in-depth analysis that demonstrates complete understanding of most concepts

Provides analysis that demonstrates understanding of some concepts

Does not provide analysis and/or shows lack of understanding of concepts

20

Integration and Application

All of the course concepts are correctly applied

Most of the course concepts are correctly applied

Some of the course concepts are correctly applied

Does not correctly apply any of the course concepts

10

Critical Thinking

Draws insightful conclusions that are thoroughly defended with evidence and examples

Draws informed conclusions that are justified with evidence

Draws logical conclusions, but does not defend with evidence

Does not draw logical conclusions

20

Research

Incorporates many scholarly resources effectively that reflect depth and breadth of research

Incorporates some scholarly resources effectively that reflect depth and breadth of research

Incorporates a few scholarly resources that reflect depth and breadth of research

Does not incorporate scholarly resources that reflect depth and breadth of research

15

Writing (Mechanics/Citations)

No errors related to organization, grammar and style, and citations

Minor errors related to organization, grammar and style, and citations

Some errors related to organization, grammar and style, and citations

Major errors related to organization, grammar and style, and citations

10

Total

100%

Biggest Challenges Facing Organizations in the Next 20 Years

/in /by
  1. Biggest Challenges Facing Organizations in the Next 20 Years
    In this assignment, you will create a PowerPoint presentation outlining what you anticipate will be the biggest challenges facing organizations in the next twenty years.
    Prepare an eight-slide presentation in which you include:

    1. A title slide.
    2. A slide with an introduction to your presentation.
    3. A slide listing your chosen five challenges you believe organizations will face in the next 20 years.
    4. One slide for each of the five challenges and your explanation for choosing that challenge.
    5. A summary slide that addresses key points of your paper.
    6. Recorded narration for your presentation, indicating what you would say if you were actually presenting in front of an audience.
    7. This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions.
      The specific course learning outcome associated with this assignment is:
    • Analyze organizational behavior challenges faced by management professionals.
  2. By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution’s policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.

Finc615 unit4 worksheet

/in /by

 complete the work sheet plagiarism 

Respond to the following scenario with your thoughts, ideas, and comments. Be substantive and clear, and use research to reinforce your ideas.

Over lunch, you and Mary meet to discuss next steps with the expansion project.

“Do we have everything we need on sales and costs?” you ask. ”It must be time to compute the net present value (NPV) and internal rate of return (IRR) of the Apix expansion project.”
“We have the data from James and Luke regarding projected sales and costs, respectively, for the food packaging project,” says Mary. “It is feasible to project that we will receive a tax break from this implementation. I have information from our audit firm that indicates that future depreciation methods for taxes will be straight-line; however, the corporate rates will be reduced to 35% as we assumed in our weighted average cost of capital (WACC) calculation.”
“That sounds good,” you say.
“Right,” says Mary. “You can use a WACC of 10% for the computation of the NPV and comparison for IRR.”
“I’ve got the information I need from Luke and James,” you say. “Does this look right to you? Here’s what they gave me,” you say, as you hand a sheet of paper to Mary.“Let’s look at this now while we’re together,” she says.

The information you hand to Mary shows the following:

  • Initial investment outlay of $30 million, consisting of $25 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year
  • Project and equipment life: 5 years
  • Sales: $25 million per year for five years
  • Assume gross margin of 60% (exclusive of depreciation)
  • Depreciation: Straight-line for tax purposes
  • Selling, general, and administrative expenses: 10% of sales
  • Tax rate: 35%

You continue your conversation.

“It looks good,” says Mary. “Use this information from Luke and James to compute the cash flows for the project.”
“No problem,” you say.
“Then, compute NPV and IRR of the project using the Excel spreadsheet I sent earlier today,” says Mary. “Use the IRR financial function for the computation of IRR.”
“Okay,” you say. “I’ll submit my Excel file showing the computation of cash flows, NPV, and IRR by the end of week so you can look at it over the weekend.”
“Thanks,” says Mary.

Complete the above worksheet for this assignment.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.