Author Question: An Excel spreadsheet is being created as a record of bond purchases. The following columns have ... (Read 67 times)

khang · **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?

soda0602 · **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