Question
XYZ Ltd invested into a new local network $50,000. Revenues and maintenance costs over a five year service life of the network are presented in
XYZ Ltd invested into a new local network $50,000. Revenues and maintenance costs over a five year service life of the network are presented in the following table:
Year | Revenue | Maintenance cost |
1 | 20,000 | 5,000 |
2 | 22,000 | 7,000 |
3 | 23,000 | 9,000 |
4 | 25,000 | 11,000 |
5 | 26,000 | 13,000 |
Assume MARR = 15% and 10% historic depreciation rate for the network to answer the following questions:
Define IRR of this investment in Excel and present a printout. Is it a good investment?
Calculate EAC of the network in year 3
Assume that CCA rate coincides with the historic depreciation rate, corporate tax rate is equal to 18% and calculate the amount of taxes paid in year 3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started