Kindly use excel and use screenshots to show formulas

1. Suppose you plan to save $8,000 per year for the 35 years you are working. In addition to the amount you are saving each year, you expect to sell your house for $600,000 in year 32 and deposit this money into your account. How much can you withdraw in equal amounts each year for the 30 years you are retired. The interest rate you will earn during the 35 years you are saving is 7%. Once you retire, youll reduce the amount of stock you have in your portfolio and you will now earn a return of 5% during the 30 years you are retired. Assume that you begin saving in one year and your first withdrawal is in year 36.

2. You are examining the desirability of selling widgets. To conduct the analysis, youve estimated that you will sell 1 million units and will sell the units for $99 each for the next five years. The variable costs for producing this product is estimated to be $32 per unit. Fixed costs will be $3 million per year. The equipment used to produce the widgets will cost $20 million and will be depreciated using the MACRS depreciation schedule for a five-year useful life. In year 5, the equipment will be sold for 20% of its original cost. The tax rate is 21%. Construct a proforma income statement to find the net income and operating cash flow for each of the five years of the project.