Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to solve the following using excel: home loans. In addition, the planning committee has specified that the amount allocated to personal loans cannot exceed

How to solve the following using excel: 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.
amount allocated in dollars.)
Max
s.t.
Available investment funds
H+P+A=5000000
A+H+P=5000000
Minimum home loan amount
H0.40(H+P+A)
H0.4(A+H+P)
Maximum personal loan amount
P0.60A
H,P,A0
(b) How much (in dollars) should be allocated to each type of loan?
home loans $2000000
personal loans
auto loans
$
1875000
What is the total annual return (in dollars)?
$443750
What is the annual percentage return? (Round your answer to two decimal places.)
8.88
(c) If the interest rate on home loans increases to 9%, would the amount allocated to each type of loan change? Explain.
Since 0.09 i: within the allowable range, the amount allocated to each type of loan obtained in part (b) will not change.
(d) Suppose the total amount of new funds available is increased by $50,000. What effect would this have on the total annual return? Explain. (Round your answer to the nearest dollar.)
Increasing the amount of new funds available by $50,000 will increase the total annual return (in dollars) by $
(e)
How much would the annual percentage return change? (Round your answer to two decimal places.)
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Jeff Madura

8th Edition

0324568215, 978-0324568219

More Books

Students also viewed these Finance questions

Question

Refer to Exercise State in words the event F (BUC).

Answered: 1 week ago