Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please take a look at this Using your spreadsheet from Part 1, assume the following information and change your spreadsheet setup /formulas as needed to

please take a look at this

image text in transcribedimage text in transcribedimage text in transcribed

Using your spreadsheet from Part 1, assume the following information and change your spreadsheet setup /formulas as needed to solve for the missing values. (Remember, only use cell referencing and formulas). Relationship #1 Revenues ? Expenses 33,500 Net Income 83,500 Relationship #2 Beginning Retained Earnings Net Income Dividends Ending Retained Earnings Relationship #3 Assets Liabilities Common Stock Retained Earnings 234,000 ? 40,500 ? 18,500 132,500 Required: 1. Complete the table below based on your results: Revenues Beginning Retained Earnings Net Income (Relationship #2) Liabilities Retained Earnings (Relationship #3) 2. Which formula would be incorrect in arriving at Retained Earnings in Relationship #3? =G18 =J15-J16-17 O=G15+G16-G17 =G18-G15+G17 3. Assume the Net Income was actually a Net Loss of $18,500, Expense were $66,800, Beginning Retained Earnings was $87,000, and Ending Retained Earnings was unknown. Which of the following amounts will change? Ending Retained Earnings only Revenues and Common Stock Ending Retained Earnings and Common Stock Ending Retained Earnings and Revenue 4. What is the revised ending balance in Retained Earnings? $50,000 $58,300 $68,300 $57,300

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

University Auditing In The Digital Era Challenges And Lessons For Higher Education Professionals And CAEs

Authors: Sezer Bozkus Kahyaoglu; Erman Coskun

1st Edition

0367553228, 9780367553227

More Books

Students also viewed these Accounting questions