ROI
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?
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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?
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.
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
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