need answers in excel formula to show answers

A proposed new investment has projected sales of $635,000. Variable costs are 44 percent of sales, and fixed costs are $193,000 : depreciation is $54,000. Prepare a pro forma income statement assuming a tax rate of 21 percent. What is the projected net income? Complete the following analysis. Do not hard code values in your calculations. Complete the following analysis. Do not hard code values in your calculations