Commercial Loan Case Study

CommericalLoanCaseStudy1.xlsx

Balance Sheet

Period Ending		31-Dec-14	31-Dec-13	31-Dec-12	2015	2016	2017	2018	2019
Assets
Current Assets
	Cash And Cash Equivalents	1,113,608	604,965	290,291
	Short Term Investments	494,888	595,440	457,787
	Net Receivables	-	-	-
	Inventory	-	-	-
	Other Current Assets	2,331,973	1,858,358	1,492,713
Total Current Assets		3,940,469	3,058,763	2,240,791
Long Term Investments		-	-	-
Property Plant and Equipment		149,875	133,605	131,681
Goodwill		-	-	-
Intangible Assets		2,773,326	2,091,071	1,506,008
Accumulated Amortization		-	-	-
Other Assets		192,981	129,124	89,410
Deferred Long Term Asset Charges		-	-	-
Total Assets		7,056,651	5,412,563	3,967,890
Liabilities
Current Liabilities
	Accounts Payable	271,327	162,453	139,607
	Short/Current Long Term Debt	-	-	-
	Other Current Liabilities	2,391,827	1,991,750	1,536,319
Total Current Liabilities		2,663,154	2,154,203	1,675,926
Long Term Debt		900,000	500,000	400,000
Other Liabilities		1,635,789	1,424,799	1,147,291
Deferred Long Term Liability Charges		-	-	-
Minority Interest		-	-	-
Negative Goodwill		-	-	-
Total Liabilities		5,198,943	4,079,002	3,223,217
Stockholders' Equity
Misc Stocks Options Warrants		-	-	-
Redeemable Preferred Stock		-	-	-
Preferred Stock		-	-	-
Common Stock		60	60	56
Retained Earnings		819,284	552,485	440,082
Treasury Stock		-	-	-
Capital Surplus		1,042,810	777,441	301,616
Other Stockholder Equity		-4,446	3,575	2,919
Total Stockholder Equity		1,857,708	1,333,561	744,673
Net Tangible Assets		-915,618	-757,510	-761,335

Period Ending		31-Dec-14	31-Dec-13	31-Dec-12	2015	2016	2017	2018	2019
Total Revenue		5,504,656	4,374,562	3,609,282
Cost of Revenue		3,752,760	3,117,203	2,652,058
Gross Profit		1,751,896	1,257,359	957,224
	Operating Expenses
	Research Development	472,321	378,769	329,008
	Selling General and Administrative	876,927	650,243	578,224
	Non Recurring	-	-	-
	Others	-	-	-
	Total Operating Expenses	-	-	-
Operating Income or Loss		402,648	228,347	49,992
	Income from Continuing Operations
	Total Other Income/Expenses Net	-3,060	-28,131	474
	Earnings Before Interest And Taxes	399,588	200,216	50,466
	Interest Expense	50,219	29,142	19,986
	Income Before Tax	349,369	171,074	30,480
	Income Tax Expense	82,570	58,671	13,328
	Minority Interest	-	-	-
	Net Income From Continuing Ops	266,799	87,274	17,152
	Non-recurring Events
	Discontinued Operations	-	-	-
	Extraordinary Items	-	-	-
	Effect Of Accounting Changes	-	-	-
	Other Items	-	-	-
Net Income		266,799	112,403	17,152
Preferred Stock And Other Adjustments		-	-	-
Net Income Applicable To Common Shares		266,799	112,403	17,152