Hi,
how do i need to use RATE to calculate the interest of a fixed ROI, as shown in the attached picture ?
Regards,
Frank
2015-05-24---16-07-55.jpg
Hi,
how do i need to use RATE to calculate the interest of a fixed ROI, as shown in the attached picture ?
Regards,
Frank
2015-05-24---16-07-55.jpg
Wouldn't the interest rate be 100% per annum?
return on investment (%) = (Net profit / Investment) × 100
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi,
in this case its fixed ROI, no matter how long it takes to pay back. I basically need to re-calculate the interest based on the outcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks