Spreadsheet formula wanted

tony

Posts: 136

Likes: 91

Spreadsheet formula wanted Nov 5, 2015 16:15:22 GMT

Quote

Post by tony on Nov 5, 2015 16:15:22 GMT

I know little about spreadsheets but I have managed, by trial and error, to create one for recording my P2P investments. It contains a column showing the interest due to be paid to me each month - easy for platforms such as Savings Stream where interest only is returned. Can anyone provide me with a formula which will return the amount of interest plus capital expected each month for Funding Empire and the interest and service fee for platforms like Funding Circle?

tony Posts: 136 Likes: 91	Spreadsheet formula wanted Nov 7, 2015 20:22:21 GMT Quote Select Post Deselect Post Link to Post Back to Top Post by tony on Nov 7, 2015 20:22:21 GMT Thanks for that. I would like to separate my column into two so that one shows the interest due and the other the capital. Can you provide me with formula's to achieve this?

jfm Member of DD Central Posts: 135 Likes: 67	Spreadsheet formula wanted Nov 11, 2015 20:44:05 GMT Quote Select Post Deselect Post Link to Post Back to Top Post by jfm on Nov 11, 2015 20:44:05 GMT Nov 7, 2015 20:22:21 GMT tony said: Can you provide me with formula... Perhaps something like: interest = capital b/f * rate capital repaid = payment - interest capital c/f = capital b/f - capital repaid

Post by tony on Nov 5, 2015 16:15:22 GMT

Post by tony on Nov 7, 2015 20:22:21 GMT

Post by jfm on Nov 11, 2015 20:44:05 GMT