(a) Develop proforma Project Income Statement Using Excel Spreadsheet

(b) Compute Net Project Cash flows, NPV, IRR and PayBack Period

(c) Develop Problem-Solving and Critical Thinking Skills

pls post with excel formulas so I can cross reference

Excel Flle Edit Vlew Insert Format Tools Data Window Help Home Insert Draw Page Layout Formulas Data Review View \& Tell me AB %& fack Develop Problem-Solving and Critical Thinking Skills INSTRUCTOR: 1. Learning Objectives (a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period Skills 1) Llfe Perlod of the Equipment =4 years 2) New equipment cost 8) Sales for first year (1) G 1 k L M N 0 P 0 R 3) Equipment ship \& install cost 4) Related start up cost 5) Inventory increase 6) Accounts Payable increase 7) Equip. Salvage Value Estimated End of Year 4 (fully depreciated) ESTIMATING Initlal Outlay (Cash Flow, CFo,T=0) YEAR Investments: 1) Equipment cost 2) Shipping and Install cost 3) Start up expenses Total Basis Cost (1+2+3) 4) Net Working Capital Inventory Inc.- Acct. Payable Inc. \begin{tabular}{|c|c|c|c|c|} \hline CF0 & CF1 & CF2 & CF3 & CF4 \\ 0 & 1 & 2 & 3 & 4 \\ \hline \end{tabular} Total Initial Outlay Excel Flle Edit Vlew Insert Format Tools Data Window Help Home Insert Draw Page Layout Formulas Data Review View \& Tell me AB %& fack Develop Problem-Solving and Critical Thinking Skills INSTRUCTOR: 1. Learning Objectives (a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows, NPV, IRR and PayBack Period Skills 1) Llfe Perlod of the Equipment =4 years 2) New equipment cost 8) Sales for first year (1) G 1 k L M N 0 P 0 R 3) Equipment ship \& install cost 4) Related start up cost 5) Inventory increase 6) Accounts Payable increase 7) Equip. Salvage Value Estimated End of Year 4 (fully depreciated) ESTIMATING Initlal Outlay (Cash Flow, CFo,T=0) YEAR Investments: 1) Equipment cost 2) Shipping and Install cost 3) Start up expenses Total Basis Cost (1+2+3) 4) Net Working Capital Inventory Inc.- Acct. Payable Inc. \begin{tabular}{|c|c|c|c|c|} \hline CF0 & CF1 & CF2 & CF3 & CF4 \\ 0 & 1 & 2 & 3 & 4 \\ \hline \end{tabular} Total Initial Outlay