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
algol [13]
3 years ago
14

You have been asked to calculate the internal rate of return for an investment with the following cash flows, using the Excel IR

R function: The cost of the investment is $500,000. Cash flows in years 1 through 5 are $200,000; $160,000; $120,000; $80,000; and $40,000, respectively. The residual value of the investment is $25,000. Using Excel's IRR function, what is the internal rate of return on the investment after 5 years
Business
1 answer:
marusya05 [52]3 years ago
6 0

Answer:

9.92 %

Explanation:

The Summary of Cash flows to use in the calculation are as follows :

Year 0 = ($500,000)

Year 1 = $200,000

Year 2 = $160,000

Year 3 = $120,000

Year 4 = $80,000

Year 5 = ($40,000 + $25,000) = $65,000

therefore,

the internal rate of return on the investment after 5 years is 9.92 %

You might be interested in
Total (10 marks) QUESTION TWO Amani Ltd. Manufacturers a single product. Currently, the company has eight employees who produce
rewona [7]
Since the unsigned is 3000 it’s
5 0
2 years ago
What do you feel is the most important thing that you can do when saving money and what are some other ways you can save money.
Gnesinka [82]
Check your stuff to see what you already have and what you need.To go around buying everything you want just because its pretty.
4 0
3 years ago
Monica heard that as a general rule, she should spend no more than one week's pay on rent. If Monica's salary is $42,068 per yea
BlackZzzverrR [31]
The answer is $809. There are 52 weeks in a year, so $42,068/52 = $809.
8 0
4 years ago
Read 2 more answers
When i grow up i would like to be a real estate agent and also create my own business
Anarel [89]

Answer:

re write to (after high school i would follow my dreams and seek my future to become knows as a real estate agent and would love to become one good salary and a wealth living for my future family) -there you go add more if its not enough

Explanation:

7 0
3 years ago
Read 2 more answers
50 points. Ethics are essential in good accounting. For this assignment, find examples of poor ethical behavior in accounting an
Alexxandr [17]

Answer:

Ethics of accounting information is providing accounting information to make good economic decisions in the financial statement of the organization.

Explanation:

8 0
3 years ago
Other questions:
  • Why is hazard city at more risk for lahars than hutton or wrightstown, even though they are closer to lava mountain than hazard
    13·1 answer
  • The income statement of Sunland Company for the month of July shows net income of $2,760 based on Service Revenue $7,160, Salari
    14·1 answer
  • The cost of a completed job in a job-order costing system typically consists of the actual direct materials cost of the job, the
    5·1 answer
  • ne of the most important financial management activities that a firm undertakes is its evaluation and allocation of investment f
    9·1 answer
  • The original cost of the truck was $32,000. What would be the journal entry for Combs Co. to record the disposal of the delivery
    5·1 answer
  • 6. You own a coal mining company and are considering opening a new mine. The mine will cost $120.0 million to open. If this mone
    9·1 answer
  • Choose the multiple choice answers which, when strung together, create an accurate definition of gdp. the u.s. nominal gross dom
    7·1 answer
  • While under contract to play professional basketball for the Philadelphia 76ers, Billy Cunningham, an outstanding player, negoti
    8·1 answer
  • In a balanced budget, the amount you ______ is ______ the amount you earn.
    8·2 answers
  • Could someone explain to me what the money market in Italy is, thank you all​
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!