Question: Please use excel to solve and show excel functions used Free Cash Flow (FCF) Profit After tax Add back depreciation begin{tabular}{|l|r|r|} hline Balance sheet -

Please use excel to solve and show excel functions used  Please use excel to solve and show excel functions used Free
Cash Flow (FCF) Profit After tax Add back depreciation \begin{tabular}{|l|r|r|} \hline Balance
sheet - Assets & 1/1/02 & 12/31/02 \\ \hline Current assets &

Free Cash Flow (FCF) Profit After tax Add back depreciation \begin{tabular}{|l|r|r|} \hline Balance sheet - Assets & 1/1/02 & 12/31/02 \\ \hline Current assets & & \\ \hline Cash & 1,000,000 & 229,376 \\ \hline Treasury securities & 0 & 120,000 \\ \hline Prepaid expenses & 0 & 290,500 \\ \hline Payments receivable & 0 & 55,000 \\ \hline Inventory & 0 & 25,000 \\ \hline Total current assets & 1,000,000 & 719,876 \\ \hline Fixed assets & & \\ \hline At cost & & 1,230,000 \\ \hline Accumulate depreciation & 0 & 100,000 \\ \hline Net_Fixed_assets & 0 & 1,00 \\ \hline \end{tabular} \begin{tabular}{|l|r|r|} \hline Current liabilities & 0 & 30,000 \\ \hline Accounts payable & 0 & 12,200 \\ \hline Notes payable & 0 & 42,200 \\ \hline Total current liabilities & & \\ \hline & & 373,333 \\ \hline Long-term liabilities & 0 & 300,000 \\ \hline Mortgage & 0 & \\ \hline Operating machine loan & & 1,120,500 \\ \hline Equity & 1,000,000 & 13,843 \\ \hline Equity & 0 & \\ \hline Accumulated retained earnings & & 1,849,876 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!