Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Enter formulas in cells that contain question marks (only use formulas). After entering formulas in all of the cells that contain question marks, verify that
Enter formulas in cells that contain question marks (only use formulas). After entering formulas in all of the cells that contain question marks, verify that the amounts match the example below. Relationship #1 Relationship #2 Relationship #3 Revenues $35,000 Beginning Retained Earnings $42,000 Assets $100,000 Expenses 25,000 Net Income 10,000 Liabilities 22,000 Net Income 10,000 Dividends 6,000 Common Stock 32,000 Ending Retained Earnings 46,000 Retained Earnings 46,000 Check your worksheet setup and formulas by changind Revenues to $50,000 and Expenses to $35,000. You should now have net income of $15,000, Assets of $105,000, and a balance in Retained Earnings of $51,000. G H E F K B D View the tutorial, then complete the worksheet, replacing the question marks below with formulas. Glven Information: Revenues $35,000 Expenses 25,000 Beginning Retained Earning 42,000 Dividends 6,000 Liabilities 22,000 Common Stock 32,000 3 5 6 7 18 19 Relationship #1 Revenues $ Expenses Net Income Relationship #2 3 Beginning Retained Earnings $ Net Income Dividends Ending Retained Earnings ? ? ? Relationship #3 Assets $ Liabilities Common Stock Retained Earnings 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 Relationship #2 Relationship #3 Revenues Beginning Retained Earnings ? Assets 236,000 Expenses 34,000 Net Income Liabilities Net Income 84,000 Dividends 19,000 Common Stock 41,000 Ending Retained Earnings 133,000 Retained Earnings 2 ? Required: 1. Complete the table below based on your results: Revenues Beginning Retained Ewings Net Income (Relationship 112) Liabilities Retained Earnings (Relationship 113) 2. Which formula would be incorrect in arriving at Retained Earnings in Relationship #3? O-G18 O=J15-J16-J17 O-G15 G16-G17 O-G18-G15 G17 3. Assume the Net Income was actually a Net Loss of $19,000, Expense were $67,200, Beginning Retained Earnings was $88,000, and Ending Retained Earnings was unknown. Which of the following amounts will change? O Ending Retained Earnings only O 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? O $50,000 O $58,200 O $68.200 O $57,200
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started