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
Skysong Corporation has retained earnings of $691,300 at January 1, 2020. Net income during 2020 was $1,552,100, and cash divide
just olya [345]

Answer:

                               Skysong Corporation

                       Statement of Retained Earnings

Retained earnings balance January 1, 2020               $691,300

Add:

Adjustments to 2019 Income Statement                       $88,390

Net profits 2020                                                          $1,552,100

Less:

<u>Dividends declared and distributed                            ($82,000) </u>

Retained earnings balance December 31, 2020      $2,249,790

Since the land purchase was recorded as maintenance expense by error, the 2019 income statement must be adjusted by adding that amount.

4 0
3 years ago
Drudgen Fitness Inc. is a fitness equipment provider that markets its products through a chain of retailoutlets in four states.
Anarel [89]

Answer:

4) buying and installing new computers in the new outlets

Explanation:

The five component model of information systems includes what a company needs to create is IT infrastructure and it includes:

  1. people: I firmly believe that people are the most important component of any system, at least until AI replaces us.
  2. hardware: refers to the equipment needed (e.g. computers, etc.)
  3. software: includes both system (windows or linux) and applications software (e.g. ERP software)
  4. database: the place where collected data is stored, e.g. physical storage devices or cloud storage
  5. network: the connections needed for different hardware to work together, e.g. cables, routers, internet service
8 0
3 years ago
Expansionary fiscal policies are designed to
DochEvi [55]
<span>A. Boost the economy Expansionary policies increase the money in supply to encourage spending, boost economic growth and counteract inflation.</span>
8 0
3 years ago
How does a bond issuer decide on the appropriate coupon rate to set on its bonds?
Novay_Z [31]

Answer

The answer and procedures of the exercise are attached in the following image.

Explanation  

Please consider the data provided by the exercise. If you have any question please write me back. All the exercises are solved in a single sheet with the formulas indications.  

4 0
3 years ago
Gugenheim, Inc., has a bond outstanding with a coupon rate of 7.7 percent and annual payments. The yield to maturity is 8.9 perc
Anna [14]

Answer:

Bond price= $1,793.62

Explanation:

Giving the following information:

Face value= $2,000

Number of periods= 17

Cupon rate= 0.077

YTM= 0.089

T<u>o calculate the price of the bond, we need to use the following formula:</u>

Bond Price​= cupon*{[1 - (1+i)^-n] / i} + [face value/(1+i)^n]

Bond Price​= 154*{[1 - (1.089^-17)] / 0.089} + [2,000/1.089^17)

Bond Price​= 1,324.21 + 469.41

Bond price= $1,793.62

3 0
3 years ago
Other questions:
  • At Milton farms, where a large part of the management comes from the same sociocultural background, many employees of diverse et
    5·1 answer
  • The economy is in the horizontal portion of the AS curve, investment spending is interest insensitive and there is no liquidity
    8·1 answer
  • Suppose 2-year treasury bonds yield 4.5%, while 1-year bonds yield 3%. r* is 1%, and the maturity risk premium is zero. using th
    9·1 answer
  • Every decision you make in a computer program involves evaluating one or more _____ expression
    11·1 answer
  • What is 40 divided by 31
    8·2 answers
  • If you were a systems administrator for a data center, what steps would you take to create and manage a data center to store the
    12·1 answer
  • Question 1<br> Describe the role of supply, demand, and competition in a free-enterprise system.
    15·1 answer
  • Since institutional investors own a large percentage of shares in many corporations they may have the ability to vote large bloc
    10·1 answer
  • Rosario and pamela work together. They are also friends outside of work. Rosario and pamela are constantly texting each other. T
    12·1 answer
  • Through effective ______, people can successfully resolve conflicts and create positive change. problem-solving strategies manag
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!