Example can be found here titled: Monthly Deposit Savings Calculator w/Compounding Comparison.
[login to view URL]
I have included a screenshot incase you are unable to view
I need exactly this format for the Inputs except with SIMPLE not compounding interest.
The outputs incremented daily, monthly, quarterly, yearly need to be changed to Monthly, Quarterly, Semi-Annualy, and Yearly.
Instead of future value I want what the amount of interest earned for each period would be.
For example $1000 at 20% interest for 1 year would be $200.
Divided by 12 would be $16.67 monthly payment value.
For Quarterly it would be $200 divided by 4 so the Quarterly payment would be $50.
Semi-Quarterly would have 2 payments equaling $100.
Annualy would have only the one payment of $200.
Also it needs to have a final total amount column totaling the initial amount, deposits, and simple interest.
Please contact me with any questions or with your quote.