Using your existing excel spreadsheet, find the tabs labeled “Sources & Uses”, “Cash Flow,” “Sale,” and “Amortization.” Locate the “Cash Flow” tab and complete the analysis. Please keep in mind that your project may have a negative cash flow. If so, the next assignment will attempt to provide creative solutions to mitigate this.
Assignment #5 406 South Boulder Ave (DRAFT) Rent Roll Residential Income Unit Type (Bd/Ba) # of Units SF Per Unit Total SF Monthly Rent/Unit Monthly Rent Total Total Annual Rent Monthly Rent/SF 1.Bedroom 50 750 37,500 $ 1,850 $ 92500 $ 1,110,000 $ 2.47 2.Bedroom 60 900 54,000 $ 2,150 $ 129000 $ 1,548,000 $ […]