We have a muni bond for 14 million twenty year term 5, Ask an Expert

Finance

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.

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M9279010

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Suppose you expect to rent a house when you retire in 35

Suppose you expect to rent a house when you retire in 35 years. Today, rent for a 3 bedroom, 2 bathroom home costs $36,000 per year. You expect inflation to be 2% per year between now and when you die and that rent will ...

1 cornell enterprises is considering a project that has

1) Cornell Enterprises is considering a project that has the following cash flow and WACC data. What is the project's NPV? Note that a project's projected NPV can be negative, in which case it will be rejected. WACC: 10. ...

A work-at-home opportunity is available in which you will

A work-at-home opportunity is available in which you will receive 3 percent of the sales for customers you refer to the company. The cost of your "franchise fee" is $600. How much would your customers have to buy to cove ...

Financial and economic analysis problems -1 the operative

Financial and Economic Analysis Problems - 1. The operative question among macro policy specialists and investors is "by how much will the Federal Reserve target higher interest rates in 2017?" Currently, the U.S. econom ...

Could you please explain this question for me pretty

Could you please explain this question for me? Pretty struggle with it right now. "The biggest four banks in Australia are too big to fail. With reference to financial system stability, critique this statement."

Market-value ratios garret industries has a priceearnings

(?Market-value ratios?) Garret Industries has a? price/earnings ratio of 19.46X a. If? Garret's earnings per share is ?$1.65?, what is the price per share of? Garret's stock? b. Using the price per share you found in par ...

Jack has his new atm business up and running customer

Jack has his new ATM business up and running. Customer interest has been high. He has employed several experienced sales people in hopes of a rapid expansion. Jack has negotiated a deal with the manufacturer where the co ...

Piping hot food services is evaluating a project that costs

Piping Hot Food Services is evaluating a project that costs $75,000. The project is expected to generate after-tax cash flows equal to $26,000 per year for four years. Their required rate of return is 14%. What is the ne ...

Does the agency problem only happen in the relationship

Does the agency problem only happen in the relationship between Employees and Stockholders? How about the relationship between clients and stars?

Consider a currency swap for 10 million and sf 15 million

Consider a currency swap for $10 million and SF 15 million. One party pays dollars at a fixed rate of 9%, and the other pays Swiss francs at a fixed rate of 8 percent. The payments are made semiannually based on the exac ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert