Select Page
QuestionsCategory: Financials QuadrantExcel formula for Net Debt / Cash (+/-)
Joseph Foo asked 3 years ago

Hi Victor, when I check the excel financial analysis formula, it is using debt minus cash which gives a negative result. Is it an error?

1 Answers
Victor Chng answered 3 years ago

Hi Joseph,
 
The calculation is correct because Row 37 is called Net Cash per share. If the cash is more than debt it will give you a positive figure vice versa when the debt is more than cash it will give you a negative figure.