That way if a value changes in a cell the answer to the formula changes with it. The calculation of the intrinsic value formula of the stock is done by dividing the value of the business by the number of outstanding shares of the company in the market. Book Value Initial Cost Accumulated Depreciation.
It can be defined as the net asset value of the firm or of the company that can be calculated as total assets less intangible assets that is goodwill patents etc and liabilities.
Formula to Calculate Book Value of a Company. Determine the capitalization rate from a recent comparable sold property. It accounts for the time value of money and can be used to compare investment alternatives. PV 213592 or the minimum amount that you would need to be paid today to have 2200 one year from now.