ZuoTi.Pro
Question

Use Microsoft Excel to determine the rate of return for a project that has an initial...

Use Microsoft Excel to determine the rate of return for a project that has an initial cost of $90,000 and would provide positive cash flows of $15,000 the first year, $17,000 the second year, $15,000 the third year, $21000 the fourth year, $23,000 the fifth year, and $35,000 the sixth year.

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
Use Microsoft Excel to determine the rate of return for a project that has an initial...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 34. Determine the internal rate of return for a project that costs -$156,000 and would yield...

    34. Determine the internal rate of return for a project that costs -$156,000 and would yield after-tax cash flows of $24,000 the first year, $26,000 the second year, $29,000 the third year, $31,000 the fourth year, $35,000 the fifth year, and $41,000 the sixth year.

  • Your company has an opportunity to invest in a project that is expected to result in...

    Your company has an opportunity to invest in a project that is expected to result in after-tax cash flows of $13,000 the first year, $15,000 the second year, $18,000 the third year, -$8,000 the fourth year, $25,000 the fifth year, $31,000 the sixth year, $34,000 the seventh year, and -$6,000 the eighth year. The project would cost the firm $67,100. If the firm's cost of capital is 12%, what is the modified internal rate of return?

  • 1 of 2 CHAPTER7 RATE OF RETURN ANALYSIS Problem1 An investment of $100,000 today, will pay...

    1 of 2 CHAPTER7 RATE OF RETURN ANALYSIS Problem1 An investment of $100,000 today, will pay 10 annual payments of $15,000 each. Compute the rate of return on this investment to the second decimal place. Problem 2 Determine the ROR for a project that has an initial cost of $82,000 and would provide positive cash flows of S12,000 the first year, $14,000 the second year, $16,000 the third year, $18,000 the fourth year, $20,000 the fifth year, and S15,000 the...

  • - Compute the inte or retu Positive cash nowS 000 the fourth year ST1000the Solutions return...

    - Compute the inte or retu Positive cash nowS 000 the fourth year ST1000the Solutions return for project that has an initial cost of $43.000 and would provide 2000 the first year(58,000xhe second year $9.000 the third year,S10 SXC) year, and $12,000 the sixth year. year, and 12,000 the

  • need help with this question Question 7 (2 points) Your company has an opportunity to invest...

    need help with this question Question 7 (2 points) Your company has an opportunity to invest in a project that is expected to result in after-tax cash flows of $7,000 the first year, $9,000 the second year, $12,000 the third year, -$8,000 the fourth year, $19,000 the fifth year, $25,000 the sixth year, $28,000 the seventh year, and - $6,000 the eighth year. The project would cost the firm $47,300. If the firm's cost of capital is 10%, what is...

  • Internal rate of return: For the project shown in the following​ table, Initial Investment $120,000 Year...

    Internal rate of return: For the project shown in the following​ table, Initial Investment $120,000 Year (t)   Cash inflows 1   $35,000 2   $40,000 3   $20,000 4   $40,000 5   $15,000 ​, calculate the internal rate of return ​(IRR). Then​ indicate, for the​ project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The​ project's IRR is ___​%.

  • EXCEL SOLUTION NEEDED: EXCEL FORMULA ONLY PLEASE The internal rate of return (IRR) is the rate...

    EXCEL SOLUTION NEEDED: EXCEL FORMULA ONLY PLEASE The internal rate of return (IRR) is the rate of return for a series of cash flows that results in a zero NPV. Excel's IRR function easily computes the IRR for a series of cash flows. What is the IRR for the project with the following cash flows? t Cash flow 0 $              (30,000) 1                     8,000 2                   10,000 3                   11,000 4                   17,000 5                   12,000 IRR:

  • A company is considering investing in a project. The project requires an initial investment of three payments, each...

    A company is considering investing in a project. The project requires an initial investment of three payments, each of RM105,000. The first is due at the start of the project, the second six months later, and the third payment is due one year after the start of the project. After 15 years, it is assumed that a major refurbishment of the infrastructure will be required, costing RM200,000. The project is expected to provide a continuous income stream as follows: •...

  • dont use excel , use formula 11. You are considering a project with an initial cash...

    dont use excel , use formula 11. You are considering a project with an initial cash outlay of 60.0 8 a project with an initial cash outlay of 60.000 Lira and expected free cash flows of 20.000 Lira at the end of each year for ra at the end of each year for 5 years. The required rate of return for this project is 12% (2p) A. Calculate the project's payback period. B. Calculate the project's NPV. (4p) C. Calculate...

  • You are analyzing a project with an initial cost of £50,000. The project is expected to...

    You are analyzing a project with an initial cost of £50,000. The project is expected to return £10,000 the first year, £35,000 the second year and £40,000 the third and final year. The current spot rate is £0.5086. The nominal return relevant to the project is 11 percent in the U.S. The nominal risk-free rate in the U.S. is three percent while it is five percent in the U.K. Assume that uncovered interest rate parity exists. What is the net...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT