thank you for help. it is simple model

thank you for help. it is simple model

ATTACHMENT PREVIEW

Download attachment

1
Payback Period
Initial Investsment
74,000.00
Years
Additional Revenues
Additional Expenses
Increase Net Cash flow
1
19,800.00
3,000.00
2
27,000.00
3,000.00
3
32,400.00
3,000.00
4
32,400.00
3,000.00
Time period:
0
1
2
3
4
Cash flow:
Cumulative cash flow:
% of year required for payback:
Payback period
2
Accounting Rate of Return
Initial Investsment
74,000.00
Deprecation
Years
Additional Revenues
Additional Expenses
Expense
Increase Net Income
1
19,800.00
3,000.00
2
27,000.00
3,000.00
3
32,400.00
3,000.00
4
32,400.00
3,000.00
Useful life
Time period:
0
1
2
3
4
Increase Net Income:
Average Net Income
Initial Investsment
ARR
3
WACC
12%
NPV and IRR
Initial Investsment
74,000.00
Years
Additional Revenues
Additional Expenses
Increase Net Cash flow
1
19,800.00
3,000.00
2
27,000.00
3,000.00
3
32,400.00
3,000.00
4
32,400.00
3,000.00
Time period:
0
1
2
3
4
Cash flow:
NPV
IRR
4
WACC
12%
NPV and IRR
Net
Initial Investsment
74,000.00
Reduction in
Increase
Years
Additional Revenues
Additional Expenses
Increase Net Cash flow
Cash Flow
After reduction
1
19,800.00
3,000.00
0.3333333333
2
27,000.00
3,000.00
0.3333333333
3
32,400.00
3,000.00
0.3333333333
4
32,400.00
3,000.00
0.3333333333
Time period:
0
1
2
3
4
Cash flow:
NPV
IRR

Leave a Comment