Time: 15 min
Difficulty: Easy
Time to complete: 15 min
Difficulty: beginner
Challenge227_Data.xlsx (14.8 KB)
Time to complete: 10 minutes
Level: Beginner
Solution:
Challenge227_mysolution.xlsx (14.8 KB)
25 minutes
Intermediate
Challenge227_Data (2).xlsx (21.9 KB)
Time to Complete: 20 minutes
Rating: Intermediate
Challenge227 Hailey Smith.xlsx (22.0 KB)
- Existing region: IRR-5.47% NPV-$1,048,427.37 New Region: IRR-5.48% NPV-$2,000,000
- New Region
- ($2,000,000)
- DONE
- $922.44
- $982.52, $2,000,000, 2,036
Time: 10 Minutes, Difficulty: 3/10
- Existing: IRR 5.47%, NPV $48,427.37; New: IRR 5.48%, NPV $38,072.62
- Existing
- IO: (1,000,000)
- Bond Price: $992.44
- Net Bond Price $982.52
- Bonds Required (accounting for 10% safety): 1120
Time to complete: 15
Rating: beginner
Challenge227_Data.xlsx (14.8 KB)
Time: 20 min
Difficulty: Intermediate
Challenge227_Data(1).xlsx (14.8 KB)
Time to complete~15 min
Difficulty: Easy
My solution:
| Face Value | $1,000 |
|---|---|
| CPN Rate | 4.90% |
| Years till maturity | 20 |
| Payments per year | 2 |
| Market Rate | 4.96% |
| Comission Fee | 1% |
| Safety window | 10% |
| Price of the Bonds | ($992.44) |
| Net Price of Bond | ($982.52) |
| Estimated Costs of selected project | $(1,000,000.00) |
| Number of Bonds to Sell | 1,120 |
1 Like
Time to complete: 15 minutes
Solution:
Challenge227_Data.xlsx (14.7 KB)
Time to complete: 15 min
Rating: Easy
Solution:
Challenge227_Data.xlsx (14.8 KB)
Time: 20 mins
Difficulty: Beginner
Seems applicable to the career I want to have.
Challenge227.xlsx (14.9 KB)
Challenge227_Data.xlsx (14.8 KB)
Time to complete: 20 min
Difficulty: medium
Solution:
Challenge227_TVM_Data.xlsx (14.8 KB)
1 Like
Challenge227_Data.xlsx (15.8 KB)
time: 15 min
difficulty: medium
solution:
Challenge227_Data.xlsx (14.8 KB)
Time- 20 minutes
Level- Intermediate
Comments- good learning about tvm in excel
Challenge227_Data.xlsx (14.9 KB)