could you please find a solution on excel

2 different questions

Exercise 4.13: Arya Sales is planning a new business. They estimate Product A will bring in revenues of $100,000 in the first year with an annual increase of %3, Product B $80,000 with an annual increase of %5, and Product C $70,000 with an annual increase of $5,000. Create a spreadsheet for 10 years and find NPV and FV for the total sales. The rate of interest is 4% per year. D o Initial Balance RATE Initial deposit Amount of increase on Deposit NPER per year at COY per year years Exercise 4.6: On finding 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 $ 100 every year for 30 years. In other words, you deposh $ 600 in the 2 year, S 700 in the 3 year and so on. What will be the NIV for the cash flow stream? Year Cash Out Cash In Flow Net Cash Flow flow 0 1 2 3 4 5 6 7 5 9 10 NPV