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

raenoj

  • Member
  • Posts: 340
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Did you know?

Drugs are in development that may cure asthma and hay fever once and for all. They target leukotrienes, which are known to cause tightening of the air passages in the lungs and increase mucus productions in nasal passages.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

The cure for trichomoniasis is easy as long as the patient does not drink alcoholic beverages for 24 hours. Just a single dose of medication is needed to rid the body of the disease. However, without proper precautions, an individual may contract the disease repeatedly. In fact, most people develop trichomoniasis again within three months of their last treatment.

Directionality of the hydrogen bond Directionality of the hydrogen bond
Electron microscope video of a needle on a vinyl record Electron microscope video of a needle on a vinyl record
Harlem’s Promise Academy has a record of graduating and sending to college more than 90 percent ... Harlem’s Promise Academy has a record of graduating and sending to college more than 90 percent ...
Hydrogen-bond donors and acceptors in water Hydrogen-bond donors and acceptors in water
A police record search of 250 incoming Grade 10 at a Secondary School shows that 26 had been ... A police record search of 250 incoming Grade 10 at a Secondary School shows that 26 had been ...
Formation of a peptide bond between two amino acids Formation of a peptide bond between two amino acids
Video: DNA Replication

For a complete list of videos, visit our video library