Muni bond amortization

Assignment Help Finance Basics
Reference no: EM1358695

I need a muni bond amortization table generator in Excel. We have a mini bond for $14 million, 20 year term, 5% interest, semi annual payments in April and November, the April payments are interest only, the November payments are principal and interest. Need to be able to vary the principal amount, interest rate and term for future problem solving.

Reference no: EM1358695

Questions Cloud

Examine two advantages to providing timely performance : Examine two advantages to providing timely performance feedback to employees and Introduce two examples of possible repercussions of not providing employees with performance feedback in a timely manner
Explain how does the capital-financial account differ : Explain how does the capital/financial account differ from the current account. Give examples of what is included in each.
What are different types of memory : What are some of the newer technology innovations you have seen in regards to I/O and Memory? What are the different types of Memory and how much is recommended?
Deliberate planning and military strategy : What is deliberate planning and how does it support national military strategy? Give an example of a scenario that might require deliberate planning.
Muni bond amortization : We have a muni bond for $14 million, twenty year term, 5 percent interest, semi annual payments in April and November, the April payments are interest only,
Diversity practices : Examine the diversity practices of your organization to determine if it is engaged in surface-level or deep-level diversity.
Illustrate what are main ingredients for economic growth : Why are poor countries poor and rich countries rich. Illustrate what are the main ingredients for economic growth.
Explain differences in wireless dsl services : Wireless DSL is available in her apartment building for $45 per month for 1.5 Mbps down and 256 Kbps up. Explain the differences in these services and make a recommendation.
How many days would be required to move one of the charges : how many days would be required to move one of the charges.

Reviews

Write a Review

Finance Basics Questions & Answers

  Computing present value of 30 year annuity

Find out  the present value of 30 year annuity with payments of $800 per year when interest rates are 12% annually?

  Calculating financial ratios

Just Dew It Corporation reports the following balance sheet data for 2004 and 2005. Based on the given balance sheets, calculate the following financial ratios for every year. Negative amount should be indicated by a minus sign.

  Petsmart ranking and market share in industry

What is Petsmart's ranking and market share in industry? What companies are its major competitors? Where does it rank in its industry and sector?

  Computation of net operating income and market value

Computation of Net operating Income and Market Value and Stock Price and If the selling price per deck of cards will be the same under each method

  Compute current price of the stock

State Street Corporation will pay a dividend on common stock of $4.00 per share at the end of the year. The required return on common stock is 11 percent.

  Computation of the value of the annuity payment

Computation of the value of the annuity payment and how much will you have to deposit each year if your first deposit

  Determining the maximum price and current yield

Rate of return on this investment (YTM), determine the maximum price that you must be eager to pay for this bond? Solve for PV.

  Effective rate of discounted loan

What is the effective rate of interest if the loan is for 1 year and is paid off in one payment at the end of the year? What is the effective rate of interest if the loan is for 1 month?

  Question on present value and future value

What is the present value of $15,000 to be received 11 years from today when the annual discount rate is 10%?

  Make a income statement pro forma

Make a income statement pro forma

  Determination of current share price

Baruk Industries has no cash and a debt obligation of 36 million dollar that is now due. The market value of Baruk's assets is $81 million, and the firm has no other liabilities. Suppose perfect capital markets.

  Margin required to hold a futures contract

The margin required to hold a futures contract is not a down payment but a form of security bond.  What will be your comments on this?

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