Question

In: Finance

Using this Company's information, please create a Balance Sheet and Income Statement Note: Please create these...

Using this Company's information, please create a

  1. Balance Sheet and Income Statement

Note: Please create these statements for the year 2018 only

2017

2018

Accounts Payable

$81,000

$66,000

Accounts Receivable

$110,000

$128,000

Accumulated Depreciation, PP&E

$290,000

$356,000

Cash and Cash Equivalents

$62,000

$54,000

Common Stock

$415,000

$425,000

Cost of Goods Sold

$359,000

$368,000

Depreciation Expense

$62,000

$66,000

Dividends

$20,000

$25,000

Income Tax Expense

$18,000

$23,000

Interest Expense

$44,000

$44,000

Inventory

$48,000

$55,000

Long-Term Notes Payable

$850,000

$810,000

Patents

$678,000

$712,000

PP&E

$875,000

$925,000

R&D Expense

$141,000

$135,000

Retained Earnings

$137,000

$217,000

Revenues

$845,000

$912,000

SG&A Expense

$158,000

$171,000

Solutions

Expert Solution

Income Statement
Particulars Amount($) Amount($)
Net Sales 912000
Less: Cost of goods sold 368000
Gross profit 544000
Less: Depreciation 66000
R&D 135000
S,G &A 171000
EBIT 172000
Less: Interest 44000
Earnings before tax 128000
Less: Taxes 23000
Net Income 105000
Less: Dividends paid 25000
Additions to retained earnings 80000
Balance Sheet
LIABILITIES AND EQUITY Amount($) Amount($) ASSETS Amount($) Amount($)
Current liabilities Current Assets
Accounts payable 66000 Cash 54000
Accounts receivable 128000
Total current liabilities 66000 Inventory 55000
Total current assets 237000
notes payable 810000
Total liabilities 876000 Gross PPE 925000
Common stock 425000 Less: Accumulated dep 356000
Retained earnings 217000 Net Fixed assets 569000
Total Equity 642000 Patents 712000
Total liabilities and equity 1518000 Total assets 1518000

Related Solutions

Create a balance sheet and income statement using the following information: WIth proper financial statement formatting...
Create a balance sheet and income statement using the following information: WIth proper financial statement formatting Any missing information, please fill in. Total Shareholder Equity Long Term Debt: 3,650,000 Inventories: 350,000 Income Taxes: 85,000 Total Non-Operating Expenses, Net Common stock: 100,000 Total Assets Retained Earnings: 3,000,000 Cost of Goods Sold: 2,000,000 Interest Income: 20,000 Accounts Receivable: 1,500,000 General and Administrative Costs: 1,000,000 Accruals: 800,000 Preferred Stock Net Earnings Goodwill & Other Intangibles: 1,800,000 Net Revenue: 4,500,000 Earnings Before Income Taxes...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below...
Using Microsoft Excel, create a balance sheet and an income statement using the relevant information below Calculate the Net Working Capital and the Net Operating Working Capital for both years Perform vertical analysis on both statements, for both years Perform Horizontal analysis on both statements for the most current year What was the Net Operating Profit After Taxes for both years? 2016 Accounts Receivable 400 Sales 5000 Accounts Payable 650 Inventory 1400 COGS 3000 Common Stock 1500 Cash 1600 Oper....
Please create a retained earnings statement, income statement, and a balance sheet for the month of...
Please create a retained earnings statement, income statement, and a balance sheet for the month of December following accounts and their ending balances. Cash (debit) : $37,308.90 Accounts Receivable (debit) : $11,700 Notes Receivable (debit) : $10,000 Interest Receivable (debit) : $41.67 Merchandise Inventory (debit) : $3,150 Prepaid Advertising (debit) : $250 Office Supplies Inventory (debit) : $180 Prepaid Insurance (debit) : $1,100 Land (debit) : $59,500 Equipment (debit) : $12,000 Accumulated Depreciation - Equipment (credit) : $116.66 Accounts Payable...
Based on the information below create an income statement, balance sheet, and cash flow statement. On...
Based on the information below create an income statement, balance sheet, and cash flow statement. On January 2, 2003, Alexander, together with a number of relatives and friends, established Chemalite, Inc.; 500,000 shares were issued, of which Alexander received 125,000 in exchange for his patent, and the remainder were sold to the other investors at $1 per share. During the period January 2, 2003, through June 30, 2003, Chemalite, Inc., made the following expenditures: January 15—Paid $7,500 in legal fees,...
Create an income statement and balance sheet using the data below. Important: double the balance of...
Create an income statement and balance sheet using the data below. Important: double the balance of the Net Sales and make the necessary corrections to balance. Inputs Accounts Payable 12,000 Accounts Receivable 10,000 Accruals 10,000 Accumulated Depreciation 100,000 Beginning of year Inventory 50,000 Beginning of year Retained Earnings 120,000 Cash 7,000 Common Stock 121,500 Cost of Goods Sold 200,000 Current Portion - Long Term Debt 1,500 Depreciation Expense 25,000 Dividends 40,000 Gross Property, Plant, and Equipment 400,000 Interest Expense 15,000...
Create a Fictitious balance sheet and income statement.
Create a Fictitious balance sheet and income statement.
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me...
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me to run a gas station business, and you may make up your own numbers, just dont copy someone elses from the internet.
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me...
Please create a balance sheet,income statement, and cash flow statement for the calendar year for me to run a gas station business, and you may make up your own numbers, just dont copy someone elses from the internet.
Below are balance sheet and income statement data for Howard Bannister Company.  Note: For the balance sheet...
Below are balance sheet and income statement data for Howard Bannister Company.  Note: For the balance sheet data, the end-of-year information is in the left column. Balance Sheet Data   20X2   20X1 Accounts Payable................................................................................................ 95............................................................. 165 Accumulated Depreciation................................................................................ 520 ...........................................................339 Cash      ................................................................................................................ 130 ..........................................................100 Common Stock ..............................................................................................    1,000......................................................... 700 DIVIDENDS PAYABLE......................................................................................... 40............................................................ 25 Equipment......................................................................................................... 2,395....................................................... 2,700 Income Tax Payable ..........................................................................................100............................................................ 135 Inventory.......................................................................................................... 1,120........................................................... 890 Mortgage Payable.............................................................................................. 900......................................................... 1,500 Prepaid General Expenses............................................................................... 300............................................................. 350 Retained Earnings (ending balance, after closing)...................................... 1,240...................................................... 1,098 Unearned Sales Revenue.....................................................................................
Given the following information please construct a balance sheet and an income statement for the company....
Given the following information please construct a balance sheet and an income statement for the company. It provides software via a cloud subscription. There is no inventory. All information in $000 Total Revenues                                            5,374 Cash                                                                  908 Common Stock                                                651 Cost of Revenues Subscription                     925 Interest Expense                                               16 Additional Paid in Capital                           3,954 Retained Earnings                                       (630) Cost of Revenues Professional Services     365 Gross Margin                                                4,084 Short term securities                                       87 Long term debt                                            2,328 Accounts Receivable                                  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT