Business Investment Report
peace4595
FINA310UNIT4IPTemplaterev1.xlsxNPV
| UNIT 4 HOMEWORK TEMPLATE FOR NPV AND PAYBACK CALCULATIONS: | |||||||
| NAME | |||||||
| Date | |||||||
| Step 1: | PLUG IN | INTEREST RATE = | |||||
| Step 2: | PLUG IN THE CASH FLOWS BELOW: | ||||||
| CASH FLOW | PVIF FACTOR | PV of the cash flows | |||||
| INITIAL INVESTMENT= | 1 | - 0 | |||||
| 1 | 1 | - 0 | |||||
| 2 | 1 | - 0 | |||||
| 3 | 1 | - 0 | |||||
| 4 | 1 | - 0 | |||||
| 5 | 1 | - 0 | |||||
| NET PRESENT VALUE = | - 0 | ||||||
| Reference: | |||||||
| Nybro, P. (2020) Unit 4 chat. AIU Online. Retrieved from | URL |
PAYBACK
| PAYBACK APPROACH | ||||||||
| STEP 1 | PLUG IN THE CASH FLOWS BELOW: | |||||||
| CASH FLOW | PV of the cash flows | |||||||
| INITIAL INVESTMENT= | - 0 | - 0 | ||||||
| 1 | - 0 | 1 | ||||||
| 2 | - 0 | 2 | ||||||
| 3 | - 0 | 3 | ||||||
| 4 | - 0 | 4 | ||||||
| 5 | - 0 | 5 | ||||||
| 6 | - 0 | 6 | ||||||
| 7 | - 0 | 7 | ||||||
| 8 | - 0 | 8 | ||||||
| 9 | - 0 | 9 | ||||||
| 10 | - 0 | 10 | ||||||
