Thursday, June 18, 2020

Send You A Real Estate Cash Flow Analysis In Excel











About:

If you are a real estate investor, this sheet is for you! This sheet will allow you to enter the financials for your property, or potential investment, and from it you can extract basically everything you want to know about how that property should perform over the next 5-10 years! (rents, mortgage and expenses, taxes, cap rates, potential profit when you want to sell, and internal rates of return on the project).



For my capstone course in college I created this absolutely beautiful 10 year property cash flow spreadsheet. Every single cell is correctly linked, and it is completely ready for you to enter your property's information. The spreadsheet is extensive and includes tabs for Variable Rates (choose rate & inflation for Vacancy Rates, Operating Expenses, & Potential Gross Income), Annual Operating Data Input Sheet, Sensitivity Analysis (premium version only), Full Amortization Schedule (premium only) 10 year ratios, 5 and 10 year Before Tax Cash Flow, After Tax Cash Flows, Unlevered ATCF, Internal Rate of Return (IRR), Gross Present Value & Net Present Value of your project.  Prudently invest in your investments :)



10 yr amortization - Standard Package

Reviews


:

Quick, easy, and as described. Thanks

:

Very quick turnaround. I appreciate it..

:

Great quick seller

:

very knowledgeable

:

very impressive work




No comments:

Post a Comment