+ Reply to Thread
Results 1 to 6 of 6

Lease with residual

  1. 11-03-2010, 05:57 PM #1
    BRISBANEBOB
    BRISBANEBOB is offline
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Lease with residual

    I am trying to construct a table where a loan (say $500,000) is 50% amortised over a given period (say 5 years) at a fixed interest rate. I can't work out the formula which will allow it to calculate interest on the full $500k in the monthly repayments but only make capital repayments on $250k

    I am trying to use PMT. Is that suitable?

    Thanks for any advice.
    Last edited by BRISBANEBOB; 11-04-2010 at 12:17 AM.
    Reply With QuoteRegister To Reply
  2. 11-03-2010, 08:05 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Lease with residual

    I am trying to use PMT. Is that suitable?
    Think so:

    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 11-03-2010, 08:28 PM #3
    BRISBANEBOB
    BRISBANEBOB is offline
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Lease with residual

    OK, that's what I thought but when I run it I don't get the $250k residual (see attached). It's close but no cigar so there must be some other switch somewhere which I'm not seeing...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 11-04-2010, 12:01 AM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Lease with residual

    If you're paying monthly, the periods should be 60 and the interest 1/12 of annual interest.
    Reply With QuoteRegister To Reply
  5. 11-04-2010, 12:14 AM #5
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Lease with residual

    E.g., 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 11-04-2010, 12:16 AM #6
    BRISBANEBOB
    BRISBANEBOB is offline
    Forum Contributor
    Join Date
    12-02-2008
    Location
    Brisbane
    MS-Off Ver
    2016
    Posts
    807

    Re: Lease with residual

    Got it - thanks. Much appreciated. Reputation added to.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1