• Facebook - White Circle
  • Twitter - White Circle
  • LinkedIn - White Circle

© 2019 Excel Model Shop

Airbnb investment model

Purpose

The purpose of the model is to enable the user to forecast an Airbnb property investment. The model has the capability to estimate the returns of an AirBnB-type property investment.

 

Outputs

  • Integrated Financial Statements including Income Statement, Balance Sheet and Cash Flow
  • Dashboard including key summary financials, results, Return on Investment (ROI), capital gain, and investment cash requirement

 

Timeline

  • The model has a monthly timeline that runs for 10 years
  • There are annual summaries
  • A flexible model start date and flexible forecast start date
  • The ability to include both historical actual data and produce forecast data
  • The ability to enter historical Profit and Loss balance and an Opening Balance sheet

 

General

  • The ability to update the model units
  • The model provides check and commercial alert messages to assist the user

 

Structure

  • The ability to enter up to two scenarios to be able to compare between different pricing structures etc
  • There is a macro within the model required in order to update the mortagage calculations. There is a button at the top of each sheet called "Update debt calcs". The alert message will prompt the user when to click the macro button. The user is not expected nor required to have specialist knowledge of VBA or macros in order to benefit from this model

 

Sales

  • The user can enter assumptions such as occupancy rates and prices to create an AirBnB type model
  • There are different assumptions for peak times during the year such as the summer or winter (user defined)
  • The user can enter different assumptions in terms of occupancy and prices for weekends

 

Property purchase

  • The user has the ability to enter purchase assumptions such as date, sale price, legal costs, company set-up costs and historic property price growth
  • Enter assumptions for property taxes based on the value of the priperty
  • Enter mortgage or loan assumptions such as the type of loan, the deposit required, the term, the initial term, interest rates, whether the investor overpays the mortgage, any upfront fees

 

Cost of sales

 

  • Include potential cleaning fees (normally required for an AirBnB type model), service fees, and management company fees
  • Assumptions are entered annually as either a percentage of sales or fixed cost

 

Overheads

 

  • Split by local taxes, bills, service charge, insurance cost, miscellaneous charges, sundries, furnishings and maintenance
  • Costs are entered annually
  • User defines the month in which insurance costs and other miscellaneous charges are paid

 

Taxes

  • User enters an annual tax rate and manually enters when company tax is paid
  • T&Cs

    Refer to T&Cs page for Terms and Conditions of sale

£50.00Price