complete the problem using Excel formula

P-1: Growth and financing (L04) Sales double from $600,000 to $1,200,000 next year. Net assets (Assets - Liabilities) will remain at 50 percent of sales and there is an 8 percent return on total sales. He will start the year with $120,000 in the bank and wishes to buy a laguar and townhouse. Does his optimistic outlook for his cash position appear to be correct? Compute his likely cash balance for the end of the year with beginning cash, plus ptofit, minus the asset buildup (change in total assets). cormmeris? p.3) Growth and financing (LO4) Galehouse Gas Stations Inc, expects sales to increase from $1,550,000 to $1,750,000 next vear, Galehouse believes that net astets (Assets - Labilities) will represent 50 percent of sales. His firm has an 8 percent return on sales and pays 45 percent of profits out as dividends: a. What effect will this growth have on funds? b. If the dwidend payout is only 25 percent, what effect will this growth have on funds