+ Reply to Thread
Results 1 to 2 of 2

Interest calculated daily and charged quarterly

  1. #1
    Registered User
    Join Date
    10-18-2011
    Location
    Perth
    MS-Off Ver
    Excel 2010
    Posts
    1

    Interest calculated daily and charged quarterly

    Hi guys.

    Hope you can help. I dont know where to begin. I can calculate on paper but it takes to long. There must be an easier way.

    I have a home loan where the interest in calculated daily on the outstanding balance and charged to the account quarterly (the interest is added to the principal quarterly)

    On paper i do the outstanding daily balance * interest rate = x
    Then i will calculate x/360 = daily interest. Then i repeat every day for a quarter based on what is outstanding (Ie that will change once i make a payment)
    Then i add them all together to work out what the total owing is.

    I would like to be able to use and excell formula that will work out the interest that will be charged at the end of that quarter if i make additional payments on x day in that period. (The x day will differ sometime the extra payment will be at the start of the month and sometime it will be at the end and i would like to be able to work out if i make more than one x number of payments)

    Ie I generally pay into the loan every week (but the amount is different every week)

    In addition...
    I know it may be difficult do you think it is possible to work out if i pay x amount into the loan per week (Amount the same) interest calculated daily charged at the end of the quarter, if it is possible to work out the time it would take to pay off the loan?

    Thank you in advance.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: Interest calculated daily and charged quarterly

    your begging in scratch
    try this:
    Attached Files Attached Files
    Last edited by vlady; 10-18-2011 at 10:59 PM.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1