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

jamesnevil303

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

« previous next »
 

Did you know?

Alzheimer's disease affects only about 10% of people older than 65 years of age. Most forms of decreased mental function and dementia are caused by disuse (letting the mind get lazy).

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

Patients who have been on total parenteral nutrition for more than a few days may need to have foods gradually reintroduced to give the digestive tract time to start working again.

Did you know?

Giardia is one of the most common intestinal parasites worldwide, and infects up to 20% of the world population, mostly in poorer countries with inadequate sanitation. Infections are most common in children, though chronic Giardia is more common in adults.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

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
Electrocardiography. (a) Electrodes are placed on the patient’s chest to record the electrical event Electrocardiography. (a) Electrodes are placed on the patient’s chest to record the electrical event
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 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 ...
Columns With Papyriform And Bud Capitals, Hypostyle Hall, Great Temple Of Amun At Karnak Columns With Papyriform And Bud Capitals, Hypostyle Hall, Great Temple Of Amun At Karnak
Nick buys a $25 000, 5.4% bond with quarterly interest coupons, 3 years before maturity, to ... Nick buys a $25 000, 5.4% bond with quarterly interest coupons, 3 years before maturity, to ...
Video: Michaelis–Menten equation & Kinetic parameters

For a complete list of videos, visit our video library