I am considering to build a tool in coda for property management from an investors perspective, but I am still unsure if coda does have the needed functionality. One key element is the ability to calculate loans so that later on the loan to property value ratio can be calculated. Calculating loans is a prime excel task and I was wondering if this task could be accomplished in Coda. I understand that there are some financial formulas but they don’t seem to do the trick since they can’t account for unscheduled repayments.
I am thinking that this would require the possibility to create individual records for each months payment by clicking a button. Each record then calculates interest and repayment plus has an extra field for unscheduled repayments.
Do you think this is feasible in Coda?
P.S. I am currently also evaluating Ninox but don’t like there UI as much as the one of Coda.