| FINC400 Unit 5 IP Template |
| | To Start: Fill in Cells C4 through C13 with the given information from the assignment directions. |
| | Bicycle Units |
| | Price per bicycle |
| | Fixed Costs |
| | Variable Cost per Bicycle |
| | Initial Net Working Capital |
| | Initial Machine Investment |
| | Straight-Line Depreciation Time |
| | Tax rate |
| | Required rate of return |
| | Machine sold at Year 5 |
| | | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |
| | Capital Expenditures | $0 | | | | | $0 |
| | Change in Net Working Capital | $0 | | | | | $0 |
| | Change in Revenue | | $0 | $0 | $0 | $0 | $0 |
| | Change in Variable Costs | | $0 | $0 | $0 | $0 | $0 |
| | Change in Fixed Costs | | $0 | $0 | $0 | $0 | $0 |
| | Depreciation | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | EBIT | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Tax Rate * EBIT | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Depreciation | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Operating Cash Flow | | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | Total Project Cash Flow | $0 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| | NPV | ERROR:#DIV/0! |
| | In the following textbox, answer the following question in 50 or fewer words: Should the project be accepted or not? |
Clifford Lee
CopyofFINC400Unit5IndividualProjectTemplate.xlsx
