Purchase Solution

Sub Annual Time Value of Money

Not what you're looking for?

Ask Custom Question

I would like to have the solution to the following sample problems in EXCEL format so that I can see the formulas used. Thanks

1.A zero-coupon bond is a security that pays no interest, and is therefore bought at a substantial discount from its face value. If stated interest rates are 5% annually (with continuous compounding) how much would you pay today for a zero coupon bond with a face value of $1,200 that matures in 9 years?

Please round your answer to the nearest cent.

2. A financial institution offers a "double-your-money" savings account in which you will have $2 in 7 years for every dollar you invest today. What stated annual interest rate (assuming monthly compounding) does this account offer?

Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123).

3. You have $50,000 in savings for retirement in an investment earning a stated annual rate of 8% compounded semi-annually. You aspire to have $1,000,000 in savings when you retire. Assuming you add no more to your savings, how many years will it take to reach your goal?

Please round your answer to the nearest hundredth.

Note that the HP 12c financial calculator rounds up the periods result to the next integer and will not give the correct answer to the nearest hundredth. Therefore, you should use Excel or a financial calculator that does provide decimal precision to the number of periods.

4. You deposit $1,200 in a bank account that pays 9% stated annual interest compounded semi-annually. What is the value of your investment at the end of 4 years?

Please round your answer to the nearest cent.

Purchase this Solution

Solution Summary

A few problems related to compounded interest solved here in Excel.

Solution provided by:
Education
  • BEng, Allahabad University, India
  • MSc , Pune University, India
  • PhD (IP), Pune University, India
Recent Feedback
  • " In question 2, you incorrectly add in the $3.00 dividend that was just paid to determine the value of the stock price using the dividend discount model. In question 4 response, it should have also been recognized that dividend discount models are not useful if any of the parameters used in the model are inaccurate. "
  • "feedback: fail to recognize the operating cash flow will not begin until the end of year 3."
  • "Answer was correct"
  • "Great thanks"
  • "Perfect solution..thank you"
Purchase this Solution


Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts