Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Excel

Needs to be a EXCEL file 

Questions

1. An investment project provides cash inflows of $795 per year for eight years. a) What is the project payback period if the initial cost is $3,500? b) What if the initial cost is $5,000? c) What if it is $6,500?

2. Your firm wants to choose between two project options:

· Project A offers the following opportunity: $450,000 invested today will yield an expected income stream of $145,000 per year for five years, starting in Year 1.

· Project B requires an initial investment of $400,000, but its expected revenue stream is: Year 1 = 0, Year 2 = $50,000, Year 3 = $200,000, Year 4 = $300,000, and Year 5 = $200,000.

Assume that a required rate of return for your company is 12% and that inflation is expected to remain steady at 5% for the life of the project. Which is the better investment? Why?

3. Your vice president informs you that she has researched the possibility of automating your organization’s order-entry system. She has projected that the new system will reduce labor costs by $25,000 each year over the next five years. The purchase price (including installation and testing) of the new system is $100,000. The system is expected to have a useful life of five years, after which time it can be sold in the secondary computer systems market for $15,000.What is the net present value of this investment if the discount rate is 8.5% per year?

4. You are considering an investment in a startup that will cost $100,000 but you will receive a cash inflow of $25,000 every year for 5 years from the sale of products the startup will manufacture. The required return is 9%, and payback cutoff is 5 years. a) What is the payback period? b) What is the discounted payback period? (assume 5% discount rate) c) What is the NPV? d) What is the IRR? e)  Should we accept the project?

5. Your company is planning to introduce a new online shopping service.  To reduce risk, senior management propose developing the service in three stages:

a) A market test for one year with a few customers at a cost of $1 million. The likelihood of success for this test is estimated to be 75%.

b) A introductory period of one year, if the market test is successful. During this test the most widely ordered products will be available through the service to a wider audience. This phase of the project is estimated to cost $2.5 million with have a 50% chance of success.

c) Full roll-out of the service at the end of the second year if the introductory period is successful. This phase is estimated to cost $15 million and is expected to start generating revenue only by the end of the third year.

There are 3 possible outcomes from the full roll out:

Outcome

Probability

Year 4 Revenue

Year 5 Revenue

Year 6 Revenue

Year 7 Revenue

Huge Success

25%

$12M

$15M

$18M

$21M

Moderate Success

50%

$7M

$9M

$11M

$13M

Failure

25%

-$3M

-$4M

-$5M

-$6M

 i) Construct a decision tree and list all the outcomes and cumulative probabilities (it may be easier to construct the tree in a different program and copy and paste into Excel)

ii) Assume all the values are present values. Should the company pursue this project based on the expected NPV?

Grading Rubric

What: An Excel (or similar) file with solutions to the five questions above posted in your Assignments Folder.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

orientation

MGT 561 – Test 3 Essay Answers should be cited and referenced. You can do the references for all three at the end of all the essays or you can reference each one. The Answer should be 2-3 pages and double spaced. Be thorough in your answer. This work is

All Carpet Cleaner

How Often Should You Get Your Carpets Cleaned? Many people wait until their carpets look visibly dirty before cleaning them, but by that time, a lot of hidden dirt and allergens have already accumulated. The frequency of all carpet cleaning depends on a few key factors, including how much foot traffic

FEG Plus With Free Derma Roller Price in Lahore

Why Choose FEG Plus with Free Derma Roller? When you purchase FEG Plus, you not only get the powerful lash and brow serum but also a complimentary Derma Roller. The Derma Roller helps to enhance the absorption of the serum, allowing it to penetrate more deeply into the skin for

Business & Finance Assignment

Purpose: This assignment gives students an opportunity to apply principles of budget design, equity, and strategic planning to secure funding for an initiative that addresses an identified organizational need. It develops skills in resource justification, cost framing, and mission alignment. Assignment Description: Students will create a professional-style grant proposal seeking

I’m Working On This Question And I Need A Sample Draft To Help Me Study MKT600

Hide Assignment Information Turnitin™ This assignment will be submitted to Turnitin™. Instructions Objectives: LO1: The student will understand the role and content of the quality management plan for a project. LO2: The student will be able to develop a Quality Management Plan for a project. Instructions: Fill in the attached

short answer

instructions and reading attched Please answer the following questions. 1. In the ‘Turning the Tables’ reading there is a profile of first contract campaigns by the News Guild-CWA at the LA Times and at Law360. How did the organizing/bargaining committees use communication and mobilization during the negotiations to enhance their

HUM 102 Module Two Project

Please see attached file Unit Resources {Insert Unit Title]1.html Introduction The learning resources in this module will introduce you to the three topics that you’ll be able to choose from for your project and will provide you with examples of how the humanities relate to those topics. You’ll also learn

IDS 104 Module Two Journal Guidelines and Rubric

please see attached file. You will find 2 assignments. I will pay extra for both. Module Two Journal Guidelines and Rubric.html IDS 104 Module Two Journal Guidelines and Rubric Overview A growth mindset—the belief that abilities and intelligence can be developed through dedication and effort—is an essential skill for lifelong

Organizational Change

Describe a significant organizational change that you have witnessed or been a part of. Discuss its origins, impacts, and outcomes. Was it ultimately good for the organization? Were there winners and losers? Be sure to respond to at least TWO of your classmates’ posts.

Unit VIII

see attachment Unit VIII Assignment ABC Corporation has 3 plants across the United States in 3 different regions consisting of East, Central, and West. Last year, each plant purchased new equipment for their plants, and each plant earns the same income of $200,000. However, each plant required a different investment

Unit VII

see attachment Problem ABC Manufacuring Instructions: Direct Labor Budget for the Year Ending Dec 31, 202X 1. Review the data given, fill in the information in yellow cells to determine number of employees needed. Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Direct labor hours per unit 1 1

Foriegn

Topic Foreign exchange market  BUSI 606 Discussion Assignment Instructions The Discussions allow you the opportunity to apply what you have learned from the Module: Week’s readings. There are 2 parts to each Discussion: thread and replies. Both parts must be posted and written in a substantive manner, without spelling and

Keeping up with the joneses

 Research what the idiom; “Keeping up with the Joneses” means and relate how it can affect a person’s spending as they age. 2. It’s easier than ever to spend money today than it was in the past. Explain why this is so. 

Module 1 project 1 IDS-104

Please see attachment below Module One Short Paper Guidelines and Rubric.html IDS 104 Module One Short Paper Guidelines and Rubric Overview Digital communities are everywhere, from social media groups and online learning forums to gaming and hobby-based platforms. These spaces bring people together with shared interests, goals, or experiences, and

Module 1 Project 1

Please see attachment below for assignment details. Module One Short Answer Assignment Guidelines and Rubric.html HUM 102 Module One Short Answer Assignment Guidelines and Rubric Overview Creative works help us make sense of the world around us. This assignment will allow you to explore how creative works from the subject

Computer Applications in Accounting

image4.png image5.png image6.png image7.png image8.png image9.png image10.png image11.png image12.png image13.png image14.png image15.png image16.png image17.png image18.png image19.png image20.png image21.png image22.png image23.png image24.png image25.png image26.png image27.png image28.png image1.png image2.png image3.png

Case Study

   Your city is encouraging the use of reusable, eco-friendly water bottles to cut down on plastic waste. In the current local market, a reusable bottle sells for about $5, and each month about 10,000 bottles are sold. Surveys show some consumers are willing to pay up to $8 for