Question: Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero at MARR = 5%. The study period
Problem 1 Using Microsoft Excel, create an investment cash-flow diagram that will have a present worth of zero at MARR = 5%. The study period needs to be exactly 14 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 Select a certain interest rate (a value that is not listed in the interest tables, e.g.5.37%) and create your own table for the factors (P/F, F/P, P/A, F/A, A/P, A/F, P/G, A/G, F/G). Your table should cover a total of 10 years
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
