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
Giant Industries has a $674,232 gross operating income, operating expenses of $329,129, and other expenses totaling $38,719. Wha
Mekhanik [1.2K]

Answer:

$345,103 Is the answer I'm not good at explaining things so I won't attempt it.

5 0
2 years ago
Bravo company had $5,100 of supplies on hand at the beginning of 2016. on march 31 bravo purchased an additional $12,400 of supp
lana66690 [7]
Supplies expense is $11,400.00.

Expenses = Beg Inv + Addl Inv - Remaining
                 = 5,100 + 12,400 - 6,100
                 = 11,400
8 0
4 years ago
Read 2 more answers
Government is typically a​ ________.
xxTIMURxx [149]
Answer: D. net demander of funds because it borrows more than it saves

The government incurs more debts than gain profits as shown by most financial reports. The government is viewed similarly to that of business firms being net demanders by loaning huge amounts to financial institutions indirectly. The indirect borrowing done by government is done through debt security selling. 
8 0
3 years ago
A liquidity ratio measures the Group of answer choices income or operating success of an enterprise over a period of time. abili
mr Goodwill [35]

Answer:

short-term ability of the enterprise to pay its maturing obligations and to meet unexpected needs for cash

Explanation:

A liquidity ratio can be regarded as type of financial ratio which is been utilized in determination of a ability of a company to pay out its short-term debt obligations. The metric is way to determine if there is a possibility for company to use its current as well as liquid and assets to cover up for its current liabilities.

It should be noted that A liquidity ratio measures short-term ability of the enterprise to pay its maturing obligations and to meet unexpected needs for cash.

6 0
3 years ago
g Jana just found out that she is going to receive an​ end-of-year bonus of ​$32,200. She is in the 35 percent marginal tax brac
maria [59]

Answer:

Jana just found out that she is going to receive an​ end-of-year bonus of ​$32,200. She is in the 35 percent marginal tax bracket. Calculate her income tax on this bonus.

  • tax liability = $32,200 x 35%  = $11,270

Now assume that instead of receiving a​ bonus, Jana receives the ​$32,200 as a​ long-term capital gain. What will be her​ tax?

  • tax liability = $32,200 x 15% = $4,830

Which form of compensation offers Jana the best​ after-tax return?

  • if the bonus is taxed as a long term capital gain, she will páy less than half the taxes, so it is the best option for her

Would your calculation be different if the gain was​ short-term rather than​ long-term?

  • Short term capital gains are taxed at the same rate as ordinary income, so the difference between the bonus being a long vs short term capital gain is very significant to Jana.

8 0
3 years ago
Other questions:
  • Leon is catering a luncheon. He is only supplying the food. What kind of catering service is he providing?
    7·1 answer
  • The manager of the main laboratory facility at Elmhurst HealthElmhurst Health Center is interested in being able to predict the
    10·1 answer
  • How does a diversified investment portfolio reduce investors' risk of losing money?
    6·2 answers
  • All the following are necessary to effect mentoring except
    6·2 answers
  • Type the correct answer in the box. Spell the word correctly.
    5·2 answers
  • What is a loan?
    5·1 answer
  • Why do people buy franchise instead of expanding by opening more stores​
    9·2 answers
  • Gene Simmons Company uses normal costing in each of its three manufacturing departments. Factory overhead is applied to producti
    14·1 answer
  • When will their be a season two of Arcane?
    15·2 answers
  • Mcduff's boss told him he needs to be more concise in his report writing. to do this, mcduff should?
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!