I want to calculate interest on an account.
Interest will be calculated daily and compounded monthly.
I have a statement of the account that gives me debits, credits and a running balance.
Some day there will be multiple transactions, and some days there will be none.
I need an excel or access solution to take this input data and give me 365 daily closing balances.
See the attached file for an example of the source data I would have, and my desired output data.
Such jobs are my daily practice. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to Plus
13 freelance font une offre moyenne de $123 pour ce travail
Hi I am an excel expert as well as certified professional (equivalenT to CPA). I would like to apply for the job posted by you. Thanks Rohit
we do not offer package we offer Only guaranteed results..100% quality work within time limit...Read more in PMB
Hi, I'm Jenny. Well oriented, well organized and accurate in doing my job. Can extend working hours if its needed. I always wanted to have an excellent appreciation from my client. Thanks,
Respected Sir, I am sumit narang from India. I am Microsoft certified solution developer having certification from usa and got certificates signed by bill gates and master of visual basic.I a Plus
This can be done in Excel macro. I can do this for you perfectly as a small software. Please see PM for details. You will also have choice to extract report any time for any period from this little tool. Simp Plus
Please let me know when we have to start the work for you . I am also on Skype add me as sankalpsaxena7