The Kickass Entrepreneur
  • About
  • Blog
    • All Blogs
    • Create Wealth (Investing)
    • Entrepreneur Interviews
    • Featured Top Posts
    • Growing Profits
    • Growing Revenues
    • Marketing
    • Positive State of Mind
    • Real Estate Investing
    • Retirement
    • Sales
    • Selling your Business
  • Book
  • Courses
  • Podcast
  • Resources
  • Contact
The Kickass Entrepreneur
Subscribe
The Kickass Entrepreneur
  • About
  • Blog
    • All Blogs
    • Create Wealth (Investing)
    • Entrepreneur Interviews
    • Featured Top Posts
    • Growing Profits
    • Growing Revenues
    • Marketing
    • Positive State of Mind
    • Real Estate Investing
    • Retirement
    • Sales
    • Selling your Business
  • Book
  • Courses
  • Podcast
  • Resources
  • Contact
  • All Blogs
  • Real Estate Investing

Download a Free Real Estate Investment Spreadsheet

  • December 13, 2021
  • One comment
  • 74.8K views
  • 6 minute read
  • Jeff Wiener
Real Estate Investment Spreadsheet
Real Estate Investment Spreadsheet
Share
Tweet
Share

If you would prefer to skip directly to download the investment property calculator excel spreadsheet, you can by following the above link where you can download the Excel sheet for free, or, you can click the red toolbar below. 

Download the Excel Sheet

I’ve written extensively on not only why you should invest in commercial and multi-family real estate, but, how to create wealth by investing in real estate.

In the article:  Here’s How To Buy An Apartment Building And Make A Whopping 110% In Three Years, I detailed my purchasing analysis in regard to investing in an investment real estate property.

The Real Estate Investment Spreadsheet – An Explanation

One of the main criteria, when you invest in real estate, is to analyze the building’s CAP rate, and in addition, to consider how profitable the building is (NOI), and whether it makes for a suitable investment.

There are many factors that go into determining the profitability of investment property such as location, condition, investment purpose, projected cash flows, profit opportunities, etc.

Generally speaking, determining the profitability of an investment property can be achieved in different ways. You can either take advantage of my spreadsheet, engage an experienced consultant knowledgeable in a particular geographical area or use available investment property analysis software tools.

“When estimating how profitable the building Net Operating Income is, there are two methods of calculation which are commonly used: Discounted Cash Flow Analysis (DCF) and Internal Rate of Return (IRR)”, explains Jasper Juhl, a real estate expert and CEO of Better Estimate.

To find out how profitable the building NOI will be with each method, we’ll need to have an understanding of each method and its calculations. 

In the article I referenced above, the building I was considering buying had a fairly low CAP rate. Under most circumstances, an investor might find it difficult to invest in a building with a low CAP rate, however, in this circumstance, I demonstrated why the lower the CAP rate, the better the short-term building increase would be. In this particular case, my return was going to be 110% inside 3 years.

Before moving into the free real estate investment spreadsheet explanation, here’s a quick recap

** NOTE, if you want a more detailed explanation of CAP Rate and Pro Forma cap rate, you can get that from this article:  What is CAP Rate and Pro Forma CAP Rate in Commercial Real Estate and How Can You Create Wealth With These Numbers?

CAP Rate Formula

CAP rate calculation = Building’s Profit (BI) / Building’s Purchase Price

For example, let’s say the building has a sale price of $100,000, and after all expenses including insurance, hydro, and utilities, the profit is $100,00.  The CAP rate will be calculated as:

CAP rate = $10,000 / $100,000 = 10%

Now, there’s one more important real estate formula you need to understand, pro forma CAP rate.

If you’re going to buy that $100,000 building, and you know the building needs $20,000 in repair costs immediately after taking possession, then technically you should add that number into your calculations.

The pro forma CAP rate will consider this $20,000 in additional building repair costs as part of the CAP rate.  

