Balance Sheet and Income Statement ASSETS 2015 2014 CASH AND MARKETABLE SECURITIES 29,000 25,000 ACCOUNTS RECEIVABLE...
|
Balance Sheet and Income Statement |
||
|
ASSETS |
2015 |
2014 |
|
CASH AND MARKETABLE SECURITIES |
29,000 |
25,000 |
|
ACCOUNTS RECEIVABLE |
116,000 |
100,000 |
|
INVENTORIES |
145,000 |
125,000 |
|
CURRENT ASSETS |
290,000 |
250,000 |
|
GROSS PLANT AND EQUIPMENT |
362,000 |
350,000 |
|
LESS: ACCUMULATED DEPRECIATION |
130,000 |
100,000 |
|
NET FIXED ASSETS |
232,000 |
250,000 |
|
TOTAL ASSETS |
522,000 |
500,000 |
|
LIABILITIES AND EQUITY |
||
|
ACCOUNTS PAYABLE |
90,480 |
78,000 |
|
ACCRURALS |
34,800 |
30,000 |
|
NOTES PAYABLE |
25,420 |
34,000 |
|
CURRENT LAIBILITIES |
150,700 |
142,000 |
|
LONG TERM DEBT |
145,000 |
140,000 |
|
TOTAL LIABILITIES |
295,700 |
282,000 |
|
COMMON STOCK ($1.00 par) |
150,000 |
150,000 |
|
RETAINED EARNINGS |
76,300 |
68,000 |
|
TOTAL OWNER’S EQUITY |
226,300 |
218,000 |
|
TOTAL LIABILITIES AND EQUITY |
522,000 |
500,000 |
|
INCOME STATEMENT |
2015 |
2014 |
|
NET REVENUES & SALES (100,000 UNITS) |
812,000 |
700,000 |
|
COST OF GOODS SOLD |
522,000 |
450,000 |
|
GROSS PROFIT |
290,000 |
250,000 |
|
FIXED OPERATING EXPENSES (pre depreciation) |
174,200 |
151,000 |
|
EBITDA Earnings Before Interest, Taxes, Depreciation & Amortization |
115,800 |
99,000 |
|
DEPRECIATION EXPENSE |
30,000 |
25,000 |
|
OPERATING INCOME (EBIT) |
85,800 |
74,000 |
|
INTEREST |
14,500 |
14,000 |
|
INCOME BEFORE TAXES (EBT) |
71,300 |
60,000 |
|
INCOME TAXES (40%) |
28,520 |
24,000 |
|
NET INCOME |
42,780 |
36,000 |
|
Dividends |
34,480 |
28,500 |
|
Retained Earnings |
8,300 |
7,500 |
|
NUMBER OF SHARES OUTSTANDING |
50,000 |
50,000 |
|
Dividends per share |
0.6896 |
0.57 |
Assume the company is operating at full capacity. If we expect sales to increase by 10% next year what should be the new level of net income?
|
Industry Ratios |
|||||||
|
Current |
1.8 x |
Fixed Asset Turnover |
4.0x |
Net Profit Margin |
8.7% |
||
|
Quick |
1 x |
Total Asset Turnover |
1.3x |
ROA |
12.6% |
||
|
Inventory Turnover |
3.4x |
Debt Ratio |
45.0% |
ROE |
17.2% |
||
|
DSO |
42.1 days |
TIE |
6.5x |
Price/Earnings |
13.0x |
||
|
ROIC |
14.5% |
Market/Book |
2.0x |
||||
Homework Answers
Net Revenue and Sales = $ 812000, Net Profit Margin = 8.7 %
Rise in Sales = 10 %
New Sales / Revenue = 1.1 x 812000 = $ 893200
New Net Profit = (Net Profit Margin / 100) x 893200 = $ 77708.4
Add Answer to:
Balance Sheet and Income Statement
ASSETS
2015
2014
CASH AND MARKETABLE SECURITIES
29,000
25,000
ACCOUNTS RECEIVABLE...
On average how long did it take for the firm to collect from its customers in...
On average how long did it take for the firm to collect from its customers in 2015? On average how long did it take for the firm to collect from its customers in 2015? Balance Sheet and Income Statement ASSETS 2015 2014 CASH AND MARKETABLE SECURITIES 29,000 25,000 ACCOUNTS RECEIVABLE 116,000 100,000 INVENTORIES 145,000 125,000 CURRENT ASSETS 290,000 250,000 GROSS PLANT AND EQUIPMENT 362,000 350,000 LESS: ACCUMULATED DEPRECIATION 130,000 100,000 NET FIXED ASSETS 232,000 250,000 TOTAL ASSETS 522,000 500,000 LIABILITIES...
2015 2014 2015 Awets Current Assets Cash Accounts Receivable Credit Card Receivable Marketable Securities Notes Receivable...
2015 2014 2015 Awets Current Assets Cash Accounts Receivable Credit Card Receivable Marketable Securities Notes Receivable Inventory Prepaid Expenses Total Current Assets $25,000 $5,000 57.000 $20.000 $30,000 $32000 $40.000 $159.000 $23,000 $4.500 $6,000 $18,000 $25.000 $27.000 $36.000 $129.500 Revenues Sales Cash Sales AR Sales Credit Card Sales Total Sales Cost of Sales Gross Profit $45,000 $21,000 $76,000 $142,000 $38.340 $103,660 Direct Operating Expenses Payroll Expenses Other Expenses Total Departmental perses Fund Avusts $14.200 $12,780 526,900 Gross Operating Income 576.GRO tau...
Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets Provincial...
Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets Provincial Imports, Inc., Balance Sheet December 31, 2015 Liabilities and stockholders' equity $ 200,000 Accounts payable 225,000 Taxes payable 625.000 Notes payable 500,000 Other current liabilities $1,550,000 Total current liabilities 1,400,000 Long-term debt $2.950,000 Total liabilities Common stock Retained earnings Total liabilities and equity $ 700,000 95,000 200,000 5,000 $1,000,000 500,000 $1,500,000 75,000 1.375,000 $2.950.000 (1) Projected sales are $6,000,000. (2) Cost of goods sold...
Ending Balance Joel de Paris, Inc. Balance Sheet Beginning Balance Assets Cash $ 140,000 Accounts receivable 450,000 I...
Ending Balance Joel de Paris, Inc. Balance Sheet Beginning Balance Assets Cash $ 140,000 Accounts receivable 450,000 Inventory 320,000 Plant and equipment, net 680,000 Investment in Buisson, S.A. 250,000 Land (undeveloped) 180,000 Total assets $2,020,000 Liabilities and Stockholders' Equity Accounts payable $ 360,000 Long-term debt 1,500,000 Stockholders' equity 160,000 Total liabilities and stockholders' $2,020,000 equity $ 120,000 530,000 380,000 620,000 280,000 170,000 $2,100,000 $ 310,000 1,500,000 290,000 $2,100,000 Joel de Paris, Inc. Income Statement Sales Operating expenses Net operating income...
MARNI COMPANY Balance Sheet As of December 31 ASSETS Cash 50,000 Accounts receivable 100,000 Inventory 200,000...
MARNI COMPANY Balance Sheet As of December 31 ASSETS Cash 50,000 Accounts receivable 100,000 Inventory 200,000 650,000 Net plant and equipment $1,000,000 Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Accounts payable 100,000 Accrued expenses 90,000 Long-term debt Common stock 250,000 100,000 Paid-in capital 50,000 Retained earnings 410,000 $1,000,000 Total liabilities and stockholders' equity MARNI COMPANY Income Statement For the year ended December 31 Sales (all on credit) $2,000,000 1,750,000 Cost of goods sold Gross profit 250,000 Sales and administrative expenses 30,000...
Balance Sheet (Millions of $) Assets 2019 Cash and securities 1554 Accounts receivable 9660 Inventories 13440...
Balance Sheet (Millions of $) Assets 2019 Cash and securities 1554 Accounts receivable 9660 Inventories 13440 Total current assets $24,654.00 Net plant and equipment 17346 Total assets $42,000.00 Liabilities and Equity Accounts payable 7980 Notes payable 5,880.00 Accruals 4620 Total current liabilities $18,480.00 Long-term bonds 10920 Total liabilities $29,400.00 Common stock (175 M shares) 3,360.00 Retained earnings 9240 Total common equity $12,600.00 Total liabilities and equity $42,000.00 Income Statement (Millions of $) 2019 Net sales $60,000.00 Operating costs except depr'n...
Balance Sheet (Millions of $) Assets 2016 Cash and securities $ 1,554.0 Accounts receivable 9,660.0 Inventories...
Balance Sheet (Millions of $) Assets 2016 Cash and securities $ 1,554.0 Accounts receivable 9,660.0 Inventories 13,440.0 Total current assets $24,654.0 Net plant and equipment 17,346.0 $42,000.0 Total assets Liabilities and Equity Accounts payable Notes payable $7,980.0 5,880.0 Accruals 4,620.0 Total current liabilities $18,480.0 Long-term bonds 10,920.0 $29,400.0 Total liabilities Common stock 3,360.0 Retained earnings 9,240.0 $12,600.0 Total common equity Total liabilities and equity $42,000.0 Income Statement (Millions of $) 2016 Net sales $58,800.0 Operating costs except depreciation $54,978.0 $1,029.0...
Question 6 2015 2014 Revenues Assets Current Assets Sales Points out of 1.00 Flag question Cash...
Question 6 2015 2014 Revenues Assets Current Assets Sales Points out of 1.00 Flag question Cash Accounts Receivable Credit Card Receivable Marketable Securities Notes Receivable Inventory Prepaid Expenses Total Current Assets $25,000 $5,000 $7,000 $20,000 $30,000 $32,000 $40,000 $159,000 $23,000 $4,500 $6,000 $18,000 $25,000 $27,000 $36,000 $139,500 Cash Sales A/R Sales Credit Card Sales Total Sales Cost of Sales Gross Proli $145,000 $51.000 $76,000 $272,000 $73,440 5198,560 Direct Operating Expenses Payroll Expenses Other Expenses Total Departmental Expenses $27,200 $24.480 $51,680...
Greasy Spoon Restaurant - Case 1 Greasy Spoon Restaurant Balance Sheet ASSETS 2017 2016 Cash Marketable...
Greasy Spoon Restaurant - Case 1 Greasy Spoon Restaurant Balance Sheet ASSETS 2017 2016 Cash Marketable Securities Accts. Rec. Inventories Total Current Assets $12,000 66,000 152,000 191,000 $421.000 $31,000 82,000 104,000 145,000 $362,000 Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets $195,000 63,000 $132,000 $180,000 52,000 $128,000 Total Assets $553,000 $490,000 Liabilities and Equity A/P Notes Payable Accruals Total Current Liabilities $136,000 200,000 27,000 $363,000 $126,000 190,000 25,000 $341,000 Long Term debt 38,000 40,000 $381,000 Total Liabilities $401,000 Equity...
Balance Sheet ASSETS: Cash and Marketable Securities: $75.00 Accounts Receivable: $100.00 Inventories: $200.00 TOTAL CURRENT ASSETS:...
Balance Sheet ASSETS: Cash and Marketable Securities: $75.00 Accounts Receivable: $100.00 Inventories: $200.00 TOTAL CURRENT ASSETS: $375.00 Gross Property, Plant and Equipment: (blank) less Accumulated Depreciation: $50.00 NET FIXED ASSETS: (blank) TOTAL ASSETS: (blank) LIABILITIES AND EQUITY: Accounts Payable: $75.00 Notes Payable: (blank) Accruals: $75.00 TOTAL CURRENT LIABILITIES: $300.00 Long Term Debt: $350.00 TOTAL LIABILITIES: $650.00 PREFERRED STOCK: (blank) Common Stock: $50.00 Accumulated Retained Earnings: $125.00 COMMON EQUITY: $175.00 TOTAL LIABILITIES AND EQUITY: $875.00 1. Consider the balance sheet above:...
2015 2014 2015 Awets Current Assets Cash Accounts Receivable Credit Card Receivable Marketable Securities Notes Receivable Inventory Prepaid Expenses Total Current Assets $25,000 $5,000 57.000 $20.000 $30,000 $32000 $40.000 $159.000 $23,000 $4.500 $6,000 $18,000 $25.000 $27.000 $36.000 $129.500 Revenues Sales Cash Sales AR Sales Credit Card Sales Total Sales Cost of Sales Gross Profit $45,000 $21,000 $76,000 $142,000 $38.340 $103,660 Direct Operating Expenses Payroll Expenses Other Expenses Total Departmental perses Fund Avusts $14.200 $12,780 526,900 Gross Operating Income 576.GRO tau...
Assets Cash Marketable securities Accounts receivable Inventories Total current assets Net fixed assets Total assets Provincial Imports, Inc., Balance Sheet December 31, 2015 Liabilities and stockholders' equity $ 200,000 Accounts payable 225,000 Taxes payable 625.000 Notes payable 500,000 Other current liabilities $1,550,000 Total current liabilities 1,400,000 Long-term debt $2.950,000 Total liabilities Common stock Retained earnings Total liabilities and equity $ 700,000 95,000 200,000 5,000 $1,000,000 500,000 $1,500,000 75,000 1.375,000 $2.950.000 (1) Projected sales are $6,000,000. (2) Cost of goods sold...
Ending Balance Joel de Paris, Inc. Balance Sheet Beginning Balance Assets Cash $ 140,000 Accounts receivable 450,000 Inventory 320,000 Plant and equipment, net 680,000 Investment in Buisson, S.A. 250,000 Land (undeveloped) 180,000 Total assets $2,020,000 Liabilities and Stockholders' Equity Accounts payable $ 360,000 Long-term debt 1,500,000 Stockholders' equity 160,000 Total liabilities and stockholders' $2,020,000 equity $ 120,000 530,000 380,000 620,000 280,000 170,000 $2,100,000 $ 310,000 1,500,000 290,000 $2,100,000 Joel de Paris, Inc. Income Statement Sales Operating expenses Net operating income...
MARNI COMPANY Balance Sheet As of December 31 ASSETS Cash 50,000 Accounts receivable 100,000 Inventory 200,000 650,000 Net plant and equipment $1,000,000 Total assets LIABILITIES AND STOCKHOLDERS' EQUITY Accounts payable 100,000 Accrued expenses 90,000 Long-term debt Common stock 250,000 100,000 Paid-in capital 50,000 Retained earnings 410,000 $1,000,000 Total liabilities and stockholders' equity MARNI COMPANY Income Statement For the year ended December 31 Sales (all on credit) $2,000,000 1,750,000 Cost of goods sold Gross profit 250,000 Sales and administrative expenses 30,000...
Balance Sheet (Millions of $) Assets 2016 Cash and securities $ 1,554.0 Accounts receivable 9,660.0 Inventories 13,440.0 Total current assets $24,654.0 Net plant and equipment 17,346.0 $42,000.0 Total assets Liabilities and Equity Accounts payable Notes payable $7,980.0 5,880.0 Accruals 4,620.0 Total current liabilities $18,480.0 Long-term bonds 10,920.0 $29,400.0 Total liabilities Common stock 3,360.0 Retained earnings 9,240.0 $12,600.0 Total common equity Total liabilities and equity $42,000.0 Income Statement (Millions of $) 2016 Net sales $58,800.0 Operating costs except depreciation $54,978.0 $1,029.0...
Question 6 2015 2014 Revenues Assets Current Assets Sales Points out of 1.00 Flag question Cash Accounts Receivable Credit Card Receivable Marketable Securities Notes Receivable Inventory Prepaid Expenses Total Current Assets $25,000 $5,000 $7,000 $20,000 $30,000 $32,000 $40,000 $159,000 $23,000 $4,500 $6,000 $18,000 $25,000 $27,000 $36,000 $139,500 Cash Sales A/R Sales Credit Card Sales Total Sales Cost of Sales Gross Proli $145,000 $51.000 $76,000 $272,000 $73,440 5198,560 Direct Operating Expenses Payroll Expenses Other Expenses Total Departmental Expenses $27,200 $24.480 $51,680...
Greasy Spoon Restaurant - Case 1 Greasy Spoon Restaurant Balance Sheet ASSETS 2017 2016 Cash Marketable Securities Accts. Rec. Inventories Total Current Assets $12,000 66,000 152,000 191,000 $421.000 $31,000 82,000 104,000 145,000 $362,000 Gross Fixed Assets Less: Accumulated Depreciation Net Fixed Assets $195,000 63,000 $132,000 $180,000 52,000 $128,000 Total Assets $553,000 $490,000 Liabilities and Equity A/P Notes Payable Accruals Total Current Liabilities $136,000 200,000 27,000 $363,000 $126,000 190,000 25,000 $341,000 Long Term debt 38,000 40,000 $381,000 Total Liabilities $401,000 Equity...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago