Financial modelling doubts

Posts: 2
Joined: Tue Sep 11, 2012 12:29 pm

Financial modelling doubts

Postby ajay190 » Sun Sep 23, 2012 12:08 am


Can you please explain us below topic

1)Building interest on excess cash and cash revolver.

2)And how we can create dupont analysis the way it is created in Groupon model

3)Modelling Deferred tax.

-Ajay Agarwal.


Finance Junkie
Posts: 61
Joined: Fri Aug 03, 2012 11:24 am

Re: Financial modelling doubts

Postby pankaj » Wed Sep 26, 2012 11:44 pm

to build interest on excess cash/ cash revolver you need to "on" the "Enable iterative calculation" option (file -->Options--->Formulas). So,once the iterative calculation option is on, you can link the profit and loss line item (interest on cash or interest paid on cash revolver)with the balance sheet line item (excess cash or cash revolver). This will create a circular reference, which will help in calculating the interest received/interest paid once the numbers are inserted in the balance sheet.

For Dupont analysis we have just linked the required (selected) profit and loss and balance sheet line items and used the dupont formula to calculate the ROE (return on equity). The excel workbook is not password protect,you can check out how we have linked the line items and calculated the ROE.

Return to “Open Source Financial Modeling”


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.