Maestría en Administración - MBA · 2021
Prefactibilidad de una famiempresa de alquiler de cabañas en el sector Guatapé - El Peñol (Antioquia)
This document consists of a pre-feasibility study whose objective was to determine the technical and economic feasibility of a new family business, with which it is sought to start a cabin rental business located in the tourist area of Guatapé and Piedra del Peñol, in Antioquia. The statistical data for calculating the income of the project were obtained in the virtual platforms Airbnb and AirDNA, which consisted of the average prices per night and the monthly percentages of hotel occupancy for the last 36 months in cabins located in the aforementioned tourism sector. On the other hand, the expenses and costs of the project were estimated, and together with the previously estimated income, the base, optimistic and pessimistic scenarios to be evaluated were constructed, which differ from each other by the amount of the expected monthly income. Subsequently, the projected cash flow was prepared, whose inputs were the following: income, costs and expenses, initial investment, financial expenses, depreciation and amortization calculations. The internal opportunity rate (TIO) was then defined and the NPV and IRR were calculated for two cases: with financial leverage and without leverage. The financial model carried out showed that the leveraged project (financed with the banking sector) is viable for the base and optimistic scenarios, while it is not viable for the pessimistic scenario. On the other hand, for the unlevered project (100% own financing), the study shows that it is only viable for the optimistic scenario
Texto completo 116 páginas con texto
Leer la tesis completa Ficha en el repositorio
Contenido
- INTRODUCCIÓNp. 10
- CASO DE ESTUDIO: OPORTUNIDAD DE NEGOCIOp. 12
- JUSTIFICACIÓNp. 19
- OBJETIVOSp. 21
- Objetivo generalp. 21
- Objetivos específicosp. 21
- MARCO DE REFERENCIA CONCEPTUALp. 22
- METODOLOGÍAp. 30
- Estudio del entorno y del sectorp. 34
- Entorno políticop. 34
- Entorno económicop. 36
- Entorno socialp. 38
- Entorno tecnológicop. 39
- Entorno ecológicop. 40
- Entorno legalp. 42
- Estudio de mercadop. 46
- Productop. 46
- Plaza (mercado objetivo – oferta y demanda)p. 51
- Preciop. 52
- Promociónp. 64
- Estudio técnicop. 67
- Localizaciónp. 67
- Tamaño (inversión)p. 71
- Estudio administrativo y organizacionalp. 79
- Estudio legalp. 81
- Evaluación financierap. 85
- Presupuestosp. 85
- Estado de resultados proyectadosp. 93
- Flujo de caja netop. 94
- Criterios de evaluación financierap. 99
- CONCLUSIONESp. 108
- REFERENCIAS BIBLIOGRÁFICASp. 110
- internacionales en 2018 (en millones)p. 14
- Guatapép. 64
- Figura 3 Localización de Colombia en el contexto globalp. 68
- Peñol, en Antioquiap. 68
- Figura 5 Localización de Guatapé y El Peñol con respecto a Medellínp. 69
- Figura 6 Alojamientos en El Peñol listados en Airbnbp. 70
- Figura 7 Alojamientos en Guatapé listados en Airbnbp. 71
- Figura 8 Esquema general de la propiedadp. 73
- Figura 10 Fotos reales de la fincap. 75
- del alquiler del inmueble a los huéspedesp. 79