Question

In: Statistics and Probability

The Sketchy Loner is a bank that issues 6 types of loans. In addition, to diversify...

The Sketchy Loner is a bank that issues 6 types of loans. In addition, to diversify its portfolio and minimize its risk, the bank invests in risk-free securities. The 6 loan types and the risk-free securities with their annual rates of return are given below:

Type of Loan or Security Annual Rate of Return (%)
Home Mortgage (first) 12%
Home Mortgage (second) 13%
Commercial loan 16%
Auto Loan 16%
Home Improvement Loan 19%
Risk Free Security 11.5%

The bank’s objective is to maximize the annual rate of return on investments subject to the following policies, restrictions, and regulations:

1. The bank has $780 million in available funds.

2. Risk-free securities must contain at least 10% of the total funds available for investments.

3. Home improvement loans cannot exceed $90,000,000.

4. The investment in first and second mortgage loans must be at least 60 percent of all the funds invested in the 5 loan types.

5. The investment in the first mortgage loans must be at least three times the funds invested in second mortgage loans.

6. Home improvement loans cannot exceed 15 percent of the funds invested in first mortgage loans.

7. Automotive loans and home improvement loans together may not exceed the commercial loans.

8. Commercial loans cannot exceed 60% of the total funds invested in mortgage loans.

a) Formulate the problem into proper Linear programming format

b) Use Excel’s Solver to determine the optimal solution

c) State the optimal solution in the context of the business problem, that is to say, how exactly should the money be allocated to the possible investments?

Solutions

Expert Solution

Sol:

Let be the proportion of total funds invested in the loan types (also called weights) , Home Mortgage (first), Home Mortgage (second), Commercial loan, Auto Loan, Home Improvement Loan, Risk Free Security respectively

These are the decision variables.

The annual rate of return of the portfolio is

We want to maximize the annual rate of return on investments and hence the above os the objective function

Now the constraints

The proportions sum to 1

2.

Risk-free securities (proportion X6)  must contain at least 10% of the total funds available for investments.


3.

Home improvement loans (proportion X5) cannot exceed $90,000,000

4.

The investment in first and second mortgage loans (X1,X2) must be at least 60 percent of all the funds invested in the 5 loan types (X1+..+ X5 which is same as 1-X6) .


5.

The investment in the first mortgage loans (X1) must be at least three times the funds invested in second mortgage loans (X2)


6.

Home improvement loans (X5) cannot exceed 15 percent of the funds invested in first mortgage loans (X1).


7.

Automotive loans (X4) and home improvement loans (X5) together may not exceed the commercial loans (X3).


8.

Commercial loans (X3) cannot exceed 60% of the total funds invested in mortgage loans.

a)

The LP model is

maximize

s.t.

b)

Prepare the following sheet

get this

setup the solver using data--->solver

get this

c).

$780 million in available funds needs to be allocated in the following manner to get  an optimum/maximum annual rate of return on investments of 13.71%

Type of Loan or Security Amount invested ($)
Home Mortgage (first) 315,900,000.00
Home Mortgage (second) 105,300,000.00
Commercial loan 233,415,000.00
Auto Loan                           -  
Home Improvement Loan     47,385,000.00
Risk Free Security     78,000,000.00

If you Satisfy with Answer, Please give me "Thumb Up". It is very useful for me.
Thank you for your support.


Related Solutions

The Sketchy Loner is a bank that issues 6 types of loans. In addition, to diversify...
The Sketchy Loner is a bank that issues 6 types of loans. In addition, to diversify its portfolio and minimize its risk, the bank invests in risk-free securities. The 6 loan types and the risk-free securities with their annual rates of return are given below: Type of Loan or Security Annual Rate of Return (%) Home Mortgage (first) 12% Home Mortgage (second) 13% Commercial loan 16% Auto Loan 16% Home Improvement Loan 19% Risk Free Security 11.5% The bank’s objective...
A local SME bank provides 4 types of loans of its customers and these loans yield...
A local SME bank provides 4 types of loans of its customers and these loans yield the following interest rates to the Bank: Personal Loan 1:         14% Personal Loan 2:         20% Home Loan:                20% Overdraft:                   10% The Bank has a maximum foreseeable lending capability of Rs 700 million and is further constrained by the policies: Personal Loan 1 must be at least 45% of all personal loans issued and at least 15% of all loans issued (in Rs...
Bank provides 5 different loans. The types of these loans and monthly interest rates are given...
Bank provides 5 different loans. The types of these loans and monthly interest rates are given below. Type Of Credit Percentage Of Interest(month) A (commercial)                                5.5 B)(home)                                          3.5 C (auto)                                             5 D (House 2)                                       4.5 E (short term))                                  6 The bank can give credit £ 100 million. The goal is to maximize interest income But have some obligations about the loans: Credit C cannot be more than 25% of credit B. Credit A can be given up to a maximum...
A large bank claims that approximately 14% of all house loans it issues are in default....
A large bank claims that approximately 14% of all house loans it issues are in default. A random sample of 243 house loans issued by this bank finds that 42 of them are in default. Do the data indicate that the proportion of loans in default exceeds 14%? (a) State the null and alternative hypotheses for the test. (b) State the formula for the test statistic and compute its value. Justify your answer. (c) Construct the rejection region and make...
A large bank claims that approximately 14% of all house loans it issues are in default....
A large bank claims that approximately 14% of all house loans it issues are in default. A random sample of 243 house loans issued by this bank finds that 42 of them are in default. Do the data indicate that the proportion of loans in default exceeds 14%? (a) State the null and alternative hypotheses for the test. (b) State the formula for the test statistic and compute its value. Justify your answer. (c) Construct the rejection region and make...
1.         To gain the benefit of _______________, a bank makes various types of loans, to various...
1.         To gain the benefit of _______________, a bank makes various types of loans, to various types of borrowers. A.     guaranteed income B.      diversification C.      more firm-specific risk exposure D.     reduced operational risk E.      reduced off-balance-sheet risk 2.         Argentina unilaterally told its creditors in 2005 that it would henceforth repay only $0.30 for every $1.00 of its debt that was outstanding. Argentina’s creditors had been exposed to ______________ risk, which was then realized. A.     sovereign B.      operational C.      technology D.    ...
The loan department of a bank offers 3 different types of loans: signature, mortgage, and commercial....
The loan department of a bank offers 3 different types of loans: signature, mortgage, and commercial. The following cost and activity estimates are available for the upcoming year: Activity Activity Cost Activity Driver Answering customer questions $ 35,000 customer inquiries Filling out loan application     60,000 pages Loan application processing     30,000 data entry hours Loan analysis & evaluation   100,000 loan dollars Preparation of loan checks     28,000 checks prepared Posting of loan payments     42,000 checks received Total $295,000 The following activity driver...
28. Bank loans and bills of exchange with focus on: A.short-term bank loans/credits used for operational...
28. Bank loans and bills of exchange with focus on: A.short-term bank loans/credits used for operational funding B.supplier credits, their importance and types C..long-term bank loans/credits used for strategic funding D. nature of discounting bills and discount loans E. other external sources for long-term corporate financing
Which of the following is NOT a difference between bank loans and corporate bonds.    Bank...
Which of the following is NOT a difference between bank loans and corporate bonds.    Bank loans typically have more covenants than corporate bonds. Bank loans typically have a longer maturity than corporate bonds. Bank loans typically carry a floating interest rate, while corporate bonds carry a fixed rate of interest. Bank loans can be prepaid while corporate bonds cannot unless they have a callability provision.
Distinguish between issues of valuation in commercial and farm loans
Distinguish between issues of valuation in commercial and farm loans
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT