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

LVPMS

  • Member
  • Posts: 323
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

There are 20 feet of blood vessels in each square inch of human skin.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

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.

Did you know?

Many of the drugs used by neuroscientists are derived from toxic plants and venomous animals (such as snakes, spiders, snails, and puffer fish).

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Corrosion on Copper Bond Pad Corrosion on Copper Bond Pad
Monkeys and apes such as this chimpanzee can be recognized in the fossil record by the anatomy of th Monkeys and apes such as this chimpanzee can be recognized in the fossil record by the anatomy of th
Carbon dioxide. This molecule exhibits a nonpolar bond and results in a linear and symmetrical ... Carbon dioxide. This molecule exhibits a nonpolar bond and results in a linear and symmetrical ...
Record the first puff and this final reading for each cylinder. The final readings should all be ... Record the first puff and this final reading for each cylinder. The final readings should all be ...
Peptides and the Peptide Bond Peptides and the Peptide Bond
Hydrogen bond Hydrogen bond
Video: Brief Summary on Photosynthesis - Animation

For a complete list of videos, visit our video library