Please upload all Excel files created for this assignment.

REQUIRED

$1.$ 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!

$2.$ Prepare a chart to reconcile the change in the Investment in Goose from the date of purchase, January $1,2022,$ to December $31,2023.$ Make sure you have totals for year$-$end $2022$ and $2023$ so any manager reading the chart can easily see what is driving changes in the investment balance. Use a single underline before the year$-$end totals, but I recommend highlighting that row in a different color and not using a double underline below the numbers.

$3.$ Prepare all $2023$ 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.

$4.$ 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