Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 3.1C

Kelly Jones is a financial analyst for Wolverine Manufacturing, a company that produces engine bearings for the automotive industry. Wolverine is in the process of hammering out a new labor agreement with its unionized workforce. One of the major concerns of the labor union is the funding of Wolverine’s retirement plan for its hourly employees. The union believes the company has not been contributing enough money to this fund to cover the benefits it will need to pay to retiring employees. Because of this, the union wants the company to contribute approximately $1.5 million dollars in additional money to this fund over the next 20 years. These extra contributions would begin with an extra payment of $20,000 at the end of 1 year with annual payments increasing by 12.35% per year for the next 19 years.

The union has asked the company to set up a sinking fund to cover the extra annual payments to the retirement fund. The Wolverines’ CFO and the union’s chief negotiator have agreed that AAA rated bonds recently issued by three different companies may be used to establish this fund. The following table summarizes the provisions of these bonds.

Chapter 3, Problem 3.1C, Kelly Jones is a financial analyst for Wolverine Manufacturing, a company that produces engine

According to this table, Wolverine may buy bonds issued by AC&C for $847.88 per bond. Each AC&C bond will pay the bondholder $80 per year for the next 15 years, plus an extra payment of $1,000 (the par value) in the fifteenth year. Similar interpretations apply to the information for the IBN and MicroHard bonds. A money market fund yielding 5% may be used to hold any coupon payments that are not needed to meet the company’s required retirement fund payment in any given year.

Wolverine’s CFO has asked Kelly to determine how much money the company would have to invest and which bonds the company should buy in order to meet the labor union’s demands.

If you were Kelly, what would you tell the CFO?

Blurred answer
Students have asked these similar questions
Mostlarge businesses rely on many complex processes to keep them running smoothly. Two large areas that impact large areas of business and IT are ERP and CRM. Respond to the following questions: • How do ERP and CRM help a company? What are the drawbacks to setting up those different types of systems in a business? What direct effects do these systems have on customers?
Please original work Who owns a customer's information in United States and Europe? Who should profit from it? How would that work Please cite in text reference and add weblinks
What significant role context plays in social interactions
Knowledge Booster
Background pattern image
Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License