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 110 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

skipfourms123

  • Member
  • Posts: 343
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

Dogs have been used in studies to detect various cancers in human subjects. They have been trained to sniff breath samples from humans that were collected by having them breathe into special tubes. These people included 55 lung cancer patients, 31 breast cancer patients, and 83 cancer-free patients. The dogs detected 54 of the 55 lung cancer patients as having cancer, detected 28 of the 31 breast cancer patients, and gave only three false-positive results (detecting cancer in people who didn't have it).

Did you know?

Signs of depression include feeling sad most of the time for 2 weeks or longer; loss of interest in things normally enjoyed; lack of energy; sleep and appetite disturbances; weight changes; feelings of hopelessness, helplessness, or worthlessness; an inability to make decisions; and thoughts of death and suicide.

Did you know?

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Ionic Bond Ionic Bond
The puppet, created for the Tbilisi Marionette Theatre, is controlled by forces hidden from public ... The puppet, created for the Tbilisi Marionette Theatre, is controlled by forces hidden from public ...
A color-coded record. A color-coded record.
Catalysis of peptide bond hydrolysis by chymotrypsin (part 2) Catalysis of peptide bond hydrolysis by chymotrypsin (part 2)
Created Equal: A Social and Political History of the United States, Brief Edition Created Equal: A Social and Political History of the United States, Brief Edition
Covalent bond Covalent bond
Video: Role of ATP in muscle movement

For a complete list of videos, visit our video library