Dividend, Book Value, Market Value, Subscribed Shares Calculation

Balance Sheet of a company:

Balance Sheet of a Business
Assets		Liabilities & Stockholders Equity
Current Assets(Includes Subscribed Receivable 7200000)	31629714	Current liabilities	15387428
Fixed Assets	53856000	long-term liabilities	10258286
		Stockholders’ equity	59840000
Total Assets	85485714	Total	85485714

Statement of Shareholders equity:

Shareholders Equity
Preferred Stock Par Value Rs. 100 Callable at Rs, 102 Authorized Shares 200000 Dividend per Share Rs. 6		12000000
Total Preferred Stock at par		12000000
Common Stock Par Value Rs. 5 Authorized Shares 5000000
Issued	10000000
Subscribed	4000000
Total Common Stock at Par		14000000
Additional Paid in Capital:
Preferred Stock at premium	360, 000
Common (including subscribed) at premium	30800000
Total Additional Paid in Capital		31160000
Retained Earning		2680000
Total Stockholders Equity		59840000

Dividend, Retained Earning and Share (Stock) Holders Equity Calculation

Information:

Exxen limited was incorporated in January 2004 with authorization to issue 75,000 shares of Rs. 100 par value preferred stock and 1.5 million shares of Re. 1 par value of common stock. The company issued the 50,000 preferred shares at par. 700,000 shares of common stock were issued at Rs. 15 per share. The preferred stock was issued to pay a 9% cumulative dividend and is callable at Rs. 110. From the first year of incorporation to 2008 the company earned a total profit of Rs. 8,750,000 and paid dividend of Rs. 0.60 per share each year on the common stock. In 2009, the company reported a net Profit of Rs. 1,500,000 and paid no dividends to common stock holders.

Requirements:

Prepare the stockholder’s equity section of the balance sheet from the information given above at December 31, 2009.

XPath (libxml2) in Python

Step 1: Install libxml2 using synaptic package manager

Step 2: Create an xml file that you want to traverse.

For example I am using w3school’s xml document http://www.w3schools.com/xpath/books.xml.
We can also use the local file exist on file system.

Step 3: Create a python for example having name xpathcode.py

Open the xpathcode.py import the libxml2 and urllib. Parse the xml file.

import libxml2
import urllib
rss=libxml2.parseDoc(urllib.urlopen('http://www.w3schools.com/xpath/books.xml').read())