Purchase Solution

Muni Bond Amortization

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

This solution contains a Muni Bond Amortization table in an Excel file for the transactions mentioned in the question. The Excel file allows changes tot he principal amount, interest rate, term for future problem solving.

Purchase this Solution
Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Basics of corporate finance

These questions will test you on your knowledge of finance.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

View More Free Quizzes
Related BrainMass Solutions

  • Bond Analysis: Muni Bond Yield

    In this solution, we analyze the given muni bond.

  • City of Gainesville issued muni bonds: What is the net present value of the refunding?

    296330 City of Gainesville issued muni bonds: What is the net present value of the refunding? The City of Gainesville issued $1,000,000 of 14 percent coupon, 30-year, semiannual payment, tax-exempt muni bonds 10 years ago.

  • Refunding Net Present Value

    The bonds had a 10 year call protection, but now Gainesville can call the bond if it chooses to do so. The call premium would be 5 percent of the face amount.

  • Tax equivalent yield of a municipal bond

    The formula for the tax equivalent yield (TEY) is: TEY = (Muni Bond Yield) / (1 - Tax Rate) Sin the yield of the municipal bond is 0.04 (4%) and the tax rate is 0.3 (30%), then the TEY is: TEY = 0.04/(1-0.3) = 0.0571 = 5.71% I hope this helps

  • Bond Types

    Government Bonds: Government bonds are usually referred to as risk-free bonds, because the government can raise taxes or simply print more money to redeem the bond at maturity. A typical government bond is the treasury bond. a.

  • Net Present Value of a City's Refunding

    143912 Net Present Value of a City's Refunding The City of Charleston issued $3,000,000 of 8% coupon, 30-year, semiannual payment, tax-exempt muni bonds 10 years ago.

  • Bonds amortization of premium, bond interest expense

    86401 Amortization of premium on bonds payable, amount of bond interest expense to be recognized Circle the one best answer. Circle the correct one 1. The amortization of premium on bonds payable a. will increase bond interest expense.

  • Aumont Company: Entries for Bond Transactions

    and bond amortization for 2007-2009, and prepare the journal entry to record the interest payment and the amortization for 2007 and 2009.

  • Entries for Bond Transactions Aumont Company

    The entries are then created by pointing at the relevant amount in the amortization schedule. This is a template that you can now use for any bond problem. The journal entries are based on the bond amortization schedule.

View More Related Solutions