Purchase Solution

MS Excel Exercises

Not what you're looking for?

Ask Custom Question

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) ...

Solution provided by:
Lokesh Jain, MSc
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.

View More Free Quizzes
Related BrainMass Solutions

  • Stock Dividends and Splits - Albatross Inc. and Husky Corp.

    For your review, attached is a fully formatted MS Excel spreadsheet containing the required journal entries for the issuance of dividends and stock spilts for the Albatross Inc. and Husky Corporation exercises.

  • 32 Review Problems

    For your review, I have attached a formatted MS Excel spreadsheet containing information for the completion of the various exercises contained in your original post.

  • Accounting Information Systems and Special Journals

    Exercises 7-1, 7-4, and 7-10 For your convenience, I have attached a formatted MS Excel spreadsheet containing the text below. Please feel free to contact me in the future in the event that additional assistance is required.

  • Project Risk Management

    Please use MS Excel (2003 or 2007). Please see the attachment. Which project to bid on? From the point of view of EMV it is appropriate to bid for Project 2 that is $50,000.

  • Depreciation and Journal Entries: A Taxi Company

    For your review, I have attached a formatted MS Excel spreadsheet containing detailed instructions and illustrations for completion of the posted depreciation exercises.

  • Descriptive Statistics and Probability Exercises

    http://office.microsoft.com/en-us/excel-help/skew-HP005209261.aspx MS Excel does not come with the ability to draw Box-and-Whisker plots, but the following website has steps to workaround this to make a chart close to the Box and Whisker: http://blog.immeria.net

  • Time Value of Money

    Each problem is solved by using functions in MS Excel.

  • Z-Test for Mean, Z-Test for Proportion, ANOVA

    A separate Excel sheet showing the ANOVA analysis has also been included.

  • Quantitative methods in healthcare management

    Use this template for your calculations and answers: • Excel template for Exercises 11.1 and 11.6 Note on using the Excel templates: Use the automated Excel tables in Sheets 1 and 3 to perform calculations, and Sheets 2 and 4 to record your answers

View More Related Solutions