MS Excel Exercises
Not what you're looking for?
How long would it take you to obtain $1,000,000 if you saved $2,500 quarterly and were able to obtain a 7% rate of return per year?
Calculate the current yield on a bond that has the following characteristics:
(a) NPER: 30, (B) Price--$1,125, (c) Coupon Rate: 6%, (d) Market Rate of Interest: 4%.
Calculate the Yield to Maturity on a bond that has the following characteristics:
(a) NPER: 25, Coupon Rate: 4%, and Price--$800.
Calculate the current market price of a bond that has the following characteristics:
(a) NPER: 23, (b) Yield to Maturity: 5%, and (c) Coupon Rate: 6%.
Purchase this Solution
Solution Summary
Solutions describe the steps to find the following by using built in functions in MS Excel :
a) Time period
b) YTM
c) Current yield
d) Market price
Solution Preview
Please refer attached file for better clarity of formulas in MS excel.
How long would it take you to obtain a $1,000,000 if you saved $2,500 quarterly and were able to obtain a 7% rate of return per year?
Rate=7%/4=1.75% Per quarter
PMT=-$2,500
NPER=?
FV=$1,000,000
Number of periods=NPER=119.8619454 =NPER(C3,C4,,C6)
(We have used the NPER function in MS Excel to get this value)
Time required=29.96548636 Years
Calculate the current yield on a bond that has the following characteristics: (a) ...
Education
- BEng (Hons) , Birla Institute of Technology and Science, India
- MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
- "Thank you"
- "Really great step by step solution"
- "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
- "Thanks Again! This is totally a great service!"
- "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Operations Management
This quiz tests a student's knowledge about Operations Management
Basics of corporate finance
These questions will test you on your knowledge of finance.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.