Adding dates and LTV to the schedule

In this exercise, we'll add all that we've learned about EOMONTH() and loan to value to add to our dashboard.

The asset value and the loan date have been added to the input section of the dashboard. The dates and loan to value will need to be added in for every period in the output section of the dashboard.

This exercise will only be using monthly calculations, so you shouldn't need to add a complex formula for your EOMONTH() calculation. For your EOMONTH() formula, use the prior row plus 1 month ahead offset.