20 - Excel Formulas

ucla | MGMT 170 | 2023-06-12T10:39

Supplemental

REVIEW Q25 of Practce Final regardng FAR
refi is tax free
taking sale proceeds in installments reduces tax or may be tax free
rsing interest → inc cap rate → dec property value
triple net pays everything but loan payments
REIT must pay out at least 50% of proceeds
fannie mae and freddie mac own 50% of all american resi loaans
commericial loan have prepayment penalities and lockouts while resi loans DO NOT have prepayment penalties

=PMT
rate, nper, pv, fv, type
- in monthly periods
- use to find monthly payments
- Debt Service is PMT for the period (annual)
=RATE
=PV
=FV
=CUMPRINC
- use to find cumulative amortzation from start to end date
=CUMIPMT
- finds cumulative interest paid between start and end date
Cap Rate
- = NOI / Purchase Price
Debt Service
DSCR
- = NOI / Debt Service
- = annual PMT / NOI
NOI
- = Income - opex (possibly with expense stop)
Depreciation
- 27.5 years for Resi
- 39 for Commercial
taxable income
- NOI - interest pai - depreciation
BTCF (before tax cash flow)
- NOI - ddebt service
FAR
- floor to area ratio → determins number of floors as a multiple
- i.e. if u have some square footage → multiply by FAR to get total over all floors

📌

**SUMMARY
**