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
Using the SMART goal-writing criteria, what refers to asking how to achieve the goal?
Deffense [45]

In SMART goal-writing criteria, the one that refers to being able to complete a goal is: Attainable

In determining a goal, we need to make sore that the Goal is possible based on our current ability, otherwise we just make ourselves and other people that we lead to a massive failure that could destroy our Morale as a team

3 0
3 years ago
Read 2 more answers
The current rates for an 80/20 mortgages are 4.15% for the first mortgages and 9.75% for the second mortgage. On a $200,000 30 y
olganol [36]

Answer: The actual rate of the mortgage is 5.27%.

Since we're taking two mortgages for a total of $200,000 for 30 years, we can find the actual rate of the mortgage by finding the weighted average of the two rates. The weights in this case will be the proportion of loan taken at each rate

We have

Rates       Weights      Rates * Weights

4.15            0.80     4.15 * 0.80 = 3.32

9.75             0.20    9.75 * 0.20 = 1.95      

Total                                             5.27%  

5 0
3 years ago
On January 1, 2018, Jacob Inc. purchased a commercial truck for $48,000 and uses the straight-line depreciation method. The truc
Norma-Jean [14]

Answer:

option (D) loss, $3,000

Explanation:

Given:

price of the truck = $48,000

estimated residual value = $8,000

Exchange price of the truck = $60,000

Trade allowance = $35,000

Since, straight line depreciation is given, thus,

Total depreciation = \frac{\textup{48,000−8,000}}{\textup{8}}

or

Total depreciation = $5,000 per year

Therefore,

the book value after two years

= Price of truck - total depreciation in two years

or

= $48,000 − ($5,000 × 2 years)

= $38,000

Now,

a trade allowance received ( i.e $35,000 ) is less than the book value

therefore a loss is recorded

The amount of loss = (Book value - trade allowance received)

or

The amount of loss =  $38,000 - $35,000 = $3,000

Hence, correct answer is option (D) loss, $3,000

5 0
3 years ago
A 28-year-old single investor has funds saved at a bank. He contacts an RR and wants to begin allocating funds to a retirement a
Contact [7]

Answer: a. 80% stocks, 20% bonds

Explanation:

Stocks are a better fit for young people for 2 reasons;

1. Younger people are usually more risk tolerant. This means that they can pick financial vehicles that are more reflective of this risk taking mentality such as Stocks.

2. As they are far from retirement, their main goal should be saving for retirement. Stocks offer a better chance as Capital Appreciation so that their investments will grow before they retire leaving them in a better position when they do.

Fixed income is more for the older generation so that they may be sure of stable income while they are in retirement.

At the same time, every portfolio should be diversified to avoid risk so 20% going to bonds is ideal.

6 0
3 years ago
Madison Park Co-op, a whole foods grocery and gift shop, has provided the following data to be used in its service department co
REY [17]

Answer:

Total cost Groceries department 4,103,238

Total cost Gif department 366,763

Explanation:

\left[\begin{array}{ccccc}&Administration&Janitorial&Grocerys&Gifs\\$employee hours&&350&2690&160\\$square feet&&&9200&800\\Direct \: Cost&190000&70000&3860000&350000\\$Allocate A&-190000&20781.25&159718.75&9500\\$Subtotal&&90781.25&4019718.75&359500\\$Allocate J&&-90781.25&83518.75&7262.5\\$Total&&&4103237.5&366762.5\\\end{array}\right]

Adminstration cost will be distributed among Janitorial, Groceries and Gifs

we add up the employee hours:

350 + 2690 +160 = 3200

Then, we cross multuply:

190,000 x 350/3200 = 20781.25

190,000 x 2690/3200 = 159718.75

190,000 x 160/3200 = 9500

we add them to their cost and then do the same for Janitorial.

9200+ 800 = 10,000

90781.25 x 9200/10000 = 83518.75

90781.25 x 800/10000 = 7262.5

giving the total cost of the operating departments.

7 0
3 years ago
Other questions:
  • Brady recently graduated from SUNY–New Paltz with his bachelor’s degree. He works for Makarov & Company CPAs. The firm pays
    6·2 answers
  • A perfectly competitive firm facing a price of $10 decides to produce 100 widgets. If its marginal cost of producing the last wi
    7·1 answer
  • What is one reason that more affluent individuals may experience better health?
    5·1 answer
  • Kota Toy Corporation manufactures lizard dolls in two departments, Molding and Assembly. In the Molding Department, plastic is i
    12·1 answer
  • International business differs from domestic business in that a firm operating across borders must deal with: Group of answer ch
    12·1 answer
  • Many government? programs, such as unemployment? compensation, operate on a deficit during recessions and a surplus during perio
    6·1 answer
  • On January 1, 2018, Surreal Manufacturing issued 570 bonds, each with a face value of $1,000, a stated interest rate of 3 percen
    15·1 answer
  • The information below pertains to Barkley Company for 2015.
    7·1 answer
  • If property rights are not well enforced, all of the following are likely to occur except;_________
    7·1 answer
  • 4. When the actual price of a good is above its equilibrium market price, competition
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!