the formula contained in the yellow highlighted cell (I39) is=[ ] ( [ ] ,I9,I24) this formula can be copied over to the entire live svenario section without any manual modification .

hint : do not forget to use absolute references

88ea 32 Invontory (Days) 33 Accounts Payable (Days) 34 Capital Expenditfures ($000's) 35 Debt Issuance (Repaymen) (S000's) 36 Equity Issued (Repaid) ($000's) 73 73 73 73 37 37 37 37 20,000 20.000 20,000 (20,000) 20,000 37 38 Live Case 39 Revenue Growth (% Change) 40 Cost of Goods Sold (% of Revenue) 10.0 % 10.0% 10.0 % 100% 42.0% 47.0 % 500% 360% ( The formula contained in the yellow highlighted cell (139) is 19,124). This formula can be copied over to the entire live scenario section without any manual modification. (Hint: do not forget to use absolute references.) 88ea 32 Invontory (Days) 33 Accounts Payable (Days) 34 Capital Expenditfures ($000's) 35 Debt Issuance (Repaymen) (S000's) 36 Equity Issued (Repaid) ($000's) 73 73 73 73 37 37 37 37 20,000 20.000 20,000 (20,000) 20,000 37 38 Live Case 39 Revenue Growth (% Change) 40 Cost of Goods Sold (% of Revenue) 10.0 % 10.0% 10.0 % 100% 42.0% 47.0 % 500% 360% ( The formula contained in the yellow highlighted cell (139) is 19,124). This formula can be copied over to the entire live scenario section without any manual modification. (Hint: do not forget to use absolute references.)