|日5 Relationships among Financial Statements - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A Alignment Number Conditional Format as Cell Formatting Table Styles...

solve the missing amounts and how the financial statements are linked

Extracted text: |日5 Relationships among Financial Statements - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A Alignment Number Conditional Format as Cell Formatting Table Styles Paste BIU. Cells Clipboard G Font Styles A1 Presented below are incomplete financial statements for Marta Communications, A 1 'resented below are incomplete financialstatements for Marta Communications, Inc. 2 3 tequired: iolve for the missing amounts. NOTE: When on amount on one financial stotement is again shown on inother stotement, you MUST reference the cell from the earlier stotement rather than colculote the omount, thus 4 ces 5. ndicoting the relationship between the two statements. MARTA COMMUNICATIONS, INC. Income Statement 10 For the Month Ended March 31, 20X1 11 iales Revenues S34,500 12 xpenses: Rent Expense 14 Wages Expense 13 2,600 15 Utilities Expense 4,800 16 Income Tax Expense 800 17 det income 54,100 18 19 20 MARTA COMMUNICATIONS, INC. 21 Statement of Retained Earnings 22 For the Month Ended March 31, 20X1 23 letained Earnings, March 1, 20X1 50 24 Add: Net income