The pro forma CAP rate formula is similar to the CAP rate formula:

Pro Forma CAP Rate Formula:  

Pro forma CAP rate formula:  Building’s Profit after repairs (BI) / Building’s Purchase Price

In this case, the numbers will look as follows:  $10,000 / $120,000 = 8.33%

A large component of the real estate investment spreadsheet is in helping you calculate the building’s CAP rate.  There’s also a multi-family mortgage calculator in the spreadsheet.

Download the Excel Sheet

Real Estate Investment Spreadsheet – The Details

The fields in the free real estate investment spreadsheet are as follows 

** There’s a GREEN Tab called “Start Here”

** Only enter values into the green fields. Do not touch the yellow fields

  • In cell B3 enter the purchase price of the property
  • In cell B4 enter the building’s downpayment
  • In cell B7 enter the amortization period in years
  • In cell B8 enter the interest rate
  • In cell B9 enter the mortgage’s first payment date

Now we move into the monthly rents for the multi family units, so, enter those values into the real estate investment spreadsheet:

  • In cell B12 to B33, you can enter the monthly rents for each unit
  • In cell B37 and B38, enter the parking and laundry revenue

The free Excel sheet will automatically calculate the gross monthly income

Subtract Expenses

In the Excel sheet, you will notice cells C42 to C50 lists many of a building’s typical expenses, and that includes: taxes, insurance, electricity, hydro, gardener, water, management, maintenance, heat, and snow clearing.

Once done, the system will calculate the building’s profit, and, then automatically calculate the building’s CAP rate.

In the sheet that you download, you will notice in cell B56 the CAP rate is 6%.

The system will calculate the yearly profit, and in this case, it is $72,000, the monthly profit is $6,000, and the dollars in your pocket after paying the mortgage is $1,777, which you will see in cell C62. The yearly profit is $21,327 as per the example in the Excel sheet.

Real Estate Risk Arbitrage

In the example I provided above regarding the property where I proposed to make 110% inside 3-years, the property had an approximate 25% IRR (internal rate of return), was an example of something called real estate risk arbitrage.

If you know that you will be able to quickly upgrade and flip a property, and you have calculated the proposed imputed value to be significantly higher, and you can buy something for $X, and sell for $X plus $Y, then you have real estate risk arbitrage.

Download the Excel Sheet

What is Real Estate Recapture

Real estate recapture is the building value that is recovered with every mortgage payment. Each mortgage payment attributes a certain amount toward the principal and the balance toward the interest.  

Let’s say, for example, that you have a $100,000 mortgage, and your next mortgage payment is $700.  Of that $700, $200 goes toward interest and $500 toward the principal repayment. Your recapture, in this case, is $500, and you now have a mortgage of $99,500.

You will notice that in cell C62 I called the field “total profit per month”.  In actual fact, this doesn’t really profit, because some of what the Excel sheet considers “profit” is really a contribution toward the building’s principal repayment, and in turn, is attributed back as equity.

A great tool for real estate companies is a flipbook maker. For example, you can present the results of this Spreadsheet with an interactive flipbook to customers or people interested. By making it interactive and containing all details, you can get more investors’ proposals and more clients for your company.

Monthly Amortization

In the real estate investment spreadsheet, you will notice another tab called “monthly amortization”.  This is a mortgage table.

Click here to download the free rental property investment analysis calculator excel spreadsheet.

PaydayPact is the right choice for you if you need money to invest in real estate.

Other Real Estate Articles I’ve written:

REITs vs Rentals: Should you buy your own investment real estate property or invest in a REIT?

How to Create Massive Wealth Investing in Multi-Family Apartments

What are Real Assets, and How to Diversify Your Wealth by Investing in Them?

How Do You Make Money Investing in Apartment Buildings?

How Can a 25-Year-Old Buy Their First Home in an Expensive Real Estate Market, and Still Create Wealth?

Download a Free Real Estate Investment Spreadsheet

