Economics Homework Help
Oakton Community College Sneaker Cash Flow Statement Spreadsheet
Produce a detailed free cash flow statement for the Sneaker 13 project and calculate the NPV, IRR, and Payback period for the project. Use this excel table for your calculations and make any necessary adjustments.
|
Template for Project Analysis Year 0 1 2 3 4 5 6 7 |
||||||||
|
Total sales |
||||||||
|
Reduction in sales due to Cannibalization |
||||||||
|
Cost of sales |
||||||||
|
Reduction in cost of sales due to Cannibalization |
||||||||
|
SG&A expenses |
||||||||
|
Advertising & promotion expenses |
||||||||
|
R&D Expenses |
||||||||
|
Opportunity costs |
||||||||
|
Depreciation |
||||||||
|
EBIT |
||||||||
|
Taxes |
||||||||
|
NOPAT |
||||||||
|
Depreciation |
||||||||
|
Capital expenditures |
||||||||
|
ΔNWC |
||||||||
|
Adjustments for Salvage/Liquidation values |
||||||||
|
Adjustments for Disposal Costs |
||||||||
|
Free Cash Flow |
||||||||
Talk to us support@bestqualitywriters.com