Hello!
So I have found a 'loan amortization schedule' template in the Excel templates section which has just about everything I need on it. What I can't work out is how to add a one time deposit amount to the template. It has an optional extra payments section, but that adds the amount to each individual repayment.
What I am hoping to do is add a one time deposit amount which shows up as an extra line item 1month prior to the first repayment amount being listed.
I am hoping you have access to this template from excel as my computer is playing up and wont let me add a link. Please let me know if you need further info. I only have pretty basic knowledge of excel which is why I thought using this template would be easier than building my own.
Thanks!
So I have found a 'loan amortization schedule' template in the Excel templates section which has just about everything I need on it. What I can't work out is how to add a one time deposit amount to the template. It has an optional extra payments section, but that adds the amount to each individual repayment.
What I am hoping to do is add a one time deposit amount which shows up as an extra line item 1month prior to the first repayment amount being listed.
I am hoping you have access to this template from excel as my computer is playing up and wont let me add a link. Please let me know if you need further info. I only have pretty basic knowledge of excel which is why I thought using this template would be easier than building my own.
Thanks!
