Back ground info: Summer Tyme, Inc. has cash available and is considering a new three-year expansion project that requires an initial fixed investment as indicated below. For tax purposes, the fixed assets will be depreciated straight-line to zero over its three-year tax life for book and tax purposes. The fixed assets will have a market (salvage) value shown at the end of the project. The project is estimated to generate revenues during the three years starting as shown below and growing each year. Costs are a % of the same year sales. The project net working capital requirement is shown as a % of the next year's revenue.

Fill in the chart below of blanks for year 1, 2, 3:

INPUTS Revenue Year 1 Revenue Growth Costs (% of rev.) Investment Depr. years $2,650,000 5% 28% $4,800,000 You may use positive or negative numbers in this section below in any consistent manner. Please make sure your Excel formulas are consistent and that your cash flow numbers are correct SL Final tax book value$ FA Sale valuet-3$ 900,000 10% NWC req't of next year's sales Tax rate 35%