Please do not respond if you cannot complete today:

I need help creating an excel spread sheet, I am not sure where to start on this one. Thank you

PLEASE NOTE – ALL RELEVANT information is attached. I mainly need the help with the spreadsheet.

Using the information calculated in previous weeks’ activities (NOI, debt service, interest, depreciation, and taxes (using an assumed 28% tax bracket) and ATCF) compute the before- tax IRR and NPV as well as the after-tax IRR and NPV.  Briefly discuss the impact of the following:

1)         A lower interest rate on the loan

2)         A higher depreciation deduction

3)         A lower NOI (aka higher expenses)

4)         A lower tax rate

You  must submit an EXCEL spreadsheet to validate your analysis.  Show the different scenarios in different tabs of the spreadsheet.   Ideally you will create a “master” table with all of your variables and reference each of the variables in your formulas.

Property I am using:

http://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&ved=0CFsQFjAF&url=http%3A%2F%2Fcp.capitalpacific.com%2FProperties%2FBalentine-Plaza–NewarkCA.pdf&ei=Qwb0UabMD6vriQLz8oHoCA&usg=AFQjCNEp_-SB0ISu74lMOrJQaTEpcNuHYg&sig2=XrDBUjj7osxxn4rxqlzv4A&bvm=bv.49784469,d.cGE