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 68 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
Excellent

bigcheese9

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

The B-complex vitamins and vitamin C are not stored in the body and must be replaced each day.

Did you know?

It is widely believed that giving a daily oral dose of aspirin to heart attack patients improves their chances of survival because the aspirin blocks the formation of new blood clots.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

The world has been horrified recently at a U.S. Congress so polarized and paralyzed that it cannot p The world has been horrified recently at a U.S. Congress so polarized and paralyzed that it cannot p
The Phanerozoic Oxygen Isotope Record of Seawater The Phanerozoic Oxygen Isotope Record of Seawater
Hydrogen Bond Hydrogen Bond
Catalysis of peptide bond hydrolysis by chymotrypsin (part 1) Catalysis of peptide bond hydrolysis by chymotrypsin (part 1)
An ulcer is created when the mucosal lining of the GI tract erodes or breaks An ulcer is created when the mucosal lining of the GI tract erodes or breaks
Hydrogen Bond with Peptide Hydrogen Bond with Peptide
Video: Darwin's Observation (Fossils, Galapagos Islands & Africa ) and Natural Selection (Adaptive Traits)

For a complete list of videos, visit our video library