Please solve for yellow highlighted ? and show work
Answer -
Income Statement: | |
Rent expense | $20000 |
Total Expenses | $90000 |
Net income | $110000 |
Statement of stockholders equity: | |
Dividends | $30000 |
Ending retained earnings (Aug 31) | $103000 |
Balance sheet: | |
Cash | $30000 |
Total assets | $164000 |
Accounts payable | $9000 |
Total liabilities | $40000 |
Retained earnings | $103000 |
Calculation:
1. Net income:
Here, net income of Talley Inc. for the month of August is already given in the statement of shareholders equity.
So, Net income = $110000 (given)
2. Total expenses:
Net income = Service revenue - Total expenses
So,
Total expenses = Service revenue - Net income
Total expenses = $200000 - $110000
Total expenses = $90000
3. Rent expense:
Here,
Total expenses = Salaries expense + Rent expense + Insurance expense + Utilities expense + Miscellaneous expense
So,
Rent expense = Total expenses - (Salaries expense + Insurance expense + Utilities expense + Miscellaneous expense)
Rent expense = $90000 - ($60000 + $7000 + $2000 + $1000)
Rent expense = $20000
4. Dividends:
Total stockholders equity (Ending balance) = Total stockholders equity (Beginning balance) + New stock issuance + Net income - Dividends
Therefore,
Dividends = Total stockholders equity (Beginning balance) + New stock issuance + Net income - Total stockholders equity (Ending balance)
Dividends = $38000 + $6000 + $110000 - $124000
Dividends = $30000
5. Ending retained earnings (Aug 31):
Ending retained earnings (Aug 31) = Beginning retained earnings (Aug 01) + Net income - Dividends
Ending retained earnings (Aug 31) = $23000 + $110000 - $30000
Ending retained earnings (Aug 31) = $103000
6. Total assets:
In order for the balance sheet to balance, total liabilities and stockholders' equity must be equal to the total assets.
So,
Total assets = Total liabilities and stockholders equity
Therefore, Total assets = $164000
7. Cash:
Here,
Total assets = Cash + Supplies + Equipment + Land
Therefore,
Cash = Total assets - (Supplies + Equipment + Land)
Cash = $164000 - ($4000 + $90000 + $40000)
Cash = $30000
8. Total liabilities:
Total liabilities and stockholders equity = Total liabilities + Total stockholders equity
So,
Total liabilities = Total liabilities and stockholders equity - Total stockholders equity
Total liabilities = $164000 - $124000
Total liabilities = $40000
9. Accounts payable:
Here,
Total liabilities = Accounts payable + Salaries payable + Note payable
So,
Accounts payable = Total liabilities - (Salaries payable + Note payable)
Accounts payable = $40000 - ($1000 + $30000)
Accounts payable = $9000
10. Retained earnings:
Total stockholders equity = Common stock + Retained earnings
Therefore,
Retained earnings = Total stockholders equity - Common stock
Retained earnings = $124000 - $21000
Retained earnings = $103000
Please solve for yellow highlighted ? and show work Problem V: The following are condensed financial...
Problem V: The following are condensed financial statements for Talley Inc. for the month of August. Solve for all spots marked with a “?*. You may either write or type your answers over the question marks or enter them in the chart on the next page. Talley Inc. Income Statement For the month ended August 31, 20X1 $ 200,000 Service revenue Expenses: $ 60,000 Salaries expense Rent expense Insurance expense 7,000 Utilities expense 2,000 1.000 Miscellaneous expense Total expenses Net...
I need help finding the values with question marks Problem IV: Below are condensed financial statements for Harrington Inc. for the month of August. Solve for all spots marked with a ". You may either write or type your answers over the question marks or en them in the chart on the next page. Harrington Indc. Income Statement For the month ended August 31, 20X1 Service revenue Expenses: 175,000 Salaries expense Rent expense Insurance expense Utilities expense Miscellaneous expense Total...
Solve for the missing amounts: Solve for amounts in boxes highlighted. 1 Presented below are incomplete financial statements for Marta Communications, Inc. 2 3 Required: 4 Solve for the missing amounts. NOTE: When an amount on one financial statement is again shown on 5 another statement, you MUST reference the cell from the earlier statement rather than calculate the amount, thus 6 indicating the relationship between the two statements. MARTA COMMUNICATIONS, INC. Income Statement For the Month Ended March 31,...
Yellow boxes need excel formulas in them A1 X fic Presented below are incomplete financial statements for Marta Communications, 1 Presented below are incomplete financial statements for Marta Communications, Inc. 3 Required: 4 Solve for the missing amounts. NOTE: When an amount on one financial statement is again shown on another statement, you MUST reference the cell from the earlier statement rather than calculate the amount, thus indicating the relationship between the two statements. BEBO O va MARTA COMMUNICATIONS, INC....
Required: Solve for the missing amounts. NOTE: When an amount on one financial statement is again shown on another statement, you MUST reference the cell from the earlier statement rather than calculate the amount, thus indicating the relationship between the two statements. MARTA COMMUNICATIONS, INC Income Statement For the Month Ended March 31, 20X1 Sales Revenues $34,500 Expenses: Rent Expense Salaries Expense Utilities Expense Income Tax Expense 2,600 4,800 800 $4,100 Net income MARTA COMMUNICATIONS, INC. Statement of Stockholders' Equity...
Please show all work (3.5 pts) Links between the financial statements: Below are financial statements for Not So Strong, Inc. at the end of 2018, with a few pieces missing: Not So Strong, Inc. Income Statement Service Revenues $56,350 Expenses: Utilities $800 Wages $22,100 Rent $18,000 NET INCOME (a) Not So Strong, Inc. Statement of Stockholders’ Equity Common Stock (CS) Retained Earnings Total Stockholders’ Equity Beginning Balance: (c) $13,720 $17,720 CS Issuances $6,000 $6,000 Add: Net Income (a) (a) Less: Dividends...
Calculator Financial statements We-Sell Realty was organized as a corporation on August 1, 2017, by the issuance of common stock of $15,000. We Sell Realty is owned and operated The following statements for We-Sell Realty were prepared after its first month of operations: We-Sell Realty Income Statement August 31, 2017 Sales commissions $140,000 Expenses: $87,000 Office salaries expense Rent expense Automobile expense Miscellaneous expense 18,000 7,500 2,200 1,150 Supplies expense Total expenses (115,850) Net income $25,000 Omar Farah Statement of...
solve for the missing amounts ( no need to make a excel sheet just state the line # and answer ) t Calibri B I - 11 - - A A . - A - Alignment Number Paste U - Cells Editing Conditional Format as Cell Formatting" Table Styles Styles Clipboard Font A1 Presented below are incomplete financial statements for Marta Communications, 1 Presented below are incomplete financial statements for Marta Communications, Inc. 3 Required: 4 Solve for the missing...
Salsa Inc Income Statement For the month ended August 31,20X1 Service revenue Expenses Salaries expense Rent expense Interest expense Utilities expense Other expense $ 50,000 10,000 5,000 4,000 8,000 Total expenses Net Income $_200,000 Salsa Inc. Statement of Stockholders' Equity For the month ended August 31,20X1 Common Stock $ 20,000 8,000 Retained Earnings $ 19,000 Total Stockholders' Equity Beginning balances - Aug 1 Add: New stock issuances Add: Net income Less: Dividends $ 39,000 8,000 200,000 200,000 Ending balances -...
Below are incomplete financial statements for Cyclone, Inc. Required: Calculate the missing amounts. CYCLONE, INC. Income Statement Year ended Dec. 31, 2021 Revenues Expenses: Salaries $ 12,000 Rent 6,000 Advertising 4,000 Net income CYCLONE, INC. Statement of Stockholders' Equity Year ended Dec. 31, 2021 Common Stock Retained Earnings Total Stockholders' Equity $ 19,000 13,000 $ 6,000 Beginning balance Issuances of stock Add: Net income Less: Dividends Ending balance 4,000 4,000 $ 15,000 $ 7,000 $ 22,000 Assets $ CYCLONE, INC....