Question: please use the spread sheet to complete parts a,b,&c and explain begin{tabular}{|c|c|c|} hline Income Statement & 2019 & 2020 hline Sales & $150,000.00 &

please use the spread sheet to complete parts a,b,&c and explain
 please use the spread sheet to complete parts a,b,&c and explain
\begin{tabular}{|c|c|c|} \hline Income Statement & 2019 & 2020 \\ \hline Sales &

\begin{tabular}{|c|c|c|} \hline Income Statement & 2019 & 2020 \\ \hline Sales & $150,000.00 & $175,000.00 \\ \hline Cost of Goods & $35,000.00 & $38,500.00 \\ \hline Gross Profit & $115,000.00 & $136,500,00 \\ \hline SEA & $15,000.00 & $16,500.00 \\ \hline Depreciation & $20,000.00 & $20,000,00 \\ \hline & $80,000.00 & $100,000.00 \\ \hline Interest & $5,450.00 & $3,437.18 \\ \hline & $74,550.00 & $96,56282 \\ \hline Taves & $29,820.00 & $38.625.13 \\ \hline Net Income & $44,73000 & $57937.69 \\ \hline Dividends & $13,41900 & $17381,31 \\ \hline Addition to Retained Eamings & $31,311,00 & $40,556.38 \\ \hline Balance Sheet & 2019 & 2020 \\ \hline \multicolumn{3}{|l|}{ Assets } \\ \hline Cash and Cash Equivalents & $3,00000 & $3,300.00 \\ \hline Acc Receivable & $20,00000 & $22,00000 \\ \hline Inventory & $10,000.00 & $11,000,00 \\ \hline Short Term investments & $000 & $2,000.00 \\ \hline Current Assets & $33,000,00 & $38,300.00 \\ \hline GrossPPE & $600,00000 & $530,000.00 \\ \hline Accumulated Depreciation & $100,000,00 & $120,000.00 \\ \hline NotPPE & $400,000,00 & $410,000.00 \\ \hline Total Assets & $433,00000 & $448300.00 \\ \hline \multicolumn{3}{|l|}{ Liabilities and Equily } \\ \hline Accounts Payabie & $20,000,00 & $20000.00 \\ \hline Accruals & $3,000.00 & $3,000.00 \\ \hline Notes Payabies & $15,000.00 & $15,000.00 \\ \hline Current Liabilities & $38,000,00 & $40,000,00 \\ \hline Long Term Debt & $100,000,00 & $89,743,62 \\ \hline Total Liabilities & $138,000.00 & $99,743.62 \\ \hline Retained Eamings & $98,000.00 & $138,56638 \\ \hline Preferred Stock & $10,000,00 & $10,000.00 \\ \hline Common Stook & $200,000,00 & $200,000.00 \\ \hline Total Equity & $308,000,00 & $348,56638 \\ \hline Total Liabilities and Equity & $433,000,00 & $448,300,00 \\ \hline \end{tabular} a. Compute the 2020 NOPAT. NOPAT=EBRT(1T) b. Compute the 2020 NIOC NIOC=TNOC(P)TNOC c. Compute the 2020 FCFs FCFS = NOPAT - NIOC \begin{tabular}{|c|c|c|} \hline Income Statement & 2019 & 2020 \\ \hline Sales & $150,000.00 & $175,000.00 \\ \hline Cost of Goods & $35,000.00 & $38,500.00 \\ \hline Gross Profit & $115,000.00 & $136,500,00 \\ \hline SEA & $15,000.00 & $16,500.00 \\ \hline Depreciation & $20,000.00 & $20,000,00 \\ \hline & $80,000.00 & $100,000.00 \\ \hline Interest & $5,450.00 & $3,437.18 \\ \hline & $74,550.00 & $96,56282 \\ \hline Taves & $29,820.00 & $38.625.13 \\ \hline Net Income & $44,73000 & $57937.69 \\ \hline Dividends & $13,41900 & $17381,31 \\ \hline Addition to Retained Eamings & $31,311,00 & $40,556.38 \\ \hline Balance Sheet & 2019 & 2020 \\ \hline \multicolumn{3}{|l|}{ Assets } \\ \hline Cash and Cash Equivalents & $3,00000 & $3,300.00 \\ \hline Acc Receivable & $20,00000 & $22,00000 \\ \hline Inventory & $10,000.00 & $11,000,00 \\ \hline Short Term investments & $000 & $2,000.00 \\ \hline Current Assets & $33,000,00 & $38,300.00 \\ \hline GrossPPE & $600,00000 & $530,000.00 \\ \hline Accumulated Depreciation & $100,000,00 & $120,000.00 \\ \hline NotPPE & $400,000,00 & $410,000.00 \\ \hline Total Assets & $433,00000 & $448300.00 \\ \hline \multicolumn{3}{|l|}{ Liabilities and Equily } \\ \hline Accounts Payabie & $20,000,00 & $20000.00 \\ \hline Accruals & $3,000.00 & $3,000.00 \\ \hline Notes Payabies & $15,000.00 & $15,000.00 \\ \hline Current Liabilities & $38,000,00 & $40,000,00 \\ \hline Long Term Debt & $100,000,00 & $89,743,62 \\ \hline Total Liabilities & $138,000.00 & $99,743.62 \\ \hline Retained Eamings & $98,000.00 & $138,56638 \\ \hline Preferred Stock & $10,000,00 & $10,000.00 \\ \hline Common Stook & $200,000,00 & $200,000.00 \\ \hline Total Equity & $308,000,00 & $348,56638 \\ \hline Total Liabilities and Equity & $433,000,00 & $448,300,00 \\ \hline \end{tabular} a. Compute the 2020 NOPAT. NOPAT=EBRT(1T) b. Compute the 2020 NIOC NIOC=TNOC(P)TNOC c. Compute the 2020 FCFs FCFS = NOPAT - NIOC

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!