ADDITIONAL WORK
Sensitivity Analysis - FINC 670
This assignment was used to teach us the importance of a sensitivity analysis and how to use it to work out different assumptions in a financial model. The model below is broken down into a Rent Roll, Operating Statement, and a Discounted Cash Flow model.
The Rent Roll shows the break down of different tenants of the building. How much square footage they have, how much they pay (monthly and annually), annual utilities, and CAM charges. Next tab shows the Operating Statement and assumptions used in the model. Going through the Operating Statement helps teach us about the steps of PGI, VCL, EGI, OE, CAPX and finally NOI. Finally the DCF tab expands upon the operating statement to record annual cash flows, and find the DCR, LTV Ratio, and IRR.
President's Point DCF Model - LDEV 668
In LDEV 668 I learned how to value land and find lot pricing, the home price on calculated lot, and annual income to afford the home. I worked on a couple of DCF model projects like the one below, and another one while in LDEV 669 is shown on my budget page as part of the Discipline Knowledge.
One of the DCF project I worked on while in LDEV 668 is below and this was a the first DCF model we were assigned in the class to teach us about a lot takedown schedule, and using our cash sources to finance the development project, and reach our investor's minimum IRR requirement. The model is broken down into multiple tabs including an assumptions page, sales proceeds, cash flow, debt schedule, and the notes and cover pages. The first couple of pages show how to use the assumptions and sales proceeds to figure out the schedule for taking down the 100 lots in the development and the sales revenue that will be acquired by the final months. The Cash Flow tab and Debt Schedule tab taught me about how the developer's loan is scheduled out and how sale proceeds are used to eventually pay off the lender's loan and start making a profit, and a favorable IRR.
