An Excel spreadsheet contains the following information about annuities: Column A: Payment, Column B: Rate, Column C: Compounded, Column D: Years, Column E: Total Annuity Investment, Column F: Present Value Factor, Column G: Present Value of Annuity Investment, Column H: Total Interest. Which is the formula needed in Column G to calculate the Present Value of Annuity Investment?
A) =ROUND((B6E6),2)
B) =ROUND((A6F6),2)
C) =ROUND((A6B6D6),2)
D) =ROUND((E6F6),2)
Q. 2A 1,900 bond at a 11.65 interest rate is purchased at 80 of face value. What is the rate of annual yield to the investor? Assume the bond is purchased on the interest date.
A) 14
B) 16
C) 81
D) 99
Q. 3Megan has 700 shares of a Building Finder's common stock. There are dividends of 320,000 to be distributed among its common stockholders. There are 65,000 shares of common stock outstanding. How much will Megan receive?
A) 142.19
B) 3,003
C) 3,444
D) 61,556
Q. 4Marty purchased 290 shares of stock at 11.55 per share. The commission is 4 for round lots and an additional 5 for odd lots. What is the total cost of the transaction?
A) 51.75
B) 92.40
C) 3,349.50
D) 3,493.65
Q. 5Mary is considering the purchase of 5 bonds. What is the market value of these bonds? Face value of each bond: 500 Price per bond: 75.5 Interest rate: 9.25 Commission per 500 bond: 5
A) 231.25
B) 1,887.50
C) 2,642.50
D) 18,875
Quick Reply
