90.2K

Verified Solution

Link Copied!

6 Assumptions 7 8 Case 1 9 Revenue Growth (% Change) 10 Cost of Goods Sold (% of Revenue) 11 Salares and Benelts (% of Revenue) 12 Rent and Overhead (3000's) 13 Depreciaion &Amorization (% of PP&E) 14 Interest (% of Deb 15 Tax Rale (% of Eamings Belore Tax) 16 Accourts Receiable (Days) 17 Inventory (Days) 18 Accounts Payabie (Days) 19 Captal Expenditures ($000's) 20 Debt issuance (Repayment) (S000's) 21 Equity Issued (Repaid) (S000s) 10.0 % 47.0 % 17.0 % 10.0% 10.0% 10.0% 10.0% 36.0 % 17 0 % 15,000 42.0% 50.0% 35.0% 17 0 % 15.000 17.0% 17.0% 15,000 15,000 15,000 35.0% 35.0% 350% 35.0% 35.0% 10 0 % 10 0 % 10 0 % 10.0% 10.0% 28.0% 28.0% 28.0% 28.0% 28.0% 18 18 18 18 18 80 37 90 100 100 100 37 37 37 37 15,000 15,000 15,000 15,000 15,000 20,000) 22 23 Case 2 24 Revenue Growth (% Change ) 25 Cost of Goods Sold (% of Reverue) 26 Salares and Benefits % of Revenue) 27 Rent and Overhead ($000's) 20 Deprociation & Amorization (% of PP&E) 29 Interest (% of Deb) 30 Tax Rale % of Eamings Belore Tax) 31 Accourts Reoeivable (Deys) 32 Inventory (Days) 33 Accourts Payable (Days) 34 Captal Expendituros ($000's) as Debr issaance (Repayment) (5000) 36 Equty Issued Repaid) (5000s 35 % 30% 5 0% 45 % 4.0% 35 0% 37 0% 36.0% 36.0% 37 0% 18 0% 18 0% 18 0% 18 0% 180% 10,000 10,000 10,000 10,000 10,000 40.0% 40 0% 40 0% 400% 40.0% 50 % 5 0% 5 0% 50% 50% 28.0 % 280% 18 28.0% 28 0% 18 28 0% 18 18 18 73 73 73 73 73 37 37 37 37 37 20,000 20000 20 000 20,000 20,000 (20 000) 37 38 Live Case 39 Revenue Grosth (% Change) 40 Cost of Goods Sold (% of Revenue) 10 0 % 10 0% 10 0% 10.0% 10 0% 35 0% 42 0% 47 0% 50.0% 380% 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.) 6 Assumptions 7 8 Case 1 9 Revenue Growth (% Change) 10 Cost of Goods Sold (% of Revenue) 11 Salares and Benelts (% of Revenue) 12 Rent and Overhead (3000's) 13 Depreciaion &Amorization (% of PP&E) 14 Interest (% of Deb 15 Tax Rale (% of Eamings Belore Tax) 16 Accourts Receiable (Days) 17 Inventory (Days) 18 Accounts Payabie (Days) 19 Captal Expenditures ($000's) 20 Debt issuance (Repayment) (S000's) 21 Equity Issued (Repaid) (S000s) 10.0 % 47.0 % 17.0 % 10.0% 10.0% 10.0% 10.0% 36.0 % 17 0 % 15,000 42.0% 50.0% 35.0% 17 0 % 15.000 17.0% 17.0% 15,000 15,000 15,000 35.0% 35.0% 350% 35.0% 35.0% 10 0 % 10 0 % 10 0 % 10.0% 10.0% 28.0% 28.0% 28.0% 28.0% 28.0% 18 18 18 18 18 80 37 90 100 100 100 37 37 37 37 15,000 15,000 15,000 15,000 15,000 20,000) 22 23 Case 2 24 Revenue Growth (% Change ) 25 Cost of Goods Sold (% of Reverue) 26 Salares and Benefits % of Revenue) 27 Rent and Overhead ($000's) 20 Deprociation & Amorization (% of PP&E) 29 Interest (% of Deb) 30 Tax Rale % of Eamings Belore Tax) 31 Accourts Reoeivable (Deys) 32 Inventory (Days) 33 Accourts Payable (Days) 34 Captal Expendituros ($000's) as Debr issaance (Repayment) (5000) 36 Equty Issued Repaid) (5000s 35 % 30% 5 0% 45 % 4.0% 35 0% 37 0% 36.0% 36.0% 37 0% 18 0% 18 0% 18 0% 18 0% 180% 10,000 10,000 10,000 10,000 10,000 40.0% 40 0% 40 0% 400% 40.0% 50 % 5 0% 5 0% 50% 50% 28.0 % 280% 18 28.0% 28 0% 18 28 0% 18 18 18 73 73 73 73 73 37 37 37 37 37 20,000 20000 20 000 20,000 20,000 (20 000) 37 38 Live Case 39 Revenue Grosth (% Change) 40 Cost of Goods Sold (% of Revenue) 10 0 % 10 0% 10 0% 10.0% 10 0% 35 0% 42 0% 47 0% 50.0% 380% 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.)

Answer & Explanation Solved by verified expert

See Answer