We claimed that our model for Barney-Jones is generalizable. Try generalizing it to the case where there are two more potential investments, F and G. Investment F requires a cash outlay in year 2 and returns $0.50 in each of the next four years. Investment G requires a cash outlay in year 3 and returns $0.75 in each of years 5, 6, and 7. Modify the model as necessary, making the objective the final cash after year 7.
Answer to relevant QuestionsIn our Barney-Jones spreadsheet model, we ran investments across columns and years down rows. Many financial analysts prefer the opposite. Modify the spreadsheet model so that years go across columns and investments go down ...Suppose the investments in the Barney-Jones problem sometimes require cash outlays in more than one year. For example, a $1 investment in investment B might require $0.25 to be spent in year 1 and $0.75 to be spent in year ...In the capital budgeting model in Figure 14.40, investment 4 has the largest ratio of NPV to cash requirement, but it is not selected in the optimal solution. How much NPV is lost if Tatham is forced to select investment 4? ...In the optimal solution to the Great Threads model, no pants are produced. Suppose Great Threads has an order for 300 pairs of pants that must be produced. Modify the model appropriately and use Solver to find the new ...In the peak-load pricing model, the demand functions have positive and negative coefficients of prices. The negative coefficients indicate that as the price of a product increases, demand for that product decreases. The ...
Post your question