Learning Goal: I’m working on a real estate spreadsheet and need support to help me learn.Assignment instructions:Files in this content area are examples of helping you prepare for the project. For the actual project, use the PDF at the bottom of this page. (Do not create your project based on the full example PDF here or the one shown in the video).This project is designed to introduce you to a variety of real estate concepts involving multi-housing real estate investment including vacancy, expenses, net operating income, and depreciation. Other concepts are reinforced from prior projects including payments, loan balances, principal payments, IRR, and NPV.The first steps are to watch the lecture videos, read the text, and do some of your own independent study on the concepts listed above. Of course, contact me if you have questions but DO NOT wait until the last few days before the project is due. I may be busy and unable to meet at a time that matches up with you! Our department also has an Excel tutor available to help if you need some assistance – but you must ask and do it early, not the day the project is due!The following items are examples that show you both a fully completed project and a detailed video walkthrough of me building the model step-by-step. Your video should roughly match mine. It should feature you building the spreadsheet cell by cell and describing what you are doing. Your project has two parts.1) A complete, working spreadsheet that was built by YOU ALONE. This should not be a group project and you must NOT take somebody else’s spreadsheet and change a little formatting to disguise the fact you CHEATED. (Must be your own work!)2) Enough videos recorded at www.screencastomatic.com for you to narrate your entire model building process. For some of you, this may take only two videos at fifteen minutes each. Some of you will upload 2 HOURS of video (please try NOT to do this). Use pause often to avoid long stretches where you are thinking or just typing in lots of text, headings, etc.IMPORTANT – BOTH PARTS OF THE PROJECT MUST BE COMPLETED IN ORDER TO QUALIFY FOR FULL CREDITPrint out a copy of the Example Solution below and watch along with the video (Note that when I’m calculating the effective gross income, I accidentally put the year (1, 2 or 3) into my “sum” formula!! Don’t do this ;-))Example Solution – DO NOT use these numbers for your Project!Video of Example Solution – (Make sure you enable Flash, click on the “Lock” next to the web address and allow Flash, then reload the page) – DO NOT use these numbers for your Project!Here is yet another link to the example video for you to try if the one above give you trouble… apt2012.mp4Then, take the following PDF and record yourself building your own video using the following PDF with different assumptions. When you’re done, upload your Excel file and video recordings to the Dropbox.Actual Project Assumptions <--- use this file when you create your spreadsheet.
For This or a Similar Paper Click Here To Order Now
