Create a spreadsheet in good format that calculates the
following items for the Questionable Company on December 13 2012.1.The
current value of a $10000 note with a face rate of interest of 2% when the
market rate of interest for similar notes is 8%.2.The
issue price for a $1000 Bond that pays 8% quarterly and matures in 5 years.The current market rate of interest is 6% for
similar bonds.3.The
implicit interest rate if a 10% $100000 5 year Note that pays interest
semi-annually is issued for $103956. 4.The
monthly payments on a 5 year loan of $30000 when the rate of interest is 9.6%.