Question

In: Accounting

Based on the following information can you confirm the Income Statement and Balance Sheet were done...

Based on the following information can you confirm the Income Statement and Balance Sheet were done correctly? Both have been completed after the information. If there is an error please list why there is an error, they appear correct to me. Thank you, and please take your time....

Income Statement Data for 20XX:

Units produced and sold = 420

Sales ($80 per unit selling price) = $33600

Cost of goods sold ($30 per unit, all variable costs) = $12600

Labor = $0 (Mr. and Mr. Lee were the only ones working and did not pay themselves)

Advertising fees =$2000

Bank fees = $150

Phone/internet = $1200

Shipping ($3 per unit) = $1260

Utilities = $900

Office supplies = $800

Interest expense on note payable = $350

Depreciation expense (straight line) = $800

Income tax rate = 26 %

Other Financial Data for 20XX:

Proceeds from sale of equipment = $3000. The equipment originally cost $1000 and had accumulated depreciation of $200.

Purchase of equipment = $1600 (The machine is purchased on the last day of 20XX so no depreciation expense is recorded.)

Repayment of note payable = $5000

Consider any data relevant from the income statement.

Balance Sheet Data for Beginning of 20XX:

Cash and cash equivalents = $10000

Accounts receivable = $0 (Cash is received at time of sale)

Raw materials inventory = $10500

Equipment = $5000 (This includes the $1000 cost of the equipment sold in 20XX).

