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. 

attached file 


*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 
Q

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 


My Email id is - urs.ish...@gmail.com .

Please send the excel solved file & let me know, how to solved it .. please 
TRY TO reply ASAP ..thanks

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Attachment: Financial Analysis (3).xlsx
Description: MS-Excel 2007 spreadsheet

Reply via email to