Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please fill in yellow table, but also show excel calculations; this is crucial to my understanding. TIA! Just Dew It Corporation reports the following balance
Please fill in yellow table, but also show excel calculations; this is crucial to my understanding. TIA!
Just Dew It Corporation reports the following balance sheet information for 2020 and 2021 . Use this information to prepare the 2020 and 2 2021 cammon-size balance sheets. 3 \begin{tabular}{|l|l|l|} \hline input area: & \\ \hline \end{tabular} 4 5 6 \begin{tabular}{|c|c|c|} \hline & 2020 & 2021 \\ \hline \multicolumn{3}{|l|}{ Current Assets } \\ \hline Cash & $14,588 & $17,631 \\ \hline Accounts receivable & 35,258 & 41,019 \\ \hline Inventory & 65,567 & 71,505 \\ \hline Total & $115,413 & $130,155 \\ \hline \end{tabular} 12 13 14 15 16 Net plant and equipment \begin{tabular}{r} $477,413 \\ \hline \end{tabular} 17 \begin{tabular}{|c|c|c|} \hline & & Long-term debt \\ \hline & & Owners' equity \\ \hline & & \begin{tabular}{c} Comman stock and \\ paid-in surplus \end{tabular} \\ \hline & & Retained earnings \\ \hline$477,413 & $498,421 & Total \\ \hline 5592826 & $628,576 & \begin{tabular}{c} Total liabilities and \\ owners' equity \end{tabular} \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline 2020 & 2021 \\ \hline$55,653 & $63,073 \\ \hline 21,895 & 25,324 \\ \hline$77,548 & $88,397 \\ \hline$58,000 & $62,000 \\ \hline$60,000 & $60,000 \\ \hline 397,278 & 418,179 \\ \hline$457,278 & $478,179 \\ \hline$592.826 & $628,576 \\ \hline \end{tabular} 18 19 (Use cells A6 to F17 from the given information to complete this question.) 20 21 Output area: 22 23 24 25 Current assets 26 Cash 27 Accounts receivable 28 Inventary 29 Total 30 31 32 Current liabilities Accounts payable Notes payable Total Long-term debt Owners' equity Comman stock and paid-in surplus 33 34 Net plant and equipment Retained earnings Total. 35 Total liabilities and owners' equityStep 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