Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 4% for home loans. 12% for personal loans, and 5% for automobile loans. The bank's planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed 60% of the amount allocated to automobile loans. (a) Formulate a linear programming model that can be used to determine the amount of funds ASB should allocate to each type of loan to maximize the total annual return for the new funds. If the constant is "1", it must be entered in the box. If your answer is zero, enter "0", Let H amount allocated to home loans Pamount allocated to personal loans A = amount allocated to automobile loans s.t. ΑΣ Minimum Home Loans A & Personal Loan Requirement Amount of New Funds (b) How much should be allocated to each type of loan? Loan type Home Personal Automobile Allocation 5 5 What is the total annual return? If required, round your answer to nearest whole dollar amount. $ What is the annual percentage return? If required, round your answer to two decimal places. (c) If the interest rate on home loans increases to 9%, would the amount allocated to each type of loan change? -Select your answer- Explain. An increase to 9% Select your answer within the allowable range, so the amount allocated to each type of loen -Select your answer- change. (d) Suppose the total amount of new funds available is increased by $10.000. What effect would this have on the total annual return? Explain. If required, round your answer to nearest whole dollar amount. An increase of $10,000 to the total amount of funds available would increase the total annual return by $ (e) Assume that ASB has the original $1 million in new funds available and that the planning committee has agreed to relax the requirement that at least 40% of the new funds must be allocated to home loans by 1%. How much would the annual return change? If required, round your answer to nearest whole dollar amount. 5 How much would the annual percentage retum change? If required, round your answer to two decimal places.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter16: Working Capital Policy And Short-term Financing
Section: Chapter Questions
Problem 19P
icon
Related questions
Question
None
Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 4% for home loans. 12% for personal loans, and 5% for automobile loans. The bank's planning committee has decided that at least 40% of the new funds must be
allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed 60% of the amount allocated to automobile loans.
(a) Formulate a linear programming model that can be used to determine the amount of funds ASB should allocate to each type of loan to maximize the total annual return for the new funds. If the constant is "1", it must be entered in the box. If your answer is zero, enter "0",
Let H amount allocated to home loans
Pamount allocated to personal loans
A = amount allocated to automobile loans
s.t.
ΑΣ
Minimum Home Loans
A &
Personal Loan Requirement
Amount of New Funds
(b) How much should be allocated to each type of loan?
Loan type
Home
Personal
Automobile
Allocation
5
5
What is the total annual return?
If required, round your answer to nearest whole dollar amount.
$
What is the annual percentage return?
If required, round your answer to two decimal places.
(c) If the interest rate on home loans increases to 9%, would the amount allocated to each type of loan change?
-Select your answer-
Explain.
An increase to 9%
Select your answer
within the allowable range, so the amount allocated to each type of loen -Select your answer- change.
(d) Suppose the total amount of new funds available is increased by $10.000. What effect would this have on the total annual return? Explain.
If required, round your answer to nearest whole dollar amount.
An increase of $10,000 to the total amount of funds available would increase the total annual return by $
(e) Assume that ASB has the original $1 million in new funds available and that the planning committee has agreed to relax the requirement that at least 40% of the new funds must be allocated to home loans by 1%. How much would the annual return change?
If required, round your answer to nearest whole dollar amount.
5
How much would the annual percentage retum change?
If required, round your answer to two decimal places.
Transcribed Image Text:Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home loans, personal loans, and automobile loans. The annual rates of return for the three types of loans are 4% for home loans. 12% for personal loans, and 5% for automobile loans. The bank's planning committee has decided that at least 40% of the new funds must be allocated to home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed 60% of the amount allocated to automobile loans. (a) Formulate a linear programming model that can be used to determine the amount of funds ASB should allocate to each type of loan to maximize the total annual return for the new funds. If the constant is "1", it must be entered in the box. If your answer is zero, enter "0", Let H amount allocated to home loans Pamount allocated to personal loans A = amount allocated to automobile loans s.t. ΑΣ Minimum Home Loans A & Personal Loan Requirement Amount of New Funds (b) How much should be allocated to each type of loan? Loan type Home Personal Automobile Allocation 5 5 What is the total annual return? If required, round your answer to nearest whole dollar amount. $ What is the annual percentage return? If required, round your answer to two decimal places. (c) If the interest rate on home loans increases to 9%, would the amount allocated to each type of loan change? -Select your answer- Explain. An increase to 9% Select your answer within the allowable range, so the amount allocated to each type of loen -Select your answer- change. (d) Suppose the total amount of new funds available is increased by $10.000. What effect would this have on the total annual return? Explain. If required, round your answer to nearest whole dollar amount. An increase of $10,000 to the total amount of funds available would increase the total annual return by $ (e) Assume that ASB has the original $1 million in new funds available and that the planning committee has agreed to relax the requirement that at least 40% of the new funds must be allocated to home loans by 1%. How much would the annual return change? If required, round your answer to nearest whole dollar amount. 5 How much would the annual percentage retum change? If required, round your answer to two decimal places.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning