Apprentice Training Log Excel Template | Training Hours, Skills Sign Off, Goals and Reviews
£15.00
Buy to Let Analyser Excel Template | Yield, Cash Flow, Refurb, Mortgage and 10 Year Projection
Instant download
£19.00
For landlords and property investors weighing up a rental purchase. It works out yield and cash flow and stress tests the deal, so you decide on numbers rather than gut feel. You can compare three deals side by side, budget the refurb room by room and see the mortgage year by year. A ten year projection and exit scenarios show what selling or refinancing could leave you with.
What it covers
- Deal analyser for yield, cash flow and a stress test
- Compare three deals on one page
- Room by room refurb budget that feeds the deal analyser
- Mortgage schedule for interest only vs repayment, year by year
- Ten year projection with rent growth and capital growth
- Exit scenarios comparing a sale with a refinance
Who it is for
Suits new and experienced landlords, property investors, deal sourcers and small portfolio owners.
What is inside
- How To Use and Quick Start guides, from download to working in ten minutes
- Deal Analyser
- Deal Comparison
- Refurb Budget
- Mortgage Schedule
- 10 Year Projection
- Exit Scenarios
- Notes and Actions, Log and Diary and Monthly Review tabs
How it works
Open the file in Microsoft Excel and read the How To Use tab first, it takes two minutes. White cells are yours to type in and blue tinted cells calculate themselves, so there are no formulas to write. The example rows show every feature working, overtype them with your own figures and the totals and charts update as you go.
What you get
- One editable Excel (.xlsx) workbook with 10 tabs
- Built for Microsoft Excel, no macros and no formulas for you to write
- Example rows included so you can see every feature working
- Commercial licence, use in your own business, not for resale
- Instant digital download, no physical item shipped
Small print
Template only. The names, jobs and figures shown in the product images and in the example rows are examples only, overtype them with your own. A planning and record keeping aid, not professional advice, so check big decisions with the relevant professional.
Commercial licence for your own business. Not for resale.
List the documents, pages and formats included.
Page count, file format and how it is delivered.
Single-business commercial licence. Edit and use these files in your own business for as many jobs and clients as you like, and send the finished documents to your customers.
Strictly not for resale. You may not resell, share, give away or upload the files, edited or unedited, anywhere, or use them to make templates for others. SiteSums keeps the copyright.
Common questions about editing and using the template.
