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
Date 25-Aug-19 29-Sep-19 27-Oct-19 24-Nov-19 29-Dec-19

To book your Test, 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.

 

FINTREE FINANCIAL MODELING

SAMPLE TEST

 

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 tasks-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&Newbro Ltd
    3. Rijdewalde Leather Company
    4. Tringen Typewriters

We recommend you to have a stable internet connection to be able to complete certain questions. Your analysis will require you to reasonably justify your answer in a descriptive but concise paragraph.

 

  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.