Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please notice that the questions start at #3! begin{tabular}{cc|l|l|} hline 3 & 0 & What is the value in cell F51 hline 4 &
Please notice that the questions start at \#3! \begin{tabular}{cc|l|l|} \hline 3 & 0 & What is the value in cell F51 \\ \hline 4 & 74,000 & What is the value in cell M29 \\ \hline 5 & 0 & What is the value in cell K30 \\ \hline 6 & 74,000 & What is the value in cell M31 \\ \hline 7 & 0 & What is the value in cell M35 \\ \hline 8 & 0 & What is the value in cell M42 \\ \hline 9 & 0 & What is the value in cell K51 \\ \hline 10 & 254,000 & What is the value in cell L51 \\ \hline 11 & 220,000 & What is the value in cell M51 \\ \hline 12 & 0 & What is the value in cell P34 \\ \hline 13 & 20,000 & What is the value in cell Q34 \\ \hline 14 & 316,000 & What is the value in cell T36 \\ \hline 15 & 0 & What is the value in cell T50 \\ \hline 16 & What is the value in cell T51 \\ \hline 17 & & \\ \hline \end{tabular} January 1, 2022 \begin{tabular}{|l|r|r|l|r|r|} \hline & \multicolumn{1}{l|}{ Big } & Little & dr & cr & Consol. \\ \hline Cash & 30000 & 20000 & & & 50000 \\ \hline Receivables & 35000 & 30000 & & & 65000 \\ \hline Inventory & 45000 & 50000 & & & 95000 \\ \hline Investment in Little & 200000 & 0 & & 200000 & 0 \\ \hline PPE, net & 260000 & 250000 & & & 510000 \\ \hline Patents & 30000 & 20000 & & & 50000 \\ \hline Other assets & 10000 & 80000 & & & 40000 \\ \hline & & & & & \\ \hline Accounts payable & 60000 & 50000 & & & 110000 \\ \hline Bonds payable & 200000 & 150000 & & & 350000 \\ \hline Common Stock & 150000 & 50000 & 50000 & & 150000 \\ \hline Retained earnings & 200000 & 200000 & 200000 & & 200000 \\ \hline NCInterest & & & & & \\ \hline & & & & & \\ \hline \end{tabular} December 31, 2022 \begin{tabular}{|l|r|r|r|r|r|} \hline & \multicolumn{1}{|l|}{ Big } & Little & & & Consol. \\ \hline Sales & 300000 & 250000 & & & \\ \hline Expenses & 250000 & 220000 & & & \\ \hline Investment income & 24000 & & 24000 & & 0 \\ \hline Net income & 74000 & 30000 & 30000 & & 74000 \\ \hline Income to NC Interest & & & & & \\ \hline Income to controlling interest & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline Beginning R/E & 200000 & 200000 & 200000 & & 200000 \\ \hline Add: Income & 74000 & 30000 & 30000 & & 74000 \\ \hline Less: Dividends & 20000 & 10000 & & 10000 & \\ \hline Ending R/E & 254000 & 220000 & 220000 & & 254000 \\ \hline & & & & & \\ \hline Cash & 35000 & 22000 & & & \\ \hline Receivables & 36000 & 27000 & & & \\ \hline Inventory & 40000 & 42000 & & & \\ \hline Investment in Little & 216000 & & & 216000 & \\ \hline PPE, net & 250000 & 240000 & & & \\ \hline Patents & 25000 & 15000 & & & \\ \hline Other assets & 62000 & 124000 & & & \\ \hline & & & & & \\ \hline Accounts payable & 60000 & 50000 & & & \\ \hline Bonds payable & 200000 & 150000 & & & \\ \hline Common Stock & 150000 & 50000 & 50000 & & \\ \hline Retained earnings & 254000 & 220000 & 220000 & & \\ \hline NC Interest & & & & & \\ \hline & & & & & \\ \hline \end{tabular} December 31, 2023 Please notice that the questions start at \#3! \begin{tabular}{cc|l|l|} \hline 3 & 0 & What is the value in cell F51 \\ \hline 4 & 74,000 & What is the value in cell M29 \\ \hline 5 & 0 & What is the value in cell K30 \\ \hline 6 & 74,000 & What is the value in cell M31 \\ \hline 7 & 0 & What is the value in cell M35 \\ \hline 8 & 0 & What is the value in cell M42 \\ \hline 9 & 0 & What is the value in cell K51 \\ \hline 10 & 254,000 & What is the value in cell L51 \\ \hline 11 & 220,000 & What is the value in cell M51 \\ \hline 12 & 0 & What is the value in cell P34 \\ \hline 13 & 20,000 & What is the value in cell Q34 \\ \hline 14 & 316,000 & What is the value in cell T36 \\ \hline 15 & 0 & What is the value in cell T50 \\ \hline 16 & What is the value in cell T51 \\ \hline 17 & & \\ \hline \end{tabular} January 1, 2022 \begin{tabular}{|l|r|r|l|r|r|} \hline & \multicolumn{1}{l|}{ Big } & Little & dr & cr & Consol. \\ \hline Cash & 30000 & 20000 & & & 50000 \\ \hline Receivables & 35000 & 30000 & & & 65000 \\ \hline Inventory & 45000 & 50000 & & & 95000 \\ \hline Investment in Little & 200000 & 0 & & 200000 & 0 \\ \hline PPE, net & 260000 & 250000 & & & 510000 \\ \hline Patents & 30000 & 20000 & & & 50000 \\ \hline Other assets & 10000 & 80000 & & & 40000 \\ \hline & & & & & \\ \hline Accounts payable & 60000 & 50000 & & & 110000 \\ \hline Bonds payable & 200000 & 150000 & & & 350000 \\ \hline Common Stock & 150000 & 50000 & 50000 & & 150000 \\ \hline Retained earnings & 200000 & 200000 & 200000 & & 200000 \\ \hline NCInterest & & & & & \\ \hline & & & & & \\ \hline \end{tabular} December 31, 2022 \begin{tabular}{|l|r|r|r|r|r|} \hline & \multicolumn{1}{|l|}{ Big } & Little & & & Consol. \\ \hline Sales & 300000 & 250000 & & & \\ \hline Expenses & 250000 & 220000 & & & \\ \hline Investment income & 24000 & & 24000 & & 0 \\ \hline Net income & 74000 & 30000 & 30000 & & 74000 \\ \hline Income to NC Interest & & & & & \\ \hline Income to controlling interest & & & & & \\ \hline & & & & & \\ \hline & & & & & \\ \hline Beginning R/E & 200000 & 200000 & 200000 & & 200000 \\ \hline Add: Income & 74000 & 30000 & 30000 & & 74000 \\ \hline Less: Dividends & 20000 & 10000 & & 10000 & \\ \hline Ending R/E & 254000 & 220000 & 220000 & & 254000 \\ \hline & & & & & \\ \hline Cash & 35000 & 22000 & & & \\ \hline Receivables & 36000 & 27000 & & & \\ \hline Inventory & 40000 & 42000 & & & \\ \hline Investment in Little & 216000 & & & 216000 & \\ \hline PPE, net & 250000 & 240000 & & & \\ \hline Patents & 25000 & 15000 & & & \\ \hline Other assets & 62000 & 124000 & & & \\ \hline & & & & & \\ \hline Accounts payable & 60000 & 50000 & & & \\ \hline Bonds payable & 200000 & 150000 & & & \\ \hline Common Stock & 150000 & 50000 & 50000 & & \\ \hline Retained earnings & 254000 & 220000 & 220000 & & \\ \hline NC Interest & & & & & \\ \hline & & & & & \\ \hline \end{tabular} December 31, 2023
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