Skip to content

CodingLikeCoking/Canvest-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 

Repository files navigation

Valuation model for Canvest Environmental Protection Group Co. Ltd. (1381 HK Equity)

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.

Excel Tabs

Company Historical

Contains actual historical data of Canvest from FY2011 to FY2021, collected from the prospectus and the annual reports of Canvest.

Industry+Forecast

Contains our forecast on the figures presented in Company Historical tab.

Transpose + Statements

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.

DCF Model

Contains the DCF model we used to price Canvest.

Beta

Contains the calculation of beta (correlation with market) between Canvest and HSCEI Index.

Our team's full report

The report will be uploaded to the repository in future if possible.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published