Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Please correct answer and don't use hand rating
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
Knowledge Booster
Similar questions
- Give typing answer with explanation and conclusion 1- Imagine the bond above displayed the following details: $10,000 Matures: January 31, 2030; Interest of $200 payable June 30 and December 31 of each year. Can you calculate the annual effective interest rate for this bond? a)2% b)4% c)6% d)One cannot tell.arrow_forwardDetermine the Purchase Price of a Bond that is purchased on the Coupon Date. A $500 bond matures on March 1, 2026, interest is 6.7% payable semi-annually. Determine the purchase price of the bond on September 1, 2020, to yield 8.7% compounded semi-annually. Will this bond sell at a premium or at a discount? discount a.) Determine the value of the coupon. b.) Determine the number of coupons left on the bond. 11 c.) Determine the Present Value of the Bond. d.) Determine the Present Value of the Coupons. e.) What is the purchase price of the Bond on September 1, 2020? >arrow_forwardListen Assume that there is a bond that pays $20.00 at the and of year 2, and $105.00 at the end of year 7. It sells at a total =$(20.00+105.00). The Macauley duration of the bond is? Answer with two digits decimal accuracy. Blank Excel Worksheet Your Answerarrow_forward
- PLEASE GIVE ME THE RIGHT ANSWERSarrow_forwardBhaarrow_forwardConsider a bond with semiannual interest payments that has a Settlement Date of 8/15/2020, a Maturity Date of 2/15/2031, a Coupon Rate of 5.00%, a Market Price of $975, a Face Value of $1,000, and a Required Return of 5.35%. What is the Macaulay Duration using the Duration function on these bonds expressed as a decimal calculated to two decimal places if you purchase them at the current market price? For example, if your answer is 12.345 then enter as 12.35 in the answerarrow_forward
- Suppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $750, calculate the interest rate that the bond would yield to a bond buyer. Show all work.arrow_forwardConsider an investor who, on January 1, 2022, purchases a TIPS bond with an original principal of $111,000, an 10 percent annual (or 5 percent semiannual) coupon rate, and 15 years to maturity. a. If the semiannual inflation rate during the first six months is 0.5 percent, calculate the principal amount used to determine the first coupon payment and the first coupon payment (paid on June 30, 2022). b. From your answer to part a, calculate the inflation-adjusted principal at the beginning of the second six months. c. Suppose that the semiannual inflation rate for the second six-month period is 1.3 percent. Calculate the inflation-adjusted principal at the end of the second six months (on December 31, 2022) and the coupon payment to the investor for the second six-month period. (For all requirements, round your answers to 2 decimal places. (e.g., 32.16)) a. Principal amount Coupon payment b. Inflation-adjusted principal c. Inflation-adjusted principal at the end of the second six months…arrow_forwardRequired: Find the duration of a bond with settlement date May 29, 2018, and maturity date November 19, 2027. The coupon rate of the bond is 6%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 7%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified durationarrow_forward
- Pls help with below homework.arrow_forwardgive me answerarrow_forwardAssume that a 5-year bond pays interest of $110 once a year (1 payment / year) and will mature for $1,000. Also assume that the yield to maturity on this bond is currently 12 percent. Given this information, determine the duration of this bond. Answer truncated to 2 decimal places. For example, if your answer is 3.267, enter "3.26".arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT