be and how would it look like in excel?
Lola's Company
Balance Sheet
December st
Assets
Cash and Cash Equivalents $
Accounts Receivable $
Inventory $
Prepaid Expenses $
Property, Plant and Equipment $
Total Assets $
Liabilities
Accounts Payable $
Notes Payable $
Accrued Expenses $
Total Liabilities $
Owner's Equity
Common Stock $
Retained Earning $
Total Owner's Equity $
Total Liabilities and Owner's Equity $
Statement of Owner's Equity
December st
Owner's Equity at Beginning of Year
$
Net Income for the Year
$
Issuance of Common Stock
$
Dividends Paid
$
Owner's Equity at End of Year
$
Lola's Company
Statement of Cash Flow
December st
Cash Flows from Operating Activities
Net Income $
Depreciation Expense $
Increase in Accounts Receivable $
Increase in Inventory $$
Decrease in Prepaid Expenses
$
Net Cash Provided by Operating Activities
$
Cash Flows from Investing Activities
Purchase of Property, Plant and Equipment
$
Net Cash Used in Investing Activities
$
Cash Flows from Financing Activities
Proceeds from Isguance of Common Stock
$
Repayment of Notes Payable
$
Net Cash Provided by Financing Activities
$
Net Increase in Cash and Cash Equivalents
$
Income Statement
December
Revenue
Sales Revenue $
Interest Income $
Total Revenue
$
Expenses
Cost of Goods Sold $
Depreciation Expense $
Salaries and Wages Expense $
Rent Expense $
Total Expenses
$
Net Income
$