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

[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: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 QQ. 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 please solve this,and if u want the excel file , i will send ..