I made a version 3 of the spread sheet. It is aslitle better. it compares two company's : one with a 10% profit and one withe a 9% lower profit. The company withe the 10% is profiting of the taks claim.
You are able to vary : 1-The marked capitalization of TGIC 2-The investmend made by ainvestor 3-The expected annual profit
Simulatione version 2
The system calculate the stock value per year and the % added by the taks profit of TGIC
What we see is that by the current : 1-market capitalization $5.000.000 2-envestmend $82.000.000 3-NOL utilization of nearly 100% 4-Expected annual profit 10%
result:
$84.759558 extra profit over a period of 20 years for the stock holders. But that is a very good profit for the investor but not for the stock holders of TGIC
The conclusion is that the current stock value is to low
we need to calculate the value of TGIC based on the profit for the stock holders