New batches for CFA Level I & FRM Part I Starting from coming Saturday and Sunday at Mumbai, Pune, & Bengaluru resp.    Master Workshop on Financial Modeling on 16th to 22nd Dec, Click here for more info

FinTree Financial Modeling Testing

We are glad to announce that tests will be held monthly for the Financial Modeling Course. The FinTree Financial Modeling Course helps you build a strong foundation in your finance career and we have taken the initiative to facilitate your fast track to finance.

To know more about the Financial Modeling Course, click here.

The Financial Modeling Tests will be held on the following dates:

Day Sunday Sunday Sunday Sunday Sunday Sunday Sunday
Date 24-Nov-19 29-Dec-19 26-Jan-20 23-Feb-20 29-Mar-2020 26-Apr-20 31-May-20

Book your Test Slot please email on dashrath@fintreeindia.com

The model of a FinTree Financial Modeling Test provided underneath will help you understand what a test paper will look like on the above-mentioned dates.

 

Testing Guidelines

  1. Testing time is of 10 hours in duration from 8 am to 6 pm on the testing day.
  2. We recommend you have an internet connection and a personal computer with spreadsheet software.
  3. You will be required to download a file containing the questions, made available to you via email.
  4. Every question has a deadline which will be mentioned on the question sheet.
  5. Please read the instructions and the content of the question mentioned in a respective question carefully, prior to answering.
  6. Submitting your answer after the mentioned deadline renders your answer to not be considered by our proctors; we hold this policy steadfastly as no individual shall have an unfair advantage over another in terms of time required to complete the test.

 

FINTREE FINANCIAL MODELING

Profarma Certificate [Download]

FinTree FM Proforma Certificate

FM Proforma Certificate [ Click on Image for Full Size]

SAMPLE TEST             [Download]

Instructions: Complete the following assignments and submit them at the under-mentioned timings to utkarsh@fintreeindia.com with the subject line as-

FinTree FM Test – <Your Name> – <Question No>

  1. Complete the Excel test provided in File #2. Your completed test must be sent via email by 12 pm.

Our tests will require you to have a personal computer with an office suite to be able to successfully complete the task-at-hand.

  1. Propose a three-point investment rationale (positive or negative) for the stocks below; you may use the internet. The assignment must be sent via email by 3 pm. 
    1. Acme Motors
    2. Spärson & Neubro Ltd
    3. Rijdewalde Leather Company
    4. Tringen Typewriters

We recommend you to have an internet connection to be able to receive and you’re your completed answers to questions. Your analysis will require you to reasonably justify your answer in a descriptive but concise paragraph.

Sample Questions

  1. If you had to select one stock from the FMCG sector today, which one would you select? What would be the rationale(s) behind your choice? Explain your selection in a summarized report and send via email by 4 pm.

Some questions may require you to use critical thinking backed by quantitative data to be able to adequately justify your answer. On the basis of a question, your conclusion can be either subjective or objective.

  1. Suggest a suitable stock from the energy sector in France on the basis of the P/E ratio. Submit your calculations justifying its selection in an excel file to be sent via email at or before 5 pm.

During the course of your test, pay attention to the specifics of the instructions. The question above is relatively more objective.

  1. Perform an asset-based valuation on the stocks provided underneath and provide your computations & description in an excel file to be sent via email by 6 pm:
    1. Bank of North America
    2. Westuhal Brewers
    3. A technology stock of your choice

A question may or may not require you to provide the computations you performed while solving the question. Knowledge of concepts tackled during the financial modeling course will be tested either directly or indirectly.