Hi Joe,

Yes, there is a formula to calculate escalation in Microsoft Excel. You can use the POWER function to calculate the escalation rate for each year and then multiply it by the original price to get the escalated price for each year.

Here are the steps to do it:

1. Enter the original price in cell A1 (in your case, $1,000).
2. Enter the escalation rate in cell A2 (in your case, 4.5%).
3. Enter the number of years in cell A3 (in your case, 10).
4. In cell B1, enter the formula
   Code:

   =A1*(1+A2/100)^1

   . This will give you the escalated price for year 1.
5. Copy the formula in cell B1 and paste it in cells B2 to B10. This will give you the escalated price for each year.
6. To get the escalated price for year 10, simply refer to cell B10.

That's it! You now have the escalated price for each year and separately for year 10.

I hope this helps. Let me know if you have any further questions.