1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
dimulka [17.4K]
3 years ago
6

IRR in Excel!(CHAPTER 9) Your company is considering a new project opportunity. It would immediately receive $200. In return, in

the next 4 years it will need to pay the following amounts of money: In 1 year: $80 In 2 years: $70 In 3 years: $60 In 4 years: $50 The required annual rate of return is 19%. Answer the following questions: (a) The Internal Rate of Return for this project is . %. (Round your answer to TWO decimal places. Put your answer in percent, NOT in decimals. For example, if your answer is 12.34 percent, then you need to put 12.34, and NOT 0.12)
Business
1 answer:
oksian1 [2.3K]3 years ago
3 0

Answer:

12.44%

Explanation:

Internal rate of return is the discount rate that equates the after-tax cash flows from an investment to the amount invested

IRR can be calculated with a financial calculator  

cash floe in yer0 = 200

cash flow in year 1 = -80

cash flow in year 2 = - 70

cash flow in year 2 = - 60

cash flow in year 2 = - 40

irr = 12.44%

To find the IRR using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the IRR button and then press the compute button.  

You might be interested in
Integrating the information streams produced by a firm into a single, coherent enterprise-wide set of data, and then using model
e-lub [12.9K]

Answer:

business intellingence (BI) and business analytics (BA)

Explanation:

Business intelligence is aetgof that is focused on the present profitability of the business. It uses past data to better improve current processes aimed at meeting the firm's present needs.

Business analytics on the other hand is the use of past data to predict future action that will best enable a firm meet its business objectives.

Therefore business intelligence and business analytics involves integrating the information streams produced by a firm into a single, coherent enterprise-wide set of data, and then using modeling, statistical analysis tools, and data mining tools to make sense out of all these data so that managers can make better decisions and better plans.

6 0
3 years ago
You have been accepted into college. The college guarantees that your tuition will not increase for the four years you attend. T
Rasek [7]

Answer:

$73,254.81

Explanation:

We assume fees paid as annuity (PMT). Now, we have to find Present Value (PV) of annuity

PV = PMT*(1-  1/(1+r)^n) / r

Where PMT = 10000, n = 8 payments, r r = ​4.0%/2 = 2% = 0.02

PV = $10,000 * (1 - 1/(1+0.02)^8) / 0.02

PV = $10,000 *  (1 - 1/1.171659381) / 0.02

PV = $10,000 * 0.146509629 / 0.02

PV = $73254.8145

PV = $73,254.81

$73,254.81 is the money i must deposit today if i intend to make no further deposits and would like to make all the tuition payments from this account.

6 0
3 years ago
Suppose Foreign (Upper F )imposes a tariff on imports from Home (Upper H ). All else​ equal, this action will cause the​ long-ru
Orlov [11]

Answer:

D. increase; decrease

Explanation:

When foreign imposes a tariff on import from home then there will be decreaing the import leading to a decreased demand of domestic currency by foreigners.

Therefore, domestic currency will depreciate and foreign currency will appreciate thus this action will lead to real home/Foreign rate to increase and will decrease the nominal home/foreign exchange rate.

5 0
3 years ago
An organization looking for general agreement on ethical practices might take what step?
Kisachek [45]

An organization looking for general agreement on ethical practices might:<u> establish an ethical code of conduct.</u>

<h3>What is establish an ethical code of conduct?</h3>

Ethical code of conduct can be defined as a set of guidelines, policy, rules and regulation that a person is expected to follow and abide by in an organization.

This code of conduct enables us to know the organization norms and values as well  what is right and what is wrong which in turn means that it enables us to know the right things to do and thing to to avoid.

The code of conduct encourage ethical act which is to be honest and to have integrity among others and as well discourage unethical behavior in an organization which is why most organization has ethical code of conduct that enables their employee or workers to known the ethical ways they should behave.

Therefore an organization looking for general agreement on ethical practices might:<u> establish an ethical code of conduct.</u>

Learn more about establish an ethical code of conduct here:brainly.com/question/28465686

#SPJ1

4 0
1 year ago
You are the marketing officer for either a large hotel or a car dealer. Produce a report for
Klio2033 [76]
Hbvhhhbbhjj
Bbhbbbbbhh
5 0
2 years ago
Other questions:
  • What is markerting management
    9·1 answer
  • A high degree of managerial mobility in societies that emphasize individualism can lead to Group of answer choices increased man
    7·1 answer
  • The use of sharp, temporary price cuts as a form of _________________ would enable traditional US automakers to discourage new c
    8·2 answers
  • Suppose you have the following values for a short-run production process: Q = 20, VC = 100, FC = 600 and MC = 40. Given this, we
    8·1 answer
  • Question 3
    10·1 answer
  • Benjamin wants to become a biotechnologist and eventually run his own
    12·1 answer
  • Which is the most important decision factor in transportation?
    9·1 answer
  • CWN Company uses a job order costing system and last period incurred $82,000 of actual overhead and $100,000 of direct labor. CW
    9·1 answer
  • Washington Farms makes apple dumplings and apple pies using the same
    15·1 answer
  • A sum of $6,500 deposited in an account grows to $8,000 in 9 years. Assuming annual compounding, what interest rate is being pai
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!