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]
4 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]4 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
A prosecutor convened a grand jury to bring criminal charges against a pharmaceutical corporation. The charges were related to a
Rina8888 [55]

The answer is,  the Fifth Amendment privilege does not extend to the custodian of corporate records.

<h3>What defines a pharmaceutical company?</h3>
  • A pharmaceutical company, often known as a drug company, is a for-profit organization with a license to conduct medication research, development, marketing, and/or distribution, usually in the context of healthcare.

<h3>What is the role of pharmaceutical companies?</h3>
  • The pharmaceutical sector creates, produces, and markets pharmaceutical products. Its goal is not to define sickness.
  • The majority of drugs created by pharmaceutical corporations are designed to treat conditions that have already been identified as such by the medical community.

<h3>What is an example of pharmaceutical?</h3>
  • Pharmacies or prescribed medications are mentioned in the definition of pharmaceutical.
  • Prozac is an example of a pharmaceutical drug. (medicine) Of, pertaining to, or involving a pharmacy or pharmacists

Learn more about pharmaceutical corporation here:

brainly.com/question/27520309

#SPJ4

5 0
2 years ago
How is the unemployment rate calculated?
nasty-shy [4]

Answer:

hi, tge answer is C - Number of Unemployed Persons / Labor Force.

7 0
3 years ago
Flingers Inc. reveals the following information in their annual report for FY 2004. Earnings and Expenses Sales $10,000,000 Cost
Slav-nsk [51]

Answer:

25%

Explanation:

Given: Sales= $10,000,000

           Cost of goods sold= $5000000.

           Pre-tax earning= $500000.

           Merchandise inventory= $80000.

           Total assets= $2000000.

Now, computing the value of return on assets.

Formula; Return\ on\ assets= \frac{Net\ income}{Average\ total\ assets} \times 100

⇒ Return\ on\ assets= \frac{500000}{2000000} \times 100

⇒ Return\ on\ assets= 0.25 \times 100

∴ Return on assets= 25\%

Hence, Flinger´s return on assets is 25%

7 0
4 years ago
Taj operates a sole proprietorship, maintaining the business records under the cash-basis method of accounting. Taj performs ser
love history [14]

Answer:

Option D. $0

Explanation:

The reason is that Taj will have to recognize a bad debt expense of $12,000 which would decrease the receivable with the same amount.

The entry would be:

Dr Bad Debt Expense $12,000

Cr Accounts Receivables    $12,000

This means that the Taj will not reconize loss, all he will do is pass a bad debt expense entry. So the correct answer is option D.

3 0
4 years ago
What is TRUE about time as a factor in investing?
lbvjy [14]

Answer:

A. The more time the investor has, the more risk they can take because there is time to weather the declines in a stock and wait for it to regain some of its value before selling.

Explanation:

This is basically the reason why younger investors can afford higher risks than older investors. If you are 60 years old, you will probably invest in very secure stocks or bonds. Instead, when you are 25, you can afford investing in risky stocks that have higher than average growth potential.

5 0
3 years ago
Other questions:
  • Because all work ultimately entails some human interaction, effort, or involvement, Bossidy and Charan believe that focusing on
    15·1 answer
  • Which of the following is NOT a leading reason that employees resist change? Multiple Choice fear of failure individual predispo
    9·1 answer
  • It’s the top one cane somebody pls help
    7·1 answer
  • 8) A useful characteristic of money is that money
    15·1 answer
  • An arbitrage is best defined as Multiple Choice a legal condition imposed by the CFTC. the act of simultaneously buying and sell
    7·2 answers
  • You have just been hired as a brand manager of toothpaste for a large consumer products company. Your job mainly involves encour
    5·1 answer
  • Research that is theoretical in nature and is generally intended for the fundamental purpose of discovering new knowledge, with
    9·1 answer
  • Metro Event Planning Services collects fees from its customers in advance. On January​ 1, 2019, the balance of its Unearned Reve
    12·1 answer
  • In a freehold estate what describes when the ownership includes all immovable structures attached to the land such as buildings,
    11·1 answer
  • Using a price skimming strategy, Apple stakes out a price and then maintains and defends that price by significantly increasing
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!