Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 &

pleae help solvng this in excel and explain each step thus indirect method cash flow
image text in transcribed
image text in transcribed
\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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting For Management

Authors: Paresh Shah

2nd Edition

0198077033, 978-0198077039

More Books

Students also viewed these Accounting questions