Your corporation has just approved an 8-year expansion plan to grow its market share. The plan...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your corporation has just approved an 8-year expansion plan to grow its market share. The plan requires an influx of cash in each of the 8 years. Management wants to develop a financial plan to ensure the cash needed for the expansion will be available at the beginning of each of the 8 years. The corporation has the following investment options: Security 1 2 3 Savings Account Price per unit $1,200 $1,000 $1,175 Return Rate (%) 10.255 6.7550 12.110 5.500 Years to Maturity 5 6 a. Develop a linear programming model to minimize the total dollars needed to be invested now to meet the expansion cash needs in the next 8 years. Hint: this is the objective function. Use Excel Solver, solving method: Simplex LP. b. How many units of each security 1, 2, and 3 should the corporation purchase? What is the investment amount in each security 1, 2, and 3 in year 1? c. How much should the corporation place in the savings account in each of the 8 years? d. Assuming the corporation currently has $1.8 Million available cash to invest and given the cash needs for the expansion, is the investment plan that you developed feasible? Explain your answer and provide reasoning. Your corporation has just approved an 8-year expansion plan to grow its market share. The plan requires an influx of cash in each of the 8 years. Management wants to develop a financial plan to ensure the cash needed for the expansion will be available at the beginning of each of the 8 years. The corporation has the following investment options: Security 1 2 3 Savings Account Price per unit $1,200 $1,000 $1,175 Return Rate (%) 10.255 6.7550 12.110 5.500 Years to Maturity 5 6 a. Develop a linear programming model to minimize the total dollars needed to be invested now to meet the expansion cash needs in the next 8 years. Hint: this is the objective function. Use Excel Solver, solving method: Simplex LP. b. How many units of each security 1, 2, and 3 should the corporation purchase? What is the investment amount in each security 1, 2, and 3 in year 1? c. How much should the corporation place in the savings account in each of the 8 years? d. Assuming the corporation currently has $1.8 Million available cash to invest and given the cash needs for the expansion, is the investment plan that you developed feasible? Explain your answer and provide reasoning.
Expert Answer:
Answer rating: 100% (QA)
Linear Programming Model for Expansion Cash Needs Heres the linear programming model for this scenar... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Write a formula for a function g whose graph is similar to f(x) but satisfies the given conditions. Do not simplify the formula. f(x) = 3x 3x + 2 (a) Shifted right 2000 units and upward 70 units (b)...
-
Show that L/R has units of time.
-
What is the sample mean difference? A doctor wants to know if a blood pressure medication is effective. Six subjects have their blood pressures recorded. After twelve weeks on the medication, the...
-
The 2015 annual report of Bristol-Myers Squibb (BMS) reveals that the company maintains a large investment in available-for-sale securities: Did the companys available-for-sale securities experience...
-
On May 1, 2010 Kirmer Corp. purchased $450,000 of 12% bonds, int. payable on January 1 & July 1 for $422,800+accrued interest. Bonds mature on Jan. 1 2016.Amortization is recorded when interest is...
-
On 01 July 20X5 GTY, a company based in G-land, bought 100% of the ordinary shares of RKB when its retained earnings were G$100,000. There have been no share issues during the year. The statements of...
-
Provide a response to the questions within the case study. Responses to your classmates should include alternatives to their interpretations. Consider this as an email exchange with project teammates...
-
Briefly describe the solution process at the molecular level. Use the dissolution of a solid in a liquid as an example.
-
6.10.1 A Determine the resulting torque moment on the bar below. 400 N 400 N -3 m- -2 m 300 N 300 N 200 N 10.2 m 200 N
-
Give the definition & explain In terms their objective characteristics and methods : - a) descriptive research b) exploratory research c) casual research.
-
The Finance concept of Stocks and Bonds Valuation needs to applied, when answering the questions. Q 1 JW Corp has paid a dividend of $0.50. The dividend is expected to grow at a 6% rate over time....
-
In response to the United Nations Children Fund's report entitled Adjustment with a Human Face, What had World Bank implemented?
-
Successful "Product Differentiation" can make or break a company, new or old. 1. Explain why it is so important? 2. Give examples of very similar products (or services). 3. And with so-called...
-
3. Find 212 + 165 (mod 45). As part of the calculation write 212 + 165 = A + B = C(mod 45), where A, B and C are integers between 0 and 44. Enter your answer as: value of A, value of B, value of C...
-
Do animals have rights? If so, what are they? What duties do human beings have toward animals? Does KFC protect animal welfare at an acceptable level?
-
Suppose the following hypothetical data represent total assets, book value, and market value of common shareholders' equity (dollar amounts in millions) for Microsoft, Intel, and Dell, three firms...
-
Texas Instruments (TI) designs and manufactures semiconductor products for use in computers, telecommunications equipment, automobiles, and other electronics-based products. The manufacturing of...
-
A sales-based ranking of software companies provided by Yahoo! Finance on November 5, 2008, places Oracle Corporation third behind sales leaders Microsoft Corporation and IBM Software. Typical of...
-
On January 1, Lorraine, Inc., entered into a lease contract. The lease contract was a ten-year lease for a computer with \(\$ 15,000\) annual lease payments due at the end of each year. Lorraine took...
-
The relation between a bond's coupon rate and yield rate is known to influence a bond's issuance price. Presented below are coupon rates and yield rates for a selection of corporate bonds. Identity...
-
The following costs were incurred for the month of June for the Process A23 Department. Use this information to prepare a responsibility report for the month of June. Budget Actual Sales in units.....
Study smarter with the SolutionInn App