This valuation model is made for 2022 IGEF Value Investment Proposal Competition (Internet Archive). Our team (Team 33) analyzed 1381.HK and valued the company with DCF Model.
The valuation model in Excel format is included in this repository.
Contains actual historical data of Canvest from FY2011 to FY2021, collected from the prospectus and the annual reports of Canvest.
Contains our forecast on the figures presented in Company Historical tab.
Contains the table in Industry+Forecast, in a readable format. The Income Statement, Balance Sheet and Cash Flow Statement (including our forecast) are listed here. This tab also includes the breakdown of the revenue and profit, and calculates some of the key financial ratios.
Contains the DCF model we used to price Canvest.
Contains the calculation of beta (correlation with market) between Canvest and HSCEI Index.
The report will be uploaded to the repository in future if possible.