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

70.2K

Verified Solution

Question

Accounting

pleae help solvng this in excel and explain each step thus indirect method cash flow
image
image
\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
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students