Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
USE SOLVER PLEASE SHOW SCREEN SCHOTS ON EXCEL! As part of the settlement for a class action lawsuit, Hoxworth corporation must provide sufficient cash to make the following annual payments (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 (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 securites (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. a. Use linear programming to find the minimum cash settlement necessary to fund the annual payments.B. Suppose that the annual payments are t be made at the end of ecah yea. Reformulate the model to accommodate this change. How much would Hoxworth save this change could be negotiated?
How is the financial plan and budget related to a company’s strategic plan?
Use the data in the following table to compute the percentage change in EBIT that would occur if sales were to increase by10%.
Calculate the covariance between portfolio A, which has 10% in asset 1 and 90% in asset 2, and portfolio B, which has 60% in asset 1 and 40% in asset 2:
Based on the information provided prepare the following operating budgets for 2015: Sales, Production, Direct Material, Direct Labor, Manufacturing Overhead, Ending Inventory, Cost of Goods Sold, Selling, General and Administrative Budgets, and a Bud..
Calculate the future worth.
A company is considering a new piece of equipment for a project lasting 10 years. what is the annual worth that the company can expect from the machine?
Suppose a stock had an initial price of $60 per share, paid a dividend of $.60 per share during the year, and had an ending share price of $53. Compute the percentage total return. (Negative amount should be indicated by a minus sign. Do not round in..
Calculating Investment Returns: You bought one of Bergen Manufacturing Co.’s 7 percent coupon bonds one year ago for $943.82. These bonds make annual payments and mature six years from now. Suppose you decide to sell your bonds today when the require..
What is the expected rate of return on a portfolio Which consists of $9,000 invested in an S&P 500 Index fund, $32,500 in a technology fund, and $8,500 in Treasury Bills. The expected rate of return is 11% on the S&P Index fund, 14% on the technology..
Nations Shipping determined the rate to apply overhead based on direct labor hours would be $8. 40, and based on machine hours would be $5. 20. Job 43D used $12. 40 of direct materials, 0. 46 machine hours, and 18 minutes of direct labor at a cost of..
The shareholders of Motive Power Corp. need to elect four new directors to the board. There are 14,700,000 shares of common stock outstanding, and the current share price is $11.00. If the company uses cumulative voting procedures, how much will it c..
Calculate the expected return and standard deviation of returns for portfolios that are 25%,75% and 125% invested in the market portfolio.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd