70.2K

Verified Solution

Link Copied!

pleae help solvng this in excel and explain each step thus indirect method cash flow

\begin{tabular}{|l|r|r|r|} \hline \multicolumn{3}{|c|}{ Balance Sheet } \\ \hline Assets & 2019 & 2018 & \\ \hline Cash & 13000 & 11000 & 2000 \\ \hline A/R & 4000 & 5000 & -1000 \\ \hline Inventory & 1000 & 2000 & -1000 \\ \hline Insurance in advance & 2000 & 3000 & -1000 \\ \hline long term investment in ABC Compnay & 17000 & 22000 & -5000 \\ \hline PP\&E & 22000 & 17000 & 5000 \\ \hline Accumulated Deprication & 5000 & 4000 & 1000 \\ \hline & 54000 & 56000 & \\ \hline Liabilties & & & \\ \hline A/P & 4000 & 7000 & -3000 \\ \hline Tax payable & 5000 & 1000 & 4000 \\ \hline bonds paybale & 5000 & 10000 & -5000 \\ \hline Total Liabilties & 14000 & 18000 & \\ \hline Owners' Equity & & & \\ \hline Ordinay Shares & 15000 & 15000 & \\ \hline Reserves & 8000 & 8000 & \\ \hline RE & 17000 & 15000 & 2000 \\ \hline Total Owners Equity & 40000 & 38000 & \\ \hline Total Liabilties \& Owners Equity & 54000 & 56000 & \\ \hline \end{tabular} \begin{tabular}{|l|r|l|} \hline \multicolumn{3}{|c|}{ Income statement } \\ \hline sales & 50000 & \\ \hline COGS & 20000 & \\ \hline Gross Profit & 30000 & \\ \hline Operating Expenses & 17000 & \\ \hline Operating Income & 13000 & \\ \hline Other Revenues & 2000 & \\ \hline other expenses & 1000 & \\ \hline Income befor Tax & 14000 & \\ \hline Tax & 7000 & \\ \hline Net Income & 7000 & \\ \hline \end{tabular} Extra Inforamtion 1- PPE of cost 5000 and Book value of 2000 was sold for 4000

Answer & Explanation Solved by verified expert

See Answer