Corporate Finance Excel week 2
AliceRanwodds
MGMT332_Excel_Template_2.xlsProb. 1
| Annuity | |||||
| 1 | 2 | 3 | |||
| Discount rate | Best choice? | ||||
| Growth rate | |||||
| NPV | |||||
| IRR | |||||
| Cash flows: | |||||
| Start | |||||
| Year 1 | |||||
| Year 2 | |||||
| Year 3 | |||||
| Year 4 | |||||
| Year 5 | |||||
| Year 6 and on |
Prob. 2
| Software | Extended Plan | |||
| Discount rate | ||||
| Growth rate | Text answer here. | |||
| NPV | ||||
| IRR | ||||
| Cash flows: | ||||
| Start | ||||
| Year 1 | ||||
| Year 2 | ||||
| Year 3 | ||||
| Year 4 | ||||
| Year 5 | ||||
| Year 6 | ||||
| Year 7 | ||||
| Year 8 |
Prob. 3
| Rental Property | |||
| Discount rate | |||
| Growth rate | |||
| NPV | Text answer here. | ||
| IRR | |||
| Cash flows: | |||
| Start | |||
| Year 1 | |||
| Year 2 | |||
| Year 3 and on |
Prob. 4
| July 2000 pay due | |||
| Interest rate | |||
| Future value of July 2000 pay on July 1, 2011 | |||
| Present value of 25 yearly payments | Text answer here. | ||
| Year 1 | |||
| Year 2 | |||
| Year 3 | |||
| Year 4 | |||
| Year 5 | |||
| Year 6 | |||
| Year 7 | |||
| Year 8 | |||
| Year 9 | |||
| Year 10 | |||
| Year 11 | |||
| Year 12 | |||
| Year 13 | |||
| Year 14 | |||
| Year 15 | |||
| Year 16 | |||
| Year 17 | |||
| Year 18 | |||
| Year 19 | |||
| Year 20 | |||
| Year 21 | |||
| Year 22 | |||
| Year 23 | |||
| Year 24 | |||
| Year 25 |
Prob. 5
| Sale price (M$) per plane | ||||||||||||
| Down payment (%) | ||||||||||||
| Cost per plane (M$) | ||||||||||||
| Discount rate | ||||||||||||
| Years | ||||||||||||
| (in Million $) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| # of planes sold | ||||||||||||
| Investment | ||||||||||||
| Revenues | ||||||||||||
| Production Costs | ||||||||||||
| Cash Flow | ||||||||||||
| NPV | ||||||||||||
| IRR |
v. MAR 2021
| No content - Intentionally left blank |
