The Intrinsic Value Calculation here is not as rigorous as the spreadsheet linked above and probably over-simplified in the present version of this app. As it evolves, the App will include more features for completeness over newer releases.
Assumptions:
Only non-financial companies (neither banks nor insurance companies)
NOLs are not accounted for in DCF valuation (to be improved in future release)
Cost of Capital is fixed for the timeline of valuation and not linked to the Cost of Capital worksheet and the Country Equity Risk Premium look-up (to be improved in future release and linked to source CSV if available)
Probability of failure for the firm assumes proceeds in case of bankruptcy are 50 cents on the $ of Present Value.