This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: An Excel spreadsheet is being created as a record of bond purchases. The following columns have ... (Read 90 times)

khang

  • Hero Member
  • *****
  • Posts: 569
on: Jun 24, 2018
An Excel spreadsheet is being created as a record of bond purchases. The following columns have values entered: Column A: Number of Bonds Purchased, Column B: Face Value of Each Bond, Column C: Percent Price, Column E: Interest Rate. What are the Excel formulas for Column D: Market Value, Column F: 10 Commission per 1,000 Bond, and Column H: Annual Interest All Bonds? Use Row 2 in formulas.

Question 2

Todd purchased 270 shares of stock at 13.25 per share. The commission is 1.5 for round lots and an additional 5 for odd lots. What is the total cost of the transaction?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

soda0602

  • Sr. Member
  • ****
  • Posts: 313
Reply #1 on: Jun 24, 2018
Answer to Question 1

Column D: =A2B2C2
Column F: =A210
Column H: =A2B2E2

Answer to Question 2

3,663.63;
270  13.25 = 3,577.50
200  13.25  0.015 = 39.75
70  13.25  0.05 = 46.38
3,577.50 + 39.75 + 46.38 = 3,663.63


khang

  • Member
  • Posts: 569
Reply 2 on: Jun 24, 2018
YES! Correct, THANKS for helping me on my review

dreamfighter72

  • Member
  • Posts: 355
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

It is believed that humans initially contracted crabs from gorillas about 3 million years ago from either sleeping in gorilla nests or eating the apes.

Did you know?

As many as 20% of Americans have been infected by the fungus known as Histoplasmosis. While most people are asymptomatic or only have slight symptoms, infection can progress to a rapid and potentially fatal superinfection.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

An electrocardiogram (EKG) wave, a record of the electrical signal as it moves through the conductio An electrocardiogram (EKG) wave, a record of the electrical signal as it moves through the conductio
Ionic Bond Ionic Bond
An example of a late entry to the medical record. An example of a late entry to the medical record.
Hydrogen Bond Hydrogen Bond
The disaccharides sucrose, maltose, and lactose are created from the monosaccharides The disaccharides sucrose, maltose, and lactose are created from the monosaccharides
Individuals from highly divergent lines created by artificial selection Individuals from highly divergent lines created by artificial selection
Video: Anaphylaxis Animation

For a complete list of videos, visit our video library