Question
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
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started