Skip to content

FAQ

About Digi Advisors

Digi Advisors is Infra Advisors’ online platform, offering professionally developed financial models that allow private players to focus on bidding strategy and execution.

Digi Advisors offers a range of products, including financial models and fact sheets, designed to support bidding for Hybrid Annuity Model (HAM) Public-Private Partnership (PPP) projects.

Products and Features

The current product offering includes PPP-HAM models, specifically designed to support the bidding process.

Yes, you need Microsoft Excel 365 with macros enabled to use the Digi Advisors Products.
Digi Advisors’ products are standard offerings specifically designed for each project.
Customizable off-the-shelf solutions are provided by Infra Advisors.
No, users can input their data in the designated cells; however, Digi Advisors’ products provide sufficient flexibility to its users.
A detailed video and instruction manual are available on the website. 
Customer support is available via email.

Digi Advisors does not provide live training. However, users can refer to the video guide on the website and the instruction manual to learn how to navigate through the product.

Each Digi Advisors product is tailored to a specific project. For each project, you will need to acquire the Digi Advisors product for that specific project.

Yes, if a corrigendum issued by the authority alters the project terms and impacts the financials of the project, an updated version will be emailed to your registered email, incorporating those changes.

Yes, all your data inputs remain private and are not, under any circumstances, extracted through any external connections by Digi Advisors.

Payments and Billing

We accept payments through the Razorpay payment gateway, which supports payments via UPI and net banking.

Absolutely. Your payment information is fully secure. All transactions are encrypted and processed through secure channels, ensuring that your sensitive data remains protected throughout the payment process.

Yes, after completing your purchase, a GST invoice will be emailed to your registered email address within 24 to 48 hours.

Due to the nature of digital products, refunds are not provided. However, we ensure product quality and provide support for any issues you may face.

Licensing and Usage

No, the purchase provides a single-user license only. Any sharing, resale, or redistribution of the models is strictly prohibited and constitutes a violation of our terms of service.

You can re-download your purchased model using the link provided in your purchase confirmation email. If the link expires before the bid date, please check your email for any notifications or contact our support team for assistance.

Technical Support

If you encounter a “Security Risk” message or the macros aren’t working after downloading the model, follow these steps to make the file trusted:

  1. Locate the file: Go to the folder where you saved the downloaded model.
  2. Right-click the file: Select ‘Properties’ from the menu.
  3. Unblock the file: In the ‘Properties’ window, under the ‘General’ tab, scroll to the bottom. If you see a ‘Security’ section with an ‘Unblock’ checkbox, tick the box.
  4. Apply and close: Click ‘Apply,’ then ‘OK’ to save the changes.

This process ensures your file is marked as safe, resolving the issue and enabling macros to function smoothly for an optimal experience with the model.

If you’re unsure or need further assistance, feel free to reach out to our support team.

When you open the Digi Advisors product for HAM, you might see a Privacy Levels pop-up. This relates to the external connection used solely to update the Bid Due Date, ensuring accurate calculations. All your inputs remain private and confidential, with no data extracted or exported from your hard disk via this connection. When prompted, select the ‘Private’ option for the current workbook to proceed securely.

If you experience any technical issues, visit the “Contact Us” section on our website and share the details of the problem. Our support team will assist you promptly.

If you receive a corrupted file through email after payment, contact our support team right away. After verifying your purchase, we’ll provide you with a replacement.

The input sheets remain inaccessible initially to ensure the model’s functionality and data integrity. To access them, enable macros and mark the file as trusted.

To enable macros and trust the file:

  1. Open the Excel file.
  2. Click Enable Content in the security warning bar at the top of the Excel window.
  3. Alternatively, go to File > Options > Trust Center > Trust Center Settings.
  4. Under Macro Settings, select Enable all macros and check Trust access to the VBA project object model.
  5. After enabling macros and trusting the file, you will be able to access the input sheets and use the model as intended.

Enabling macros and trusting the file ensures the model functions as intended, including running calculations and protecting data. Without these settings, key features like input sheets will remain inaccessible, and you won’t be able to interact with the data properly

Yes, our financial models rely on iterative calculations for accurate results, especially in scenarios involving circular references, such as interest calculations. To enable them:

  1. Open Excel and go to File > Options.
  2. Navigate to the Formulas tab.
  3. Under the Calculation options section, check the box for Enable iterative calculation.
  4. Set Maximum Iterations to 100 and Maximum Change to 0.001 for optimal performance.
  5. Click OK to save your settings.

Note: Iterative calculations are crucial for the model to function correctly. Disabling them may result in errors or incorrect outputs.

In the model, the input sheets are color-coded to help you easily identify where data can be entered:

  1. Input Sheets and Cells: The input sheets are highlighted in blue, and the cells where you can enter data will have a grey background. Regardless of the background colour, all input cells will have blue text for consistency.
  2. Bid Project Cost: The input cell for your bidding cost input will have red text instead of blue.
  3. Conditionally Formatted Input Cells: Some input cells may change colour (e.g., green or red) depending on the input you provide. These colour changes are based on the conditions set in the model to guide you and show whether the input is within an acceptable range or needs attention. However, the text in these cells will always remain blue.
