Results 1 to 3 of 3

Unique Loan Repayment calculation

Threaded View

MegaD Unique Loan Repayment... 06-22-2010, 05:30 PM
shg Re: Unique Loan Repayment... 06-22-2010, 06:40 PM
MegaD Re: Unique Loan Repayment... 06-22-2010, 10:40 PM
  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    Alberta, Canada
    MS-Off Ver
    Excel Mac 2008
    Posts
    2

    Red face Unique Loan Repayment calculation

    Hi

    I am an absolute novice with Excel (only used templates, mostly...) so please excuse if there is a simple answer to my issue which I have overlooked.

    I am borrowing $2500 from a friend. I will be repaying different amounts at different times. We have agreed that I will repay the $2500 plus the interest she would have earned from her savings account on the amount loaned, 1.5% annually (which may change if rates improve before I have fully repaid her) calculated daily and paid monthly.

    She is loaning me the money to help me purchase equipment needed to start a small business (a new camera for my photography business), I will be paying her back with any profit I earn until I have repaid the amount including the interest.

    I am not sure if I am overthinking the situation and all it is is a simple interest calculation or if this is a more complicated issue. I am looking for a way to be able to input the amounts I have repaid and calculate the interest on the amount still outstanding until I reach a zero balance owed.

    I think it's simply a FV calculation in which I would change the PV each time I make a payment, but I am not sure and would love some experienced feedback.

    Any help or guidance in figuring this out is MUCH MUCH appreciated!!!
    Last edited by MegaD; 06-22-2010 at 10:44 PM.

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