Please upload all Excel files created for this question.

REQUIRED

$1.$ Set up the income statement, statement of retained earnings and balance sheet for Tater and

Tot 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 Tot 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.

$1.$ Lead columns with dollar signs, then place another dollar sign after a summation. No other numbers within the column need dollar signs.

$2.$ Do not include decimal points $($everything is rounded to the thousands$).$

$3.$ Once you have four digits you NEED a comma.

$4.$ In the financial statements use a single underline before a total and a double underline

below all totals.

$5.$ Numbers in columns should be right aligned.