Question

Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Div
2. Assume revenues increase 20% in both Years 1 and 4, what would the revised balances be? (Negative amount should be indicat
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Revenue Expenses RE opening net income Dividends RE closing
Year 1 20880 6,200 0 14,680 2,600 12,080
year 2 7400 11,200 12,080 -3,800 0 8,280
year 3 47,400 26,200 8280 21,200 5,600 23,880
year 4 110880 41,200 23880 69,680 10,600 82,960
Revenue - expense = net income
Retained earnings = opening RE+ net income -divided
Net income RE
year 1 14,680 12,080
year2 -3,800 8,280
year 3 21,200 23,880
year 4 69,680 82,960
Add a comment
Know the answer?
Add Answer to:
Revise the given year end information in your spreadsheet with the following values, and then answer...
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
  • Dividends $ 2.600 Year 1 Year 2 Year 3 Year 4 Revenue $17,400 7,400 47, 400...

    Dividends $ 2.600 Year 1 Year 2 Year 3 Year 4 Revenue $17,400 7,400 47, 400 92,400 Expenses $ 6,200 11,200 26,200 41,200 5,600 10,600 Required: 1. Complete the table below based on your spreadsheet results: (Negative amount should be indicated by a minus sign.) Year Net Income Retained Earnings

  • Dividends $ 2.600 Year 1 Year 2 Year 3 Year 4 Revenue $17,400 7,400 47, 400...

    Dividends $ 2.600 Year 1 Year 2 Year 3 Year 4 Revenue $17,400 7,400 47, 400 92,400 Expenses $ 6,200 11,200 26,200 41,200 5,600 10,600 Required: 1. Complete the table below based on your spreadsheet results: (Negative amount should be indicated by a minus sign.) Year Net Income Retained Earnings

  • Revise the given year end information in your spreadsheet with the following values, and then answer...

    Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Dividends $ 2,850 Year 1 Year 2 Year 3 Year 4 Revenue $18,400 8 .400 48,400 93,400 Expenses $ 6,700 11,700 26,700 41,700 5,850 10,850 Required: 1. Complete the table below based on your spreadsheet results: (Negative amount should be indicated by a minus sign.) Year Net Income Retained Earnings < Prey 18 of 18 !!! Next > Required information 2....

  • Revise the given year end information in your spreadsheet with the following values, and then answer...

    Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Dividends $ 2,400 Year 1 Year 2 Year 3 Year 4 Revenue $ 16,600 6 ,600 46,600 91,600 Expenses $ 5,800 10,800 25, 800 40,800 5,400 10,400 Required: 1. Complete the table below based on your spreadsheet results: (Negative amount should be indicated by a minus sign.) Year Net Income Retained Earnings 2. Assume revenues increase 20% in both Years 1...

  • Revise the given year end information in your spreadsheet with the following values, and then answer...

    Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Dividends $ 2,700 Year 1 Year 2 Year 3 Year 4 Revenue $17,800 7,800 47,800 92,800 Expenses $ 6,480 11,400 26,400 41,400 5,700 10,700 Required: 1. Complete the table below based on your spreadsheet results: (Negative amount should be indicated by a minus sign.) Year Net Income Retained Earnings 1 2 4 2. Assume revenues increase 20% in both Years 1...

  • Revise the data in your spreadsheet based on the following assumptions, and then answer the questions...

    Revise the data in your spreadsheet based on the following assumptions, and then answer the questions that follow: Expenses: Advertising Expense $ 14,000 Assets: Cash $ 26,000 Insurance expense 20,000 Accounts receivable 24,000 Salaries expense 49,000 Supplies 15,000 Rent expense 10,000 Land 55,000 Liabilities: Salaries payable 12,000 Revenues: Service revenue 94,000 Notes payable 36,000 Interest revenue 9,000 Dividends: Dividends 9,000 Equity: Common stock 44,000 Retained earnings 27,000 Required: 1. What is the Net Income/(Loss)? $27,000 $10,000 $13,000 $20,500 Assume the...

  • Seminoles Corporation's fiscal year-end is December 31, 2018. The following is a partial adjusted trial balance...

    Seminoles Corporation's fiscal year-end is December 31, 2018. The following is a partial adjusted trial balance as of December 31 Accounts Debit Credit $26,000 Retained Earnings Dividends Service Revenue Interest Revenue Salaries Expense Rent Expense Advertising Expense Depreciation Expense Interest Expense 2,600 46,000 5,600 14,600 5,600 2,600 10,600 4,600 Required 1. Prepare the necessary closing entries. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Answer is not complete Date General...

  • Revise your Statement of Cash Flows based on the new information provided below and then answer...

    Revise your Statement of Cash Flows based on the new information provided below and then answer the questions that follow. Beginning cash balance $ 22,000 Issuance of Common Stock for cash $ 17,200 Collections from customers 176,400 Payment of office rent 33,600 Sale of building for cash 72,000 Payment of dividends 12,200 Bank borrowing 67,500 Payment of salaries 56,400 Sales to customers on account 203,700 Payment of advertising expense 21,000 Purchase of materials on account 129,200 Purchase of equipment for...

  • The following information is available for Amos Company for the year ended December 31, 2017. a....

    The following information is available for Amos Company for the year ended December 31, 2017. a. Balance of retained earnings, December 31, 2016, prior to discovery of error, $867,000. b. Cash dividends declared and paid during 2017, $17,000. c. It neglected to record 2015 depreciation expense of $43,600, which is net of $5,600 in tax benefits. d. The company earned $217,000 in 2017 net income. Prepare a 2017 statement of retained earnings for Amos Company. (Amounts to be deducted should...

  • Can someone please show me the proper way to set up this spreadsheet Given the following information, prepare an income...

    Can someone please show me the proper way to set up this spreadsheet Given the following information, prepare an income statement and statement of retained earnings to solve the unknown (a, b, c) Paid-in-Capital, beginning of period $1,700 Paid-in Capital, end of period c Ratained earnings, beginning of period b Retained earnings, end of period $2,300 Revenues $2,800 Cost and expenses a Net Income $1,300 Dividends $400 Additional Investments by stockholders $100

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