Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Nutsy Inc. Statement of Net Income 2020 2019 2018 Revenue 4,500,000 4,000,000 3,000,000 Cost of Good Sold 2,800,000 2,200,000 1,500,000 Gross Profit 1,700,000 1,800,000 1,500,000

Nutsy Inc.
Statement of Net Income 2020 2019 2018
Revenue 4,500,000 4,000,000 3,000,000
Cost of Good Sold 2,800,000 2,200,000 1,500,000
Gross Profit 1,700,000 1,800,000 1,500,000
Operating Expenses
Salaries 720,000 650,000 600,000
Rent 100,000 100,000 100,000
Interest Expense 36,000 36,000 60,000
Depreciation 55,000 50,000 40,000
Amortization 10,000 10,000 10,000
Loss/ (gain) on sale of equipment (8,000) 5,000 -
Total Operating Expenses 913,000 851,000 810,000
Net Income 787,000 949,000 690,000
Nutsy Inc.
Balance Sheet 2020 2019 2018
Cash 3,103,400 2,193,800 2,300,000
Accounts Receivable, net of bad debt allowance 850,000 910,000 800,000
Inventory 570,000 550,000 500,000
Pre-paid expenses 75,000 100,000 120,000
Total Current Assets 4,598,400 3,753,800 3,720,000
Property, Plant and Equipment, net of depreciation 2,610,000 2,620,000 2,380,000
Intangible assets, net of amortization 100,000 110,000 120,000
Total Non-current assets 2,710,000 2,730,000 2,500,000
TOTAL ASSETS 7,308,400 6,483,800 6,220,000
Current Liabilities
Accounts Payable 440,000 400,000 300,000
Wages Payable 30,000 50,000 25,000
Income Taxes Payable 157,400 189,800 100,000
Total Current Liabilities 627,400 639,800 425,000
Non Current Liabilites
Bonds Payable 1,200,000 1,200,000 2,000,000
Total Non Current Liabilities 1,200,000 1,200,000 2,000,000
Total Liabilities 1,827,400 1,839,800 2,425,000
Shareholder's Equity
Common Stock, $10 par value 450,000 400,000 400,000
Additional Paid In Capital 1,400,000 1,300,000 1,300,000
Retained Earnings 3,631,000 2,944,000 2,095,000
Total Shareholders Equity 5,481,000 4,644,000 3,795,000
TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 7,308,400 6,483,800 6,220,000
Other Transactions:
2019
1) Purchased a building for $300,000 cash
2) Sold a vehicle originally purchased for $40,000 for $5,000 cash. Accumulated depreciation on the vehicle was $30,000 at the time of the sale.
3) Retired bonds payable for $800,000 cash
4) Paid a cash dividend of $100,000
2020
1) Issued 100,000 shares of $1 par value common stock for $350,000
2) Sold equipment for $8,000. Equipment was originally purchased for $280,000. The equipment was fully depreciated at the time of sale.
3) Purchased equipment for $45,000
4) Repurchased stock for $200,000
5) Paid a cash dividend of $100,000

Use the financial statements excel worksheets (first tab) and other information (second tab) for Nutsy, Inc. Download Nutsy, Inc.to complete the Statement of Cash Flows for 2019. Prepare the Statement of Cash Flows on the excel worksheet (make sure to be in balance) before submitting your answers below.

NOTE: use whole dollars only. Do not use a $ sign. Do not use a decimal (e.g. use 10,000, not 10,000.00) and use a comma to separate thousands (e.g. use 10,000 not 10000). Indicate negative numbers with a minus sign (e.g. -10,000)

Enter below Statement of Cash Flows for Nutsy, Inc. for the period ending December 31, 2019

Net Income

Depreciation Expense

Amortization Expense
gain or loss on disposal of assets
Accounts Receivable
Inventory
Prepaid Expenses
Accounts Payable
Wages Payable
Income Tax Payable
Cash provided (used) by Operating Activities
Purchase of a building
Proceeds from the sale of vehicle
Cash provided (used) by Investing Activities
Retirement of Bonds
Dividends Paid
Cash provided (used) by Financing Activities
Net Increase (Decrease) in Cash
Beginning Cash Balance
Ending Cash Balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting And Auditing Standards For Islamic Financial Institutions

Authors: Mohd MaSum Billah

1st Edition

103206353X, 978-1032063539

More Books

Students also viewed these Accounting questions

Question

What is operatiing system?

Answered: 1 week ago

Question

1-4 How will MIS help my career?

Answered: 1 week ago