CRITICAL THINKING ASSIGNMENT (120 points): Complete the following questions using

CRITICAL THINKING ASSIGNMENT (120 points):

Complete the following questions using Microsoft Excel. No other submission format is allowed. Review the grading rubric to confirm you are meeting the assignment requirements. 

Paderborn Industries is considering two investment projects. The estimated cash flow in SARs for each project is as follows:

Year

Plant Expansion 

(7,500,000)

Retail Store Expansion

(7,500,000)

1

2,200,000

3,050,000

2

2,200,000

2,700,000

3

2,200,000

2,050,000

4

2,200,000

1,650,000

5

2,200,000

920,000

Total

11,000,000

10,370,000

The company has decided that the appropriate discount rate is 10%.

Required:

  1. Calculate the payback for each project (to 3 decimal points).
  2. Calculate the Net Present Value (NPV) for each project.
  3. Calculate the Present Value Index (PI) for each project (round to 3 decimal places).
  4. Calculate the Internal Rate of Return (IRR) for each project (Round to 2 decimal places).
  5. Advise management on which, if either, project to pursue and why.

You must show all your work for credit.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

This discussion is based on a hypothetical situation You are

  This discussion is based on a hypothetical situation You are a campaign  advisor to Abraham Lincoln prior to the election of 1860, what do you tell Mr. Lincoln to do to calm the fears of Southerners that Lincoln and his election would lead to the abolition of slavery in

the Yukl (2013) text for its practical discussion on ethical

the Yukl (2013) text for its practical discussion on ethical leadership. Also, reflect on the important leadership and management theories and practices covered during the past six weeks. Share one key point about ethical leadership that is most relevant to your current (or prior) work situation. Also, share how this

Patriot Act & Homeland Security Act and Cyber Crime Prior

   Patriot Act & Homeland Security Act and Cyber Crime Prior to beginning work on this discussion read the Fong and Delaney (2013) (Links to an external site.) article and the Mitchell and Pate online resource (Links to an external site.). The destruction of the World Trade Towers, the attack on the Pentagon,

Bodies and brands as sources of poltical information: body languagr

Bodies and brands as sources of poltical information: body languagr and meaning-making in politics Approximately ten minutes, please reference scholarly sources, new and current affairs, emerging trends, showcase a text or artifact, or incorporate audio-visual resources to enhance our understanding of the selected seminar topic and assigned reading. and please

Each of your answers should be written using your own

Each of your answers should be written using your own words. Do not copy and paste from your textbook or an Internet source. Ensure you cite your work and add reference(s) at the end of your journal. These should be the sources you are citing in your work. Read Focal

Each healthcare organization has its own internal policies related to

Each healthcare organization has its own internal policies related to how data is managed. There are also federal guidelines and regulations regarding the use of patient data. The data harvested by healthcare organizations is no longer uniquely derived from HIT systems. Wearable technologies have emerged in the market. Mega companies

You are a professional career counselor. Your manager want to

You are a professional career counselor. Your manager want to make a speech to other  career counselors on how globalization impacts career counselling, right now, and how it will affect it in the future.  She thinks that transitions will be more frequent in future, partly related to globalization. But she

Article Summary: A list of references is included at the

  Article Summary: A list of references is included at the end of each chapter of the course textbook. Choose one of the references, locate that source, and summarize it offering a concluding section of analytical commentary. Do so using APA format in five typewritten pages plus reference page. Cite

Topic 10 DQ 2 Evidence-based practice is now widely recognized

 Topic 10 DQ 2 Evidence-based practice is now widely recognized as the key to improving healthcare quality and patient outcomes (Chien, 2019). So EBP is an essential component of the practice of a BSN-prepared RN. The BSN curriculum is more focused on EBP and providing high-quality education and skills training

Textbook – Principles of Information Systems Read Chapters 3 and

Textbook – Principles of Information Systems Read Chapters 3 and 4 in your textbook. Using the discussion link below, respond to the following prompts and questions: Discuss the interaction of application software with a computer’s hardware and operating system. How does the operating system act as a moderator between hardware

Myths and Fairytales – Premium Paper Help

Instruction   Imagine that you are directing a soon-to-be-staged production of a myth or fairy tale (choose one of the choices below) and that you are pitching your ideas to the producers (me). Your job is to convey your vision for the production and your ideal cast in order to

How should Facebook respond to the 2014 research situation? How

  How should Facebook respond to the 2014 research situation? How could an earlier response have helped the company avoid the 2018 controversies and keep the trust of its users? Should the company promise to never again conduct a survey of this sort? Should it go even further and explicitly

Chapter 3 drives your clinical project plan. Create a step-by-step

 Chapter 3 drives your clinical project plan. Create a step-by-step outline with brief notes from the beginning to the end of the planned capstone clinical hours. Each movement you have to make should be carefully planned out. How many days do you expect this to take? Have you avoided any

Instructions As part of the annual review conducted by the

Instructions As part of the annual review conducted by the safety and compliance department at your company, several situations were identified as potentially non-compliant. Here are some lab policy breaches that have occurred in a research lab: taking the backup supply of a critical reagent without reporting to supply personnel

rior to beginning work on this video presentation, read Fourth

  rior to beginning work on this video presentation, read Fourth Amendment: Search and Seizure (Links to an external site.), The Difference Between the 5th and 6th Amendment Right to Counsel (Links to an external site.), Probable Cause and Reasonable Suspicion (Links to an external site.), Saul Ornelas and Ismael Ornelas Ledesma, Petitioners

Below is a list of podcasts on some of the

  Below is a list of podcasts on some of the philosophical issues that we have been discussing. They are taken from the website Philosophy Bites, which I highly recommend for exploring philosophical topics After listening to one of the episodes, you should write a two-page reflection in which you

Preparing for a Speech Before a Security Professional Organization

Preparing for a Speech Before a Security Professional Organization Scenario: You are the Corporate Security Director for XYZ and a recognized leader in the security profession. You accept an invitation to speak at the ASIS International Seminar and Exhibits about the various security operational and other challenges with which organizations

Analyze the use of satire as a means of social critique in Jonathan

1. Your essays must be double-spaced and follow the standard essay format. You must use Times New Roman 12 point font or the default in word. 2. You are not required to do research for this essay. However, if you intend to include research sources, you must correctly cite your