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. OPTION A: Cut costs by taking away all sales commissions and put sales personnel on straight salary. Selling expenses will drop to 50% of sales, but general expenses will increase to $29,000 per month. Also, the sales growth rate will drop to 1% per month. OPTION B: Double the sales commission rate and eliminate all sales salaries. This will increase the sales growth rate to 4% and reduce general expenses to $9,000 per month. It will also raise selling expenses to 70% of sales January PROJECTED MONTHLY NET INCOME April February March May Option A Option B