In 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 rows. Run Solver to ensure that your modified model is correct.
Answer to relevant QuestionsIn the pension fund problem, suppose there is a fourth bond, bond 4. Its unit cost in 2010 is $1020; it returns coupons of $70 in years 2011 through 2016 and a payment of $1070 in 2017. Modify the model to incorporate this ...In the pension fund problem, you know that if the amount of money allocated initially is less than the amount found by Solver, James will not be able to meet all of the pension fund payments. Use the current model to ...As it currently stands, investment 7 in the capital budgeting model in Figure 14.40 has the lowest ratio of NPV to cash requirement, 2.5. Keeping this same ratio, can you change the cash requirement and NPV for investment 7 ...In the original Western Airlines set-covering model in Figure 14.52, we assumed that each city must be covered by at least one hub. Suppose that for added flexibility in flight routing, Western requires that each city must ...In the peak-load pricing model, we assumed that the capacity level is a decision variable. Assume now that capacity has already been set at 30 kwh. Change the model appropriately and run Solver. Then use SolverTable to see ...
Post your question