ANSWER :
Part A: LP Formulation:
Decision Variables:
Let,
A = # $ Amount to be invested in Bond A
B = # $ Amount to be invested in Bond B
C = # $ Amount to be invested in Bond C
D = # $ Amount to be invested in Bond D
E = # $ Amount to be invested in Bond E
Thus, there are total 5 decision variables to be found for the given sum. (Answer 2)
Objective Function:
Max Z = 0.095 A + 0.08 B + 0.09 C + 0.09 D + 0.09 E
Subject to Constraints:
C1 = A + B + C + D + E ≤ 100000 (Total Amount to be invested)
C2 = B + E ≥ 0.50 (A + B + C + D + E) (At least 50% of the total investment should be done in short term bonds)
C3 = A + D + E ≤ 0.50 (A + B + C + D + E) (No more than 50% of the total investment to be done in high risk bonds)
C4 = A + B + D ≥ 0.30 (A + B + C + D + E) (At least 30% of the total investment to be done in the tax free bonds)
C5 = 0.095 A + 0.08 B + 0.09 D ≥ 0.40 ( 0.095 A + 0.08 B + 0.09 C + 0.09 D + 0.09 E ) (At least 40% of the total annual return should come from the tax free investments)
Non-Negativity Condition:
A, B, C, D, E ≥ 0
Part B: LP Solution:
As it is specifically mentioned in the question, we will solve the given LP model by using MS-Excel Solver data tool as mentioned in the below steps:
Step 1: Prepare the following table in the excel
(Note: Make Sure to prepare this table in the exact Rows and Columns as mentioned in the below screenshot)
Step 2: Now, enter the exact formulas as mentioned in the below screenshot and then press enter:
Hence, we get the following table:
Step 3: Now, open Solver (Data > Analyze > Solver), and fill the exact data in Solver Pop-Up Window as shown in the below screenshot:
Step 4: Once, you press the solve button as mentioned in the above step, you will get the following table. Here, the highlighted values are the optimal values for the decision variables:
Thus,
Answer 3 = 8898.31 $ (Rounded to 2 decimal places)
Answer 3-a: = Ignoring all the constraints, we need to invest a total of $ 100000, thus, the lowest return = 0.08 x 100000 = $ 8000 and the Highest Return = 0.095 x 100000 = $ 9500, thus, the value of objective function would have to be between 8000 $ and 9500 $
Answer 4 = 20338.98 $ (Rounded to 2 decimal places)
Answer 5= 20338.98 $ (Rounded to 2 decimal places)
Answer 6 = 29661.02 $ (Rounded to 2 decimal places)
Answer 7 = 0 $
Answer 8 = 29661.02 $ (Rounded to 2 decimal places)
_____________________________________________
Please Please up vote this answer. your up vote is so valuable to me Please. Thank you so much.
PLEASE ATTACH THE SPREAD SHEET 19. A trust officer at the Blacksburg National Bank needs to...
PLEASE ATTACH THE SPREAD SHEET 19. A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximine the annual retum. Annual Bulu Maturity Risk TaxFree 9.9% Long High Yes B 8.0% Short Low с 9.0% Long Low No D 9.0% Long High Yes No Short The officer wants to invest at least 50% of the money in short-term issues and no more than 50% in high-risk issues. At...
A trust officer at the Blacksburg National Bank needs to determine how to invest $150,000 in the following collection of bonds to maximize the annual return. Bond Annual Return Maturity Risk Tax Free A 9.5% Long High Yes B 8.0% Short Low Yes C 9.0% Long Low No D 9.0% Long High Yes E 9.0% Short High No The officer wants to invest at least 40% of the money in short-term issues and no more than 20% in high-risk issues....
A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual return. Bond Yield Maturity Risk Task free A 9.50% LONG 0.996 YES B 8.00% SHORT 0.55 YES C 9.00% LONG 0.368 NO D 9.00% SHORT 0.775 NO E 9.00% LONG YES With the low risk score of bond E being uncertain, The officer wants the average risk score for his investments to be less than...
A trust officer at the Blacksburg National Bank needs to determine how to invest $100,000 in the following collection of bonds to maximize the annual return. Bond Yield Maturity Risk Task free A 9.50% LONG 0.996 YES B 8.00% SHORT 0.55 YES C 9.00% LONG 0.368 NO D 9.00% SHORT 0.775 NO E 9.00% LONG YES With the low risk score of bond E being uncertain, The officer wants the average risk score for his investments to be less than...
help pls Questions 21-27 are based on the following information. CAPM and stock valuation. Your aunt, Beth, plans to invest in the common stock of Smart-investment Corporation Knowing that you are studying finance, she asks for your suggestion. You calculation shows that yield on Treasury securities is 6%. You know that the S&P 500 Index's expected annual return is 14% Your coonometric model tells you that beta of this company's stock is 1.25. Aunt Beth tells you that this company...
Please summarize this article in a summary. For Pensions, Valuing Real Estate Is Tough. Covid-19 Brings New Hurdles With Covid-19 and the dramatic slowdown in deal making, investors are finding it more difficult to calculate the value of real-estate holdings Public pension funds invested in malls, apartments and offices over the last decade in search of higher returns. Now they are grappling with how much those real-estate investments are worth in a world transformed by Covid-19. Pension giant California Public...
BioCom, Inc.: Part 3, A Fresh Look at the WACC In the course of discussing the fiber-optic blood pressure monitor project that we introduced in Chapter 10, a recently hired financial analyst who is working on her MBA asks how the company arrived at 9.5 % as the discount rate to use when evaluating capital budgeting projects. Her question is followed by an embarrassing silence that seems to last forever. Eventually, the comptroller, who has been with the company...
can you please give feed back to this.. like add something or give a comment about the following posts. 1) Profit Margin = NetincomeSales Profit margin is very useful in analyzing the financial health of the firm because it indicates how much money is generated per every dollar in sales. A higher profit margin means there are low expense ratios relative to sales. In other words, it tells us how a company uses its income. When a company has a...
Chapter Case. A Job at S&S Air A Job at S&S Air V ou recently graduated from college, and your job search led you to S&S Air. Because you felt the company's business was headed I skyward, you accepted the job offer. As you are finishing your employment paperwork, Chris Guthrie, who works in the finance department, stops by to inform you about the company's new 401(k) plan. A 401(k) is a type of retirement plan offered by many companies....
A Job at S&S Air V ou recently graduated from college, and your job search led you to S&S Air. Because you felt the company's business was headed I skyward, you accepted the job offer. As you are finishing your employment paperwork, Chris Guthrie, who works in the finance department, stops by to inform you about the company's new 401(k) plan. A 401(k) is a type of retirement plan offered by many companies. A 401(k) is tax deferred, which means...