hello, this is a project that I'm working now to get the ROI of an investment or amount, I'm trying to get the formulas to go with it, I have all the template and option for now, anyone would mind helping me?
Your setup is a little confusing. For example, you have $15,000 for 'ROI %', 10.00% for 'Loan terms' and $0 for Interest Amount. It might help to summarize the project in words to clarify what you are trying to calculate.
SG
I spoke too soon, I have a question, so I'm trying to get the formula to apply or subtract each payment from "data" tab to "Pmt Amount Per Month" so what I'm doing is just function: Annualized Interest $1,950 - SECU $300 (this is from the data template", and I get the value but when I dragged is doesn't work? it adds, instead of subtraction. I'm trying to reduce the $1950, to $0 if I make one payment every single month? can you help me with this formula also how to add the "iferror" so i can leave with the "-" simbols until i entered the next month payment. Thank you for your help.
Thank you so much, for helping me to achieve this task, here's the loom to better understand the logic behind it.
https://www.loom.com/share/cfc319f3bae94124b5634a2a86dbb345
I was able to find the answer for most of this question thank you for your help,
ROI
