For the Revere Street Case Study, construct pro forma financial statements to the MS Excel model as depicted in Foundations of Real Estate Pro Forma Modelling by Roger Staiger.  The model must include 10-year forecasted balance sheet, income statement and statement of cash flow.  In addition, provide pro forma ratio summaries for the 10-years (these are critical and not reviewed in the book).
The MS Excel model construction is demonstrated in Roger Staiger’s book.  In addition to the write-up explaining the financial performance of the multifamily project, include a thumb drive, i.e. electronic submission, of your MS Excel model with pro forma financial statements and ratios.  The electronic model will be checked to ensure integrity and validity of your pro forma statements, i.e. that they actually work with the model and forecast correct.
Please note that you will need to adjust the inputs section to accommodate Accounts Payable, Accounts Receivable (suggest 30 days), tax (Use a flat 35% for Federal and 6% for state), and depreciation (use straightline methodology).

Do you want your assignment written by the best essay experts? Order now, for an amazing discount.