Please fill the spread sheet with the information provided below

MARK'S CONSULTING Transactions for Year 1: 1. Cash acquired from stock issuance 2. Cash received for services Cash borrowed from creditors 4. Expenses paid 5. Land purchase 20.000 35,000 25,000 22,000 30,000 Transactions for Year 2: Beginning Cash Balances: Cash Land Notes Payable Common Stock Retained Earnings 28,000 30,000 25,000 20,000 13,000 nimt Cash acquired from stock issuance Cash received for Year 2 services Cash paid to creditors 4. Expenses paid 5. Dividend paid 6. Determined market value of land 24,000 95,000 15,000 71,500 3,000 47,000 MARK'S CONSULTING Accounting Equation for Year 1 Assets Liabilities Notes Payable + Stockholders' Equity | Common Retained + Stock Earnings Cash 20.000 Land = Acct. Title/RE Event 1. Issued Stock 2. Revenue 3. Loan 4. Paid Expenses 5. Purchased Land Totals MARK'S CONSULTING Accounting Equation for Year 2 Assets = Liabilities Notes Payable + Stockholders' Equity | Common Retained Stock Earnings Cash Land Acct. Title/RE Event Beginning Balance 1. Issued Stock 2. Revenue 3. Paid Loan 4. Paid Expenses 5. Paid Dividends 6. Land Value Totals Requirement b. : MARK'S CONSULTING Income Statements For the Period Ended December 31 Year 1 Year 2 Service Revenue Expenses Net Income MARK'S CONSULTING Statements of Changes in Stockholders' Equity For the Period Ended December 31 Year 1 Year 2 Beginning Common Stock Plus: Common Stock Issued Ending Common Stock Beginning Retained Earnings Plus: Net Income Less: Dividends Ending Retained Earnings Total Stockholder's Equity MARK'S CONSULTING Balance Sheets As of December 31 Year 1 Year 2 Assets Cash Land Total Assets Liabilities Notes Payable Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity MARK'S CONSULTING Statements of Cash Flows For the Year Ended December 31 Year 1 Year 2 Cash Flows from Operating Activities: Cash Receipts from Customers Cash Payments for Expenses Net Cash Flow from Operating Activities Cash Flows from Investing Activities: Cash Payment for Land Net Cash Flow from Investing Activities Cash Flows from Financing Activities: Cash Receipts from Borrowing Cash Receipts from Stock Issue Cash Payment of Debt Cash Payment for Dividends Net Cash Flow from Financing Activities Net Change in Cash Plus: Beginning Cash Balance Ending Cash Balance MARK'S CONSULTING Transactions for Year 1: 1. Cash acquired from stock issuance 2. Cash received for services Cash borrowed from creditors 4. Expenses paid 5. Land purchase 20.000 35,000 25,000 22,000 30,000 Transactions for Year 2: Beginning Cash Balances: Cash Land Notes Payable Common Stock Retained Earnings 28,000 30,000 25,000 20,000 13,000 nimt Cash acquired from stock issuance Cash received for Year 2 services Cash paid to creditors 4. Expenses paid 5. Dividend paid 6. Determined market value of land 24,000 95,000 15,000 71,500 3,000 47,000 MARK'S CONSULTING Accounting Equation for Year 1 Assets Liabilities Notes Payable + Stockholders' Equity | Common Retained + Stock Earnings Cash 20.000 Land = Acct. Title/RE Event 1. Issued Stock 2. Revenue 3. Loan 4. Paid Expenses 5. Purchased Land Totals MARK'S CONSULTING Accounting Equation for Year 2 Assets = Liabilities Notes Payable + Stockholders' Equity | Common Retained Stock Earnings Cash Land Acct. Title/RE Event Beginning Balance 1. Issued Stock 2. Revenue 3. Paid Loan 4. Paid Expenses 5. Paid Dividends 6. Land Value Totals Requirement b. : MARK'S CONSULTING Income Statements For the Period Ended December 31 Year 1 Year 2 Service Revenue Expenses Net Income MARK'S CONSULTING Statements of Changes in Stockholders' Equity For the Period Ended December 31 Year 1 Year 2 Beginning Common Stock Plus: Common Stock Issued Ending Common Stock Beginning Retained Earnings Plus: Net Income Less: Dividends Ending Retained Earnings Total Stockholder's Equity MARK'S CONSULTING Balance Sheets As of December 31 Year 1 Year 2 Assets Cash Land Total Assets Liabilities Notes Payable Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity MARK'S CONSULTING Statements of Cash Flows For the Year Ended December 31 Year 1 Year 2 Cash Flows from Operating Activities: Cash Receipts from Customers Cash Payments for Expenses Net Cash Flow from Operating Activities Cash Flows from Investing Activities: Cash Payment for Land Net Cash Flow from Investing Activities Cash Flows from Financing Activities: Cash Receipts from Borrowing Cash Receipts from Stock Issue Cash Payment of Debt Cash Payment for Dividends Net Cash Flow from Financing Activities Net Change in Cash Plus: Beginning Cash Balance Ending Cash Balance