University of the Incarnate Word OIU Manufacturing Financial Statement Excel Worksheet attached is a excel assignment, On the excel spread sheet is everyth

University of the Incarnate Word OIU Manufacturing Financial Statement Excel Worksheet attached is a excel assignment, On the excel spread sheet is everything you need to complete. if you have any question, please feel free to contact me OIU Manufacturing
Use the following selected data and additional information from the records of OIU Manufacturing to
produce the Statement of Cash Flows; using the Indirect Method.
Sales revenue
Cost of goods sold
Gross profit
General and administrative expenses
Depreciation expense
Total expenses and losses
Income before interest and taxes
Interest expense
Income before taxes
Income tax expense
Net income
For the Year Ended
December 31, 2016
$ 527,000
336,000
$ 191,000
$ 53,000
72,000
$ 125,000
$ 66,000
14,000
$ 52,000
16,000
$ 36,000
Balance Sheet Data
2016
Cash
Accounts receivable
Inventory
Prepaid rent
Total current assets
Land
Plant and equipment
Accumulated depreciation
Total long-term assets
Total assets
$
Accounts payable
Other accrued liabilities
Income taxes payable
Total current liabilities
Long-term bank loan payable
Common stock
Retained earnings
Total stockholders’ equity
Total liabilities and stockholders’ equity
$ 149,000
31,000
8,000
$ 188,000
$ 125,000
$ 288,000
252,000
$ 540,000
$ 853,000
$ 142,000
25,000
10,000
$ 177,000
$ 125,000
$ 192,000
222,000
$ 414,000
$ 716,000
$
$
$
$
$
$
31,000
86,000
77,000
12,000
206,000
240,000
719,000
(312,000)
647,000
853,000
2015
–
$
$
$
$
$
40,000
72,000
91,000
15,000
218,000
163,000
575,000
(240,000)
498,000
716,000
Additional information:
Common stock was issued for cash
The only items affecting retained earnings in 2016 were net income and dividends declared and paid.
–
Period Ending
2-Oct-16 27-Sep-15
Assets
Current Assets
Cash And Cash Equivalents
Short Term Investments
Net Receivables
Inventory
Other Current Assets
2,128,800
134,400
768,800
1,378,500
350,000
1,530,100
81,300 MARKETABLE SECURITIES
719,000 ACCOUNTS or CURRENT RECEIVABLES
1,306,400
334,200
Total Current Assets
Property Plant and Equipment
4,760,500
4,533,800
3,971,000
4,088,300
Total Assets
14,329,500 12,416,300
Liabilities
Total Current Liabilities
Long Term Debt
Total Liabilities
4,546,900
3,202,200
8,445,500
3,648,100
2,347,500
6,598,300 DEBT
Total Stockholder Equity
5,884,000
5,818,000
Period Ending
Total Revenue
Cost of Revenue
2-Oct-16 27-Sep-15
21,315,900 19,162,700
8,511,100 7,787,500
Earnings Before Interest And Taxes 4,279,900
Interest Expense
81,300
Income Before Tax
4,198,600
Net Income
3,135,900
3,973,500
70,500
3,903,000
2,946,200
Name:
Section:
1. Working capital:
Calculate the following measures by entering each numerator and denominator.
Ratio
2. Current ratio
3. Acid-Test (Quick) ratio
Accounts receivable
4. turnover
Number of days’ sales in
5. receivables
6. Inventory turnover
Number of days’ sales in
7. inventory
Return on Common
8 Stockholders’ Equity
Debt to stockholders’
9. equity
Number of times interest
10. charges earned
Numerator
Denominator
Calculated
Value

Purchase answer to see full
attachment