Hi -

I need help in instituting two key changes in the attached financial model (I didn't build this model, it has so many linkages and I'm no excel expert) and I'm not sure how to best update it. The two changes are, and they should be made in the "Base Case P&L V2" tab

1. amortize the following expenses so that the total cost is divided evenly across all years of the contract. Total costs are found on "Operating Expenses" tab
o Operating expenses/direct/fulfillment/Platform-Highwire (Row 130)
o Operating expenses/direct/fulfillment/other (Row 131)
o Operating expenses/direct/pub tech/Backfile digitization (Row 142)
o Operating expenses/direct/pub tech/other (Row 145)
Need a formula for these rows.

2. I need year -1, or at least be able to start the contract year with year 2, so that year 1 is the transition year. This is necessary because we are often doing a P&L for a book/ journal that would start with us in 2 years time. Again, this change should go in the "Base Case P&L V2"
Need to add a column and formula for "Year -1")

Thanks very much for your help!

Sarah