Balance Sheet query

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

Balance Sheet query

Postby ajay190 » Tue Sep 11, 2012 12:39 pm

Hi All,

I have below query in Q_Valuation_Case_v4 sheet Balance sheet tab in some places I see =Assumptions!J17*('P&L'!J11/365)*2-BS!I12 formulae is used .Could you please advise why we have to multiply 2 and substract it form prevoius year.Also please advise when to use this logic of multiply by 2 and subsctract by previous year as i do not see this to all balances sheet items this logic is used.

Thankyou,
-Ajay Agarwal.

anilbains
Posts: 1
Joined: Fri Sep 14, 2012 6:20 pm

Re: Balance Sheet query

Postby anilbains » Fri Sep 14, 2012 6:39 pm

Ajay, the balance sheet numbers are as on date, these numbers do not represent the values throughout the year but on a particular date. To calculate the mixed ratios, which involve the P&L items and BS items, we need to take the number that would be more appropriate through out the year. So we take the average of the beginning and the ending of the year numbers.
Now, suppose I have taken a mixed ratio considering the average of Balance Sheet values, and then projected the ratio. To use the projected ratio to calculate the balance sheet item, I need to multiple with 2 and then subtract the last year's value.
For Example: I have Rev(10), Rev(11) as the revenue of FY 10 and FY (11).
I(10),I(11) as inventory for FY 10 and FY 11.
So the Inventory # of Days = [I(10)+I(11)]/[2*Rev(11)]*365 for FY(11).
Now, if the Inventory # of Days for FY 11 were given to us, then I(11) would be
= 2*(Inventory # of Days)*Rev(11)/365-I(10) just writing I(11) in terms of other terms.
Hope this answers!! Feel free to write back in case of any other query.

Gabrieloi
Posts: 1
Joined: Mon Feb 15, 2016 5:46 pm
Location: WakSciereemer
Contact:

Balance Sheet query

Postby Gabrieloi » Thu Feb 18, 2016 7:35 am

BALANCE SHEET OF LIFE

> Our Birth is our Opening Balance
> Our Death is our Closing Balance
> Our Prejudiced Views are our Liabilities
> Our Creative Ideas are our Assets
> Heart is our Current Asset
> Soul is our Fixed Asset
> Brain is our Fixed Deposit
> Thinking is our Current Account
> Achievements are our Capital
> Character & Morals, our Stock-in-Trade
> Friends are our General Reserves
> Values & Behavior are our Goodwill
> Patience is our Interest Earned
> Love is our Dividend
> Children are our Bonus Issues
> Education is Brands / Patents
> Knowledge is our Investment
> Experience is our Premium Account
> The Aim is to Tally the Balance Sheet Accurately.
> The Goal is to get the Best Presented Accounts Award.
> Some very Good and Very bad things ...
> The most destructive habit....... ........ .....Worry
> The greatest Joy......... ......... ............ ...Giving
> The greatest loss........ Loss of self-respect
> The most satisfying work........ .......Helping others
> The ugliest personality trait....... ... .....Selfishness
>
> Our greatest natural resource.... .......... ...Our youth
> The greatest shot in the arm........ ..Encouragement
> The greatest problem to overcome.... ........ ...Fear
> The most effective sleeping pill....... Peace of mind
> The most crippling failure disease..... ... .......Excuses
> The most powerful force in life........ ............ . Love
> The most dangerous act...... ..A gossip
> The worlds most incredible computer.... . ....The brain
> The worst thing to be without..... ............ ..... Hope
> The deadliest weapon...... ........ ..........The tongue
> The two most power-filled words....... ........ I Can
> The greatest asset....... .......... ........ ....Faith
> The most worthless emotion.... ......... ....Self- pity
> The most beautiful attire...... ......... ........SMILE
> The most prized possession.. ........ .....Integrity
> The most powerful channel of communication. ......Prayer
> The most contagious spirit...... .......... ......Enthusiasm
> Life ends; when you stop Dreaming,
> Hope ends; when you stop Believing,
> Love ends; when you stop Caring,
> And Friendship ends; when you stop Sharing... So please share this balance sheet of life.


Return to “Open Source Financial Modeling”



Disclaimer

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 abuse@edupristine.com and we will rectify it.