Average score both tabs: 38% The .. Company issues 10%, 5-year bonds with a par value...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Average score both tabs: 38% The .. Company issues 10%, 5-year bonds with a par value of $460,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 9%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect. Par Value Term (years) Annual market % Annual contract % Payments per year $460,000 5 9% 10% What is the amount of each semiannual interest payment? How many semiannual payments of $23.000 will be made in total2 Using the PV function, calculate the issue price of the bond. Make sure the formula returns a positive value. See the instructions tab for help on the PV function. $23,000 Complete the amortization schedule for these bonds. Make sure all formulas return positive values. Cash Interest Bond Interest Premium Amortization Unamortized Premium Carrying Value Semiannual Interest Period Paid Expense 0 1 $23,000.00 2 $23,000.00 3 $23,000.00 4 $23,000.00 5 $23,000.00 6 $23,000.00 7 $23,000.00 8 $23,000.00 9 $23,000.00 10 $23,000.00 Totals $230,000.00 $0.00 $0.00 Average score both tabs: 38% The .. Company issues 10%, 5-year bonds with a par value of $460,000 and semiannual interest payments. On the issue date, the annual market rate for these bonds is 9%. Enter a valid Excel formula or function in each of the yellow cells below. Formulas must refer to cells addresses. Entering a value will be marked as incorrect. Par Value Term (years) Annual market % Annual contract % Payments per year $460,000 5 9% 10% What is the amount of each semiannual interest payment? How many semiannual payments of $23.000 will be made in total2 Using the PV function, calculate the issue price of the bond. Make sure the formula returns a positive value. See the instructions tab for help on the PV function. $23,000 Complete the amortization schedule for these bonds. Make sure all formulas return positive values. Cash Interest Bond Interest Premium Amortization Unamortized Premium Carrying Value Semiannual Interest Period Paid Expense 0 1 $23,000.00 2 $23,000.00 3 $23,000.00 4 $23,000.00 5 $23,000.00 6 $23,000.00 7 $23,000.00 8 $23,000.00 9 $23,000.00 10 $23,000.00 Totals $230,000.00 $0.00 $0.00
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
si hiciste un trabajo de reparacin en tu auto, lo ms probable es que el taller ________ usara para pagarle al mecnico. Un plan de trabajo a destajo Un plan de horas estndar un mapa de Bedeaux el...
-
What are the advantages and disadvantages of developing an organization specific quality framework such as the SQF. What are the advantages and disadvantages of adop an existing framework such as the...
-
Explain how each of the following illustrates one of the four principles of interaction. a. At a college tutoring co-op, students can arrange to provide tutoring in subjects they are good in (like...
-
Sams Supermarkets tests its checkout clerks by randomly examining the printout receipts for scanning errors. The following numbers are the number of errors on each receipt for October 27: 0, 1, 1, 0,...
-
List the main rights of auditors.
-
You make 2 quarts of salsa for a party. The recipe calls for 5 teaspoons of lime juice per quart, but you had accidentally put in 5 tablespoons per quart. You decide to feed your guests the salsa...
-
Recording Sales Transactions Presented below is information from Lopez Computers Incorporated. July 1 Sold $30,000 of computers to Smallwood Company with terms 3/15, n/60. Lopez uses the gross method...
-
Rodarta Corporation applies manufacturing overhead to productson the basis of standard machine-hours. The company's predeterminedoverhead rate for fixed manufacturing overhead is $5.00 permachine-h 2...
-
A(n) Blank______ is a object that orbits the Earth receiving and transmitting signals from Earth-based stations over a wide area. Multiple choice question. smartphones geocoin geocache satellite
-
The prompt reporting of communicable diseases is necessary in order for states to protect citizens health by invoking the power to quarantine.
-
Timely reporting of drug interactions is necessary to help prevent harmful occurrences by those dispensing, prescribing, and taking the medication reported.
-
Match the following terms to their definitions: 1. Tells whether a company can pay all its current liabilities if they become due immediately 2. Measures a company's success in using assets to earn...
-
Senior abuse is less likely to be reported than child abuse, and proving senior abuse charges is often difficult. Types of senior abuse include abandonment, emotional or psychological abuse, physical...
-
In 2010, common stockholders received \($2\) per share in annual dividends. The market price per share for common stock was \($12.\) Compute the dividend yield for common stock.
-
Visit Moreno Valley College's webpage www.mvc.eduLinks to an external site. and find the following information: 1) The Current Academic Calendar 2) A description of the Management Communications...
-
What did Lennox gain by integrating their WMS, TMS, and labor management systems?
-
Consider the function \(f(x)=x,-\pi
-
Differentiate the Fourier sine series term by term in Problem 18. Show that the result is not true. Why not? Data from Problem 18 Consider the function \(f(x)=x, 0
-
Consider the function \(f(x)=x, 0
Study smarter with the SolutionInn App