FINANCIAL STATEMENTS Balance Sheet Check 2013 OK Historical Results 2014 2015 OK OK 2016 OK 2017 OK Live Case 2018 OK 11 Forecast Period 2019 2020 OK OK Sher Price 2021 OK $3485 2022 OK! Assumptions 100% 1004 17.04 10.0% 35.0% 17.0% 15,000 5.000 Case 1 9 Revenue Growth [% Change) mo Cost of Goods Sold (% of Revenue) 11 Salaries and Benefits (% of Revenue) 2 Rent and Overhead (5000's) 13 Depreciation & Amortization (% of PP&E) 14. Interest (% of Debt) 15 Tax Rate(% of Eamings Before Taxi 16 Accounts Receivable (Days) 17: Inventory Days) 18 Accounts Payable (Days) 19 Capital Expenditures (5000's) 20 Debt issuance Repayment) (5000's) 21 Equity issued (Repaid) (5000's) 35.0% 10.0% 28.0% 15.000 20.000 4.5% 37.0% 180% 10 000 23 Case 2 24 Revenue Growth 1% Change) 2 Cost of Goods Sold (96 of Revenue) 26 Salaries and Benefits % of Revenue 27 Rent and Overhead (5000's) 28 Depreciation & Amortization of PP&E) 29 Interest of Debt 30 Tax Rate of Earings Before Tax Accounts Receivable (Ov) Muottery Days Accounts Payable (Days) 40% 36.0% 18 0% 10,000 40.0% 50% 35% 30% 18.0% 10,000 40.0% 30% 35.0% 18.09 10,000 40.0% 50% 280% 40.0 50% 505 2805 280% 13 I MTA chocolate cherry h... (10) Pinterest M Inbox - pppprehan... dubizzle Dubai Se... (1) IF Form Sale.. Private PA Job Offer... 18 Accounts Payable (Days) 19 Captal Expendituros ($000's) 20 Debt Issuance (Repayment (5000) 21 Equity Issued (Repaid (5000's) 15,000 15,000 15,000 15,000 (20,000) 15,000 40% 38.09 3.5% 1809 38,0% 18.0% 10,000 40.0% 2 Caso 2 24 Revenue Growth (% Change) 25 Cost of Goods Sold (% of Revenue) 26 Salaries and Benefits (% of Revenue) 27 Rent and Overhead (5000's) 28 Depreciation & Amortization (% of PP&E) 29 Interest (% of Debe 30 Tax Rate(% of Eamings Before Tax) 31 Accounts Receivable (Days) 32 Inventory (Days) 33 Accounts Payable (Days) 34 Capital Expenditures (5000's) 35 Debt issuance (Repayment (S000's) 36 Equity Issued (Repaid (5000's) 3.0% 35.0% 18.0% 10,000 40.0% 50% 28 0% 18 73 50% 28.0% 73 37 20.000 20.000 20.000 (20,000) 38 Live Case 39 Revenue Growth 1% Change) 40 Cost of Goods Solid (56 of Revenue) 100% 42.0% 100% 47.0% 100% 50.0% 100% 36.0% 100% 35 0% 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. FINANCIAL STATEMENTS Balance Sheet Check 2013 OK Historical Results 2014 2015 OK OK 2016 OK 2017 OK Live Case 2018 OK 11 Forecast Period 2019 2020 OK OK Sher Price 2021 OK $3485 2022 OK! Assumptions 100% 1004 17.04 10.0% 35.0% 17.0% 15,000 5.000 Case 1 9 Revenue Growth [% Change) mo Cost of Goods Sold (% of Revenue) 11 Salaries and Benefits (% of Revenue) 2 Rent and Overhead (5000's) 13 Depreciation & Amortization (% of PP&E) 14. Interest (% of Debt) 15 Tax Rate(% of Eamings Before Taxi 16 Accounts Receivable (Days) 17: Inventory Days) 18 Accounts Payable (Days) 19 Capital Expenditures (5000's) 20 Debt issuance Repayment) (5000's) 21 Equity issued (Repaid) (5000's) 35.0% 10.0% 28.0% 15.000 20.000 4.5% 37.0% 180% 10 000 23 Case 2 24 Revenue Growth 1% Change) 2 Cost of Goods Sold (96 of Revenue) 26 Salaries and Benefits % of Revenue 27 Rent and Overhead (5000's) 28 Depreciation & Amortization of PP&E) 29 Interest of Debt 30 Tax Rate of Earings Before Tax Accounts Receivable (Ov) Muottery Days Accounts Payable (Days) 40% 36.0% 18 0% 10,000 40.0% 50% 35% 30% 18.0% 10,000 40.0% 30% 35.0% 18.09 10,000 40.0% 50% 280% 40.0 50% 505 2805 280% 13 I MTA chocolate cherry h... (10) Pinterest M Inbox - pppprehan... dubizzle Dubai Se... (1) IF Form Sale.. Private PA Job Offer... 18 Accounts Payable (Days) 19 Captal Expendituros ($000's) 20 Debt Issuance (Repayment (5000) 21 Equity Issued (Repaid (5000's) 15,000 15,000 15,000 15,000 (20,000) 15,000 40% 38.09 3.5% 1809 38,0% 18.0% 10,000 40.0% 2 Caso 2 24 Revenue Growth (% Change) 25 Cost of Goods Sold (% of Revenue) 26 Salaries and Benefits (% of Revenue) 27 Rent and Overhead (5000's) 28 Depreciation & Amortization (% of PP&E) 29 Interest (% of Debe 30 Tax Rate(% of Eamings Before Tax) 31 Accounts Receivable (Days) 32 Inventory (Days) 33 Accounts Payable (Days) 34 Capital Expenditures (5000's) 35 Debt issuance (Repayment (S000's) 36 Equity Issued (Repaid (5000's) 3.0% 35.0% 18.0% 10,000 40.0% 50% 28 0% 18 73 50% 28.0% 73 37 20.000 20.000 20.000 (20,000) 38 Live Case 39 Revenue Growth 1% Change) 40 Cost of Goods Solid (56 of Revenue) 100% 42.0% 100% 47.0% 100% 50.0% 100% 36.0% 100% 35 0% 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