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
What is the most common method of measuring flows of trade?
kakasveta [241]

The most common method to measure flows of trade is the comparison between the exportation of merchandise, services, and the capital of the countries.

<h3>What is trade?</h3>

Trade is the situation where the countries buy (import) from or sell (export) to the countries outside the boundaries of their own territories.

Exports referred to the scenario where one country provides goods and services to another country abroad. The comparison of goods, services, and monetary capital of foreign countries with respect to their own countries can be used as a common method to measure the trade flows.

Therefore, the exporting of goods, services, and capital to other countries is the method to determine trade flows.

Learn more about the trade from the related link:

brainly.com/question/3617318

#SPJ4

4 0
2 years ago
Joe sends for a MBA catalog from State University. According to the catalog, the MBA applications are evaluated on the basis of
irinina [24]

Answer:

The answer is: C) There is a valid contract

Explanation:

According to Appellate Court ruling in Steinberg v. Chicago Medical School;

The two parties (Joe and Sate University) entered a valid contract agreement upon receiving the $100 dollar application fee from Joe. State University´s catalog is considered to be the Offer part of this contract and the $100 application fee is considered the Consideration part of the contract.

7 0
4 years ago
If the owner of a children's day-care center were to answer the question, "what business are you in?" with the statement, "We nu
S_A_V [24]

Answer:

Yes is a  market-oriented mission statement.

Explanation:

Small businesses solve problems and offer solutions for a customer's needs. A market-oriented mission statement defines a purpose that focuses on satisfying a customer's needs. The purpose of a market-oriented mission should match current market data and environments

5 0
3 years ago
You just acquired a home mortgage for 30 years in the amount of $184,500 at 4.65 percent interest, compounded monthly. How much
alex41 [277]

Answer:

EMI=P*r * (1+r)^n/(1+r)^n-1

Where EMI= equal monthly installments

P=Principal amount

r=rate of interest

n=numer of periods

Explanation:

P=$184,500

r=4.65%/12=.3875%

n=30*12=360

EMI=$184,500*.3875%*(1+.3875%)^360/((1+.3875%)^360-1)

EMI=$951

Interest in first monthly installment=$715

Principal Amount in first monthly installment=$236

7 0
3 years ago
"Maple Corp. had net sales of​ $217,550 for the year ended December​ 31, 2017. Its beginning and ending total assets were​ $94,2
BaLLatris [955]

Answer:

2.09

Explanation:

Asset ratio is  a business tool used to measure the efficiency of assets towards sales generation by comparing net sales to average total assets.

It is calculated by dividing the net sales by average total assets.

The average total assets is used in order to make allowance for fluctuation in the course of business year

<u>Workings</u>

Net sales = $217550

Opening total asset = $94200

Closing Total assets = $ 113500

Asset ratio turnover = 217550/(94200+113500)/2

=2.09

7 0
4 years ago
Other questions:
  • Which of the following choices is not an example of a transferable skill
    6·1 answer
  • Which one of the following statements related to annuities and perpetuities is correct? Multiple Choice An ordinary annuity is w
    15·1 answer
  • Petromax Enterprises uses a continuous review inventory control system for one of its SKUs. The following information is availab
    11·2 answers
  • Palante actually produced 8,000 units. The controller decided to compare their actual results to their budget. The following bud
    5·1 answer
  • Suppose that investment is $130 billion, saving is $110 billion, government expenditure on good and services is $120 billion, ex
    13·1 answer
  • Facing and resolving ethical dilemmas is challenging. However, ethical guidelines, combined with self-examination, can help you
    8·1 answer
  • Harris Supply has sales of Sales of $230, Cost of Goods Sold of $78, Depreciation of $40 and Interest Expense of $12. If their t
    5·1 answer
  • What must people taking out a mortgage agree to? Check all that apply. A loan amount plans for repairs an interest rate renovati
    10·2 answers
  • alpha corporation began using the mark zing for chocolate candy bars in new york and new jersey in 2010. in 2015, without any kn
    6·1 answer
  • On a linear demand curve, if the price is low and the quantity demanded is high, demand is _____ in that region and a price incr
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!