As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars): Year 1 2 3 4 5 6 Payment 190 215 240 285 315 460 The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street Journal. Hoxworth wants to develop a plan for making the annual payments by investing in the following securities (par value=$1000) . Funds not invested in these securities will be placed in savings. Security Current Price Rate (%) Years to Maturity 1 $1055 6.750 3 2 $1000 5.125 4 Assume that interest is paid annually. The plan will be submitted to the judge and, if approved, Hoxworth will be required to pay a trustee the amount that will be required to fund the plan. Can you show how to solve using excel solver please and thank you!
Unitary Method
The word “unitary” comes from the word “unit”, which means a single and complete entity. In this method, we find the value of a unit product from the given number of products, and then we solve for the other number of products.
Speed, Time, and Distance
Imagine you and 3 of your friends are planning to go to the playground at 6 in the evening. Your house is one mile away from the playground and one of your friends named Jim must start at 5 pm to reach the playground by walk. The other two friends are 3 miles away.
Profit and Loss
The amount earned or lost on the sale of one or more items is referred to as the profit or loss on that item.
Units and Measurements
Measurements and comparisons are the foundation of science and engineering. We, therefore, need rules that tell us how things are measured and compared. For these measurements and comparisons, we perform certain experiments, and we will need the experiments to set up the devices.
As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments (in thousands of dollars):
Year 1 2 3 4 5 6
Payment 190 215 240 285 315 460
The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual payments. Investment of the funds will be limited to savings (at 4% annually) and government securities, at prices and rates currently quoted in The Wall Street Journal.
Hoxworth wants to develop a plan for making the annual payments by investing in the following securities (par value=$1000) . Funds not invested in these securities will be placed in savings.
Security Current Price Rate (%) Years to Maturity
1 $1055 6.750 3
2 $1000 5.125 4
Assume that interest is paid annually. The plan will be submitted to the judge and, if approved, Hoxworth will be required to pay a trustee the amount that will be required to fund the plan.
Can you show how to solve using excel solver please and thank you!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 1 images
