Question

Must include the formula to the answer? x Relationships among Financial Statements - Excel PAGE LAYOUT FORMULAS DATA REVIEW - Sign In FILE HOME INSERT VIEW Calibri

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

MARTA COMMUNICATIONS, INC.
Balance Sheet
At March 31 , 20X1
Assets Liabilities
Cash $             3,400 Accounts payable $       6,800
Accounts receivable $             6,700 Stockholders` Equity
Supplies $             2,300 Common Stock $     14,000
Stores and property $           12,000 Retained Earnings $       3,600
Total Assets $           24,400 Total Liabilities & shareholders` equity $     24,400

Notes:

1) Retained Earnings as on At March 31 , 20X1 is provided in the question as $ 3,600

2) Through retained earnings, we find total liabilities.

3) In Balance Sheet, Total Assets must be equal to Total Liabilities.

4) So, Total Assets are $ 24,400

5) Accounts Receivables = Total Assets - Cash - Supplies - Stores and property

= $ 24,400 - 3,400- $2,300- $ 12,000 = $ 6,700

Add a comment
Know the answer?
Add Answer to:
Must include the formula to the answer ? x Relationships among Financial Statements - Excel PAGE...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • hent 0 Saved S.S. N:- Relationships among Financial Statements - Excel ? - 6 X FILE...

    hent 0 Saved S.S. N:- Relationships among Financial Statements - Excel ? - 6 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In anction Defined brary Names Formula Auditing Calculate Now Calculation on La Calculate Sheet + Options Calculation A1 Presented below are incomplete financial statements for Marta Communications, as MARTA COMMUNICATIONS, INC. Statement of Stockholders' Equity For the Month Ended March 31, 20X1 Common Stock Retained Earnings $0 $14,000 Total SO SO 13 Beginning Balance (March...

  • solve for the missing amounts ( no need to make a excel sheet just state the...

    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...

  • A1 ✓ Presented below are incomplete financial statements for Marta Communications, А B D с 1...

    A1 ✓ Presented below are incomplete financial statements for Marta Communications, А B D с 1 Presented below are incomplete financial statements for Marta Communications, Inc. Do N- 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. 7 MARTA COMMUNICATIONS, INC. 9 Income...

  • Need help ASAP!! Include steps for the blanks! REQUIRED: Home B A 7 с 4 Solve...

    Need help ASAP!! Include steps for the blanks! REQUIRED: Home B A 7 с 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 7 10.5 points Skipped eBook References 8 MARTA COMMUNICATIONS, INC. 9 Income Statement 10 For the Month Ended March 31, 20X1 $34,500...

  • Required: Solve for the missing amounts. NOTE: When an amount on one financial statement is again...

    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...

  • Solve for the missing amounts: Solve for amounts in boxes highlighted. 1 Presented below are incomplete...

    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...

    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....

  • XS FILE HOME Relationships among Financial Statements - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT...

    XS FILE HOME Relationships among Financial Statements - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In fc Calculate Now Calculation RC Function Defined Formula Library Names' Auditing Calculation Presented below are incomplete financial statements for Marta Communications, B 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 5 another statement, you MUST reference the cell from...

  • Marta Communications, Inc. has provided incomplete financial statements for the month ended March 31. The Controller...

    Marta Communications, Inc. has provided incomplete financial statements for the month ended March 31. The Controller has asked you to help calculate the missing amounts in the incomplete financial statements. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B11” was entered, the formula would output the...

  • Required: ae NOTE WRic OR GRO another statement, you MUST reference the cell from the earlier...

    Required: ae NOTE WRic OR GRO another statement, you MUST reference the cell from the earlier stat indicating the relationship between the two statements. rather than calculate the amount, thus MARTA COMMUNICATIONS Income Statement For the Month Ended March 31, 20X1 Sales Revenues $34,500 Expenses Rent Expense Wages Expense Utilities Expense Advertising Expense 4,800 800 S4,100 Net income MARTA COMMUNICATIONS Statement of Owner's Equity For the Month Ended March 31, 20X1 Marta, Capital, March 1,20X1 S0 Add: Net income Subtract:...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT