Please upload all Excel files created for this assignment. REQUIRED 1. Set up...
60.1K
Verified Solution
Question
Accounting
Please upload all Excel files created for this assignment. REQUIRED Set up the income statement, statement of retained earnings and balance sheet for Duck and Goose in work paper format for later consolidation. Make sure your statements BALANCE before you go any further! Prepare a chart to reconcile the change in the Investment in Goose from the date of purchase, January to December Make sure you have totals for yearend and so any manager reading the chart can easily see what is driving changes in the investment balance. Use a single underline before the yearend totals, but I recommend highlighting that row in a different color and not using a double underline below the numbers. Prepare all General Journal entries and consolidation entries in proper journal entry form, but separate according to type since the consolidation entries are NOT made in the books of either company just used to facilitate the consolidation on the worksheet. Transfer all consolidation entries into the working papers and consolidate. NOTE: Make sure your solution is professional in appearance and are properly formatted. Lead columns with dollar signs, then place another dollar sign after a summation. No other numbers within the column need dollar signs. Do not include decimal points everything is rounded to the thousands Once you have four digits you NEED a comma. In the financial statements use a single underline before a total and a double underline below all totals. Numbers in columns should be right aligned
Please upload all Excel files created for this assignment.
REQUIRED
Set up the income statement, statement of retained earnings and balance sheet for Duck and Goose in work paper format for later consolidation. Make sure your statements BALANCE before you go any further!
Prepare a chart to reconcile the change in the Investment in Goose from the date of purchase, January to December Make sure you have totals for yearend and so any manager reading the chart can easily see what is driving changes in the investment balance. Use a single underline before the yearend totals, but I recommend highlighting that row in a different color and not using a double underline below the numbers.
Prepare all General Journal entries and consolidation entries in proper journal entry form, but separate according to type since the consolidation entries are NOT made in the books of either company just used to facilitate the consolidation on the worksheet.
Transfer all consolidation entries into the working papers and consolidate.
NOTE: Make sure your solution is professional in appearance and are properly formatted.
Lead columns with dollar signs, then place another dollar sign after a summation. No other numbers within the column need dollar signs.
Do not include decimal points everything is rounded to the thousands
Once you have four digits you NEED a comma.
In the financial statements use a single underline before a total and a double underline below all totals.
Numbers in columns should be right aligned
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Best
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.