+ Reply to Thread
Results 1 to 2 of 2

Lease Payment Calculation

  1. #1
    Registered User
    Join Date
    02-16-2010
    Location
    Chicago IL
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation Lease Payment Calculation

    Hello,
    I'm trying to figure out a lease payment for a client of mine. I am leasing them equipment for 3 years, with a present value of $27,023, a residual value of $1, and a 15% rate of return. That part is simple, but I'm trying to account for the 8% cost of money to me. I'm getting that $27,023 from an investor expecting an 8% return. I am charging my client a 15% return and I make my money on the 7% margin. How can I calculate my client's payment using Microsoft Excel?
    Thanks.

  2. #2
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Lease Payment Calculation

    Maybe I'm missing something, but if you're charging 15%, how does what you're being charged affect the client? You have your principal, which you're being charged interest for, and loaning to your client for more. Your margin is the difference in payment between your client on the 15% and you on the 8%.

+ 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