Purchase Solution

Present Value

Not what you're looking for?

Ask Custom Question

Sure Tea Co. has issued 9% annual coupon bonds which are now selling at a yield to maturity of 10 percent and current yield of 9.8375%. What is the remaining maturity of these bonds?

Use the NPER function to calculate the number of years till maturity.

Face value of bond $1,000
Annual coupon rate 9%
Current yield 9.8375%
Yield to maturity 10%

Current price per bond FORMULA
Years till maturity FORMULA.

Purchase this Solution

Solution Summary

The solution uses Excel formulas to solve present value problems. Specifically, the problem is solving for the number of periods.

Solution Preview

(a) Current Price Per Bond

Current Yield = Annual Payment / Price Paid
=>0.098375 = 0.09*1000 / Price Paid
=> Price Paid = 90/0.098375
=> Price Paid = 914.87

Thus the current ...

Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

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.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.