Development and Feasibility Study of the Investment Project for LLC "Pharma-D" (2015)

PROJECT OVERVIEW

Development and Feasibility Study of the Investment Project for LLC “Pharma-D” (2015)

As part of building expertise in investment analysis and business planning, I developed a comprehensive investment project for the creation of a specialized pharmacy for patients with diabetes mellitus. The project covered the full development cycle: from marketing research of a niche market to detailed financial modeling and risk assessment.

Key Work Stages:

  1. Marketing and Organizational Analysis:
  • Evaluated market segments (patients with Type 1 and Type 2 diabetes) and identified the target audience with a high need for qualified assistance.
  • Developed a market entry strategy through partnership channels (polyclinics) and direct sales.
  • Formed a staffing plan considering team scaling.
  1. Financial Modeling:
  • Built a three-year financial model of the project, including:
    • Sales plan and Cash Flow forecast.
    • Profit and Loss Statement (P&L) and projected Balance Sheet.
    • Break-even point calculation.
  1. Investment Efficiency Assessment:
  • Calculated key integral indicators of investment efficiency based on the model data, using a discount rate of 12%:
    • Net Present Value (NPV): 29.9 million RUB (a positive value confirms economic feasibility).
    • Profitability Index (PI): 6.13 (high return on investment).
    • Internal Rate of Return (IRR): 156%.
    • Discounted Payback Period (DPP): less than 1 year (341 days), indicating high project liquidity.
  1. Sensitivity and Risk Analysis:
  • Conducted an in-depth analysis of the project’s stability against changes in external factors.
  • Investigated the impact of fluctuations in revenue, sales costs, and equipment costs on key indicators (NPV, IRR, PI).
  • Identified threshold values of factors under which the project remains effective.
  • Defined main risks (tax, competitive, operational) and developed measures to minimize them.

Result:

The created model demonstrated high business stability even under pessimistic revenue decline scenarios. This experience laid the foundation for my understanding of how financial metrics influence strategic decisions and allowed me to further apply these principles in evaluating real infrastructure and investment projects at the international level.

Leave a reply