Finance: Choosing the Right Investment Investment and Managerial Finance
Not what you're looking for?
Please help with the following problem. Provide the solutions in an Excel spreadsheet.
GRP Corporation has $500,000 in a bank account paying 0.35% annual interest. As an alternative to leaving the money in the account, the company is considering investing the entire amount for five years. possible investments have been identified as shown below.
Investment D is ten thousand shares of common stock which cost $50 per share and recently paid an annual dividend of $4.25 per share. The company has been increasing earnings and dividends at an average annual rate of 4%. The current market rate of return on a similar common stock is 12%.
Assuming that you will invest in only one of these (if any), which would you choose and why?
**needs to be done in excel
Purchase this Solution
Solution Summary
The following problem helps with a problem that involves choosing investments.
Solution Preview
See attached excel file for solution.
Answer: Given that,
Amount in bank $500.000
Annual interest 0,35%
Expected 5 year ...
Education
- MBA, Indian Institute of Finance
- Bsc, Madras University
Recent Feedback
- "I've posted a similar question for another course. It's post 657940, and it's a practice problem that I'd like to use for the final exam. Your help will be greatly appreciated. "
- "thank you!"
- "Thank you again Jayant. You are super fast. "
- "Thank you Jayant. You are appreciated. "
- "Again, thank you Jayant. You are wonderful. "
Purchase this Solution
Free BrainMass Quizzes
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.