CORPORATE FINANCE

nikkijay1130
FINE332_Excel_Template_2.xlsx
Home>Business & Finance homework help>CORPORATE FINANCE

Prob. 1

Annuity
1 2 3
Payments
Discount rate
Growth rate
Price to be paid

alfonso canella: alfonso canella: Hint: use the perpetuity formula.		 Cash Flows:
1
2
3
4
5
6
7
8
9
10

Prob. 2

Machine 1 Machine 2
Discount rate Enter text answer in the box below:
Growth rate
NPV
IRR
Cash flows:
Start
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

Prob. 3

July 2000 pay due
Interest rate
Future value of July 2000 pay on July 1, 2011 Enter text answer in the box below:
Present value of 25 yearly payments
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. 4

Lease
Implicit lease rate
Cash flows:
Start
Month 1
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Month 8
Month 9
Month 10
Month 11
Month 12
Month 13
Month 14
Month 15
Month 16
Month 17
Month 18
Month 19
Month 20
Month 21
Month 22
Month 23
Month 24
Month 25
Month 26
Month 27
Month 28
Month 29
Month 30
Month 31
Month 32
Month 33
Month 34
Month 35
Month 36

Prob. 5

Sale price (M euros)/plane
Down payment (%)
Cost per plane (M euros)
Discount rate
Years
(in Million euros) 1 2 3 4 5 6 7 8 9 10 11
# of planes sold
Investments on R&D
Revenues
Production Costs
Cash Flows
NPV
IRR

v. NOV 2021

No content - Intentionally left blank