Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Business Economics Expert

NPV, IRR, PI and Payback Period

1. There are two mutually exclusive projects under consideration by the BUILDERS-R-US Company:

Year Project A Project B
0 -30,000 -50,000
1 10,000 15,000
2 10,000 15,000
3 10,000 15,000
4 10,000 15,000

The cost of capital is 10%.

find out the following values for each project using the time value tables and Microsoft Excel.

A) NPV

B) IRR (round to the nearest whole percentage using Microsoft Excel "IRR" function.)

C) Profitability index

D) Payback period

Prepare a brief memo advocating which project should be chosen and why. You must select a project and recommend it based on your analysis. Do not discuss the merits of both.

Business Economics, Economics

  • Category:- Business Economics
  • Reference No.:- M927252

Have any Question? 


Related Questions in Business Economics

Describe the considerations that have to be taken when

Describe the considerations that have to be taken when writing an application designed to drive a database by more than one simultaneous user?

1 why does robert reich refer to wealthy people politicians

1. Why does Robert Reich refer to wealthy people, politicians, lobbyists, and large corporations as "economic bullies"? 2. How do you feel about this issue and its importance to our economy now that you understand it bet ...

Caserespond to the following case using the irac format as

Case Respond to the following case using the IRAC format as described on the directions posted on MyCMU. There are written instructions posted as well as an audio explanation of how to do the assignment. The document sho ...

You are starting your own internet business you decide to

You are starting your own Internet business. You decide to form a company that will sell cookbooks online. Justcookbooks.com is scheduled to launch 6 months from today. You estimate that the annual cost of this business ...

In a duopoly where possible options are to retain the

In a duopoly where possible options are to retain the collusive price (collude) or to lower the price in attempt to increase the firm's market share (cut). Consider the following payoff matrix for a game in which two fir ...

Make a list of products and services which are least

Make a list of products and services which are least satisfactory and have shown the least improvement over time. How many of these are produced by government? Do you agree or disagree with this statement by Milton Fried ...

On august 30 2012 shares of stock in eli lilly were selling

On August 30, 2012, shares of stock in Eli Lilly were selling for $45.00 per share. On August 30, 2016, the shares were priced at $78.35. If you bought shares four years ago for $45.00 per share and sold them now for $78 ...

Consider the demand for coal with quantities in tons when

Consider the demand for coal with quantities in tons. When the price of coal decreases from $60 to $50, the quantity of coal demanded increases from 400 to 500 tons. Similarly the price of coal increases from $70 to $90, ...

In 2004 congressman dennis kucinich proposed the free

In 2004, Congressman Dennis Kucinich proposed the Free Market Drug Act. This legislation would have removed patent protection on drugs developed with public funds and given control over pharmaceutical R&D to the National ...

Social political and cultural influencesmany people within

Social, Political, and Cultural Influences Many people within a country may recognize how social, political, and cultural influences have an impact upon them. At the same time, social, political, and cultural influences ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate