Determine what is the actual interest on the bond

Reference no: EM13207114

A company would like to have a bond offering to raise $100M for the construction of a new plant. By the time the bond goes to market, they receive only $93M. The bond is a 10 year offering with quarterly payments. The annual percentage interest rate is 3.5%. What is the actual interest on the bond.

Develop an MS Excel spreadsheet which will automatically calculate the actual bond interest given the type of information presented in Problem 1. Include the possibilities of other costs such as printing fees and annual service costs, as shown in the class notes. Note that MS Excel has several built in financial functions (PV< FV) - you should use these where possible. Compare your results in Problem 2 with the YIELD function in MS Excel.

Reference no: EM13207114

Questions Cloud

State environmental and health hazards : Polychlorinated biphenyls (PCBs), which were formerly used in the manufacture of electrical transformers, are environmental and health hazards. They break down very slowly in the environment. The decomposition of PCBs can be represented by the equ..

Explain required to produce aluminum by the hall-heroult : What constant current (in amperes) is required to produce aluminum by the Hall-Heroult

What are explicit and implicit costs of attending college : Why can the distinction between fixed costs and variable costs be made in the short run. Classify the following as fixed or variable costs: advertising expenditures, fuel, interest on company-issued bonds, shipping charges, payments for raw materi..

State how many grams of water are needed to make : How many grams of CaCl2 are needed to make 364.8 g of a solution that is 37.5% (m/m) calcium chloride in water? (Note that m/m has the same meaning as w/w.)

Determine what is the actual interest on the bond : A company would like to have a bond offering to raise $100M for the construction of a new plant. By the time the bond goes to market, they receive only $93M. The bond is a 10 year offering with quarterly payments. The annual percentage interest ra..

American exceptionalism : American exceptionalism (include an explanation of what exceptionalism is) and explain why this idea was so powerful to Americans at the turn of the 20th century.

State the cathode if you charge a lead storage : the cathode if you charge a lead storage battery for 1.85 h with a constant current of 13.4 A?

What are implications of such uncertainties for policymaker : Suppose you were in charge of designing the border security policies for airports, seaports, and roadways in the United States. How would you go about finding the optimal level of security, the optimal level of commercial trade and tourism, and th..

Write a rational expression : Write a rational expression for his total traveling time. Evaluate that expression for x = 100 km/hr.

User Account

All Pages