Monthly Compounding Interest Calculation for varied monthly rate
- or -
Post a project like this1231
$10
- Posted:
- Proposals: 2
- Remote
- #3072935
- Awarded
Description
Experience Level: Entry
I have attached an excel sheet wherein i have calculated monthly compounding interest with same rate of interest through out (file attached).
MY REQUIREMENT IS TO CALCULATE COMPOUNDING INTEREST (MONTHLY) WITH VARIED RATE OF INTEREST AS PER ATTACHED SHEET.
THE SUBMISSION SHEET SHOULD BE EDITABLE FORM.
The calculations must be self explanatory and easily understandable with illustration and required write-up.
The calculation done in my shared excel sheet is as per 18% pa (monthly compounding). I am attaching excel sheet where periodic interest rate is mentioned for different month. The compounding interest is to be calculated from beginning till end i.e. for the period mentioned in column "E" to period mentioned in column "F". The interest to be calculated with varied rate of compounding interest as mentioned in sheet titled "Period Interest Rate". Total 13 nos. of values is to be calculated but with different monthly interest rate (compounding) as mentioned in sheet titled "Periodic Interest Rate". The compounding interest calculation is to be done for value mentioned in column "B" of sheet titled "Details". Interest to be calculated on monthly compounding basis. The change in rate of interest should be visible in table along with relevant month & year. So format of table should be appropriate and comprehensive. The format should be suitable for A4 printing.
MY REQUIREMENT IS TO CALCULATE COMPOUNDING INTEREST (MONTHLY) WITH VARIED RATE OF INTEREST AS PER ATTACHED SHEET.
THE SUBMISSION SHEET SHOULD BE EDITABLE FORM.
The calculations must be self explanatory and easily understandable with illustration and required write-up.
The calculation done in my shared excel sheet is as per 18% pa (monthly compounding). I am attaching excel sheet where periodic interest rate is mentioned for different month. The compounding interest is to be calculated from beginning till end i.e. for the period mentioned in column "E" to period mentioned in column "F". The interest to be calculated with varied rate of compounding interest as mentioned in sheet titled "Period Interest Rate". Total 13 nos. of values is to be calculated but with different monthly interest rate (compounding) as mentioned in sheet titled "Periodic Interest Rate". The compounding interest calculation is to be done for value mentioned in column "B" of sheet titled "Details". Interest to be calculated on monthly compounding basis. The change in rate of interest should be visible in table along with relevant month & year. So format of table should be appropriate and comprehensive. The format should be suitable for A4 printing.
Suumit M.
80% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
67%
Last project
21 Nov 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies