Schedule Labor Now that the cost information is in place, divvying up the staff time is the next step in calculating the budgeted cost of work over the work scheduled in Excel.

This period begins to change when we copy and drag the cell down. The table below shows that at the end of 120 periods, our loan is repaid. How Do I Create a Loan Repayment Schedule in Excel?

Use Excel's Data Forecast Tool Excel's data forecasting tool lets you predict future trends based on historical data in just a few clicks, saving you from having to make those forecasts manually.