Business, 06.06.2020 22:02 1andonlyrob

Problem 4-03 (Algorithmic) The employee credit union at State University is planning the allocation of funds for the coming year. The credit union makes four types of loans to its members. In addition, the credit union invests in risk-free securities to stabilize income. The various revenueproducing investments together with annual rates of return are as follows: Type of Loan/Investment Annual Rate of Return (%) Automobile loans 8 Furniture loans 10 Other secured loans 11 Signature loans 12 Risk-free securities 9 The credit union will have $1.7 million available for investment during the coming year. State laws and credit union policies impose the following restrictions on the composition of the loans and investments: Risk-free securities may not exceed 30% of the total funds available for investment. Signature loans may not exceed 10% of the funds invested in all loans (automobile, furniture, other secured, and signature loans). Furniture loans plus other secured loans may not exceed the automobile loans. Other secured loans plus signature loans may not exceed the funds invested in risk-free securities. How should the $1.7 million be allocated to each of the loan/investment alternatives to maximize total annual return? Round your answers to the nearest dollar. Automobile Loans $ Furniture Loans $ Other Secured Loans $ Signature Loans $ Risk Free Loans $ What is the projected total annual return? Round your answer to the nearest dollar. $

Answers: 3

Show answers

Answers

auto: $535,500furniture: $144,500other secured: $391,000signature: $119,000risk-free: $510,000projected return: $160,480 (9.44%)

Explanation:

We can let the variables a, f, o, s, r stand for the amounts invested in auto loans, furniture loans, other secured loans, signature loans, and risk-free securities, respectively. The restrictions imposed are ...

r ≤ 0.30(1.7·10^6)s ≤ 0.10(a +f +o +s)f +o ≤ ao +s ≤ ra +f +o +s +r = 1.7·10^6

And the objective is to maximize ...

p = 0.08a +0.10f +0.11o +0.12s +0.09r

We can write the constraints in standard form as ...

r -510000 ≤ 0-a -f -o +9s ≤ 0-a +f +o ≤ 0o +s -r ≤ 0a +f +o +s +r -1700000 = 0

It is convenient to formulate this problem as a "solver" problem in a spreadsheet program. The spreadsheet and the solver setup are shown in the attachments. The result is ...

Automobile Loans $535,500Furniture Loans $144,500Other Secured Loans $391,000Signature Loans $119,000Risk Free Securities $510,000

The projected total annual return: $160,480 (9.44%)

_____

Comment on the attachments

The first attachment shows the NeoOffice spreadsheet used to solve this problem. The formula shown is filled in all cells G3:G8. The second attachment shows the Solver setup used to solve this problem. There are actually five constraints. The one not showing is $G$7 = 0.

Problem 4-03 (Algorithmic) The employee credit union at State University is planning the allocation

Answer from: Quest

the correct answer is:

it required the president to inform congress within forty-eight hours of any new troop commitment.

the war powers resolution (1973) is a federal law designed to limit the u.s. president’s ability to initiate or intensify military actions abroad without the approval of the congress.

it establishes that the president can send armed forces into action abroad only by declaration of war by congress, statutory authorization, or in case of a national emergency created by attack upon the united states, its territories or possessions, or its armed forces.

it requires the president to notify congress within 48 hours of sending armed forces to military action.

Answer from: Quest

answer; dogs;

Another question on Business

Business, 22.06.2019 05:00

Personal financial planning is the process of creating and achieving financial goals? true or false

Answers: 1

Answer

Business, 22.06.2019 07:10

mark, a civil engineer, entered into a contract with david. as per the contract, mark agreed to design and build a house for david for a specified fee. mark provided david with an estimation of the total cost and the contract was mutually agreed upon. however, during construction, when mark increased the price due to a miscalculation on his part, david refused to pay the amount. this scenario is an example of a mistake.

Answers: 1

Answer

Business, 22.06.2019 11:40

Select the correct answer. which is a benefit of planning for your future career? a.being less prepared after high school. b.having higher tuition in college. c.earning college credits in high school. d.ruining your chances of having a successful career.

Answers: 2

Answer

Business, 22.06.2019 19:30

He moto hotel opened for business on may 1, 2017. here is its trial balance before adjustment on may 31. moto hotel trial balance may 31, 2017 debit credit cash $ 2,283 supplies 2,600 prepaid insurance 1,800 land 14,783 buildings 72,400 equipment 16,800 accounts payable $ 4,483 unearned rent revenue 3,300 mortgage payable 38,400 common stock 59,783 rent revenue 9,000 salaries and wages expense 3,000 utilities expense 800 advertising expense 500 $114,966 $114,966 other data: 1. insurance expires at the rate of $360 per month. 2. a count of supplies shows $1,050 of unused supplies on may 31. 3. (a) annual depreciation is $2,760 on the building. (b) annual depreciation is $2,160 on equipment. 4. the mortgage interest rate is 5%. (the mortgage was taken out on may 1.) 5. unearned rent of $2,580 has been earned. 6. salaries of $810 are accrued and unpaid at may 31

Answers: 2

Answer

You know the right answer?

Problem 4-03 (Algorithmic) The employee credit union at State University is planning the allocation...

Questions