again I need the formulas to reference the cells rather than just calculating missing amounts
Relationships among Financial Statements - Excel DATA REVIEW VIEW PAGE LAYOUT FORMULAS FILE HOME INSERT Calibri 11 % Alignment Number Conditional Format as Cell Table Styles Paste BIU Formatting Styles Clipboard Font Presented below are incomplete financial statements Al A C 18 19 20 MARTA COMMUNICATIONS, INC. Statement of Retained Earnings For the Month Ended March 31, 20X1 21 22 23 Retained Earnings, March 1, 20X 24 Add: Net income $0 25 Subtract: Dividends (500) 26 Retained Earnings, March 31, 20X1 27 28 29 MARTA COMMUNICATIONS, INC. 30 Balance Sheet 31 At March 31, 20X1 Prev 1 of 2 Next > 20 . MacBook Air g0 Presented below are incomplete financial statements for Marta Communications, I Required: Solve for the missing amounts. NOTE: When an amount on one financial stateme another statement, you MUST reference the cell from the earlier statement rathert indicating the relationship between the two statements MARTA COMMUNICATIONS, INC Income Statement For the Month Ended March 31, 20X1 Sales Revenues Expenses: Rent Expense Salaries Expense Utilities Expense Income Tax Expense Net income $34,500 2,600 22,200 4,800 800 $4,100 MARTA COMMUNICATIONS, INC. Statement of Stockholders' Equity For the Month Ended March 31, 20X1 Common Stock Retained Earnin Beginning Balance (March 1, 20X1) Issuance of common stock Add: Net income for March Less: Dividends Ending Balance (March 31, 20X1) $0 $14,000 $14,000 MARTA COMMUNICATIONS, INC. Balance Sheet At March 31, 20X1 Liabilities $3,400 Accounts payable Stockholders' Equity 2,300 Common stock Retained earnings Assets Cash Accounts receivable Supplies 12,000 Land Total Liabilities and Stockho Total Assets Relationships among Financial Statements - Excel DATA REVIEW VIEW PAGE LAYOUT FORMULAS FILE HOME INSERT Calibri 11 % Alignment Number Conditional Format as Cell Table Styles Paste BIU Formatting Styles Clipboard Font Presented below are incomplete financial statements Al A C 18 19 20 MARTA COMMUNICATIONS, INC. Statement of Retained Earnings For the Month Ended March 31, 20X1 21 22 23 Retained Earnings, March 1, 20X 24 Add: Net income $0 25 Subtract: Dividends (500) 26 Retained Earnings, March 31, 20X1 27 28 29 MARTA COMMUNICATIONS, INC. 30 Balance Sheet 31 At March 31, 20X1 Prev 1 of 2 Next > 20 . MacBook Air g0 Presented below are incomplete financial statements for Marta Communications, I Required: Solve for the missing amounts. NOTE: When an amount on one financial stateme another statement, you MUST reference the cell from the earlier statement rathert indicating the relationship between the two statements MARTA COMMUNICATIONS, INC Income Statement For the Month Ended March 31, 20X1 Sales Revenues Expenses: Rent Expense Salaries Expense Utilities Expense Income Tax Expense Net income $34,500 2,600 22,200 4,800 800 $4,100 MARTA COMMUNICATIONS, INC. Statement of Stockholders' Equity For the Month Ended March 31, 20X1 Common Stock Retained Earnin Beginning Balance (March 1, 20X1) Issuance of common stock Add: Net income for March Less: Dividends Ending Balance (March 31, 20X1) $0 $14,000 $14,000 MARTA COMMUNICATIONS, INC. Balance Sheet At March 31, 20X1 Liabilities $3,400 Accounts payable Stockholders' Equity 2,300 Common stock Retained earnings Assets Cash Accounts receivable Supplies 12,000 Land Total Liabilities and Stockho Total Assets
