The assignment I am working on is called, Additional Funds Needed and I need help adding an IF statement to B21 that adds the cost of another factory to the required increase in assets if g>0. Can someone help me?

Thank you

A B 1 3. Calculate additional funds needed based on the assumption 2 that the firm has maxed out the capacity of their fixed assets and 3 that any increase will require the purchase of an additional 4 factory that costs an additional $480,000. You may still assume 5 that current assets are proportional to sales. 6 Make all other assumptions as in problem #1. 7 NSO = 8 NIO= 9 Current assets = 10 fixed assets= 11 accounts payable= 12 accrued liabilities= 13 8 14 retention rate 15 Forecasted sales NSI 16 delta_net_sales 17 Total Assets 18 AFN= 19 20 21 Required increase assets 22 Spont. Generated funds 23 increased in retained earning 24 AFN- 25 $1,600,000.00 $160,000.00 $520,000.00 $480,000.00 $48,000.00 $32,000.00 35% 100% $2,160,000.00 $560,000.00 $1,000,000.00 (TAO/NSO)*delta_net_sales -((APO+ALO)/NSO*delta_net_sales =-NS1*(NIO/NSO)*(RRO) $350,000.00 -$28,000.00 -$216,000.00 $106,000.00 E F G H (Total assets/NSO) delta_net_sales To grow an amount g. minus ((AP+AL)/NSO)*delta_net_sales from retained earnings A B 1 3. Calculate additional funds needed based on the assumption 2 that the firm has maxed out the capacity of their fixed assets and 3 that any increase will require the purchase of an additional 4 factory that costs an additional $480,000. You may still assume 5 that current assets are proportional to sales. 6 Make all other assumptions as in problem #1. 7 NSO = 8 NIO= 9 Current assets = 10 fixed assets= 11 accounts payable= 12 accrued liabilities= 13 8 14 retention rate 15 Forecasted sales NSI 16 delta_net_sales 17 Total Assets 18 AFN= 19 20 21 Required increase assets 22 Spont. Generated funds 23 increased in retained earning 24 AFN- 25 $1,600,000.00 $160,000.00 $520,000.00 $480,000.00 $48,000.00 $32,000.00 35% 100% $2,160,000.00 $560,000.00 $1,000,000.00 (TAO/NSO)*delta_net_sales -((APO+ALO)/NSO*delta_net_sales =-NS1*(NIO/NSO)*(RRO) $350,000.00 -$28,000.00 -$216,000.00 $106,000.00 E F G H (Total assets/NSO) delta_net_sales To grow an amount g. minus ((AP+AL)/NSO)*delta_net_sales from retained earnings