1 / 0

FIN 331 Phase 3 Exam

FIN 331 Phase 3 Exam. Real Estate FIN 331. Formulas and Calculator Operating Reminders. Rental Properties PGI – (V + CL) = EGI – (OE + CAPEX) = NOI ( above the line CAPEX) PGI – (V + CL) = EGI – OE = NOI – CAPEX = EBIT ( below the line CAPEX) CR = NOI / PRC OER = OE / EGI

hugh
Download Presentation

FIN 331 Phase 3 Exam

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. FIN 331 Phase 3 Exam

    Real Estate FIN 331
  2. Formulas and Calculator Operating Reminders Rental Properties PGI – (V + CL) = EGI – (OE + CAPEX) = NOI (above the line CAPEX) PGI – (V + CL) = EGI – OE = NOI– CAPEX = EBIT (below the line CAPEX) CR = NOI / PRC OER = OE / EGI EGIM = PRC / EGI
  3. Formulas and Calculator Operating Reminders Net Present value Don’t forget the minus sign (+/-) key  BA II Plus: Use the CF subroutine to record -CFo, CO1…CO5. All F0x values are 1. Press NPV key to enter Discount rate. [], then ComPuTe NPV. TI-83/84: APPS, ENTER, scroll down to 7npv (. ENTER. npv(DR, -ICO, {CF1, CF2, …,CF5}) ENTER to compute NPV.  don’t forget the minus sign. “{“ and “}” using 2nd ( and ), respectively. The negative value sign is the white key (-); press it first then enter the value and press ENTER.
  4. Formulas and Calculator Operating Reminders Mortgage Loan Payments BA II Plus: The TVM keys are in the 3rd Row: ( N ) (I/Y) ( PV ) ( PMT ) ( FV ) Make certain you set the P/Y value to 12 (number of payments per year. C/Y should also be set to 12. Enter Values for N, I/Y, PV (loan amount). CPT (compute) PMT (payment) Display should show PMT = -x,xxx.xx
  5. Formulas and Calculator Operating Reminders TI-83/84: APPS, (cursor at 1:Finance) press ENTER, (cursor at 1: TVM Solver) press ENTER . Screen shows various values in same order as the BA II Plus. Make certain P/Y and C/Y values set to 12. N = number of months in term (180 for 15yr mortgage, 360 for 30yr mortgage. Use blue cursor keys to navigate to each line then enter the appropriate values and press the ENTER key. Cursor to PMT, press ALPHA key then ENTER key. Line should show PMT = -xxxx.xxx (however many decimals you have the calculator set to show.
  6. Formulas and Calculator Operating Reminders To change decimal places: Press MODE key. Cursor down to Float: Cursor to number of decimal places desired; “2” is usually sufficient for mortgage problems. Press ENTER key. 2 should now ne blinking. Press 2nd Quit. Calculating Lenders Yield: First calculate PMT then reduce the PV value by the amount of the points. Recompute I/Y value. To compute the Effective Borrowing Cost (EBC), follow the same procedure as in #3 above, except that you reduce tie PV value by the sum of the points paid plus the financing costs charged by the mortgage banker or broker.
More Related