Question

A bank is attempting to determine where its assets should be invested during the current year....

A bank is attempting to determine where its assets should be invested during the current year. At present, $400,000 is available for investment in bonds, home loans, auto loans, and personal loans. The annual rates of return on each type of investment are known to be the following: bonds, 10%; home loans, 16%; auto loans, 13%; personal loans, 20%. To ensure that the bank's portfolio is not too risky, the bank's investment manager has placed the following two restrictions on the bank's portfolio:

The amount invested in personal loans cannot exceed the amount invested in bonds.

The amount invested in home loans cannot exceed the amount invested in auto loans.

Homework Answers

Answer #1

Using Excel

data -> solver

bond = 200000
home loan = 0
auto loan = 0
personal loan = 20000

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

DEAR STUDENT,

IF YOU HAVE ANY QUERY ASK ME IN THE COMMENT BOX,I AM HERE TO HELPS YOU.PLEASE GIVE ME POSITIVE RATINGS

*****************THANK YOU***************

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A bank provides 4 types of loans to customers - individuals. These types and the corresponding...
A bank provides 4 types of loans to customers - individuals. These types and the corresponding interest rates are shown in the table below. Loan type Annual interest rate (%) first home market 14 second home market 20 professional 20 consumer 10 The bank plans to allocate up to 250 million euros in total, with the following commitments: 1) For reasons of strengthening the first home market, first home mortgages must be at least 25% of all loans. 2) The...
X Bank holds Assets and Liabilities whose average durations and dollar amounts are as shown in...
X Bank holds Assets and Liabilities whose average durations and dollar amounts are as shown in the following table: Asset and Liability Items Avg. duration in years Dollar amount in millions Investment Grade Bonds 10 $50 Non-deposit Borrowings 0.10   20 Consumer Loans 7   250 Commercial Loans 4   400 Deposits 1.10   600 Subordinated Notes 2.80   80 Treasury Bonds 8.25   120     Calculate the weighted-adjusted duration of X’s assets portfolio and liability portfolio. What is the leverage-adjusted duration gap? If the ALM...
Adirondack Savings Bank (ASB) has $1 million in new funds that must be allocated to home...
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, 14% for personal loans, and 9% 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...
During the current year, Ron and Anne sold the following assets: (Use the dividends and capital...
During the current year, Ron and Anne sold the following assets: (Use the dividends and capital gains tax rates and tax rate schedules.) Capital Asset Market Value Tax Basis Holding Period L stock $ 50,000 $ 41,000 > 1 year M stock 28,000 39,000 > 1 year N stock 30,000 22,000 < 1 year O stock 26,000 33,000 < 1 year Antiques 7,000 4,000 > 1 year Rental home 300,000* 90,000 > 1 year *$30,000 of the gain is 25...
During the current year, Ron and Anne sold the following assets: (Use the dividends and capital...
During the current year, Ron and Anne sold the following assets: (Use the dividends and capital gains tax rates and tax rate schedules.) Capital Asset Market Value Tax Basis Holding Period L stock $ 50,000 $ 41,000 > 1 year M stock 28,000 39,000 > 1 year N stock 30,000 22,000 < 1 year O stock 26,000 33,000 < 1 year Antiques 7,000 4,000 > 1 year Rental home 300,000* 90,000 > 1 year *$30,000 of the gain is 25...
Note: This problem is for the 2018 tax year. David R. and Ella M. Cole (ages...
Note: This problem is for the 2018 tax year. David R. and Ella M. Cole (ages 39 and 38, respectively) are husband and wife who live at 1820 Elk Avenue, Denver, CO 80202. David is a self-employed consultant specializing in retail management, and Ella is a dental hygienist for a chain of dental clinics. David earned consulting fees of $145,000 in 2018. He maintains his own office and pays for all business expenses. The Coles are adequately covered by the...
ATHI AND DARRIN LOVETTE CASE: Kathi and Darrin Lovette Background Kathi and Darrin Lovette, both age...
ATHI AND DARRIN LOVETTE CASE: Kathi and Darrin Lovette Background Kathi and Darrin Lovette, both age 63, have been married for 40 years, are both in good health, and they are citizens and residents of Louisiana. They expect to work until age 66 to 70. Kathi and Darrin live in a community property state. They have the following children and grandchildren: Children Age Grandchildren Elizabeth Age 40 4 children (ages 15, 14, 13 & 12) James Age 35 3 children...
CASE: Sharesies: NZ investment platform Everyday investment company Sharesies was launched in February 2017, after conducting...
CASE: Sharesies: NZ investment platform Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills,...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills, online shopping, coffees, vouchers, food,...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes...
Everyday investment company Sharesies was launched in February 2017, after conducting research on New Zealanders’ attitudes towards investing. Prior to launching the company, the co-founders interviewed over 200 people asking them “If I gave you $50 right now, and you had to do something with it in the next 5 minutes what would you do?” Only 5 out of 200 people chose an option to save or invest the $50. More popular options were bills, online shopping, coffees, vouchers, food,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT