Posted: December 6th, 2022
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:
Place an order in 3 easy steps. Takes less than 5 mins.