Question

Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Div
Required information 2. Assume revenues increase 20% in both Years 1 and 4, what would the revised balances be? (Negative amo
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1) Solution:

Net income / loss

Retained Earnings

11,700

8,850

-3,300

-3,300

21,700

15,850

51,700

40,850

Working:

Revenue

Expenses

Dividends

Net income / loss

Retained Earnings

Year-1

18,400

6,700

2,850

11,700

8,850

Year-2

8,400

11,700

-3,300

-3,300

Year-3

48,400

26,700

5,850

21,700

15,850

Year-4

93,400

41,700

10,850

51,700

40,850

Formulas used:

Net income = Revenue - Expenses

Retained earnings = Net income - Dividends

2) Solution:

Net income / loss

Retained Earnings

15,380

12,530

-3,300

-3,300

21,700

15,850

70,380

59,530

 

Working:

Revenue

Expenses

Dividends

Net income / loss

Retained Earnings

Year-1

22,080

6,700

2,850

15,380

12,530

Year-2

8,400

11,700

-3,300

-3,300

Year-3

48,400

26,700

5,850

21,700

15,850

Year-4

112,080

41,700

10,850

70,380

59,530

 

Revenue Year-1: 18,400 + 20% * 18,400 = 22,080

Revenue Year-4: 93,400 + 20% * 93,400 = 112,080

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

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

  • 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

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

  • The year-end price and dividend information on a stock is given in the following table. Year...

    The year-end price and dividend information on a stock is given in the following table. Year 1 2 3 Price 24.60 23.60 22.50 Dividend MA 0.18 0.20 Note: NA denotes not applicable. a. What is the nominal return of the stock in years 2 and 3? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Nominal Return Year 2 % 3 b. What is the corresponding real return if the inflation rates for...

  • The year-end price and dividend information on a stock is given in the following table. Year...

    The year-end price and dividend information on a stock is given in the following table. Year Price 24.10 20.40 21.50 Dividend NA 0.11 0.19 2 3 Note: NA denotes not applicable. a. What is the nominal return of the stock in years 2 and 3? (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Year Nominal Return 2 % 3 % b. What is the corresponding real return if the inflation rates for...

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