Purchase Solution

Solving Rate of Return with Excel

Not what you're looking for?

Ask Custom Question

Here is the info I have for the problem I need to solve:

You have two investment opportunities. One will have a 10% rate of return on an investment of $500; the other will have an 11% rate of return on a principal of $700.

You would like to take an advantage of the higher yield investment but have only $500 available.

What is the maximum rate of return that you would pay to borrow the $200
need to take advantage of the high yield investment?

Purchase this Solution

Solution Summary

The expert solves the rate of return with excel.

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Operations Management

This quiz tests a student's knowledge about Operations Management