Same class is offered on March 8th and March 15th. Follow up class, "Investment Pro Forma Modeling Course" is on March 22, 201
Building an accurate pro forma is a crucial first step in any real estate investment or development venture. Using and mastering the financial capabilities in Excel can make pro forma models more accurate and bring enhanced meaning to sensitivity analyses.
This hands-on session is designed especially for real estate professionals who want to learn the basics of financial functions using Excel. Students will l earn to use financial functions and advanced tools in Excel and apply them immediately to their own invstment and development models. Financial concepts such as compounding and discounting, IRR and NPV will be reviewed and addressed in detail.
You will receive step-by-step instruction in inputs, formulas, and techniques to construct and manipulate a pro forma using basic real estate finance principles. You will gain a deeper understanding of finance concepts as you apply these concepts in a structured, hands-on learning environment.
Excel Applications to be covered include:
- Present value (PV)
- Future value (FV)
- Number of Periods (NPER)
- Rate (i)
- Internal rate of return (IRR)
- Net present value (NPV)
- IRR with variable date (XIRR)
- NPV with variable date (XNPV)
- Logic functions (IF, AND)
- Absolute and relative references
- Goal seek
- PMT, IPMT, CUMIPMT
- Data validation
- Conditional formatting
- Group and ungroup
- And much more!
|
Site by Web Equilibrium 
