Hi All,
First, I'd like to thank you for taking the time to read this and your help regarding this matter. I've attached an excel workbook that is meant to be a nearly fully automated rent concession template able to be used to quickly amortize rent up to a 20 year period of time under various conditions. I was hoping for suggestions on ways I could improve it, or any issues anybody may be able to find, regarding the layout, formula calculations, or any other limitation or improvement you can think of or suggest.
This is my first post on this website, although I have used Chandoo.org extensively to enhance my excel skills.
For some background on me: I am an accountant at a large corporation. I love to problem solve using excel and try to optimize/automate as much of my job or anyone else's that I can. I've been developing my excel skills for about 2 years now.
Thank you very much in advance for your assistance.
Best,
Ian
First, I'd like to thank you for taking the time to read this and your help regarding this matter. I've attached an excel workbook that is meant to be a nearly fully automated rent concession template able to be used to quickly amortize rent up to a 20 year period of time under various conditions. I was hoping for suggestions on ways I could improve it, or any issues anybody may be able to find, regarding the layout, formula calculations, or any other limitation or improvement you can think of or suggest.
This is my first post on this website, although I have used Chandoo.org extensively to enhance my excel skills.
For some background on me: I am an accountant at a large corporation. I love to problem solve using excel and try to optimize/automate as much of my job or anyone else's that I can. I've been developing my excel skills for about 2 years now.
Thank you very much in advance for your assistance.
Best,
Ian
Attachments

225.3 KB Views: 11