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.
이 연습은 강의의 일부입니다
Google Sheets로 하는 대출 상환 일정표
연습 안내
- Enter an asset value of $84,000 in cell
B4. - Enter a loan date of March 31, 2019 in cell
B8. - Determine the loan to value for all periods in column
M. - Use the
EOMONTH()formula to determine the correct date for all periods in columnG.
