Relationships among Financial Statements using Excel's SUM and Basic Math Functions 1. Solve for the missing amounts and understand how the financial statements are linked. XB5- ? 5 X Relationships among Financial Statements - Excel PAGE LAYOUT FORMULAS DATA REVIEW FILE HOME INSERT VIEW Sign In X Calbel AA Alignment Number Conditional Formatas Celt Formatting Table Styles Paste Cells Editing BTU- Clipboard Font AI Presented below are incomplete financial statements for Marta Communication D 1 Presented below are incomplete financial statements for Marta Communications, Inc. 2 3. Required: 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 Next signments Saved Add: Net income Subtract: Dividends Retained Earnings, March 31, 20X1 (500) MARTA COMMUNICATIONS, INC. Balance Sheet At March 31, 20X1 Liabilities $3,400 Accounts payable Stockholders' Equity 2,300 Common stock 12,000 Retained earnings Total Liabilities and Stockholders' Equity $6,800 Assets Cash Accounts receivable Office supplies Land 14,000 Total Assets 1 Sheet1 READY Attempt(s) 100%