Question

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 For the Month Ended March 31,20X1 Common Stock Retained Earnings Total Beginning Balance (March 1,20X1) Issuance of common stock $0 $14,000 $0 $14,000 $0

Answer 1

SEE THE SCREENSHOT. ANY DOUBTS, HAPPY TO HELP YOU. THANK YOU. THUMBS UP PLEASE.

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E " ゴWrap Text ta copy ▼ B 1 u. ,_a. ars-函Merge & Center, $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Alignment Number Cells Edting KM2 KL KM KN kO КР Ka KR KS KT KU KV KX KY kz 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 4 6 34500 2600 22200 [-KP6-KP8-KP10-KP11-KP12] 10 4800 12 13 14 15 16 17 18 19 20 4100 ASH BUDGET 45 BV MV ratio VARIANCE BEP, OL FL ratios B-S t loss SALES BUDGET DİFF ANALYSIS- overhead float | ORDER- erences: EV23 21-01-2019

Home nert Page Layout Formulas Data Review View dd-Ins Cut E AutoSum ー E " ゴWrap Text ta copy ▼ B l u. ,_a. ars-函Merge & Center, $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard KM26 KL Alignment Number Cells KM kO MARTA COMMUNICATIONS INC STATEMENT OF STOCKHOLDERS' EQUITY FOR THE MONTH ENDED MARCH 31, 20X1 KN KP KR KS KT KU KV KX KY kz LA 14 15 16 17 18 19 20 21 COMMON STOCK RETAINED EARNINGS BEGINNING BALANCE ISSUANCE OF COMMON STOCK ISSUANCE OF COMMON STOCK ADD: NET INCOME FOR MARCH LESS: DIVIDEND ENDING BALANCE 0 14000 14000 0 0 14000 14000 100 4100 -KP12] 500 500 23 24 25 26 14000 3600 17600 -KQ23+KU23] [-KU21+ KU22] 28 29 30 31 32 | .. CASH BUDGET 45 BV MV ratio VARIANCE BEP, OL FL ratios B-S t loss SALES BUDGET DİFF ANALYSIS- overhead float | ORDER- erences: EX23 21-01-2019

Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy E AutoSum ー E " ゴWrap Text B 1 u. ,_a. ars-函Merge & Center, $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard KM44 KL Alignment Number Cells KM KN kO KP KR KS KT KU KV KW KX KY kz LA 26 27 28 29 30 31 32 MARTA COMMUNICATIONS INC BALANCE SHEET AT MARCH 31, 20X1 ASSETS CASH ACCOUNTS RECEIVABLE SUPPLIES LAND 3400 6700 2300 12000 LIABILITIES ACCOUNTS PAYABLE STOCKHOLDERS' EQUITY COMMON STOCK RETAINED EARNINGS TOTAL LIABILITIES & STOCKHOLDERS' EQUITY 6800 14000 -KQ23] 3600 I KU23] 34 35 36 37 38 39 40 24400 -KV35] TOTAL ASSETS 24400 [-KV30+ KV32 KV33] ACCOUNTS RECEIVABLE = KQ35-KQ33-KQ32-KQ30 42 43 1 | .. CASH BUDGET bud 45 BV MV ratio VARIANCE BEP, OL FL ratios B-S t loss SALES BUDGET DİFF ANALYSIS- overhead float | ORDER- erences: EV23 21-01-2019