Please explain how the information in the first table was used to get the answers for the second table in detail.
Using financial calculator
1.
AMAZON
N=3.875*2
PMT=2.4%*1000/2
FV=1000
PV=-990.70
CPT I/Y=1.327%
Hence, YTM=1.327%*2=2.654%
2.
MACY's
N=10*2
PMT=-6.9%*1000/2
FV=-1000
I/Y=5.925%/2
CPT PV=1072.77979
Please explain how the information in the first table was used to get the answers for the second table in detail. 1. В...
Treasury notes and bonds. Use the information in the following table: . What is the price in dollars of the February 2000 Treasury note with semiannual payment if its par value is $100,000? What is the current yield of this note? What is the price in dollars of the February 2000 Treasury note? (Round to the nearest cent.) Х i Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) Today is February 15,...
P6-18 (similar to) Question Help 0 Missing information on a bond. Your broker faxed to you the following information about two monthly coupon bonds that you are considering as a potential investment. Unfortunately, your fax machine is blurring some of the items, and all you can read from the fax on the two different bonds is the following: 3. Fill in the missing data from the information that the broker sent. What is the price of the IBM coupon bond?...
*Please explain the answers* 1- .Although you will get a 30-year mortgage, you plan to prepay the loan by making an additional payment each month along with your regular payment. How much extra must you pay each month if you wish to pay off the loan in 20 years? A) $ 24.56 B) $ 54.88 C) $100.80 D) $103.28 E) $106.86 24. 2- J&J Manufacturing just issued a bond with a $1,000 face value and a coupon rate of 8%....
Please do Part 1&2 and include the steps with the
answers (it's going to be on excel thats why i need the
steps)
Part 1 -- Bonds: 1. National Company issued 6% bonds, dated January 1, with a face amount of $700,000 on January 1, 2019. The bonds are of 8-year duration and mature on December 31, 2026. The market yield for bonds of similar risk and maturity was 4.5%. Interest is made semiannually on June 30 and December 31....
2. Consider the information in Tables 1 and 2 Table 1 Market Capitalization Rate Stock iStock Price Dividend (Div) Return onPayout RatioGrowth Rate (PR) Equity (ROE) 12 14 16 10% 20% 30% 20% 10% 100% 50% 100% 0% 3 175 0% Table 2 Bond i Par Value Coupon Frequend Yearl earl Bond Maturity Yield to Maturit 6.5% 7.5% Coupon Rate 1,000 1,000 10% 5% 4 Years 3 Years (a) Consider Table 1. Complete the blanks in Table 1 (b) Consider...
Please type the formula of how
do you get the answer, For example, D16=E2*D3 Thank you
J35 1 x ✓ fx ADVANCED PROBLEM 6-2 FOR SPREADSHEET APPLICATION Callable bond and call premium. Edward has just purchased a callable bond and wants to determine the bond's potential payoff price if it is called at any time during its callable life. The callable bond is a twenty-year semiannual bond that an issuer can call starting at year ten. It is callable every...
Can
anybody help me with these questions pls
Questions 1-10 are based on the following information. Bond valuation. On Jan. 1. 2008, your cousin, Laura, purchased one 3-year semiannual bond with a coupon rate of 8%. The yield of the bond was at the time 1. How much did Laura pay for the hond a. 974.21 b. 974,69 c. 1.000 d767.90 2. This bond was a a discount bond b. premium bend c. par band d. all of the above....
0. Read examples 6 and 7 in the text
1. Write an instruction describing amortization tables in your
words. Tell what information in the columns, how the information in
the three main column is calculated, and why it is useful, Do not
use specific numbers, mathematical symbols, or excel functions, or
cell references, Be sure to explain the calculations for the three
columns.
2. Find the median home price for a city where you would like to
live. Tell how...