3) Please complete the excel spreadsheet using the following information:

a) Net Income for the year ended December 31, 2004, was $212,000

b) Dividends paid during the year ended December 31, 2004 were $84,000.

c) Accounts Receivable increased by $28,000 during the year ended December 31, 2004.

d) The cost of new buildings acquired during 2004 was $ 170,000.

e) No buildings were disposed of during 2004.

f) The land account was not affected by any transactions during the year, but the fair market value of the land at the end of 2003 was $420,000.

g)The company issued $20,000 of new common stock (paid in capital) during 2004

h)There were 200,000 shares issued and outstanding at the year-end

i)The year-end share price was $18.00

Bedouin, Inc. Balance Sheet 2004 Assets Current Assets Cash Accounts Recievable Inventory 58,000 24,000 334,000 Total Current Assets 658,000 90,000 Land Buildings Less: Accumulated Depreciation 370,000 Total Land & Building (Net Fixed Assets) Total Assets 30,000 640,000 1,298,000 Current Liabilzies Notes Payable Short-Term Accounts Payable 270,000 414,000 652,000 72,000 824,000 Total Current Liabilities 618,000 Long-Term Debt Total Liabilities Stockholders' (Owners) Equity Common Stock (Paid-in Capital Retained Earnings 140,000 34,000 474,000 1,298,000 Total Owner's Equity Total Liabilities & Owners Equity Cash flow from Operations Cash flow from Investing Activities Cash flow from Financing Activities Net Cash flow for the year (8,000) Please calculate the following for 2014: Profit Margin % Current Ratio Debt Ratio Earnings per share Dividend Payout Ratio Dividend Yield P/E ratio Screens