Question
You've just started a business that makes lava lamps. The cost of goods sold for each lamp is $12 and you sell them for $20
You've just started a business that makes lava lamps. The cost of goods sold for each lamp is $12 and you sell them for $20 each. You start the company on December 31st, 2019. At that time, you have enough inventory to make 700 lamps, you have $8,000 of cash on hand. You begin by making them in your garage. You purchased equipment used to make the lamps for $40,000 which have no salvage value and will depreciated evenly over 5 years. To finance your assets, you take out a $35,000 loanwhich will be due on December 31st, 2022. The entire principal value will be due on that date and you will need to make an interest payment of 9% of the principal value on December 31st, 2020, on December 31st, 2021, and pay off the principal plus the interest payment on December 31st, 2022. The portion of assets not financed with debt will come from an equity investment from you.
1styear activities
During the 1styear of business, you sold 3,000 lamps. At the end of the year, you have enough inventory on hand to build 850 lamps. You began purchasing on credit near the end of the year and have $4,000 in accounts payable at the end of the year. You allowed one customer to purchase on credit and have accounts receivable of $2,000 at the end of the year. You paid yourself a salary of $6,000 during the year. The company's income tax rate is 15%.
2ndyear activities
The production of the lamps has overwhelmed your garage and has taken over a portion of your house. In order to maintain familial harmony, you rent space at $800 per month to build your shelters. This will begin on January 1st, 2021. You also purchase $30,000 in equipment on January 1st, 2021, which will also be evenly depreciation over the next five years with no salvage value.
You sold 6,500 units during the year. You once again paid yourself a $6,000 salary and took $10,000 in dividends during the year. At the end of the year you had $2,500 in accounts receivable and $4,400 in accounts payable. You have enough inventory on hand to make 1,000 lamps. You owe your landlord $800 for the previous month's rent. The company's income tax rate is 15%.
3rdyear activities
During the third year, your sales jump to 15,000 units. You increased your pay to $50,000 per year and the company owed you $20,000 of that at the end of the year. You have enough inventory to produce 3,000 units at the end of the year. Once again, you owe your landlord $800 at the end of the year and your rent amount remained at $800 per month. Accounts Receivable were $5,000 at the end of the year and accounts payable were $6,000. You pay off the $35,000 loan on December 30th, 2022. The company's income tax rate is 20%. You pay yourself $25,000 in dividends during the year.
Question:
Correctly complete the Balance Sheet, Income Statement, and Statement of Cash Flows that follow.
Balance Sheet as of December 31st,
2019 2020 2021 2022
Current Assets
Cash
Accounts Receivable
Inventory
Total Current Assets
Fixed Assets
Gross Fixed Assets
Accumulated Depreciation
Net Fixed Assets
Total Assets
Current Liabilities
Accounts Payable
Accrued Expenses
Notes Payable
Total Current Liabilities
Long-Term Liabilities
Common Equity
Retained Earnings
Total Liabilities and Equity
Income Statement for the Period Ending December 31st,
2020 2021 2022
Net Sales
Cost of Goods Sold
Gross Profit
Selling, General, and Administrative Expenses
Rent Expense
Depreciation Expense
Earnings Before Interest and Taxes
Interest Expense
Earnings Before Taxes
Income Tax
Net Income
Dividends Paid
Addition to Retained Earnings
Statement of Cash Flows for the Period Ending December 31st,
2020 2021 2022
Net Income
Add: Depreciation Expense
Change in Accounts Receivable
Change in Inventory
Change Accounts Payable
Change in Accrued Expenses
Cash Flows from Operations
Cash from the Sale of Investments
Investment in Fixed Assets
Cash Flow from Investing Activities
Cash from the Issuance (Payment) of Notes Payable
Cash from the Issuance (Payment) of Long-Term Debt
Cash from the Issuance (Repurchase) of Equity
Dividends Paid
Cash Flows from Financing Activities
Net Cash Flow
Beginning Cash
Change in Cash
Ending Cash
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