(Please provide breakdown in excel) You have just turned 22 years old, received your bachelor's degree, and accepted your first job. Now you must decide how much money to put into your retirement plan. The plan works as follows: Every dollar in the plan earns 7.0 % per year. You cannot make withdrawals until you retire on your 65th birthday. After that, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn 65. You estimate that to live comfortably in retirement, you will need $100,000 per year, starting at the end of the first year of retirement and ending on your 100th birthday. You will contribute the same amount to the plan at the end of every year that you work. How much do you need to contribute each year to fund your retirement? You are thinking of making an investment in a new factory. The factory will generate revenues of S 1000000 per year for as long as you maintain it. You expect that the maintenance costs will start at $ 50000 per year and will increase 5 % per year thereafter. Assume that all revenue and maintenance costs occur at the end of the year. You intend to run the factory as long as it continues to make a positive cash flow (as long as the cash generated by the plant exceeds the maintenance costs). The factory can be built and become operational immediately and the interest rate is 6 % per year. a. What is the present value of the revenues? e. I the plant costs S 10000000 to build, should you invest in the factory