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