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 -


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
Get step-by-step solutions from verified subject matter experts
