Nper function to calculate the number of years, Finance Basics

+44 141 628 6080
[email protected]

Nper function to calculate the number of years

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

View Complete Question

Request for Solution File

Ask an Expert for Answer!!

Finance Basics: Nper function to calculate the number of years

Reference No:- TGS056557

Expected delivery within 24 Hours

Have a Question? (oR Write a Review)

Write atleast 100 words!!

Recent Questions Asked Finance Basics

Q : Calculation of percent tax bracket

What on a Synthetic Chemical Company Bond would cause the two bonds to provide the same after-tax rate of return to an investor in the 28 percent tax bracket?

Q : Summary of common stockholders equity accounts

What will Micromain's book value per share be when based on the final year-end balance sheet? Hint: Sole this problem by constructing a summary of the common's stockholders equity accounts.

Q : Calculation of equity cost of capital

Given its higher volatility, should we expect Microsoft to have an equity cost of capital that is higher than 10%? What would have to be true for Microsoft's equity cost of capital to be equal to 10%?

Q : Cost structure information

You are a hard-working analyst in the office of financial operations for a manufacturing firm that produces a single product. You have developed the following cost structure information for this company. All of it pertains to an output level of 10

Q : Nper function to calculate the number of years

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 matur

Q : Total incremental investment in accounts receivable

What would be the total incremental investment in accounts receivable and inventory to support an $80,000 increase in sales? Given the income determined in part b and the investment determined in part d, should Collins extend more liberal credit ter

Q : Calculate the pension expense

Compute the pension expense recognized in 2011. Assume the prior service cost is amortized over the average remaining service life of the employees.

Q : Effective annual percentage cost of foregoing

Calculate the effective annual percentage cost of foregoing the cash discount under each of the following credit terms:

Q : Capital budgeting decisions of multinational companies

Briefly expain how the following items affect the capital budgeting decisions of multinational companies: (a) exchange risk; (b) political risk; (c) tax law differences; (d) transfer pricing; and (e) a strategic rather than a strict financial view

1931999

Questions
Asked

3,689

Active Tutors

1439704

Questions
Answered

Start Excelling in your courses, Ask a tutor for help and get answers for your problems !!

ask Question

Request for Solution File

Ask an Expert for Answer!!

Finance Basics: Nper function to calculate the number of years

Reference No:- TGS056557

Have a Question? (oR Write a Review)

Recent Questions Asked Finance Basics

Q : Calculation of percent tax bracket

Q : Summary of common stockholders equity accounts

Q : Calculation of equity cost of capital

Q : Cost structure information

Q : Nper function to calculate the number of years

Q : Total incremental investment in accounts receivable

Q : Calculate the pension expense

Q : Effective annual percentage cost of foregoing

Q : Capital budgeting decisions of multinational companies

What are the bodies first and second line of defence

Identify which defense mechanisms are at risk

Requirement that could affect your healthcare organization

Reviewing adverse events on a hospital unit

Conduct self-reflection on your performance in the field

Why patient with dementia is no longer able to make decision

How healthcare professionals responsible for utilization

Request for Solution File

Ask an Expert for Answer!!

Finance Basics: Nper function to calculate the number of years

Reference No:- TGS056557

Recent Questions Asked Finance Basics

Q : Calculation of percent tax bracket

Q : Summary of common stockholders equity accounts

Q : Calculation of equity cost of capital

Q : Cost structure information

Q : Nper function to calculate the number of years

Q : Total incremental investment in accounts receivable

Q : Calculate the pension expense

Q : Effective annual percentage cost of foregoing

Q : Capital budgeting decisions of multinational companies

Asked Questions