Excel irr function to solve one

Assignment Help Business Economics
Reference no: EM132053547

A bond sold by Ford Cars, has a face value of $1,000, a coupon payment of $70 per year, and a maturity of 3 years. The first coupon payment occurs a year from now. The market price is $720, what is the YTM?

Clue: You can use Excel's IRR function to solve this one. There will be 3 cash flows for the 3 years of $70, $70, and $1,070.

Reference no: EM132053547

Questions Cloud

Differences between russia and china : What are the key similarities and differences between Russia and China?
Company issues new common stock at flotation cost : If the company issues new common stock at a flotation cost of 5% of the current price, what is the company’s WACC?
Decline in manufacturing employment in a sluggish economy : Apply the concepts of structural and cyclical unemployment to contrast this decline in manufacturing employment in a sluggish economy versus a healthy economy
What is the price of these bonds : The market's required return for these bonds is 8%. What is the price of these bonds?
Excel irr function to solve one : Clue: You can use Excel's IRR function to solve this one. There will be 3 cash flows for the 3 years of $70, $70, and $1,070.
What are the characteristics of a public good : What are the characteristics of a "public good"? Why is it difficult for a private company to provide a public good?
Describe the market structures to which this rule applies : Explain the MC=MR Rule. Describe the market structures to which this rule applies.Explain why a firm in pure competition is considered.
Quantity demanded of real gdp in aggregate demand : If average price of GDP increases, what happens to quantity demanded of real GDP in Aggregate Demand?
Difference in the price elasticity of supply : Why would there be a difference in the Price Elasticity of Supply for a good in the short-run compared to the long-run?

Reviews

Write a Review

Business Economics Questions & Answers

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd