Equity valuation : Target Corporation

Detalhes bibliográficos
Autor(a) principal: Teles, João Duarte
Data de Publicação: 2022
Tipo de documento: Dissertação
Idioma: eng
Título da fonte: Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
Texto Completo: http://hdl.handle.net/10400.14/38657
Resumo: This dissertation has as its main objective the valuation of Target Corporation, being its major output the resulting intrinsic value of the company’s stock. To unveil the most appropriate methods to follow and apply in order to obtain this output, a review of the main articles and literature of some of the greatest minds in the finance field was firstly performed. Even though many models were studied and reviewed, only some of them were chosen to execute the valuation, due to its greatest practical applications in “real-life” examples. Resultingly, the first and main method used was the Discounted Cash Flow, which is one if not the most known model to perform valuations. By performing the forecast of the company’s financial statements, it was possible to consequently forecast the free cash flows to the firm, and then achieve the Equity Value. Finally, the fair price of Target’s stock deemed by this model was of $259.83 per share. The second model applied was the Relative Valuation Model. By performing this valuation using P/E, EV/EBITDA, and EV/Sales multiples, intrinsic values of $220.62, $307.28, and $286.09 per share were achieved. The overall conclusion yielded by both these models is that Target’s stock is undervalued, being its intrinsic value greater than its market price. However, the report provided by Morningstar found otherwise, opinionating that its valuations conclude that the stock is overvalued and fairly priced at 159$ per share, being this different fair price the result of different assumptions and report timings.
id RCAP_509c5753435d9568df3e3e4632ccd507
oai_identifier_str oai:repositorio.ucp.pt:10400.14/38657
network_acronym_str RCAP
network_name_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository_id_str 7160
spelling Equity valuation : Target CorporationTarget corporationRetailEquity valuationDiscounted cash flowRelative valuationInvestment banking reportDomínio/Área Científica::Ciências Médicas::Outras Ciências MédicasThis dissertation has as its main objective the valuation of Target Corporation, being its major output the resulting intrinsic value of the company’s stock. To unveil the most appropriate methods to follow and apply in order to obtain this output, a review of the main articles and literature of some of the greatest minds in the finance field was firstly performed. Even though many models were studied and reviewed, only some of them were chosen to execute the valuation, due to its greatest practical applications in “real-life” examples. Resultingly, the first and main method used was the Discounted Cash Flow, which is one if not the most known model to perform valuations. By performing the forecast of the company’s financial statements, it was possible to consequently forecast the free cash flows to the firm, and then achieve the Equity Value. Finally, the fair price of Target’s stock deemed by this model was of $259.83 per share. The second model applied was the Relative Valuation Model. By performing this valuation using P/E, EV/EBITDA, and EV/Sales multiples, intrinsic values of $220.62, $307.28, and $286.09 per share were achieved. The overall conclusion yielded by both these models is that Target’s stock is undervalued, being its intrinsic value greater than its market price. However, the report provided by Morningstar found otherwise, opinionating that its valuations conclude that the stock is overvalued and fairly priced at 159$ per share, being this different fair price the result of different assumptions and report timings.A presente dissertação tem como objetivo principal a avaliação da Target Corporation, sendo o seu resultado o valor intrínseco das ações da empresa. Inicialmente, para descobrir os métodos mais apropriados a serem aplicados a fim de obter este valor, uma revisão dos principais artigos e literatura das maiores mentes da área de finanças foi realizada. Embora diversos modelos tenham sido revistos, apenas alguns deles foram escolhidos para fazer a avaliação, devido às suas maiores aplicações práticas em exemplos da “vida real”. Consequentemente, o primeiro e principal método utilizado foi o Discounted Cash Flow, que é um dos, senão mesmo o modelo mais conhecido para realizar avaliações. Ao realizar a previsão das demonstrações financeiras da empresa, foi possível prever os Free Cash Flows para a empresa e, atingir o Enterprise Value. Finalmente, o preço justo das ações da Target considerado por este modelo foi de US $259.83. O segundo modelo de avaliação aplicado foi o de Relative Valuation. Ao realizar esta avaliação usando múltiplos como P/E, EV/EBITDA e EV/Sales, foram obtidos valores intrínsecos de $220.62, $307.28, and $286.09 por ação. A conclusão geral produzida por ambos os modelos é que as ações da Target estão subvalorizadas, sendo o seu valor intrínseco maior do que o preço de mercado. No entanto, o relatório fornecido pela Morningstar concluiu o contrário, opinando que a ação está sobrevalorizada e com um preço justo de 159$ por ação, sendo este preço diferente o resultado de diferentes suposições e horizontes temporais.Martins, José Carlos TudelaVeritati - Repositório Institucional da Universidade Católica PortuguesaTeles, João Duarte2022-09-01T10:03:51Z2022-02-022022-012022-02-02T00:00:00Zinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/masterThesisapplication/pdfhttp://hdl.handle.net/10400.14/38657TID:202964540enginfo:eu-repo/semantics/openAccessreponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãoinstacron:RCAAP2023-07-12T17:44:09Zoai:repositorio.ucp.pt:10400.14/38657Portal AgregadorONGhttps://www.rcaap.pt/oai/openaireopendoar:71602024-03-19T18:31:34.311424Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informaçãofalse
dc.title.none.fl_str_mv Equity valuation : Target Corporation
title Equity valuation : Target Corporation
spellingShingle Equity valuation : Target Corporation
Teles, João Duarte
Target corporation
Retail
Equity valuation
Discounted cash flow
Relative valuation
Investment banking report
Domínio/Área Científica::Ciências Médicas::Outras Ciências Médicas
title_short Equity valuation : Target Corporation
title_full Equity valuation : Target Corporation
title_fullStr Equity valuation : Target Corporation
title_full_unstemmed Equity valuation : Target Corporation
title_sort Equity valuation : Target Corporation
author Teles, João Duarte
author_facet Teles, João Duarte
author_role author
dc.contributor.none.fl_str_mv Martins, José Carlos Tudela
Veritati - Repositório Institucional da Universidade Católica Portuguesa
dc.contributor.author.fl_str_mv Teles, João Duarte
dc.subject.por.fl_str_mv Target corporation
Retail
Equity valuation
Discounted cash flow
Relative valuation
Investment banking report
Domínio/Área Científica::Ciências Médicas::Outras Ciências Médicas
topic Target corporation
Retail
Equity valuation
Discounted cash flow
Relative valuation
Investment banking report
Domínio/Área Científica::Ciências Médicas::Outras Ciências Médicas
description This dissertation has as its main objective the valuation of Target Corporation, being its major output the resulting intrinsic value of the company’s stock. To unveil the most appropriate methods to follow and apply in order to obtain this output, a review of the main articles and literature of some of the greatest minds in the finance field was firstly performed. Even though many models were studied and reviewed, only some of them were chosen to execute the valuation, due to its greatest practical applications in “real-life” examples. Resultingly, the first and main method used was the Discounted Cash Flow, which is one if not the most known model to perform valuations. By performing the forecast of the company’s financial statements, it was possible to consequently forecast the free cash flows to the firm, and then achieve the Equity Value. Finally, the fair price of Target’s stock deemed by this model was of $259.83 per share. The second model applied was the Relative Valuation Model. By performing this valuation using P/E, EV/EBITDA, and EV/Sales multiples, intrinsic values of $220.62, $307.28, and $286.09 per share were achieved. The overall conclusion yielded by both these models is that Target’s stock is undervalued, being its intrinsic value greater than its market price. However, the report provided by Morningstar found otherwise, opinionating that its valuations conclude that the stock is overvalued and fairly priced at 159$ per share, being this different fair price the result of different assumptions and report timings.
publishDate 2022
dc.date.none.fl_str_mv 2022-09-01T10:03:51Z
2022-02-02
2022-01
2022-02-02T00:00:00Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/masterThesis
format masterThesis
status_str publishedVersion
dc.identifier.uri.fl_str_mv http://hdl.handle.net/10400.14/38657
TID:202964540
url http://hdl.handle.net/10400.14/38657
identifier_str_mv TID:202964540
dc.language.iso.fl_str_mv eng
language eng
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.format.none.fl_str_mv application/pdf
dc.source.none.fl_str_mv reponame:Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
instname:Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron:RCAAP
instname_str Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
instacron_str RCAAP
institution RCAAP
reponame_str Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
collection Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos)
repository.name.fl_str_mv Repositório Científico de Acesso Aberto de Portugal (Repositórios Cientìficos) - Agência para a Sociedade do Conhecimento (UMIC) - FCT - Sociedade da Informação
repository.mail.fl_str_mv
_version_ 1799132039426867200