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

  Determining the future value

What is the future value of $1500 after 5 years if the appropriate interest rate is 12%, compounded monthly?

  How to finding the price of the bond

How to Finding the price of the bond of the Mangold Corporation has two different bonds currently outstanding

  Determine which statements is correct

Monica and her friend Linda each believe they have a superior savings plan. Monica saved $4,500 at the end of each year for fifteen years and then let her money grow for thirty years.

  Prepare an income statement

Prepare an income statement, a statement of changes in stockholders equity, a balance sheet, and a statement of cash flows.

  Find the present value of cash flow stream

Find the present value of cash flow stream if the interest rate is 6 percent. The only capital investment needed for a small project is investment in inventory.

  Determine which of the prohibited transaction rules

Determine which of the prohibited transaction rules is correct

  Return would you earn if you made investment

If the investment needs the outlay of $400 today,what compound percentage return would you earn if you made investment.

  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?

  Description of future value of money

You want to bank enough money to pay for 4 years of college at $20,000 per year for your child. If you deposit the money on your child's 3rd birthday, how much should you deposit?

  Determine the rate of return on a bond

Determine the rate of return on a bond that pays a coupon rate of 9 percent, has a par value of $1,000, matures in five years and is currently selling for $714?

  Calculation of operating income and ebit

Calculation of operating income, EBIT and dividend per share - What was the firm's operating income, or EBIT and What dividend per share should the company declare

  Defined benefit pension plan

Kenny's Aquatics, Inc. sponsors both a profit sharing plan and a defined benefit pension plan.  If Kenny's Aquatics would also like to contribute the maximum to the profit sharing plan, how much can they contribute?

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