https://docs.google.com/spreadsheets/d/1Vp0P91k2xmTNUuWORqwCl378QziYO8zXN99l81-EUdU/edit?usp=sharing
🏠 Final Assignment: Become the Analyst
Objective: Apply the AI-Driven Fair Value Method to a new company to build your practical wealth-creation skills.
Task Instructions:
Pick a Company: Choose one company from the following list:
HDFC Bank (Banking/Finance)
TCS (IT Services)
Titan Company (Consumer/Retail)
Data Extraction: Use the Master Prompts provided in Part 2 to extract 10 years of financial data using Gemini.
Data Cleaning: Copy the data into your spreadsheet and use the
Ctrl + Hmethod to remove commas and symbols.Forecasting: Use Gemini or ChatGPT to analyze the management's recent commentary and suggest a conservative 5-year growth rate.
Calculation: Assign a Fair P/E multiple and calculate the Fair Value Price today.
Margin of Safety: Compare your calculated Fair Value with the current market price.
Submission: Share a screenshot of your final calculation and your "Decision" (Buy/Hold/Avoid) in our Private Community Group for mentor feedback!
