Unit 9 Final Project

unit_9_final_assignment-excel_spreadsheet.xls

Unit 9 Assignment


	As an investor, one needs to analyze the financial statements in order to make a decision.
	This assignment is asking you to review and analyze the financial statements and to write
	a 1-2 page expository essay response to the questions below:
	1) Reflect and describe those accounts that are increasing and decreasing more than 10%.
	2) Provide some reasoning as to why the accounts are increasing or decreasing.
	3) Discuss how you would encourage people to invest in this company.


Income Statement
	2013	2012
Sales	$ 6,350,250	$ 3,432,000
Cost of Goods Sold	$ 5,635,014	$ 2,864,000
Gross Margin	$ 715,236	$ 568,000
Operating Expenses	$ 563,130	$ 358,672
EBITDA	$ 152,106	$ 209,328
Depreciation & Amortization	$ 118,320	$ 18,900
EBIT	$ 33,786	$ 190,428
Interest Expense	$ 144,015	$ 43,828
EBT	$ (110,229)	$ 146,600
Taxes (40%)	$ (44,092)	$ 58,640
Net Income	$ (66,137)	$ 87,960
Statement of Retained Earnings, 2013
Beginning Balance Retained Earnings	$ 203,768
Add: Net Income	$ (66,137)
Less: Dividends	$ (11,000)
Ending Balance Retained Earnings	$ 126,631


Balance Sheets
	2013	2012
Assets
Cash	$ 14,250	$ 57,600
Accounts Receivable	$ 550,330	$ 351,200
Inventories	$ 1,287,360	$ 715,200
Total Current Assets	$ 1,851,940	$ 1,124,000
Gross Fixed Assets	$ 1,113,500	$ 491,000
Less: Accumulated Depreciation	$ 257,333	$ 146,200
Net Fixed Assets	$ 856,167	$ 344,800
Total Assets	$ 2,708,107	$ 1,468,800
Liabilities & Equity
Accounts Payable	$ 504,250	$ 145,600
Notes Payable	$ 586,000	$ 200,000
Accruals	$ 405,300	$ 136,000
Total Current Liabilities	$ 1,495,550	$ 481,600
Long-Term Debt	$ 625,926	$ 323,432
Common Stock	$ 460,000	$ 460,000
Retained Earnings	$ 126,631	$ 203,768
Total Equity	$ 586,631	$ 663,768
Total Liabilities & Equity	$ 2,708,107	$ 1,468,800