<span>Answer: Sheet1:Sheet4
Explanation:
The symbol : is used in Excel to refer to the range. So Sheet1: Sheet4 denotes,
FROM sheet1 TO sheet4 of the workbook.</span>
Answer:
- <em>The cash flow stream from investment X has higher present value than the the cash flow stream from investm Y.</em>
Explanation:
<u></u>
<u>1. Present value of investment X</u>
- Annual payment: C = $4,200
- Number of years: t = 8
- Rate: r = 5%
- PV₁ = ?
Formula:
![PV=C\times [\dfrac{1}{r}-\dfrac{1}{r(1+r)^t}]](https://tex.z-dn.net/?f=PV%3DC%5Ctimes%20%5B%5Cdfrac%7B1%7D%7Br%7D-%5Cdfrac%7B1%7D%7Br%281%2Br%29%5Et%7D%5D)
Substitute and compute:
![PV_1=\$ 4,200\times [\dfrac{1}{0.05}-\dfrac{1}{0.05(1+0.05)^8}]](https://tex.z-dn.net/?f=PV_1%3D%5C%24%204%2C200%5Ctimes%20%5B%5Cdfrac%7B1%7D%7B0.05%7D-%5Cdfrac%7B1%7D%7B0.05%281%2B0.05%29%5E8%7D%5D)

<u>2. Present value of investment Y</u>
- Annual payment: C = $6,100
- Number of years: t = 5
- Rate: r = 5%
Formula:
![PV=C\times [\dfrac{1}{r}-\dfrac{1}{r(1+r)^t}]](https://tex.z-dn.net/?f=PV%3DC%5Ctimes%20%5B%5Cdfrac%7B1%7D%7Br%7D-%5Cdfrac%7B1%7D%7Br%281%2Br%29%5Et%7D%5D)
Substitute and compute:
![PV_2=\$ 6,200\times [\dfrac{1}{0.05}-\dfrac{1}{0.05(1+0.05)^5}]](https://tex.z-dn.net/?f=PV_2%3D%5C%24%206%2C200%5Ctimes%20%5B%5Cdfrac%7B1%7D%7B0.05%7D-%5Cdfrac%7B1%7D%7B0.05%281%2B0.05%29%5E5%7D%5D)

Hence, the cash flow stream from investment X has higher present value than the the cash flow stream from investm Y.
Structural unemployment. This type of unemployment is the result of changes in industries and reorganization, typically as the result of technology or outsourcing for lower costs.