Question: could you please find a solution in excel D o Q Initial Balance RATE Initial deposit Amount of increase on Deposits NPER per ve ottOY
D o Q Initial Balance RATE Initial deposit Amount of increase on Deposits NPER per ve ottOY pery Exercise 4.6: On finding a job you open a money market account that earns 7% per year. You make Initial deposit of $ 1.000. You then deposit $ 500 after the end of the first year and keep increasing the deposit by 5 100 every year for 30 years. In other words, you deposit $ 600 in the 2 year, $ 700 in the 3 year and so on. What will be the NPV for the cash flow stream? year Years Cash Out Cash in Flow flow Net Cash Flow 0 1 2 3 4 5 7 8 9 10 NPV
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
