1. Create Income Statement for 2014 & 2015 2. Create Balance Sheet for 2014 & 2015...
1. Create Income Statement for 2014 & 2015
2. Create Balance Sheet for 2014 & 2015
3. Create Cash Flow Statement for 2015
Please show answers and formulas.
2014 2015
Accounts Payable $2,065,168 $3,732,362
Accounts Receivable 47,677,904 53,413,866
Cash 5,786,943 1,260,691
Common Stock 27,280,000 27,280,000
Cost of Goods Sold 45,014,348 50,298,751
Depreciation Expense 975,000 975,000
Dividends 1,200,000 1,200,000
Interest Expense 90,430 103,266
Inventory 8,399,133 8,989,075
Long-Term Debt 0 0
Notes Payable 0 ?
Other Current Liabilities 5,209,356 4,320,784
Net Property, Plant & Equip. 9,295,976 11,608,208
Retained Earnings ? ?
Revenue 56,611,367 56,775,078
Selling, General, & Admin. 6,165,153 4,742,619
Total Assets ? ?
Tax Rate = 20%
Homework Answers
| 1) | ||
| Income Statement | ||
| 2014 | 2015 | |
| Revenue | $ 5,66,11,367.00 | $ 5,67,75,078.00 |
| Less: Cost of Good Sold | $ 4,50,14,348.00 | $ 5,02,98,751.00 |
| Gross Profit | $ 1,15,97,019.00 | $ 64,76,327.00 |
| Less: Selling, General, & Admin. | $ 61,65,153.00 | $ 47,42,619.00 |
| EBITDA | $ 54,31,866.00 | $ 17,33,708.00 |
| Less: Depreciation | $ 9,75,000.00 | $ 9,75,000.00 |
| EBIT | $ 44,56,866.00 | $ 7,58,708.00 |
| Less: Interest Expense | $ 90,430.00 | $ 1,03,266.00 |
| EBT | $ 43,66,436.00 | $ 6,55,442.00 |
| Less: Tax @ 20% | $ 8,73,287.20 | $ 1,31,088.40 |
| Net Income | $ 34,93,148.80 | $ 5,24,353.60 |
| 2) | |||||
| Balance sheet | |||||
| Assets | 2014 | 2015 | Liabilities & Owner's Equity | 2014 | 2015 |
| Current Assets | Current liabilities | ||||
| Cash | $ 57,86,943.00 | $ 12,60,691.00 | Accounts Payable | $ 20,65,168.00 | $ 37,32,362.00 |
| Accounts Receivables | $ 4,76,77,904.00 | $ 5,34,13,866.00 | other Current Liabilities | $ 52,09,356.00 | $ 43,20,784.00 |
| Inventory | $ 83,99,133.00 | $ 89,89,075.00 | Total Current Liabilities | $ 72,74,524.00 | $ 80,53,146.00 |
| Total Current Assets | $ 6,18,63,980.00 | $ 6,36,63,632.00 | Long term Debt | $ - | $ - |
| Net Property, Plant & Equip. | $ 92,95,976.00 | $ 1,16,08,208.00 | Notes Payable | $ - | $ 40,08,908.40 |
| Total Liabilities | $ 72,74,524.00 | $ 1,20,62,054.40 | |||
| Owner's Equity | |||||
| Common Stock | $ 2,72,80,000.00 | $ 2,72,80,000.00 | |||
| Retained Earnings | $ 3,66,05,432.00 | $ 3,59,29,785.60 | |||
| Total Assets | $ 7,11,59,956.00 | $ 7,52,71,840.00 | Total Liabilities & Owner's Equity | $ 7,11,59,956.00 | $ 7,52,71,840.00 |
| Retained Earning bal (assumed )Difference in total of assets and liabilities(2014) = 71159956-7274524-27280000 | $ 3,66,05,432.00 | ||||
| Add: Net Profit | $ 5,24,353.60 | ||||
| Less: Dividend | $ 12,00,000.00 | ||||
| Retained earning year 2015 | $ 3,59,29,785.60 |
Add Answer to:
1. Create Income Statement for 2014 & 2015
2. Create Balance Sheet for 2014 & 2015...
1) Given the following financial information for 2014 and 2015, construct an Income Statement, Balance Sheet...
1) Given the following financial information for 2014 and 2015, construct an Income Statement, Balance Sheet and Statement of Cash Flows for Grand Twins. - The Income Statement information is for the entire year. - The Balance Sheet information is for December 31 of each year. 2014 2015 Accounts Payable $2,065,168 $3,732,362 Accounts Receivable 47,677,904 53,413,866 Cash 5,786,943 1,260,691 Common Stock 27,280,000 27,280,000 Cost of Goods Sold 45,014,348 50,298,751 Depreciation Expense 975,000 975,000...
Please create a balance sheet based on the following income and cash flow statements: for 2016...
Please create a balance sheet based on the following income and cash flow statements: for 2016 Income Statement 2016 Sales 655,150 Expenses excluding depreciation and amortization 386,878 EBITDA 268,272 Depreciation and amortization 7,388 EBIT 260,884 Interest expense 8,574 EBT 252,310 Taxes (20%) 20% 50,462 Net income 201,848 Common dividends 12,554 Addition to retained earnings 189,294 Cash flow Statement 2016 Operating Activities 203,409 Net Income 201,848 Depreciation and amortization 7,388 Increase in accounts payable 7,652 Increase in accruals (wages, utilities etc.)...
Please create a balance sheet based on the following income and cash flow statements: PLEASE FILL...
Please create a balance sheet based on the following income and cash flow statements: PLEASE FILL IN blank columm in balance sheet below for 2016 Income Statement 2016 Sales 655,150 Expenses excluding depreciation and amortization 386,878 EBITDA 268,272 Depreciation and amortization 7,388 EBIT 260,884 Interest expense 8,574 EBT 252,310 Taxes (20%) 20% 50,462 Net income 201,848 Common dividends 12,554 Addition to retained earnings 189,294 Cash flow Statement 2016 Operating Activities 203,409 Net Income 201,848 Depreciation and amortization 7,388 Increase in...
Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. JUST...
Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners’ Equity 2014 2015 2014 2015 Current assets Current liabilities Cash $ 4,000 $ 11,280 Accounts payable $ 39,040 $ 48,720 Accounts receivable 14,880 20,400 Notes payable 12,960 17,280 Inventory 61,920 90,480 Total $ 80,800 $ 122,160 Total $ 52,000 $ 66,000 Long-term debt $ 48,000 $ 36,000 Owners’ equity Common stock and...
Income Statement and Balance Sheet The following information for Rogers Enterprises is available at December 31,...
Income Statement and Balance Sheet The following information for Rogers Enterprises is available at December 31, 2019, and includes all of Rogers' financial statement amounts except retained earnings: Accounts receivable $72,920 Cash 13,240 Common stock (10,000 shares) 65,000 Income taxes expense 13,000 Income taxes payable 4,150 Interest expense 16,500 Notes payable (due in 10 years) 25,000 Prepaid rent (building) 31,500 Property, plant, and equipment 90,000 Rent expense 135,000 Retained earnings ? Salaries expense 235,200 Salaries payable 15,710 Service revenue 464,000...
Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. JUST...
Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners’ Equity 2014 2015 2014 2015 Current assets Current liabilities Cash $ 11,000 $ 14,250 Accounts payable $ 54,000 $ 63,750 Accounts receivable 27,000 36,750 Notes payable 14,800 20,500 Inventory 75,000 96,250 Total $ 113,000 $ 147,250 Total $ 68,800 $ 84,250 Long-term debt $ 50,000 $ 40,000 Owners’ equity Common stock and...
Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. Prepare the...
Just Dew It Corporation reports the following balance sheet
information for 2014 and 2015.
Prepare the 2015 combined common-size, common–base year balance
sheet for Just Dew It. (Do not round intermediate
calculations. Round your answers to 4 decimal places, e.g.,
32.1616.)
Any help is appreciated :)
JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners' Equity 2014 2015 2014 2015 Current assets Current liabilities Cash Accounts receivable Inventory $ 6,560 16,160 61,280 $ 8,600 22,600 74,600...
Question 2 Parts A-D A Use the starting balance sheet, income statement, and the list of...
Question 2 Parts A-D A Use the starting balance sheet, income statement, and the list of changes to answer the question. Valley Technology Balance Sheet As of December 31, 2019 (amounts in thousands) Cash 22,000 Liabilities 36,000 Other Assets 28,000 Equity 14,000 Total Assets 50,000 Total Liabilities & Equity 50,000 Valley Technology Income Statement January 1 to March 31, 2020 (amounts in thousands) Revenue 7,200 Expenses 3,600 Net Income 3,600 Between January 1 and March 31, 2020: 1. Cash decreases...
Cash Computations A comparative balance sheet, income statement, and additional information for Shillig Doors Inc. follow....
Cash Computations A comparative balance sheet, income statement, and additional information for Shillig Doors Inc. follow. Shillig Doors Inc. Condensed Comparative Income Statement For the Years Ended December 31, 2015 and 2014 2015 2014 Net Sales $3,946,000 $3,112,000 Cost of goods sold 2,385,600 2,364,000 Gross profit $1,561,000 $748,000 Expenses 792,000 506,000 Net income $769,000 $242,000 Shillig Doors Inc. Comparative Balance Sheet December 31, 2015 and 2014 2015 2014 Assets Current assets: Cash $131,000 $102,000 Available-for-sale securities 400.000 - Accounts receivable...
Birtle Corporation reports the following statement of financial position information for 2014 and 2015 Birtle CORPORATION...
Birtle Corporation reports the following statement of financial position information for 2014 and 2015 Birtle CORPORATION 2014 and 2015 Statement of Financial Position Assets Liabilities and Owners' Equity 2014 2015 2014 2015 Current assets Current liabilities $ 41,060 Cash Accounts receivable Inventory $ 9,279 23,683 42,636 $11,173 25,760 46,915 Accounts payable Notes payable $43,805 16,843 16,157 57217 $ 40,000 50,000 Total $ 75,598 $ 83,848 Total $ 60,648 $ 35,000 $ 50,000 Long-term debt Owners' equity Common stock and paid-in...
Just Dew It Corporation reports the following balance sheet
information for 2014 and 2015.
Prepare the 2015 combined common-size, common–base year balance
sheet for Just Dew It. (Do not round intermediate
calculations. Round your answers to 4 decimal places, e.g.,
32.1616.)
Any help is appreciated :)
JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners' Equity 2014 2015 2014 2015 Current assets Current liabilities Cash Accounts receivable Inventory $ 6,560 16,160 61,280 $ 8,600 22,600 74,600...
Birtle Corporation reports the following statement of financial position information for 2014 and 2015 Birtle CORPORATION 2014 and 2015 Statement of Financial Position Assets Liabilities and Owners' Equity 2014 2015 2014 2015 Current assets Current liabilities $ 41,060 Cash Accounts receivable Inventory $ 9,279 23,683 42,636 $11,173 25,760 46,915 Accounts payable Notes payable $43,805 16,843 16,157 57217 $ 40,000 50,000 Total $ 75,598 $ 83,848 Total $ 60,648 $ 35,000 $ 50,000 Long-term debt Owners' equity Common stock and paid-in...
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