User Account

All Pages

Calculate the issuance price of a 10 year bond

Assignment Help Financial Management
Reference no: EM132322322

Question

Solve all of the iollowing problems with Excel. Please use iorrnulas in excel to solve.

(a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month.

1. What initial principal will this repay?

(b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year.

1. What initial principal will this repay?

(c) Assume monthly car payments of $500 per month for 4 years and an interest rate of 7% per year.

What initial principal will this repay?

loan payment schedule showing the payments and interest for the life of the loan.

(3) (a) A 10-year mortgage for $95,000 is issued at a 6% annual interest rate.

(a) What is the monthly payment?

(b) How long does it take to pay off the mortgage, if $1500 per month is paid?

(c) What is the monthly payment, if the interest rate is 0.5% per month?

(4)  Calculate the Issuance Price of a 10 year bond with a face value of $250,000, stated interest rate of 4% to yield 5%. Interest payments are paid semiannually.

1 Calculate the price in excel

2 bond amortization schedule using the straight line method

3 bond amortization schedule using the effective interest method

Please note: For all of the above please label your work. Work will be graded on accuracy and the utilization of excel throughout your work.

Reference no: EM132322322

Questions Cloud

Explain why you chose such a certification : After visiting the PMI's certification website, you see several certification options. Select the certification that would most interest you and explain why.
What is the cell concentration per milliliter : What is the cell concentration per milliliter in the original sample? Please explain out on paper, do the math explaining it in detail please.
Calculate the holding gain : Assume that an entity acquired 150 items of inventory at a cost of $10 each and sold 100 of the items for $15/each when the replacement cost.
Swab surfaces get good cell counts : Please give a logical explanation of why it is sometime difficult for some groups that swab surfaces get good cell counts
Calculate the issuance price of a 10 year bond : How long does it take to pay off the mortgage, if $1500 per month is paid? What is the monthly payment, if the interest rate is 0.5% per month?
Organism physical structure : What can you identify on the pathogen (if viewing under the microscope) something about the organism's physical structure that tells you why.
Summarize articles on cyber security and risk management : Summarize 4 academically reviewed articles on Cyber Security and Risk Management and also discuss the relationship between cyber security and risk management.
Define how are the topics of the two articles related : Research at least two articles on the topic of big data and its business impacts. Write a brief synthesis and summary of the two articles. How are the topics.
Is the confirmation of accounts receivable always required : Imagine that you were auditing accounts receivable balances to confirm sales and found significant discrepancies between the recorded account.

Reviews

Write a Review

Financial Management Questions & Answers

  Compute the weighted average cost of capital

Speedy Delivery Systems can buy a piece of equipment that is anticipated to provide an 6 percent return and can be financed at 3 percent with debt. Compute the weighted average cost of capital. Which project(s) should be accepted? New machine or Piec..

  To create bond portfolio with overall duration

To create a bond portfolio with an overall duration of 15 years, the insurance company decides to buy zero coupon bonds with a maturity of 20 years.

  What is the required external financing over next year

The firm will maintain a dividend payout ratio of 0.40. What is the required external financing over the next year?

  Statements are complete except for statement of cash flows

The statements are complete except for the statement of cash flows. Prepare the statement of cash flows for the current year ended December 31

  The required rate of return on sigma corporation

Suppose the risk-free rate is 8%, the required rate of return on the stock market is 13% and the beta of the stock of Sigma Corporation is 1.1. Calculate the required rate of return on Sigma Corporation.

  Preferred lacks the ownership privilege of common stock

Preferred stock has all but which of the following characteristics? A. No stated maturity. B. Preferred lacks the ownership privilege of common stock. C. The same binding contractual obligation as debt. D. A fixed dividend payment that carries a high..

  What would the cash option payout be

The cash option amount is determined by discounting the winning amount at 8% over 22 years. - This week the lottery is worth $5 million to a single winner. What would the cash option payout be?

  What would be third year future value

What would be the third year future value?

  Forecasted cash flow of capital budgeting analysis

Why is terminal value usually the largest forecasted cash flow of a capital budgeting analysis?

  What was the growth rate in earnings per share

What was the growth rate in earnings per share (EPS) over the 5-year period?

  How much will he have in his retirement account

At the end of this month, Les will start saving $200 a month for retirement through his company's retirement plan. His employer will contribute an additional $.50 for every $1.00 that he saves. If he is employed by this firm for 30 more years and ear..

  What should be the primary objective of managers

What is the weighted average cost of capital? How do free cash flows and the weighted average cost of capital interact to determine a firm's value? What should be the primary objective of managers?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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