Excel.. How to solve this ( Maths) in Excel ( FINANCIAL )

[ishan01us]

Hi Friends,
I need your help.
I am learning excel and i have a excel file with few instructions.
Can any one able to solve this, & understand me - how we will solve it. it will be a great help.
Please find the attached excel(Math-Finance file). I tried to solve but I am not sure ,what i did and it seems its not matching


Please solve & kindly help me to understand.

I am not able to find the attached file options _

Rebate Calculation Sample:

<tbody>
</tbody>

	Gross Fee
From	To	% Rebate	$	Rebate	Net
	0		25,000.00	0%	$	-	$	25,000.00
$	25,001.00	$	50,000.00	10%	$	2,500	$	22,499.00
$	50,001.00	$	100,000.00	15%	$	7,500	$	42,499.00
$	100,001.00	$	200,000.00	20%	$	20,000	$	79,999.00
$	200,001.00	$	500,000.00	25%	$	75,000	$	224,999.00
$	500,001.00	$	1,000,000.00	30%	$	-	$	-
					$	105,000	$	394,996.00
									Q

<tbody>
</tbody>

Q. 1: Create a spreadsheet to make this calculator work where the Gross Fee is the only input to calculate the Rebate and Net. Model needs to work for any Gross Fee input value.

Q 2: Instead of using the visuals above, create a single formula field to calculate the Rebate and one to calculate the Net but referencing only the Gross Fee. Single formula means Rebate = Gross Fees – [THE FORMULA] and Net = Gross Fees – [THE FORMULA].

Q 3: Using Test 1 and 2, calculate Rebate and Net from the Gross Fee of 9,542,332.56

Help: Model needs to work for any value. Single formula means Rebate = Gross Fees – [THE FORMULA] and Net = Gross Fees – [THE FORMULA]. ==================

2nd questions : Lease Terms: Lease Commencement 01-01-15 Lease Expiration 31/12/19 Area (SqFt) 2.5 Base Rent (Per Month) $55,000.00 OPEX (Per Month) $5,000.00 Base Rent Growth Rate 3% pa Opex Growth Rate 2% pa - First 2 months are free rent months - Calculate the Cash Flow for the lease term Help: Show Total Obligation and Avg Cost / SF per year and for the whole term <tbody> </tbody>

<tbody>
</tbody>