Download the Excel Sheet

Thank you for your interest in THE KICKASS ENTREPRENEUR'S GUIDE TO INVESTING. Three Simple Steps to Build Massive Wealth with your Business's Profits. Please check your email to confirm the book download. Form: 400529

There was an error submitting your subscription. Please try again.

Related Posts:

  • Why is buying real estate in Phuket a good investment?
  • How To Buy Real Estate in Florida with The Highest Return on Investment
  • REITs vs Real Estate Ownership: Should You Buy Your Own Real Estate…
  • Top Free Wii ISOS to Download This Year
  • Invest in Real Estate for as Little as $500 Using Fundrise
  • 5 Things To Consider When Looking For A Real Estate Agent
Share
Tweet
Share
Jeff Wiener

Jeff sold his company to private equity in 2017 and is now semi-retired. Jeff spends time traveling and with his family, writing this blog, managing his real estate portfolio of apartment buildings,  overseeing his investment portfolio, investigating angel investments, coaching other entrepreneurs, and managing his private equity holdings. Jeff is currently on a couple of boards, one for profit, the other not for profit, and now helps entrepreneurs grow their business, profits, and ultimately, create wealth.

Previous Article
android app
  • Growing Revenues

From Idea to App: 5 Easy Steps to Building Your Own Android App

  • December 12, 2021
  • Monica Serreon
View Post
Next Article
a glass timer and assorted coins
  • All Blogs

15 Easy Ways to Save Time and Money When Running a Business

  • December 13, 2021
  • Rene
View Post
You May Also Like
Lawyer and accountant small business
View Post
  • All Blogs

The 8 Reasons Your SME Might Need a Lawyer

  • February 24, 2023
  • Meg Rivera
online casino
View Post
  • All Blogs

What are online games doing to standout from competitors?

  • February 21, 2023
  • Meg Rivera
Enjoying Retirement
View Post
  • All Blogs

Top 10 Best Places to Spend Your Summer Workstation

  • February 9, 2023
  • Meg Rivera
holding laptop
View Post
  • Real Estate Investing

Tackling pros and cons of virtual reality tours when buying and selling houses

  • February 9, 2023
  • Meg Rivera
Investing in Multifamily Properties
View Post
  • All Blogs

How to Choose the Right Neighborhood for Your Family: A Guide to Making the Perfect Choice

  • February 7, 2023
  • Meg Rivera
home
View Post
  • All Blogs

6 Ways To Speed Up Your Home Remodel

  • January 31, 2023
  • Frances
medical form
View Post
  • All Blogs

How Can You Win Your Medical Malpractice Case With The Right Lawyer?

  • January 24, 2023
  • Meg Rivera
volkswagen
View Post
  • All Blogs

Volkswagen VIN Decoder and How Useful It can be

  • January 20, 2023
  • Meg Rivera
1 comment
  1. Pingback: What is CAP Rate, Pro Forma CAP Rate, and CAP Rate Compression? Go Make Lots of Money with These Numbers. | The Kickass Entrepreneur

Comments are closed.

Join 6,472 Entrepreneurs That Get My Business Building and Wealth Creation Posts by Email

I can teach you how to build a successful, profitable business, and turn that into millions in personal wealth.

Thank you for your interest in THE KICKASS ENTREPRENEUR'S GUIDE TO INVESTING. Three Simple Steps to Build Massive Wealth with your Business's Profits. Please check your email to confirm the book download. Form: 400529

There was an error submitting your subscription. Please try again.

We won’t send you spam. Unsubscribe at any time.

Recent Posts
  • Debt consolidation loan form, notepad and calculator. 1
    The When And How Of Business Debt Consolidation
    • March 22, 2023
  • Logistics Software 2
    Accelerating Your Business Growth: The Role of Logistics Software Development
    • March 20, 2023
  • crude oil 3
    Energy Futures: What to expect in 2023
    • March 17, 2023
  • man writing on board 4
    What is the Difference: Lead Scoring vs. Nurturing
    • March 17, 2023
  • group session 5
    Managing Wealth: 4 Reasons You Need to Opt for a Money Management Company
    • March 17, 2023
