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
Answer this question​
Talja [164]
Can you translate what it says to 3nglidh?
3 0
3 years ago
Suppose that Musashi, an economist from an AM talk radio program, and Rina, an economist from a university in Massachusetts, are
valina [46]

Answer:

  1. b. Differences in Values
  2. c. Tariffs and import quotas generally reduce economic welfare.

Explanation:

Economists are known to disagree with each other a lot especially when they adhere to different economic theories such as the Neoclassic or Keynesian theories. In this case, these economists having opposing viewpoints in relation to what the government is doing in regards to health insurance is most probably due to different economic values they hold.

Regardless of the values they subscribe to however, most economists usually support certain propositions and one of them is free trade. They believe that the presence of tariffs and import quotas serve to reduce economic welfare as there are deadweight losses and things are more expensive for consumers.

3 0
3 years ago
Suppose that flu shots create a positive externality equal to $8 per shot. Further suppose that the government offers a $11-per-
Ede4ka [16]

Answer:

The answer is: the equilibrium quantity is larger than the socially optimal quantity.

Explanation:

In order for the equilibrium quantity and the socially optimal quantity to be equal, the government subsidy should have been equal to the positive externality created by the flu shots ($8).  Since the government subsidy is larger, $11, then the equilibrium quantity will be higher (more flu shots supplied because of high subsidy).

4 0
3 years ago
Suppose First Main Street Bank, Second Republic Bank, and Third Fidelity Bank all have zero excess reserves. The required reserv
lapo4ka [179]

Answer:

a) First Main Street Bank's T-account (before the bank makes any new loans) will look as follows:

<u>                   Assets                         |                Liabilities                  </u>

Reserves                   $1,800,000 |  Deposits             $1,800,000

b) The effect of a new deposit on excess and required reserves when the required reserve ratio is 25% are as follows:

Amount Deposited (Dollars) = $1,800,000

Change in Excess Reserves (Dollars) = $1,350,000

Change in Required Reserves (Dollars) = $450,000

Explanation:

a) Complete the following table to reflect any changes in First Main Street Bank's T-account (before the bank makes any new loans)

A deposit of $1,800,000 by Yakov into his checking account at First Main Street Bank will lead to the creation of both an asset and a liability for First Main Street Bank.

The reserves on the asset side of the T-account of First Main Street Bank will therefore increase by $1,800,000. This gives the bank the opportunity to able to give loan to its other customers from the additional reserves.

On the other hand, the deposit of $1,800,000 by Yakov will be recorded as a demand deposit on the liability side of the T-account of First Main Street Bank. This is because it is possible for Yakov to withdraw his deposit at any time.

This transaction will therefore be reflected as follows:

<u>                   Assets                         |                Liabilities                  </u>

Reserves                   $1,800,000 |  Deposits             $1,800,000

b) Complete the following table to show the effect of a new deposit on excess and required reserves when the required reserve ratio is 25%.

Note: See the attached excel file to see how the table will actually look.

The required reserve ratio of 25% implies that First Main Street Bank is required by law to hold 25% of the new reserves which in this case is the initial deposits from Yakov.

By calculating this, 25% of $1,800,00 is $450,000 and it indicates an increase of $450,000 in the required reserve of First Main Street Bank.

After deducting 25% from 100%, we have 75% left. And 75% of $1,800,000 is $1,350,000. This $1,350,000 is the excess reserves that First Main Street Bank can use to give loans to other customers.

The breakdown is therefore as follows:

Amount Deposited (Dollars) = $1,800,000

Change in Excess Reserves (Dollars) = 75% * $1,800,000 = $1,350,000

Change in Required Reserves (Dollars) = 25% * $1,800,000 = $450,000

Download xlsx
5 0
3 years ago
Gar Co. factored its receivables without recourse with Ross Bank. Gar received cash as a result of this transaction, which is be
Thepotemich [5.8K]

Answer:

Answer for the following statement is "C"

Explanation:

  • Sale of Gar's receivable accounts to Ross, with the possibility of noncollectable accounts being passed to Ross.
  • Non-recourse factoring helps a corporation to offer its invoices to a component without any duty to accept unpaid invoices.
  • If consumers refuse to pay their bills or pay their invoices late, all damages are borne by the element, making the company unregulated.

7 0
3 years ago
Other questions:
  • If a firm uses no debt, the uncertainty inherent in projections of future returns on equity can be described as business risk.
    13·1 answer
  • Owens Finest Mattress Co., Inc. decided to employ an anti-mission statement. Which of the following phrases did they use?
    13·2 answers
  • A corporation distributes a piece of personal property to a shareholder, in complete liquidation. The corporation had a basis of
    5·1 answer
  • The Elvis Alive Corporation, makers of Elvis memorabilia, has a beta of 2.35. The return on themarket portfolio is 12%, and the
    9·1 answer
  • Unless otherwise prohibited, drivers must use the three-point turn to
    12·1 answer
  • Which of the following types of research refers to research conducted for a single firm to provide specific information its mana
    8·1 answer
  • The following information is available for Splish Brothers Corporation for the year ended December 31, 2022.
    10·1 answer
  • Which source can help entrepreneurs get access to advertisements and classified ads about potential suppliers?
    8·1 answer
  • Explain Business Management Definition
    9·1 answer
  • An increase in the price of a product will reduce the amount of it purchased because
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!