Determine the proportions of investments a and b

Assignment Help Operation Management

Reference no: EM13919011

Morton Financial must decide on the percentage of available funds to commit to each of two investments, referred to as A and B, over the next four periods. The following table shows the amount of new funds available for each of the four periods, as well as the cash expenditure required for each investment (negative values) or the cash income from the in- vestment (positive values). The data shown (in thousands of dollars) reflect the amount of expenditure or income if 100% of the funds available in any period are invested in either A or B. For example, if Morton decides to invest 100% of the funds available in any pe- riod in investment A, it will incur cash expenditures of $1000 in period 1, $800 in period 2, $200 in period 3, and income of $200 in period 4. Note, however, if Morton made the decision to invest 80% in investment A, the cash expenditures or income would be 80% of the values shown.

Period	New Investment Funds Available	Investment A B
1	1500	-1000	-800
2	400	-800	-500
3	500	-200	-300
4	100	200	300

The amount of funds available in any period is the sum of the new investment funds for the period, the new loan funds, the savings from the previous period, the cash income from in- vestment A, and the cash income from investment B. The funds available in any period can be used to pay the loan and interest from the previous period, placed in savings, used to pay the cash expenditures for investment A, or used to pay the cash expenditures for investment B.

Assume an interest rate of 10% per period for savings and an interest rate of 18% per pe- riod on borrowed funds. Let

S(t) = the savings for period t

L(t) = the new loan funds for period t

Then, in any period t, the savings income from the previous period is 1.1S(t - 1), and the loan and interest expenditure from the previous period is 1.18L(t - 1).

At the end of period 4, investment A is expected to have a cash value of $3200 (assum- ing a 100% investment in A), and investment B is expected to have a cash value of $2500 (assuming a 100% investment in B). Additional income and expenses at the end of period 4 will be income from savings in period 4 less the repayment of the period 4 loan plus interest.

Suppose that the decision variables are defined as

x1 = the proportion of investment A undertaken

x2 = the proportion of investment B undertaken

For example, if x1 = 0.5, $500 would be invested in investment A during the first period, and all remaining cash flows and ending investment A values would be multiplied by 0.5. The same holds for investment B. The model must include constraints x1 1 and x2 1 to make sure that no more than 100% of the investments can be undertaken.

If no more than $200 can be borrowed in any period, determine the proportions of investments A and B and the amount of savings and borrowing in each period that will maximize the cash value for the firm at the end of the four periods.

Reference no: EM13919011

Questions Cloud

Correct cash balance as of the end of the month : What is the correct cash balance as of the end of the month? Verify this amount by reconciling the bank statement with the cash balance on the books.

Discount amounts in cells : The Discount amounts in cells D4, D5, D6 and D7 are computed using the IF function. The discount amount in column D should equal the Discount % from the assumptions area multiplied by the Sales figure from the column B if the corresponding Sales in c..

Developing an ethical culture : Discuss how Kellogg, being ethical and socially minded go hand in hand. Explain how Kellogg benefits from being socially responsible, either financially or in some other way.

Explain why adjusting entries are made at the end : Victory Associates experienced the following accounting events during its 2013 accounting period.

Determine the proportions of investments a and b : Determine the proportions of investments A and B and the amount of savings and borrowing in each period that will maximize the cash value for the firm at the end of the four periods.

Methods in behavioral research : As a team, locate at least two surveys (you can use any survey that you find on the internet). Try to find one that is relatively brief- 10 questions or less. Analyze the questions in the survey. Construct a table, such as that presented on page 1..

Social implications of real world business practices : You will consider the legal, ethical, and social implications of real world business practices. Find an example of a business facing a legal, ethical, and/or social responsibility dilemma.

How strategic planning help the organization : Why is strategic planning important to the organization? How does strategic planning help the organization?

Role of ethics and social responsibility in strategic plan : Explain the role of ethics and social responsibility in developing a strategic plan while considering stakeholder needs and agendas.

User Account

All Pages