This preview shows page 1. Sign up to view the full content.
Unformatted text preview: above information. Please use the levered template posted on Blackboard as a guide. For NOI, please use the numbers found in the solution to the unlevered University View spreadsheet (given in the template). You will need to search online for the current 10-year Treasury rate to calculate your overall interest rate. The formulas you may need to complete this assignment: =PMT() for solving monthly payment (recall that your annual Debt Service obligation will be the =PMT()*12) =FV() for solving OLB =PV() for solving the loan amount where you are given a DSCR target =NPV() for solving the levered present value of the property =min() for determining which loan is chosen. This would go in the box labeled Actual Loan Amount Received =IRR() for calculating the levered project IRR....
View Full Document
This note was uploaded on 06/08/2011 for the course BUAD 400x at USC.