Re: Calcualtion help Message #5 Posted by David on 9 Mar 2004, 1:09 p.m., in response to message #4 by Wayne Brown
Wayne, Thanks for your response. It's not in the manual. It was an equation put together by a guy that has long since disappeared. I know what the tabs look like and what I am trying to accomplish but alas I have not found anyone to help with the following need:
CST = Cost of the equipment. PMT = monthly payment. I%YR = the interest rate I am buying my money at. RV% = This is always a negative # and is used when a balloon is due at the end of the term (10% is a typical buy out). N = the length of the term in months. #ADV = number of advances (due to the time value of money this could increase my profitability on a deal substantially). PTS = The amount of money I would like to make on a deal i.e. 10 points on a $20,000.00 deal would = $2,000.00 of gross margin. There used to be 2 pages to this equation which resulted in a "more" tab.
I am willing to pay for this. I am in desperate need.
|