How do I determine the net plant, property, and equipment as an excel formula given the following information: sales: 64,800 cost of good sold: 38,880 Gross profit: 25,920 General Selling and Admin...

How do I determine the net plant, property, and equipment as an excel formula given the following information: sales: 64,800 cost of good sold: 38,880 Gross profit: 25,920 General Selling and Admin expense: 7150 Depreciation: 2500 Interest expense: 1250 Income before taxes: 4506 accounts receivable: 12,500 cash collected from sales: 52,300 gross profit margin 40% tax rate 30%

The problem also gives that net plant, propert, and equipement for year 1 is 12500, the gross profit margin is 40%, tax rate is 30% and sales growth is 20% each year.  cash collected in sales for year 2 is 52,300.  Is there a formula in excell to calculate this or is this problem missing information?