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
PSYCHO15rus [73]
2 years ago
9

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. There is no residual value to the investment. Using Excel's IRR function, what is the internal rate of return on the investment after 3 years
Business
1 answer:
agasfer [191]2 years ago
4 0

Answer:

9.92 %

Explanation:

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
When frank sells a pie to jean instead of sarah, the economic value created in society is lower because of the difference in:.
Free_Kalibri [48]

When frank sells a pie to jean instead of sarah, the economic value created in society is lower because of the difference in consumer surplus.

What is consumer surplus?

Consumer surplus occurs when a consumer pays a price that is lesser for a goods than the actual price they are willing to pay for a product.

Difference in consumer surplus occurs because Frank now has more customers and he can now sell at a price lower than the consumer would pay.

Therefore, Frank sells a pie to jean instead of sarah,when the economic value created in society is lower because of the difference in consumer surplus.

Learn more on consumer surplus here,

brainly.com/question/3209988

5 0
2 years ago
Assume the following information for a company with only two products: Product A Product B Total Sales $ 600,000 $ 400,000 $ 1,0
Mice21 [21]

Answer: $406,000

Explanation:

The following can be deduced from the question:

Total sales = $1,000,000

Variable cost = $300,000

Contribution = Sales - Variable cost

= $1,000,000 - $300,000

= $700,000

Contribution ratio = $7000,00/$1,000,000 × 100 = 70%

Fixed cost = $580,000 × 70%

= $580,000 × 0.7

= $406,000

8 0
3 years ago
The payroll department provides services for several plants in the city of yee haw junction. the payroll department's budget is
Oksi-84 [34.3K]

Answer:

The amount that the lighting plant be charged from the payroll department for its services is $25,000

Explanation:

Provided data from the question:

Payroll budget = $100,000

number of checks issued per week = 4000

number of employees = 1000

Since, the service department charge rate is calculated as the total service department expense divided by total service department usage, the amount that should be charged from the payroll department for its services;

= $100,000 ÷ 4,000

= $25 × 1,000

= $25,000.

6 0
3 years ago
If a country's money supply is $10 million, and there is only one bank where all of the people deposit their money. If the bank
Luden [163]

Answer:

The money multiplier of the economy is 20

Explanation:

Money multiplier is the term of economics which is defined as the maximum amount, the money supply could rise grounded on the increase in the reserve in the system of banking.

The formula used for computing the money multiplier is as:

Money Multiplier = 1 / r

where

r is the reserve ratio that is 5%

So, putting the same value above:

Money Multiplier = 1 / 5%

Money Multiplier = 20

7 0
2 years ago
If a price is ______ the buyer's reservation price and ______ the seller's reservation price, then the price is in the bargainin
zimovet [89]

Answer:

Here's ur answer

Explanation:

option ( a ) Above // Below

If it's useful mark me as brainlist

3 0
2 years ago
Read 2 more answers
Other questions:
  • Southwestern Bank offers to lend you $50,000 at a nominal rate of 6.5%, compounded monthly. The loan (principal plus interest) m
    10·1 answer
  • Regan grows flowers and makes ceramic vases. Jayson also grows flowers and makes ceramic vases. Regan can produce 3 times as man
    5·2 answers
  • Alex invested $10,500 in an account that pays 6 percent simple interest. how much money will he have at the end of four years?'
    8·1 answer
  • Releasing more information, in a common-value auction is a. ​Good for the bidders because it reduces the risk that they face b.
    9·1 answer
  • After hurricane katrina, many states reevaluated their coastal area building requirements. these new building codes represented
    9·1 answer
  • Havermill Co. establishes a $250 petty cash fund on September 1. On September 30, the fund is replenished. The accumulated recei
    13·1 answer
  • Federal subsidies that are only given to dairy farmers who own more than one hundred cows may raise concerns about the ______ of
    8·1 answer
  • Janet needs to assign a very important advertising account to one of her writers. First she reviewed each​ writer's work​ load,
    6·1 answer
  • The United States Bureau of Labor Statistics (BLS) conducts the Quarterly Census of Employment and Wages (QCEW) and reports a va
    12·1 answer
  • Hussein got a call yesterday from First Bank, the company that issued his credit card inquiring about an $105.00 charge made in
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!