Question: Please show me how to solve this problem using Microsoft Excel ( spreadsheet) * Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that

Please show me how to solve this problem using Microsoft Excel ( spreadsheet)
* Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero using MARR = 12%. The study period needs to be exactly 9 years and each year should have at least one unique cash-flow that is different from the cash-flows over the other years. Your answer should contain a table showing the cash-flows for each year and a graphical representation of the cash-flows (cash-flow diagram). Problem 2 Groundwater well is known to begin pumping sand once it becomes exploited (old), and this may damage the subsequent water treatment processes. To solve this problem, two alternatives are proposed: A new well can be drilled at a capital cost of $580,000 with minimal operating and maintenance expenses of $11,500 per year. A settling tank can be constructed ahead of the treatment processes which will cost $230,000 to build and $42,400 per year to operate and maintain
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
