Question

In: Statistics and Probability

ABC Savings and Loan provides five kinds of loans. These loans, with the yearly interest rate...

ABC Savings and Loan provides five kinds of loans. These loans, with the yearly interest rate charged to customers, are shown in the table below:

Type of Loan Interest charge (%)

Commercial loans 15

First mortgage 10

Home improvements   13

Second mortgage 14

Short-term revolving loan 18

Currently ABC has $53 million available to provide loans to customers. ABC does not need to use all the money for customer loans. Any money left can be invested in an investment X which yields an annual return of 14% . Its objective is to maximize total annual interest earned from the loan plus the return from the investment X.
ABC has found that the demand for short-term revolving loans never exceeds $5 million. ABC wants to satisfy the following Policies and regulations:

• Home improvement loans cannot be higher than 20 percent of first mortgage loans.• Commercial loans must be smaller than or equal to the second mortgage loans.
• The bank must provide at least 25 percent of the loans in First Mortgage.
• Short-term loans cannot exceed $5 million.

Develop a linear programming model for ABC.

Solutions

Expert Solution

Let the amount invested in Commercial loans be Xc, First mortgage Loans be Xf, Home improvement Loans be Xh, Second mortgage be Xs, Short term revolving loans be Xr, Balance amount in X be Xx

Based on the Annual interest charge given, total interest = 15%*Xc + 10%*Xf + 13%*Xh + 14%*Xs + 18%*Xr

We have to maximize this return, hence, we get Objective function as

Maximize Total Interest I = 15%*Xc + 10%*Xf + 13%*Xh + 14%*Xs + 18%*Xr + 14%*Xx

Various constraints given can be written as follows:

Xc + Xf + Xh + Xs + Xr <= 53,000,000.................Constraint for amount available for providing loans

Xx = 53,000,000 - (Xc + Xf + Xh + Xs + Xr).........Balance amount in X

Xr <= 5,000,000...................................................Constraint for Short term revolving loans

Xh <= 20%*Xf......................................................Constraint for amount in home improvement loans vs. first mortgage

Xc <= Xs..............................................................Constraint for Commercial loans vs Second mortgage

Xs >= (Xc + Xf + Xh + Xs + Xr)............................Constraint for minimum amount in Second mortgage

Xc, Xf, Xh, Xs, Xr, Xx >= 0...................................Non-negative constraint

-----------------------------------------------------------------------------------------------------------------------

PLEASE LIKE MY ANSWER


Related Solutions

Pittsburg Savings & Loan makes four kinds of loans. These loans, with the yearly interest rate...
Pittsburg Savings & Loan makes four kinds of loans. These loans, with the yearly interest rate charged to customers, are shown in the table below. Type of Loan                              Interest Charged (%, percent) Commercial Loans                                           8 Home Mortgages                                  4 Home Improvements                              6 Short-term revolving loans                     10 The bank has $25 million in available funds. Its objective is to maximize yield on investment. The demand for short-term revolving loans never exceeds $10 million. Also there are policies and regulations...
You expect to graduate with $44200 in student loans. The interest rate on your loan is...
You expect to graduate with $44200 in student loans. The interest rate on your loan is 4.8 percent compounded monthly and the loan calls for fixed monthly payments. If you repay the loan in 21 years how much are you paying in total interest over the life of the loan? (HINT: you need to calculate the monthly payment first).
Suppose you have $250,000 of loan. The terms of the loan are that the yearly interest...
Suppose you have $250,000 of loan. The terms of the loan are that the yearly interest is 6% compounded quarterly. You are to make equal quarterly payments of such magnitude as to repay this loan over 30 years. (Keep all your answers to 2 decimal places, e.g. XX.12.) (a) How much are the quarterly payments? (b)  After 5 years' payments, what principal remains to be paid? (c) How much interest is paid in the first quarter of the 6th year? (d)...
ABC Corporation currently has a fixed rate loan with an interest rate of 11% per year.  The...
ABC Corporation currently has a fixed rate loan with an interest rate of 11% per year.  The company prefers to pay a floating interest rate for the next four years because it will be a better match for its liabilities. ZYX corporation has a floating rate loan at LIBOR plus 1.5% and prefers to pay a fixed rate for the next four years.. The companies meet and agree to an interest rate swap with a notional principal of $10,000,000.  Under the terms...
JOHN BORROWS $14000 FROM THE SAVINGS AND LOAN AT A COMPOUND INTEREST RATE OF 5%/YR. HE...
JOHN BORROWS $14000 FROM THE SAVINGS AND LOAN AT A COMPOUND INTEREST RATE OF 5%/YR. HE WILL PAY BACK THE LOAN IN EQUAL ANNUAL PAYMENTS OVER A 4- YEAR PERIOD. BERTHA BORROWS $10,000 FROM SETH, WHO IS JOHN’S BROTHER.   -DETERMINE THE EQUAL ANNUAL PAYMENTS - SUMMARIZE JOHN’S FINANCIAL POSITION IN BULLET OUTLINE FORMAT          - BORROWS: $14000          -
What will be the effective interest rate when you repay a loan of $48,000 in five...
What will be the effective interest rate when you repay a loan of $48,000 in five years if the interest rate is 8.75% compounded continuously?
The interest rate for the first five years of a $27,000 mortgage loan was 3.25% compounded...
The interest rate for the first five years of a $27,000 mortgage loan was 3.25% compounded semiannually. The monthly payments computed for a 10-year amortization were rounded to the next higher $10. (Do not round intermediate calculations and round your final answers to 2 decimal places.) a. Calculate the principal balance at the end of the first term.   Principal balance $         b. Upon renewal at 5.75% compounded semiannually, monthly payments were calculated for a five-year amortization and again rounded...
A loan officer compares the interest rates for 48-month fixed-rate auto loans and 48-month variable-rate auto...
A loan officer compares the interest rates for 48-month fixed-rate auto loans and 48-month variable-rate auto loans. Two independent, random samples of auto loan rates are selected. A sample of eight 48-month fixed−rate auto loans had the following loan rates (all written as percentages):      8.71 7.13 8.11 8.87 7.87 8.29 7.43 7.86      while a sample of five 48−month variable−rate auto loans had loan rates as follows:      7.67 6.52 7.69 6.56 7.30    (a) Set up the null...
A loan officer compares the interest rates for 48-month fixed-rate auto loans and 48-month variable-rate auto...
A loan officer compares the interest rates for 48-month fixed-rate auto loans and 48-month variable-rate auto loans. Two independent, random samples of auto loan rates are selected. A sample of eight 48-month fixed−rate auto loans had the following loan rates: 8.75% 7.63% 7.26% 9.43% 7.86% 7.20% 8.09% 8.60% while a sample of five 48−month variable−rate auto loans had loan rates as follows: 7.60% 7.00% 6.79% 7.36% 6.99% Figure 10.7 Excel Output of Testing the Equality of Mean Loan Rates for...
A loan officer compares the interest rates for 48-month fixed-rate auto loans and 48-month variable-rate auto...
A loan officer compares the interest rates for 48-month fixed-rate auto loans and 48-month variable-rate auto loans. Two independent, random samples of auto loan rates are selected. A sample of five 48-month variable-rate auto loans had the following loan rates: 2.6% 3.07% 2.872% 3.24% 3.15% while a sample of five 48-month fixed-rate auto loans had loan rates as follows: 4.032% 3.85% 4.385% 3.75% 4.16% (a) Set up the null and alternative hypotheses needed to determine whether the mean rates for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT