Category: Teaching

Lesson 3: Mortgage 101

Review:

  • How to buy
  • 3 properties
  • Interview assignment

Presentation:

  • Interview assignment results
  • Mortgage 101 – video series at realtor.com
    • BasicsRatesCredit RatingDown Payment
    • Home Loans
    • Mortgage Process
  • Mortgage Types
    • Fixed vs ARM
    • 10, 15, 20, 30 – which amortization?
    • 1, 3, 5, 7, 10 – which initial time period (before ARM rate adjusts)?

Activity:

Assignment:

  1. Amortization Exercise
    • Use the 3 properties selected in class yesterday.
    • Check out current interest rates.
    • Read about amortization
      • Go to the Bankrate Amortization Schedule Calculator, scroll down and read:
        1. What is an amortization schedule?
        2. How do you calculate amortization?
        3. How do I calculate monthly payments?
    • Generate an amortization schedule
    • Save the amortization schedules
      1. Download or copy the amortization schedule into a spreadsheet
      2. Save the spreadsheet for later use
  2. Interview write-up
    • Write up a 1-page summary from your interview assignment yesterday
    • Yes, only 1 page – you can do it!
More

Lesson 2: How to Buy Real Estate

Review:

  • Course Overview
  • Why Study Real Estate
  • Interest rates

Presentation:

Activity:

  • Select 3 properties currently listed For Sale, in any US market, and note the following
    • Street Address, City, State, ZIP Code
    • # Bedrooms, # Bathrooms, Total Square Footage
    • Asking Price
    • Most recent sales price and date
    • Most recent property tax assessment
    • Link to listing (on Zillow or other)

Assignment:

  • Interview a parent/relative/friend about a recent residential real estate purchase.
    • Use the “How to buy real estate” document to guide the interview.
    • Sample questions:
      • What were the mortgage terms?
      • Who was the lender?
      • How was price negotiated?
      • Were there issues with the inspection or repairs?
      • Were there issues with the appraisal?
      • Was the closing process smooth or were there delays or problems?
More

Module 8: Final Project

Instructions for the final project:

1. Improve your Pitch Deck and ROI Analysis

  • Revise/Edit/Improve your Pitch Deck slides
  • Revise/Edit/Improve the accompanying ROI Analysis
  • Grading standards will be higher for your presentation materials and ROI analysis
  • Tighten up all your slides and then double + triple check your ROI for accuracy, consistency and clarity
  • Your deal needs to make sense.
  • If your numbers aren’t attractive, then find the lowest purchase price that makes them reasonably attractive.

2. Create a video.

  • Each student will create a video in one of two (2) formats
    • Zoom style screen recording (like my lectures), or
    • Homemade video (simply use your phone)
  • In your video you will
    • Present your revised Pitch Deck.
    • Explain your ROI Analysis
  • I want to see your face during the video. Don’t record audio only. This will help me better understand what you know and what you don’t know.
  • Don’t read from a script, make it conversational, like answering questions in a job interview. Use your own words.

3. Your video should be approximately 5 minutes in length.

  • Speak clearly! If I can’t follow your commentary it may negatively impact your grade.
  • Don’t rush through it. Take time to explain yourself.
  • Don’t make the video unnecessarily long but don’t worry if you go a little over.

4. Provide a YouTube link.

  • Post your video on YouTube (yes, only YouTube is acceptable, to keep grading manageable).
  • Post your link in Bb.
  • Post the link only! Please do not try to actually upload the video to Bb or send via email.
More

Module 8: Final Exam

Review:

  • Module 7

Presentation:

  • Video Lecture
  • Please ignore any references to the “Data Science for Business” assignment you may have seen. It’s not required.

Final Exam:

  • I will be sharing a final exam in Google Sheets format on Bb.
  • The Google Sheets file will contain materials and instructions for completing the final exam.
  • Once you have attempted all the exam questions you need to create a video presentation, as described below.
  • Video Presentation Instructions:
    • Each student will create a video in one of 2 formats
      • Zoom style screen recording (like my lectures), or
      • Homemade video (use your phone)
    • Provide a “tour” of your final exam answers with the Google Sheets file displayed.
      • Explain how you approached each question and how you arrived at each answer.
      • Be honest and direct about what you do and don’t understand.
    • Your video should be approximately 5 minutes in length.
      • Speak clearly! If I can’t follow your commentary it may negatively impact your grade.
      • Don’t rush through it. Take time to explain yourself.
      • Don’t make the video unnecessarily long but don’t worry if you go a little over.
    • Post your video on YouTube (yes, only YouTube is acceptable, to keep grading manageable).
    • Post your YouTube link in Bb.
    • Post the link only! Please do not try to actually upload the video to Bb.
More

Module 7: Simulation Part 2

Review:

Presentation:

  • Video Lecture (38 min)
  • Random Variables
    • Discrete Random Variables
      • Probability distribution table
      • Dice Simulation
    • Continuous Random Variables
      • Stock Market simulation next week

Assignment:

  • Stock Market Simulation in Sheets
    • Use Annual Stock Market Return data as a starting point
    • Assumptions
      • stock market returns are normally distributed
      • mean = 11.88%
      • standard deviation = 19.76%
  • Modifications Part 1
    • Generate a 40-year simulation (instead of 30)
    • Modify the simulation to add $1,000 to the balance each year
    • Make a histogram of your ending balances
  • Modifications Part 2
    • Add a “fixed income” (bonds) component to your simulation
    • Assumptions
      • bond market returns are normally distributed
      • mean = 7.88%
      • standard deviation = 6.86%
  • Your “portfolio” should be 60% stocks and 40% bonds
    • How does the distribution of ending balances change?
  • Submit your Sheets link or Excel file here
More

Module 7: REITs

Review:

  • 2008 Mortgage and Housing Crisis

Presentation:

Assignment:

  1. Read: investing in REITs
  2. Identify two (2) REITs from the REIT Directory you might consider for investment.
  3. Write a 2-page paper about each of the REITs. (2 papers, 4 pages total)
    1. Review the recent market performance of each REIT
    2. Answer the following:
      1. Why did you select the REIT, and/or
      2. Why do you expect your selected REIT to outperform the market
More

Module 6: Simulation Part 1

Review:

  • Module 5

Presentation:

  • Video Lecture
  • Probability
    • Topic worthy of its own course
  • Simulation
    • Random phenomenon
      • Individual outcomes are uncertain
      • Regular distribution of outcomes in large number of trials
    • Random number generation and stochastic processes
  • Coin Toss Simulation
  • Dice Roll Simulation

Assignment:

  • Replicate the Coin Toss simulation
    • 200 coin tosses (instead of 32)
    • reproduce the graph (showing 200 tosses)
  • Replicate the “Lucky 7” simulation
    • 100 rolls (instead of 32)
    • Experiment with different Payoff Odds values (in cell K2)
    • What payoff odds would you suggest the Casino owner use to maximize revenue?
  • Simulate Chuck-a-luck where the player rolls 3 dice
    • Here are the rules
    • Apply the following simplifying assumptions
      • If sum of 3 dice >10, player wins the “Big” (1 to 1 odds)
      • If the roll is three of a kind, player wins “Any Triple” (30 to 1 odds)
      • All other outcomes, player loses the bet
    • Will the “House” win money over time with these rules? Explain.
  • Upload to this Google Form
    • If Google Sheets, provide a Shared link
    • If MS Excel, upload your .xlsx file
More

Module 6: 2008 Mortgage and Housing Crisis

Review:

  • Real Estate Investment Pitch Deck

Presentation:

Assignment:

More

Module 5: Investment Proposal

Review:

  • ROI Analysis

Presentation:

  • Video Lecture
  • Funding your real estate investment
  • Think of it as a business startup … because that’s what it is.
  • Prepare a “pitch” for potential investors
  • Feel free to use materials found elsewhere

Assignment:

Create an Investment Proposal “Pitch Deck”

  1. Use the apartment building identified in Module 3.
  2. Calculate valuation metrics (should already be complete)
    1. Price per unit
    2. Gross Rent Multiplier
    3. Cap Rate
  3. Complete an ROI Analysis
  4. Prepare a PowerPoint (or Google Slides) “pitch deck” for potential investors.
    1. Include the valuation estimate
    2. Include the ROI analysis
    3. What is “the ask”, i.e., how much money do you need?
    4. Include a slide about yourself
      1. Why you are the right person to lead the investment?
      2. How will you participate and how will you be compensated?
  5. Submit your pitch deck as a PDF
    1. Download/Save your Google Slides file or your PowerPoint Presentation file (.pptx) in PDF format.
    2. Upload your PDF file to Bb.
More