I am working on an assignment in Excel, Additional funds Needed and there are three sheets(parts). I am on the 3rd sheet, 
When you read the 3rd sheet, it instructs an additional $480,000 is needed to purchase another factory. Do I add the additional money to NS0/NI0/ fixed assets to get the right answer? Do I need to change the g % / retention rate? Thank you for helping me
G11 A B C D E 13. Calculate additional funds needed based on the assumption 2 that the firm has maxxed out the capacity of their fixed assets and that any increase will require the purchase of an additional 3 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 = $1,600,000.00 8 NIO= $160,000.00 9 Current assets = $520,000.00 10 fixed assets= $480,000.00 11 accounts payable= $48,000.00 12 accrued liabilities = $32,000.00 13 BF 35% 14 retention rate 100% 15 Forecasted sales NSI 16 delta_net_sales 17 Total Assets 18 AFN = (TAO/NSO) delta_net_sales -((APO+ALO)/NSO*delta_net_sales 19 20 =-NS1*(NIO/NSO)*(RRO) 21 Required increase assets 22 Spont. Generated funds 23 increased in retained earnings 24 AFN- 25 26 1 2 3 F sheet 3 (Total assets/NSO) delta_net_sales To grow an amount g. minus ((AP+AL)/NSO) delta_net_sales from retained earnings G H I J K B D 1 1. Calculate additional funds needed. 2 Make the assumptions given below (and in the corresponding mp4s). 3 4 NSO = $1,600,000.00 5 NIO= $160,000.00 6 Current assets = $520,000.00 7 fixed assets = $480,000.00 8 accounts payable= $48,000.00 $32,000.00 9 accrued liabilities= 10 = 30% 11 retention rate 100% 12 Forecasted sales NSI $2,080,000.00 13 delta_net_sales $480,000.00 14 Total Assets $1,000,000.00 15 AFN = (TAO/NSO) delta_net_sales 16 -((APO+ALO)/NSO delta_net_sales 17 =-NS1*(NIO/NSO)*(RRO) 18 Required increase assets $300,000.00 19 Spont. Generated funds -$24,000.00 20 increased in retained earnings -$208,000.00 21 AFN- $68,000.00 22 1 2 3 CO 4 ( TI E sheet | H G To grow an amount g. minus ((AP+AL)/NSO) delta_net_sales from retained earnings H from suppliers, wkrs G11 A B C D E 13. Calculate additional funds needed based on the assumption 2 that the firm has maxxed out the capacity of their fixed assets and that any increase will require the purchase of an additional 3 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 = $1,600,000.00 8 NIO= $160,000.00 9 Current assets = $520,000.00 10 fixed assets= $480,000.00 11 accounts payable= $48,000.00 12 accrued liabilities = $32,000.00 13 BF 35% 14 retention rate 100% 15 Forecasted sales NSI 16 delta_net_sales 17 Total Assets 18 AFN = (TAO/NSO) delta_net_sales -((APO+ALO)/NSO*delta_net_sales 19 20 =-NS1*(NIO/NSO)*(RRO) 21 Required increase assets 22 Spont. Generated funds 23 increased in retained earnings 24 AFN- 25 26 1 2 3 F sheet 3 (Total assets/NSO) delta_net_sales To grow an amount g. minus ((AP+AL)/NSO) delta_net_sales from retained earnings G H I J K B D 1 1. Calculate additional funds needed. 2 Make the assumptions given below (and in the corresponding mp4s). 3 4 NSO = $1,600,000.00 5 NIO= $160,000.00 6 Current assets = $520,000.00 7 fixed assets = $480,000.00 8 accounts payable= $48,000.00 $32,000.00 9 accrued liabilities= 10 = 30% 11 retention rate 100% 12 Forecasted sales NSI $2,080,000.00 13 delta_net_sales $480,000.00 14 Total Assets $1,000,000.00 15 AFN = (TAO/NSO) delta_net_sales 16 -((APO+ALO)/NSO delta_net_sales 17 =-NS1*(NIO/NSO)*(RRO) 18 Required increase assets $300,000.00 19 Spont. Generated funds -$24,000.00 20 increased in retained earnings -$208,000.00 21 AFN- $68,000.00 22 1 2 3 CO 4 ( TI E sheet | H G To grow an amount g. minus ((AP+AL)/NSO) delta_net_sales from retained earnings H from suppliers, wkrs
