# Question

At the beginning of year 1, you have $10,000. Investments A and B are available; their cash flows are shown in the file S14_84.xlsx. Assume that any money not invested in A or B earns interest at an annual rate of 8%.

a. Determine how to maximize your cash on hand at the beginning of year 4.

b. Use SolverTable to determine how a change in the year 2 returns for investment A changes the optimal solution to the problem.

c. Use SolverTable to determine how a change in the year 3 return of investment B changes the optimal solution to the problem.

a. Determine how to maximize your cash on hand at the beginning of year 4.

b. Use SolverTable to determine how a change in the year 2 returns for investment A changes the optimal solution to the problem.

c. Use SolverTable to determine how a change in the year 3 return of investment B changes the optimal solution to the problem.

## Answer to relevant Questions

An oil company produces two types of gasoline, G1 and G2, from two types of crude oil, C1 and C2. G1 is allowed to contain up to 4% impurities, and G2 is allowed to contain up to 3% impurities. G1 sells for $48 per barrel, ...Based on Sonderman and Abrahamson (1985). In treating a brain tumor with radiation, physicians want the maximum amount of radiation possible to bombard the tissue containing the tumors. The constraint is, however, that there ...A financial company is considering investing in three projects. If it fully invests in a project, the realized cash flows (in millions of dollars) will be as listed in the file S14_97.xlsx. For example, project 1 requires a ...This problem deals with strategic planning issues for a large company.18 The main issue is planning the company’s production capacity for the coming year. At issue is the overall level of capacity and the type of ...We all hate to keep track of small change. By using random numbers, it is possible to eliminate the need for change and give the store and the customer a fair deal. This problem indicates how it could be done.a. Suppose that ...Post your question

0