Mortgage game calculator

[weaker123]

Here I have 3 pictures of a worksheet I'd like to create. The worksheet is on house mortgages I'm supposedly buying. I want to be able to delete them and put them in and have the ease of starting each one by buying and selling property at different months in the year period.


Month 1: Imgur: The most awesome images on the Internet
Month 5: Imgur: The most awesome images on the Internet
Month 8: Imgur: The most awesome images on the Internet


I've also included starting off text (VBA) of what I think the button should have to help. Thanks for your time.





<sub>Private Sub CommandButton1_Click()




'' initial constants =0
a = 0
b = 0
c = 0
d = 0
''\\initial constants =0




''payback to bank per month
Range("k10") = 0.003 * Range("h10")
''\\payback to bank per month




''constant months,,, a,b,c,d,,,,when the house is owned. I buy and sell the houses every couple of months (see sheet month 8)
Range("l10") = a * 0.997 * Range("h10")
''\\constant months,,, a,b,c,d,,,,when the house is owned. I buy and sell the houses every couple of months (see sheet month 8)




''adding all the owe back mortgages together
Range("l16") = Range("l10") + Range("l11") + Range("l12")
''\\adding all the owe back mortgages together




End Sub</sub>