Suppose a 10-year, $1,000 bond with an 8% coupon rate and semiannual coupons is trading for $1,034.74. Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the earliest appearance of the data in your formulas, usually the Given Data section.
a. What is the bond’s yield to maturity (expressed as an APR with semiannual compounding)?
b. If the bond’s yield to maturity changes to 9% APR, what will the bond’s price be?
Maturity (years) 10
Face value $ 1,000
Coupon rate 8%
Bond price $ 1,034.74

This problem has been solved! see the answerchapter 19 problem #8. quality and financial control (connect, perform)part one: geometrica designs and builds domes and space frames for large buildings. while the company had developed quality standards over time to respond to different client problems and training needs, it lacked a unified quality system, and its global client base wanted assurance that geometrica met an established international standard for quality. which of the following was an appropriate step for this company to take? a) reform its accounting and financial reporting systems to comply with sarbanes-oxleyb) establish and document a quality management system to comply with iso 9000management at workyou are the new fleet manager at xpressship, a package delivery company. as your first project, your boss has asked that you to look into implementing an electronic monitoring system for the fleet of 2,000 trucks your company owns. a recent internal audit on maintenance and repair costs on the company’s vehicles revealed while maintenance was performed regularly on the trucks, mileage or use had not been taken into account. this resulted in approximately $20,000 of unneeded repairs. you know that telematics have been used by other companies with fleets of cars or trucks and it will allow your company to not only track mileage and use, but also part replacement needs, vehicle oil pressure, and drivers’ speed and real time location. tracking these items can reduce maintenance costs while improving efficiency. you find that a simple computer can be installed in each vehicle. when the drivers return at the end of the day, the telematics information from each vehicle will be uploaded to a master computer where a software program will generate a report with results on the variables you have selected.early one morning as you are getting a cup of coffee, a few drivers that have been with the company for many years approach you with some concerns. eldon, the most senior driver says, “i heard you’re installing some type of computer to track our driving. my buddy works over at parcel and post package delivery and he said they’ve got these computers, too. he said managers are writing people up and firing drivers for speeding or not wearing seat belts. are you going to do that to us, too? ”part two: as a manager, which of the following statements would be effective in maintaining a positive relationship with company drivers? check all that apply.a) at this time, xpressship will be using telematics to monitor maintenance and repair needs, not drivers’ motoring habitsb) although the company isn’t doing so now, when xpressship begins to monitor driver motoring habits, the company will encourage them to keep a separate daily log where they can document any unusual circumstancesc) while xpressship could monitor things like speed, location, and idle time, the company trusts their drivers and will not be using that data in disciplinary decisionsd) xpressship executives are happy with their technology and believe that implementation is ideal for your organization

Acoase solution to a problem of externality ensures that a socially efficient outcome is to

Which of the following tends to result in a decrease in the selling price of houses in an area? a. an increase in the population of the city or town. b. an increase in the labor costs of construction. c. an increase in the income of new residents in the city or town. d. an increase in mortgage interest rates.