P# FINANCIAL PROJECTIONS (ESTIMATOR) Practice Preprogrammed Problem: Instructions for solving this problem begin in Section 1 on page 4. PROBLEM DATA New Age Fuels is interested in estimating its net income for each of the next five months. It appears that January sales will be $100,000, and the company is hopeful that sales will increase by 2% per month. Selling expenses are 60% of each month's sales, and general expenses average $19,000 each month. REQUIREMENT 1. You have been asked by New Age Fuels to provide net income projections for each of the next five months. Review the worksheet ESTIMATOR that follows these requirements. 2. Open the file ESTIMATOR from the website for this book at www.cengagebrain.com. Enter your name in cell A1. Enter the six formulas in the appropriate cells. Save your file as ESTIMATOR2. Print the worksheet and print the formulas. Check figure: January net income (cell B20), $21,000 WHAT-IF ANALYSIS 3. Two options, A and B, are being considered to improve the company's monthly net income over the next five months. Consider each case separately. After evaluating each suggestion, enter the monthly projected net income in the spaces provided below. Assume that both options can be accomplished immediately.