In: Accounting
Missing Amounts from Financial Statements
The financial statements at the end of Atlas Realty's first month of operations follow:
Required:
Analyze the interrelationships among the four financial statements and enter the missing amounts. If an amount is zero, enter "0".
Atlas Realty | ||
Income Statement | ||
For the Month Ended May 31, 2018 | ||
Fees earned | $400,000 | |
Expenses: | ||
Wages expense | $ | |
Rent expense | 48,000 | |
Supplies expense | 17,600 | |
Utilities expense | 14,400 | |
Miscellaneous expense | 4,800 | |
Total expenses | 288,000 | |
Net income | $ |
Atlas Realty | ||
Retained Earnings Statement | ||
For the Month Ended May 31, 2018 | ||
Retained earnings, May 1, 2018 | $ | |
Net income | $ | |
Dividends | ||
Change in retained earnings | ||
Retained earnings, May 31, 2018 | $ |
Atlas Realty | ||
Balance Sheet | ||
May 31, 2018 | ||
Assets | ||
Cash | $123200 | |
Supplies | 12,800 | |
Land | ||
Total assets | $ | |
Liabilities | ||
Accounts payable | $48,000 | |
Stockholders’ Equity | ||
Common stock | $ | |
Retained earnings | ||
Total stockholders' equity | ||
Total liabilities and stockholders’ equity | $ |
Use the minus sign to indicate cash outflows, decreases in cash, and cash payments.
Atlas Realty | ||
Statement of Cash Flows | ||
For the Month Ended May 31, 2018 | ||
Cash flows from operating activities: | ||
Cash received from customers | $ | |
Cash payments for expenses and payments to creditors | -252,800 | |
Net cash flows from operating activities | $ | |
Cash flows from investing activities: | ||
Cash payments for acquisition of land | -120,000 | |
Cash flows from financing activities: | ||
Cash received from issuing common stock | $160,000 | |
Cash dividends | -64,000 | |
Net cash flows from financing activities | ||
Net increase (decrease) in cash and May 31, 2018, cash balance | $ |
Atlas Realty | ||
Income Statement | ||
For the Month Ended May 31, 2018 | ||
Fees earned | $400,000 | |
Expenses: | ||
Wages expense | 203,200 | |
Rent expense | 48,000 | |
Supplies expense | 17,600 | |
Utilities expense | 14,400 | |
Miscellaneous expense | 4,800 | |
Total expenses | 288,000 | |
Net income | $112,000 | |
Atlas Realty | ||
Retained Earnings Statement | ||
For the Month Ended May 31, 2018 | ||
Retained earnings, May 1, 2018 | 0 | |
Net income | $112,000 | |
Dividends | 64000 | |
Change in retained earnings | $48,000 | |
Retained earnings, May 31, 2018 | $48,000 | |
Atlas Realty | ||
Balance Sheet | ||
31-May-18 | ||
Assets | ||
Cash | $123,200 | |
Supplies | 12,800 | |
Land | 120000 | |
Total assets | $256,000 | |
Liabilities | ||
Accounts payable | $48,000 | |
Stockholders’ Equity | ||
Common stock | 160000 | |
Retained earnings | $48,000 | |
Total stockholders' equity | $208,000 | |
Total liabilities and stockholders’ equity | $256,000 | |
Atlas Realty | ||
Statement of Cash Flows | ||
For the Month Ended May 31, 2018 | ||
Cash flows from operating activities: | ||
Cash received from customers | 400000 | |
Cash payments for expenses and payments to creditors | -252,800 | |
Net cash flows from operating activities | 147,200 | |
Cash flows from investing activities: | ||
Cash payments for acquisition of land | -120,000 | |
Cash flows from financing activities: | ||
Cash received from issuing common stock | $160,000 | |
Cash dividends | -64,000 | |
Net cash flows from financing activities | $96,000 | |
Net increase (decrease) in cash and May 31, 2018, cash balance | 123,200 | |