software

How can I use excel to calculate percentage rent?

Example - I am the owner of a retail building and I lease to a deli. I have
a lease that states I receive 7% of gross annual sales up to $500,000 and 3%
of gross annual sales over $500,000.

If I have the total gross annual sales in one column, is there an equation
that I can use that will take the 7% of $500,000 and 3% of anything above
$500,000?

thank you

Assume the gross is in cell A1. Use this:

=.07*min(500000,A1) .03*max(0,A1-500000)quot;Paul Squot; wrote:

gt; How can I use excel to calculate percentage rent?
gt;
gt; Example - I am the owner of a retail building and I lease to a deli. I have
gt; a lease that states I receive 7% of gross annual sales up to $500,000 and 3%
gt; of gross annual sales over $500,000.
gt;
gt; If I have the total gross annual sales in one column, is there an equation
gt; that I can use that will take the 7% of $500,000 and 3% of anything above
gt; $500,000?
gt;
gt; thank you

And, for a more generic solution, look he

www.mcgimpsey.com/excel/variablerate.html

--
Kind regards,

Niek Otten

quot;Duke Careyquot; gt; wrote in message
...
gt; Assume the gross is in cell A1. Use this:
gt;
gt; =.07*min(500000,A1) .03*max(0,A1-500000)
gt;
gt;
gt; quot;Paul Squot; wrote:
gt;
gt;gt; How can I use excel to calculate percentage rent?
gt;gt;
gt;gt; Example - I am the owner of a retail building and I lease to a deli. I
gt;gt; have
gt;gt; a lease that states I receive 7% of gross annual sales up to $500,000 and
gt;gt; 3%
gt;gt; of gross annual sales over $500,000.
gt;gt;
gt;gt; If I have the total gross annual sales in one column, is there an
gt;gt; equation
gt;gt; that I can use that will take the 7% of $500,000 and 3% of anything above
gt;gt; $500,000?
gt;gt;
gt;gt; thank you
perfect. thanks for the help!

quot;Duke Careyquot; wrote:

gt; Assume the gross is in cell A1. Use this:
gt;
gt; =.07*min(500000,A1) .03*max(0,A1-500000)
gt;
gt;
gt; quot;Paul Squot; wrote:
gt;
gt; gt; How can I use excel to calculate percentage rent?
gt; gt;
gt; gt; Example - I am the owner of a retail building and I lease to a deli. I have
gt; gt; a lease that states I receive 7% of gross annual sales up to $500,000 and 3%
gt; gt; of gross annual sales over $500,000.
gt; gt;
gt; gt; If I have the total gross annual sales in one column, is there an equation
gt; gt; that I can use that will take the 7% of $500,000 and 3% of anything above
gt; gt; $500,000?
gt; gt;
gt; gt; thank you

excellent source for info. thanks for the help.

quot;Niek Ottenquot; wrote:

gt; And, for a more generic solution, look he
gt;
gt; www.mcgimpsey.com/excel/variablerate.html
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Duke Careyquot; gt; wrote in message
gt; ...
gt; gt; Assume the gross is in cell A1. Use this:
gt; gt;
gt; gt; =.07*min(500000,A1) .03*max(0,A1-500000)
gt; gt;
gt; gt;
gt; gt; quot;Paul Squot; wrote:
gt; gt;
gt; gt;gt; How can I use excel to calculate percentage rent?
gt; gt;gt;
gt; gt;gt; Example - I am the owner of a retail building and I lease to a deli. I
gt; gt;gt; have
gt; gt;gt; a lease that states I receive 7% of gross annual sales up to $500,000 and
gt; gt;gt; 3%
gt; gt;gt; of gross annual sales over $500,000.
gt; gt;gt;
gt; gt;gt; If I have the total gross annual sales in one column, is there an
gt; gt;gt; equation
gt; gt;gt; that I can use that will take the 7% of $500,000 and 3% of anything above
gt; gt;gt; $500,000?
gt; gt;gt;
gt; gt;gt; thank you
gt;
gt;
gt;