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

The Answer is in the image, click to view ...

Go to the Estimated Earnings worksheet. Hwan has entered most of the income and expense data on

Fantastic news! We've Found the answer you've been seeking!

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.