In the Barney-Jones investment model, we ran investments across columns and years down rows. Many financial analysts seem to prefer the opposite. Modify the spreadsheet model so that years go across...

In the Barney-Jones investment model, we ran investments across columns and years down rows. Many financial analysts seem to 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. (There are two possible ways to do this, and you can experiment to see which you prefer. First, you could basically start over on a blank worksheet. Second, you could use Excel’s TRANSPOSE function.)