The color-coding helps you easily navigate the model, identify where you can input data, and ensure you’re entering values correctly. The conditional formatting serves as a visual cue for inputs that require specific attention, helping prevent errors.

The Master Check is a built-in validation tool within the model that ensures all calculations are accurate.

After entering all your inputs, for the model to function correctly and provide reliable results, the Master Check must display “Okay” in green.

In some cases, you may need to re-iterate the calculations by pressing F9 six to ten times to resolve this.

If the Master Check displays “Error,” go to the “Checks” sheet, where you’ll find details about the issue, including error messages and highlighted sections. To resolve errors, follow these major checks in the Digi Advisors financial model:

  • MCA Check: Based on Clause 22.1 of the concession agreement, this check ensures the ability to achieve Financial Close.
  • Internal Checks: Resolve all other errors first. If the error persists, please contact us.
  • Phasing Check: Double-check your inputs in the EPC Phasing sheet to avoid errors.
  • Financial Check: After resolving other errors, press F9 5–6 times to complete the iterations. If the issue persists, recheck your inputs.
  • DSRA Check: Address other errors first. If the issue persists, contact us.
  • Schedule-G: Ensure the phasing aligns with the specifications in Schedule-G of the concession agreement.
  • MCLR Date Validity: Update MCLR rates and their corresponding dates in the Assumption sheet.
  • Senior Loan Repayment: Verify repayment percentages in the Senior Loan Repayment section of the Dashboard.
  • Refresh Data: To refresh data, press Update Bid Due Date next to the Dashboard module or go to the Data tab and click Refresh All.

If you encounter a circular reference error, download the financial model again from your account page and carefully input your values.

For any unresolved errors or additional support, please reach out to us.

The Digi Advisors product includes several key checks to ensure accurate calculations. Here’s an overview of the major checks and how to resolve any errors:

  • MCA Check: Ensures the ability to achieve Financial Close, based on Clause 22.1 of the concession agreement.
  • Internal Checks: Address any other errors first. If the error persists, contact us for support.
  • Phasing Check: Review your inputs in the EPC Phasing sheet to avoid errors.
  • Financial Check: After resolving other errors, press F9 5–6 times to complete the iterations. If the issue persists, recheck your inputs.
  • DSRA Check: Resolve any other errors first. If the issue remains unresolved, please contact us.
  • Schedule-G: Verify that the phasing aligns with the specifications outlined in Schedule-G of the concession agreement.
  • MCLR Date Validity: Ensure the MCLR rates and their corresponding dates are correctly updated in the Assumption sheet.
  • Senior Loan Repayment: Check the repayment percentages in the Senior Loan Repayment section of the Dashboard.
  • Refresh Data: To refresh the data, either press Update Bid Due Date next to the Dashboard module or go to the Data tab and click Refresh All.

If you encounter a circular reference error, re-download the financial model from your account page and carefully input your values again.

For any unresolved errors or additional assistance, please don’t hesitate to contact us.

The Financial Check ensures the integrity of iterative calculations for financial calculations. If it shows “Error,” follow these steps:

  1. Ensure iterative calculations are enabled in Excel.
  2. Allow the model to iterate fully by pressing F9, watching the bottom-right status bar for updates (next to the zoom slider).
  3. Repeat the iterations six to ten times, or until no further changes show up on the status bar.
  4. If the error persists, go to the “Fin-IGAAP” sheet to check and resolve any issues with the iterative calculations by manipulating your inputs.

If the issue remains unresolved, it may be caused by incorrect inputs. In this case, download a fresh copy of the model and carefully input your values to avoid any errors.

Security and Data Integrity

Digi Advisors’ products are secured with robust protection mechanisms to ensure their integrity and functionality. We strongly advise against attempting to unlock or alter the protected sections, as this may corrupt the file and void your license agreement. For optimal use, please edit only the designated user-input cells.

The Digi Advisors products are licensed exclusively for the project specified by the purchaser. Attempting to modify, unlock, or repurpose the model for other uses may compromise its functionality and cause data corruption.

Compliance and Privacy

We take your privacy seriously. The data you provide during the purchase process is used exclusively to process your order and enhance our services. Your information is never shared or used for any other purpose.

Updates and New Features

If there are any updates after your purchase, we will send the revised product to your registered email. If you don’t receive the update, please contact us using your registered email and include a clear subject line for reference.

Digi Advisors is Infra Advisors’ online platform, offering professionally developed financial models that allow private players to focus on bidding strategy and execution.

Digi Advisors offers a range of products, including financial models and fact sheets, designed to support bidding for Hybrid Annuity Model (HAM) Public-Private Partnership (PPP) projects.

Contact Us

You can reach us through the “Contact Us” form on our website. Alternatively, email us at digiadvisors@infragroup.co.in from your registered email address.

If you require any additional services or modelling assistance, please contact us at digiadvisors@infragroup.co.in using your registered email. Be sure to include a clear and simple subject line for reference.

We’re here to provide the support you need!