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

Question

Question

Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Div

business accounting

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

	Revenue	Expenses	Dividends
Year 1	16600	5800	2400
2	6600	10800	0
3	46600	25800	5400
4	91600	40800	10400

Net Income = Revenue - Expenses
Addition to Retained earnings = Net Income - Dividends paid

Year	Net Income	Addition to Retained earnings	Ending balance of retained earnings
1	10800	8400	8400
2	-4200	-4200	4200
3	20800	15400	19600
4	50800	40400	60000

2.
	Revenue	Expenses	Dividends
Year 1	19920	5800	2400
2	6600	10800	0
3	46600	25800	5400
4	109920	40800	10400




Year	Net Income	Addition to Retained earnings	Ending balance of retained earnings
1	14120	11720	11720
2	-4200	-4200	7520
3	20800	15400	22920
4	69120	58720	81640

Add a comment

Answer 2

Similar Homework Help Questions

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 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,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 2. Assume revenues increase 20% in both Years 1 and 4, what would the revised balances be? (Negative amount should be indicated by a minus sign.) Year Net Income Retained Earnings

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...
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 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 from Amos Company for the year ended December 31, 2019. Retained earnings...

The following information is from Amos Company for the year ended December 31, 2019. Retained earnings at December 31, 2018 (before the discovery of error), $854,000. Cash dividends declared and paid during the year, $12,000. Two years ago, it forgot to record the depreciation expense of $46,600 (net of tax benefit). The company earned $223,000 in net income this year. Prepare a statement of retained earnings for Amos Company. (Amounts to be deducted should be indicated with a minus sign.)
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, $25,00o. c. It neglected to record 2015 depreciation expense of $46,600, which is net of $5,500 in tax benefits. d. The company earned $212,000 in 2017 net income Prepare a 2017 statement of retained earnings for Amos Company. (Amounts to be deducted should...

Financial Statements from the End-of-Period Spreadsheet Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a...

Financial Statements from the End-of-Period Spreadsheet Financial Statements from the End-of-Period Spreadsheet Triton Consulting is a consulting firm owned and operated by Jayson Neese. The following end-of-period spreadsheet was prepared for the year ended April 30, 2013: During the year ended April 30, 20Y3, common stock of $5,000 was issued. Triton Consulting End-of-Period Spreadsheet For the Year Ended April 30, 20Y3 Unadjusted Trial Balance Dr. Cr. Adjustments Dr. Cr. Adjusted Trial Balance Dr. Cr. Account Title Cash 21,500 51,150 2,400...

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

Homework Answers