SGD$15

Co-investment Rental Property ROI, Cap Rate Calculator, Real Estate Investment, Rental Spreadsheet, Google Sheets

0 ratings
Buy this

Co-investment Rental Property ROI, Cap Rate Calculator, Real Estate Investment, Rental Spreadsheet, Google Sheets

SGD$15
0 ratings

Are you looking to co-purchase your next rental property for investment?

This Google spreadsheet is designed to facilitate the evaluation of investing in a single, residential property with the flexibility of modelling for joint investing with others.

Use this model to evaluate the profit potential of your real estate investment:

☆ Calculate project ROI, NPV, annual cash flows like a pro

☆ Accounting of year by year P&L to understand your ‘true’ profit

☆ Supports co-investments made by multiple partners, incl. investor-level breakdown of profits and cash flows to be split

☆ Includes a debt amortization schedule and calculator

Model comes with 7 types of Tabs:

1. Enter project level assumptions (cells in yellow) in the model to help you evaluate your single rental property investment. The worksheet is pre-filled with a sample investment deal for your reference.

2. If you are co-investing with multiple partners, fill up their names, % investment share, and indicate whether or not there is an investor who acts as a manager with a 'promoted interest' (i.e., 'sweat equity'). If you are the sole investor, mark their % investment share as 0%.

3. Review Deal Summary: this worksheet shows the investment results of your deal. Return figures are shown both with and without leverage (debt).

4. Review Graphs: these worksheets contains graphics to help you visualize how your investment will look like given your current set of assumptions. These are broken down by Investment Level (what the figures and returns look like at the project level) and Investor Level (what the figures and returns look like for each individual investor).

5. Review Annual P&L to see the annual profit and losses at the investment level, including investor-by-investor view of net cash flows.

6. Review Monthly P&L: this worksheet calculates the monthly profits and losses at the investment level

7. Amortization Calc: this worksheet calculates the amortization schedule for the debt assumed.

⚠️ This digital file is only available as a Google Sheet, not an Excel Sheet. Please do not download it as Excel as this will affect its formatting.

⚠️ After your purchase, you can download your digital file instantly.

Buy this

Final sale, limited exceptions

Due to the nature of digital content, all purchases of digital products, courses and memberships from our Website are final unless a refund is required under relevant consumer protection laws.

In most cases, we cannot process refunds. Reasonable consideration might be exercised on a case by case basis. If you are not happy with your purchase let us know by reaching out to us.

Last updated Jun 29, 2024

Are you looking to co-purchase your next rental property for investment? This Google spreadsheet is designed to facilitate the evaluation of investing in a single, residential property with the flexibility of modelling for joint investing with others.

Model Assumptions
Enter project level assumptions (cells in yellow) in the model to help you evaluate your single rental property investment. The worksheet is pre-filled with a sample investment deal for your reference.
Made For You And Co Investors
If you are co-investing with multiple partners, fill up their names, % investment share, and indicate whether or not there is an investor who acts as a manager with a 'promoted interest' (i.e., 'sweat equity'). If you are the sole investor, mark their % investment share as 0%.
Review Deal Summary
This worksheet shows the investment results of your deal. Return figures are shown both with and without leverage (debt).
Review Graphs
These worksheets contains graphics to help you visualize how your investment will look like given your current set of assumptions. These are broken down by Investment Level (what the figures and returns look like at the project level) and Investor Level (what the figures and returns look like for each individual investor).
Review Annual P&L
To see the annual profit and losses at the investment level, including investor-by-investor view of net cash flows.
Review Monthly P&L
This worksheet calculates the monthly profits and losses at the investment level.
Amortization Calculator
This worksheet calculates the amortization schedule for the debt assumed.
Size
197 KB
Length
1 page
Copy product URL