An engineer has been offered an investment opportunity that will require a cash outlay of $40,000 now for a cash inflow of $3500 for each year of investment. However, she must state now the number of years she plans to retain the investment. Additionally, if the investment is retained for 6 years, a lump-sum amount of $36,000 will be returned to her; after 10 years, the lump-sum return is anticipated to be $49,000, and after 15 years, it is estimated to be $55,000. Money is currently worth 10% per year. (a) Is the decision sensitive to the retention period? If so, what investment period is best? (b) Write the format of the spreadsheet function that will display the correct PW values.
What will be an ideal response?
PW6 = -40,000 + 3500(P/A,10%,6) + 36,000(P/F,10%,6)
= -40,000 + 3500(4.3553) + 36,000(0.5645)
= $-4,434
PW10 = -40,000 + 3500(P/A,10%,10) + 49,000(P/F,10%,10)
= -40,000 + 3500(6.1446) + 49,000(0.3855)
= $396
PW15 = -40,000 + 3500(P/A,10%,15) + 55,000(P/F,10%,15)
= -40,000 + 3500(7.6061) + 55,000(0.2394)
= $-212
The PW is sensitive to the investment period; invest for 10 years
Function format: = - PV(10%,investment_years,3500,lump_sum) – 40000 displays PW
You might also like to view...
Which of the following statements is false?
A. When a binary mixture is at its bubble point, it contains almost all liquid and the first bubble of vapor. B. When a binary mixture is at a pressure above its bubble point at that composition, it will be a single liquid phase. C. When a binary mixture is at a temperature below its dew point at that composition, it will be a single liquid phase. D. When a binary mixture is at a pressure between its bubble point and dew point at that composition, it will be contain both a liquid and vapor phase. E. None of the above are false.
Neem oil comes from the neem tree
Indicate whether the statement is true or false
Consider this scenario. Assume that you want to buy a box of apples. You have the box you plan to fill up and you know that apples cost 10 cents each. How can you determine what the box of apples is going to cost you? This scenario is analogous to ____ in structural engineering.
A. bidding for a construction project B. estimates for simple projects C. determining indirect costs D. quantity takeoffs
There are _____ common breeds of geese found in the United States
a. five c. seven b. three d. ten