Featured Posts
  • Become a Decamillionaire
    How to Become a Decamillionaire, Grow your Net Worth to $10 Million, and Join the 1% Club
  • how to become wealthy
    The Entrepreneur’s Secret to How to Become Wealthy and Build a Personal Fortune
  • Most Profitable Small Businesses
    27 of the Most Profitable Small Businesses to Open in 2023
Categories
  • All Blogs (1,034)
  • Business (220)
  • Canadian Financial Products (4)
  • Create Wealth (Investing) (131)
  • Entrepreneur Interviews (25)
  • Featured Post for Main Menu (4)
  • Featured Top Posts (23)
  • Finance (56)
  • Financial and Investment Calculators and Economic Data (114)
  • Fitness (5)
  • Growing Profits (72)
  • Growing Revenues (115)
  • Growing Revenues (70)
  • Marketing (139)
  • Millionaire and Business owner interviews (3)
  • Positive State of Mind (68)
  • Real Estate Investing (17)
  • Retirement (13)
  • Reviews (12)
  • Sales (15)
  • Sell Me This Pen (8)
  • Selling your Business (13)
  • Starting a Business (1)
  • Startup Ideas (14)
  • Technology (112)
  • Top Products (4)
  • Uncategorized (54)
Follow us
Author
Jeff Wiener
Jeff sold his company to private equity in 2017 and is now semi-retired. Jeff spends time…

    CHECK OUT MY BLOG, AND SUBSCRIBE

    about
    The Kickass Entrepreneur

    Expand Your Business, Improve Profits, Create Wealth

    Expand your business, improve your profits, and create wealth. Each one of the three can be elusive goals. Follow the right steps, and you, too, can create financial independence. It is possible … you just have to take the right steps.
    NAVIGATION
    • About
    • Blog
      • All Blogs
      • Create Wealth (Investing)
      • Entrepreneur Interviews
      • Featured Top Posts
      • Growing Profits
      • Growing Revenues
      • Marketing
      • Positive State of Mind
      • Real Estate Investing
      • Retirement
      • Sales
      • Selling your Business
    • Book
    • Courses
    • Podcast
    • Resources
    • Contact
    TAGS
    apartment BATNA Business business failure business growth business sale Capitalization Rate CAP Rate cash cash flow Creating Wealth Discipline entrepreneur entrepreneurship excel extra cash Featured goal setting Growing Business investing investment real estate M&A marketing Marketing KPIs Mergers and Acquisitions | M&A | Entrepreneur Blog Millionaire millionaire next door mistakes MUR Peter Principle Profit profitability real estate retirement revenue Revenues sales sales management Semi-Retirement Blog | Entrepreneur Blog | Small Business Blog small business Stagnant stocks success Thomas Stanley wealth
    RECENT ARTICLES
    • crude oil
      Energy Futures: What to expect in 2023
      • March 17, 2023
    • deck of folders with insurance word on it
      Tips for choosing the right auto insurance coverage
      • February 17, 2023
    • holding laptop
      Tackling pros and cons of virtual reality tours when buying and selling houses
      • February 9, 2023
    • Rising gold prices concept. Investment in precious metals in the stock market
      The Pros And Cons Of Investing In Precious Metals
      • February 9, 2023
    • man looking at his tablet
      These Are The 7 Mistakes Six-Figure Earners Make
      • January 7, 2023
    • starting your own business
      6 Must-Know Tips For Starting Your Own Business
      • January 1, 2023
    The Kickass Entrepreneur
    • Coaching
    • Book
    • Blog
    • Contact
    • Privacy Policy
    • Terms
    • Disclaimer
    • Facebook
    • LinkedIn

    Input your search keywords and press Enter.