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
Candice tells Yuri that she wants to hear his ideas about the Q4 Finance Report, and Yuri says that they should compare it to la
Sloan [31]

c.

Arrogantly

Explanation:

What Candice is saying here basically boils down to 'we don't need to compare this to last year's performance as I want to see positive results not negatives'<u> insinuating that the performance has become worse in the last year.</u>

<u>Regressions in a financial report mean weaker performance over the fiscal year while projections mean that the performance was better.</u>

4 0
3 years ago
Net present value LO P3 Beyer Company is considering the purchase of an asset for $250,000. It is expected to produce the follow
Marysya12 [62]

Answer:

$20,996.49

Yes

Explanation:

Net present value is the present value of after tax cash flows from an investment less the amount invested.

NPV can be found using a financial calculator.

Cash flow in year 0 = $-250,000

Cash flow in year 1 = $83,000

Cash flow in year 2 = $43,000

Cash flow in year 3 = $76,000

Cash flow in year 4 = $127,000

Cash flow in year 5 = $49,000

I = 12%

NPV = $20,996.49

The company should accept the project because the NPV is postive.

To find the NPV using a financial calacutor:

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 NPV button, input the value for I, press enter and the arrow facing a downward direction.

3. Press compute

I hope my answer helps you

8 0
3 years ago
Read 2 more answers
A father and mother are planning a savings program to put their daughter through college. Their daughter is now 8 years old. She
Anna71 [15]

Answer:

$4,102.57

Explanation:

we must first calculate the future costs of college:

cost of college year 1 = $16,200 x (1 + 2%)¹⁰ = $19,747.71

cost of college year 2 = $19,747.71 x 1.02 = $20,142.66

cost of college year 3 = $20,142.66 x 1.02 = $20,545.51

cost of college year 4 = $20,545.51 x 1.02 = $20,956.42

in order to determine how much money does the family need to have before college starts we must discount the cost of college by 7.5%:

PV cost of college year 1 = $19,747.71

PV cost of college year 2 = 20,142.66 / 1.075 = $18,737.36

PV cost of college year 3 = $20,545.51  / 1.075² = $17,778.70

PV cost of college year 4 = $20,956.42  / 1.075³ = $16,869.09

total = $73,132.86

the future value of the grandmother's deposits:

$13,000 x (1 + 7.5%)¹⁴ = $35,781.77

$2,900 x (1 + 7.5%)¹² = $6,907.16

total = $42,688.93

that means that you will need to save $73,132.86 - $42,688.93 = $30,443.93 by the time your child turns 18

you will make 4 deposits and their future value will be:

deposit x 1.075¹⁰ = 2.0610D

deposit x 1.075⁹ = 1.9172D

deposit x 1.075⁸ = 1.7835D

deposit x 1.075⁷ = 1.6590D

total = 7.4207D

yearly deposit = $30,443.93 / 7.4207 = $4,102.57

4 0
3 years ago
How would a decrease in the price of the feed grains used to feed cattle affect the market for beef? a. The demand for beef woul
denis23 [38]

Answer: The supply of beef would increase, decreasing beef prices.

Explanation: if there is a decrease in the price of the feed grains used to feed cattle, it would leads to an increase in the supply of beef in the market and consequently decrease the price of beef in the market. It would result to an increase in the supply of beef because the cattle rearers would have enough feeds for the cattle which will make them grow faster.

5 0
3 years ago
Assume that Verizon Communications, Inc. reports the following selected balance sheet and income statement information for 2012
GalinKa [24]

Answer:

TIE 6.26238

Explanation:

Times Interest Earned:

\frac{EBIT}{Interest \: Expense} = 6.26238

EBIT = earnings before Interest and Taxes

\frac{13,652}{2,180} = 6.26238

4 0
3 years ago
Other questions:
  • "A broker-dealer who acted as financial advisor to a municipality in structuring a new issue now wishes to act as underwriter in
    8·1 answer
  • Retailer opened a baseball card store in vacant prem- ises next to an existing store. The card shop was very busy on opening day
    11·1 answer
  • Acme Manufacturing Company’s controller was classifying costs for the most recent financial statement period. Which of the follo
    7·1 answer
  • How much unused lending capacity does eternal savings have at step 4?
    12·1 answer
  • A municipal bond is paying a 6 percent annual yield. An equivalent risk corporate bond is paying 7 percent. Investors with a tax
    8·1 answer
  • A __________ represents a long-term partnership between two or more companies established to help each firm build competitive ma
    10·1 answer
  • How much must be deposited at the beginning of each year in an account that pays 4%, compounded annually, so that the account wi
    15·1 answer
  • Following are account balances (in millions of dollars) from a recent FedEx annual report, followed by several typical transacti
    14·1 answer
  • If you are a jury member, which of these are topics you might discuss with the other jurors during trial? (Select all that
    8·1 answer
  • List the 5 tests of whether personal property has become a fixture
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!