KOWIYU digital world of Financial Analystics projects portfolio.

Welcome to the realm of financial acumen, where every number tells a story, and every trend carries the weight of potential. As a seasoned financial analyst, I have traversed the intricate landscapes of markets, deciphering complexities, and uncovering opportunities that often elude the untrained eye. With over 2 years of unwavering dedication to the craft, I've cultivated a portfolio brimming with projects that epitomize precision, foresight, and strategic prowess.
Within these digital walls, you'll find a curated collection of my most notable endeavors, each one a testament to my commitment to delivering actionable insights and driving tangible results. From meticulously crafted investment strategies to in-depth market research reports, every project encapsulates the essence of my analytical prowess. Join me on this journey as we delve into the dynamic world of finance, where data reigns supreme, and astute analysis holds the key to unlocking unparalleled success. Step inside, and let's embark on a journey where numbers come alive, and opportunities abound.
.

Taiwan Semiconductor Manufacturing Company(TSMC)
Equity Report

This is an equity research report of TSMC. The objective is to provide investors with recommendation whether to buy, sell, or hold their investment of TSMC. The forcasted period is between 2022 to 2026 financial year.
Based on a comprehensive analysis of TSMC's industry position, financial performance, and market dynamics, I initiate coverage on TSMC with a SELL recommendation. This recommendation is derived from a target price of NT$ 370, representing a downside of 17.7% from the current market price. The target price is determined through a discounted cash flow (DCF) valuation methodology, utilizing a weighted average cost of capital (WACC) of 11% and a terminal growth rate of 4%. Note: This is not a financial advice but for educational purpose. Therefore,Investors are advised to carefully consider this recommendation in the context of their investment objectives, risk tolerance, and portfolio strategy.

Netflix
Equity Research Report

This project is an equity research report of Netflix. The OBJECTIVE of the project is to provide investor with investment advice of whether to buy,sell or hold their investment of Netflix.The forecasted period is between 2023 to 2027 financial year
The full report contains the following slide: 1.Story 2.Sales 3.Fundamental,valuation,momentum,and risk 4.Porter Five Force, 5. Excecutive team 6.World Class Benchmarking(WCB) 7.ESG 8.Value and 9.Risk.
RECOMMENDATION: I initiate coverage on NETFLIX with a SELL recommendation based on a target price of US$103, implying a downside of 65.4%. I derive my target price from a DCF-based valuation using a WACC of 11.6% and a terminal growth rate of 2%.

Employees Analytics Report
for Smith Corp

This project is an HR analytics report of Smith Corp.Smith Corp is a leading technology company specializing in software development and IT services.
My TASK as a consultant analyst of Smith Corp is to create an employee performance report that will be presented to the management team. The report's purpose is to inform the compensation process and ensure that compensation aligns with employee performance effectively. I collaborate with the HR team to gather relevant data.I used power query to perform ETL and therefore perform DATA MODELLING with employees performance data as central focus and also define appropriate relationships between the data to support performance analysis. The analysis was eventually visualize using MICROSOFT POWER BI to communicate the findings to the management. Click the LINK below to see the interactive DASHBOARD.

Cinemax Studio
Analytics Report

This is an analytics report of CineMax Studio.CineMax Studios is a well -established movie production company with a rich history spanning several decades. Renowned for producing a diverse range of films, CineMax Studios has contributed significantly to the entertainment industry.
THEIR CHALLENGE:
Despite its success, CineMax Studios faces the ever -evolving challenges of the film industry. In an era where data -driven decision -making is pivotal, the studio recognizes the need to harness the power of analytics for a competitive edge. The challenge lies in understanding the intricate dynamics of their extensive movie library, identifying patterns that lead to success, and strategically planning future productions to meet audience expectations.
As a Business Intelligent Consultant to Cinemax Studio, I was tasked with implementing a comprehensive data analytics solution that empowers the studio to make informed decisions. This involves leveraging Microsoft Power BI, a robust business analytics tool, to analyze historical performance, uncover trends, and provide valuable insights into the studio's movie portfolio. The following questions were provided answer with:
✓ What are the key factors influencing the success of our past movies?
✓ Which directors and genres have consistently delivered the highest-rated and highest-grossing films?
✓ How have box office earnings evolved over the years, and what insights can be derived to guide future investment strategies?
Click the link below for INSIGHTFUL DASHBOARD that answer those question.

SafeFoot Co.
Five years DCF Model

SafeFoot is a new company that manufactures and sells a unique type of eco-friendly footwear. The company is seeking investment to fund its growth and expansion plans. In order to secure funding, SafeFoot must provide a robust financial model that demonstrates its financial projections and growth potential.
As a financial analyst Consultant to the start-up company, i contributed to the fund raising by developing a financial model that shows the company's projected financial performance over the next five years.
The Model take into account the following component:
1. The company's revenue streams, cost of goods sold, operating expenses, capital expenditures, and potential financing options.
2. The model must also provide key financial metrics such as gross profit margin, operating profit margin, and cash flow projections.
3. The model must also reflect different business scenarios
Click the LINK below to see the full detail of the MODEL.