Accumulated depreciation = $1,000 (This includes the accumulated depreciation of 200 for the equipment sold in 20XX.

Accounts payable = $0 (Cash is paid at the time of purchase.)

Note payable = $5000 (This is the note payable which is repaid in 20XX)

Common stock = $15000

Retained earnings = $4500

Income Statement Data for 20XX:

Units produced and sold = 420

Sales ($80 per unit selling price) = $33600

Cost of goods sold ($30 per unit, all variable costs) = $12600

Labor = $0 (Mr. and Mr. Lee were the only ones working and did not pay themselves)

Advertising fees =$2000

Bank fees = $150

Phone/internet = $1200

Shipping ($3 per unit) = $1260

Utilities = $900

Office supplies = $800

Interest expense on note payable = $350

Depreciation expense (straight line) = $800

Income tax rate = 26 %

Other Financial Data for 20XX:

Proceeds from sale of equipment = $3000. The equipment originally cost $1000 and had accumulated depreciation of $200.

Purchase of equipment = $1600 (The machine is purchased on the last day of 20XX so no depreciation expense is recorded.)

Repayment of note payable = $5000

Consider any data relevant from the income statement.

Balance Sheet Data for Beginning of 20XX:

Cash and cash equivalents = $10000

Accounts receivable = $0 (Cash is received at time of sale)

Raw materials inventory = $10500

Equipment = $5000 (This includes the $1000 cost of the equipment sold in 20XX).

Accumulated depreciation = $1,000 (This includes the accumulated depreciation of 200 for the equipment sold in 20XX.

Accounts payable = $0 (Cash is paid at the time of purchase.)

Note payable = $5000 (This is the note payable which is repaid in 20XX)

Common stock = $15000

Retained earnings = $4500

Income Statement

for the period 1 January 20XX to 31 December 20XX

Revenue

Sales

33,600

Cost of Goods Sold

(12,600)

Gross Profit

21,000

Operating Expenses

Advertising Fees

2,000

Bank Fees

150

Phone/Internet

1,200

Shipping

1,260

Utilities

900

Office Supplies

800

Depreciation Expense

800

Total Operating Expenses

7,110

Operating Profit (EBIT)

13,890

Other Income and (expenses)

Interest expenses

(350)

Gain on sale of equipment

2,200

Profit Before Taxes (EBT)

15,740

Income Tax

4,092

Net Income

11,648

Balance Sheet

For Year Ending 20XX

Assets

Current Assets

Cash and Cash equivalents

    16,648

Accounts receivables

            -

Raw materials inventory

    10,500

Total current assets

    27,148

Non-current Assets

Equipment

     5,600

Less: accum. depreciation

       (800)

     4,800

Total assets

    31,948

Liabilities & Stockholders'equity

Current Liabilities

Accounts payable

            -

Total Current Liabilities

            -

Note payable

            -

Total Liabilities

            -

Stockholders' equity

Common Stock

    15,000

Retained earnings

    16,948

Total stockholders' equity

    31,948

Total liabilities & stockholders' equity

    31,948

Solutions

Expert Solution

The answer is absolutelycorrect.Great Work done.

Income Statement
for the period 1 January 20XX to 31 December 20XX
Revenue
Sales 33,600
Cost of Goods Sold -12,600
Gross Profit 21,000
Operating Expenses
Advertising Fees 2,000
Bank Fees 150
Phone/Internet 1,200
Shipping 1,260
Utilities 900
Office Supplies 800
Depreciation Expense 800
Total Operating Expenses 7,110
Operating Profit (EBIT) 13,890
Other Income and (expenses)
Interest expenses -350
Gain on sale of equipment 2,200
Profit Before Taxes (EBT) 15,740
Income Tax 4,092
Net Income 11,648
Balance Sheet
For Year Ending 20XX
Assets
Current Assets
Cash and Cash equivalents     16,648
Accounts receivables             -
Raw materials inventory     10,500
Total current assets     27,148
Non-current Assets
Equipment      5,600
Less: accum. depreciation        (800)      4,800
Total assets     31,948
Liabilities & Stockholders'equity
Current Liabilities
Accounts payable             -
Total Current Liabilities             -
Note payable             -
Total Liabilities             -
Stockholders' equity
Common Stock     15,000
Retained earnings     16,948
Total stockholders' equity     31,948
Total liabilities & stockholders' equity     31,948

Related Solutions

Based on the following financial information, construct the balance sheet and income statement below for Tonka...
Based on the following financial information, construct the balance sheet and income statement below for Tonka Trucking LLC for the year ending December 31, 2019. Be sure to format them as accurately as possible. Accounts Receivable $40,000 Depreciation Expense $50,000 Accumulated Depreciation $200,000 Cost of Goods Sold $50,000 Income Tax Expense $50,000 Cash $50,000 Sales Revenue $400,000 Equipment (Net of Accumulation) $200,000 Selling, General, and Administrative Expenses $100,000 Common Stock (1,000 shares) $100,000 Accounts Payable $50,000 Retained Earnings $200,000 Interest...
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,...
I need the Income Statement, Retained Earnings Statement, and Balance Sheet, based off of this information!...
I need the Income Statement, Retained Earnings Statement, and Balance Sheet, based off of this information! There are five empty slots under the expenses column in the income statement that is especially confusing me. Problem 1-3A On May 1, Sheffield Corp., a company that provides flying lessons, was started by using common stock in exchange for cash of $45,350. Following are the assets and liabilities of the company on May 31, 2019, and the revenues and expenses for the month...
Can you please form a balance sheet and income statement with the information: Start-up costs for...
Can you please form a balance sheet and income statement with the information: Start-up costs for the business will require a large amount of expenses. First a section of land will need to be purchased. This area is expected to be 500ft2. This is a sufficient quantity of space to build the warehouse where will growing will be undertaken. The warehouse will be 300ft2. This size means there will be enough room for all business activities such as growing, organizing...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the...
Based on the trial balance below, prepare the Income Statement and the Balance Sheet for the year 2012. Please show your workings for the related questions below (yes, all together!). If your final answers (below) are incorrect, I'll review your workings to grant partial credit. Trial Balance as at 31st December 2012 Trial Balance Dr Cr Sales 240,000 Purchases 150,000 Returns inwards 5,000 Returns outwards 6,000 Carriage Inwards 3,000 Inventory 1.1.2012 80,000 Salaries 25,000 Electricity and telephone 4,000 Rent 5,000...
Model constructing an income statement and balance sheet for a furniture company based on the following...
Model constructing an income statement and balance sheet for a furniture company based on the following transaction details. Please clearly show which transactions fall under the following parts of the statement: Sales Cost of Sales SG&A Expenses Interest Income Income Expense Loss on Sale of Non-Current Asset Transactions Buy wood to build bookshelves- $500 A recently hired team member builds the bookshelves and should be paid - $25 Paid electricity bill for shop where bookshelves are made - $100 Paid...
Based on the information below create the year end income statement, balance sheet, and cash flow...
Based on the information below create the year end 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...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance...
Analyzing, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market Inc. WHOLE FOODS MARKET INC. Consolidated Statement of Operations Fiscal Years Ended (in millions) Sept 25, 2016 Sept 27, 2015 Sales $15,724 $15,389 Cost of goods sold and occupancy costs 10,313 9,973 Gross profit 5,411 5,416 Selling, general and administrative expenses 4,477 4,472 Pre-opening expenses 64 67 Relocation, store closures and lease termination costs 13 16 Operating income 857...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE TAX RATE IS 40%. (COMMON EQUITY IS A PLUG IN NUMBER) ITEM 2010 2011 SALES 10,000 12,000 DEPRECIATION 3,000 3,000 COST OF GOODS SOLD 2,000 2,000 OTHER EXPENSES 3,000 4,000 INTEREST 1,000 1,000 CASH 1,000 1,000 ACCOUNTS RECEIVABLE 3,000 3,000 S.T. NOTES PAYABLE 1,000 1,000 L.T. DEBT 10,000 11,000 NET FIXED ASSETS 20,000 20,000 ACCOUNTS PAYABLE 2,000 2,000 INVENTORY 3,000 3,000 DIVIDENDS 600 600...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT