+ Reply to Thread
Results 1 to 15 of 15

ROI formula

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    ROI formula

    Hi,
    I have problem, I need a formula ROI, when I change month like 60 to 70 or etc the interest Rate calculate as per month changing, please check the screenshot.

    Thanks in advance

    farhan
    Attached Images Attached Images

  2. #2
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: ROI formula

    So, you will be looking to find the RATE associated for a fixed Pmt, when you change the TERM?

    Are you looking to answer: "What rate do I need to get for a given loan term, if I have X dollars to spend on the loan each month"?
    Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: ROI formula

    when I change term for example 60 month to 70 month Rate will be increase as per term like 5 % to 6% .....

  4. #4
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: ROI formula

    Seller takes a free and clear cash flowing rental property and sells it to an investor. The terms of the sale are the investor(buyer) puts 50% cash down on the property and seller then carries a seller financed note for the balance of the purchase price (example selling price 46,631.82 buyer puts down 23,315.91 seller carries a note for 23,315.91. Want to show optimal sales price with the best possible ROI.
    Data Point Manipulation;
    When the seller increases the term (i.e. 60 months to 72 months) then the interest rate MUST increase by one percentage point (5% to 6% etc.)

  5. #5
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: ROI formula

    Right, but that's more of a math problem than an excel problem. Can you post an example sheet? I have something to try in mind.

  6. #6
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: ROI formula

    I have attached excel file please check.
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: ROI formula

    any expert here for help me?

  8. #8
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: ROI formula

    Ok. When I put in 70, your Note Amount changes to 26,667.14 - do you want that value to NOT change?

    Here's why I'm confused:

    If I change Term to 70, leave monthly payment at 440, and change interest rate to 9.9168% - I get a Note Amount of 23,315.92 (same as the Down). I don't see where the 6% comes in.

  9. #9
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: ROI formula

    I told 6% is an example.

  10. #10
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: ROI formula

    Ok, so in that scenario, was the number 9.9168% what you are after? Is that what you wanted to get?


    If my guess was wrong - what are you trying to do? Please provide a specific correct example of the 'right' answer.

  11. #11
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: ROI formula

    no problem in note amount, I only need formula in INt Rate, that should be change according to Term

  12. #12
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: ROI formula

    Please answer my previous question.

  13. #13
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: ROI formula

    Sir, in Simple words I only need formula in Int Rate, formula reflect from Term, when we change term the interest rate will change as per term

  14. #14
    Forum Expert GeneralDisarray's Avatar
    Join Date
    09-15-2011
    Location
    Pittsburgh, PA, USA
    MS-Off Ver
    Windows Excel 2016
    Posts
    1,416

    Re: ROI formula

    I don't know what you are after - I've passed your question off to another posting for further help.

  15. #15
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: ROI formula

    Quote Originally Posted by farhangul View Post
    Sir, in Simple words I only need formula in Int Rate, formula reflect from Term, when we change term the interest rate will change as per term
    I'm not sure I understand any better than GeneralDissarray. Are you looking for the RATE() function? https://support.office.com/en-us/art...0-83fc59e748ce

    If so, I would suggest you become familiar with all of the built in functions related to Present value type problems, as there is a built in function for each quantity in the present value equation.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Tags for this Thread

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