Question

A company is making an investment of $2,180,262 that will yield the following cash flows: Year...

A company is making an investment of $2,180,262 that will yield the following cash flows:

Year 1 $254,800
Year 2 $422,300
Year 3 $713,200
Year 4 $797,700
Year 5 $1,059,982



Click here to view factor tables

What is the internal rate of return of the investment? (Round present value factor calculations to 4 decimal places, e.g. 1.2151 and final answer to 0 decimal places, e.g. 12%.)

Internal rate of return enter internal rate of return in percentage rounded to 0 decimal place %

Homework Answers

Answer #1

The Internal Rate of Return will be 12%

Since you have not provided the factor table therefore IRR is calculated using Excel.

First you need to arrange data in year wise and then You just need to use the formula of IRR in excel.

I hope this clear your doubt.

Feel free to comment if you still have any query or need something else. I'll help asap.

Do give a thumbs up if you find this helpful.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
An investment that costs $253,406 will reduce operating costs by $32,130 per year for 11 years....
An investment that costs $253,406 will reduce operating costs by $32,130 per year for 11 years. Determine the internal rate of return of the investment (ignore taxes). (Round present value factor calculations to 4 decimal places, e.g. 1.2151 and final answer to 0 decimal places, e.g. 17%.) Click here to view factor tables Internal rate of return enter internal rate of return in percentages rounded to 0 decimal places % Should the investment be undertaken if the required rate of...
Using the appropriate interest table, answer each of the following questions. (Each case is independent of...
Using the appropriate interest table, answer each of the following questions. (Each case is independent of the others.) Click here to view factor tables What is the future value of $7,020 at the end of 7 periods at 8% compounded interest? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.) The future value $enter the future value in dollars rounded to 0 decimal places eTextbook and Media Click here to view...
John Freeman is investing $8,006 at the end of each year in a fund that earns...
John Freeman is investing $8,006 at the end of each year in a fund that earns 6% interest. Click here to view factor tables In how many years will the fund be at $92,000? (Round answer to 0 decimal places, e.g. 45.) Years Newman Quincy wants to withdraw $30,000 each year for 8 years from a fund that earns 4% interest. Click here to view factor tables How much must he invest today if the first withdrawal is at year-end?...
Novak Corporation, having recently issued a $20,075,700, 15-year bond issue, is committed to make annual sinking...
Novak Corporation, having recently issued a $20,075,700, 15-year bond issue, is committed to make annual sinking fund deposits of $625,000. The deposits are made on the last day of each year and yield a return of 10%. Click here to view factor tables Determine the amount of deficiency. (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.) Deficiency $enter a dollar amount rounded to 0 decimal places
1, Leon Taylor is settling a $19,080 loan due today by making 6 equal annual payments...
1, Leon Taylor is settling a $19,080 loan due today by making 6 equal annual payments of $4,640.74. Click here to view factor tables Determine the interest rate on this loan, if the payments begin one year after the loan is signed. (Round answer to 0 decimal places, e.g. 8%.) 2, Sally Alvarez is investing $395,500 in a fund that earns 9% interest compounded annually. Click here to view factor tables What equal amounts can Sally withdraw at the end...
Chris Quincy wants to withdraw $35,600 each year for 9 years from a fund that earns...
Chris Quincy wants to withdraw $35,600 each year for 9 years from a fund that earns 4% interest. Click here to view factor tables How much must he invest today if the first withdrawal is at year-end? How much must he invest today if the first withdrawal takes place immediately? (Round factor values to 5 decimal places, e.g. 1.25124 and final answers to 0 decimal places, e.g. 458,581.) First withdrawal at year-end $enter a dollar amount rounded to 0 decimal...
Using the appropriate interest table, compute the present values of the following periodic amounts due at...
Using the appropriate interest table, compute the present values of the following periodic amounts due at the end of the designated periods. Click here to view factor tables $50,440 receivable at the end of each period for 8 periods compounded at 11%. (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.) Present value $ Click here to view factor tables $50,440 payments to be made at the end of each period...
Joanne Quick made an investment of $23,016.97. From this investment, she will receive $2,600 annually for...
Joanne Quick made an investment of $23,016.97. From this investment, she will receive $2,600 annually for the next 13 years starting one year from now. Click here to view the factor table Future Value of 1 Click here to view the factor table Future Value of an Annuity of 1 Click here to view the factor table Present Value of 1 Click here to view the factor table Present Value of an Annuity of 1 (For calculation purposes, use 5...
The Bramble Company is planning to purchase $487,000 of equipment with an estimated 7-year life and...
The Bramble Company is planning to purchase $487,000 of equipment with an estimated 7-year life and no estimated salvage value. The company has projected the following annual cash flows for the investment: Year Projected Cash Flows 1 $207,000 2 132,000 3 109,000 4 51,700 5 61,200 6 44,400 7 46,300 Total $651,600 Click here to view the factor table. Calculate the net present value of the proposed equipment purchase. Bramble uses a 11% discount rate. (For calculation purposes, use 4...
Wildhorse Co. earns 9% on an investment that will return $530,000 9 years from now. Click...
Wildhorse Co. earns 9% on an investment that will return $530,000 9 years from now. Click here to view the factor table. (For calculation purposes, use 5 decimal places as displayed in the factor table provided.) What is the amount Wildhorse should invest now to earn this rate of return? (Round answer to 2 decimal places, e.g. 5,275.25.) Wildhorse Co. should invest $enter an amount to be invested in dollars rounded to 2 decimal places Blossom Company earns 4% on...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT