Go to the Estimated Earnings worksheet. Hwan has entered most of the income and expense data on the worksheet. He estimates sales will be $825,000 in Year 1 and $1,800,000 in Year 5. He needs to calculate the sales amounts for Years 2–4. The sales should increase at a constant amount from year to year.
Project the sales amounts for Years 2–4 (cells D9:F9) using a Linear Trend interpolation.
