Melissa is starting a savings for the initial capital to start a jewelry company right after graduation for 3 years. Her job base salary after graduating is expected to be $85,000 paid through equal payments at the end of every month throughout the year. She assumes a 7% increase in annual salary each year. Melissa expects to pay $1,800 monthly rent for her apartment and an extra $1,500 per month to cover other living expenses and she plans to save the rest. As her salary grows, she is plans to move to a nicer place and lifestyle. The expected rent increase is 5% every year and the expected increase in other expenses is 10%. She plans to keep this constant pattern of expenses and income. Assume a 5% nominal interest rate per year compounded monthly.

May use excel.

1. Draw the Cash Flow Diagram
2. How much money will she have at the end of year 3?
3. If Melissa knows that she needs only $100,000 to start her company, how many months it takes until he saves up this amount with the current saving pattern? You should consider interest accumulated on her savings.