Pro-Forma Projections Excelently Engineered Bikes Hestoncal financial statements for Excofonty Engineered Bikes (EEB) tregon below Parameters for projecting through 20X1 are also listed Given this information, the CFO Deves that the form can reduce s debity EOY 20x1 Find out if she is correct by completing the projection analysis that she has started Hint Solve for Debt 1 7 Compute and import numbers for cats that look like this To complete your work you also must compute numbers for cols that look like this: but you do not need to report these numbers Project Parameters for Projections (Irrespective of History) Annual Sales Growth 5.00% Dissat at 10% of NI CAPX set at 120.00% of Depreciation Averago Depreciable life of Assets 12.00 Years --> Annual Dopred = 8.3333% of BOP netPPE Min sale cash level 4.0% of TTM Sales No stock issuance or buyback Projected Financin Statements Historical Projection Rules EOY-1 20X-1 20x1 PPE Roll Forward Eqs Item PPE (BOP) - Deprec - Capix = PPE. (EOP) 20x0 80 000 (6 667) 8.000 81 333 Rule Source Project as PPE roll forward eg Last year's EOP PPE CFO 8333% of BOP PPE 7 % of Deprec Rollwd equation Sone for this 81 333 (6 778) CFO 2. 80.000 20X1 94.500 Income Statement S COGS Depreciation SGA Interest YO 20x0 90.000 55 000 B17 10 000 1 600 Rule Source CFO Salos PPE Roll Forward Project as 5009 Sales Growth 61.115 of Sales Take from above Rol Fwd EQ 1111 7 Interest/Debite Y CON 6.778 10 500 4 Interest Equation T. Flancial Statements Historical Projection Rules Projected EOY1 20x1 FOYO 200 20X1 PPE Roll Forward Eq Item PPE (BOP) Deprec + A PPE (OP) Rule Source Projects PPE to forward og Last year's EOP PPE CFO 333 CFO 2 Rollwd quotion Golve for this BO OCO (6 607) 11 000 0133 81300 (6 778) of BOP PPE of Deprec 0 000 2 Income Statement YO 20x0 90.000 55 000 6087 10.000 1 000 8020 8.713 COOS Depreciation SGA Interest Tox NI Rule Source Salos PPER Forward 3a Inforest Equation Trate Equation 20X1 96 500 3 8.772 10 500 Projects 5009 San Growth 61. 115 of S Take from above Roll Fwd Eq 11.115 2 Interest/ Debler 47 93% Tax EBT 8 525 9253 EOY-1 20x 1 Equity Roll Forward Iturn E. NI DN PIC (PIC for buyback) 2020 31 287 8.713 0 000 0 000 40 000 Rule Source Project as Equity Rol FwEQ Last yrs Equity Incon Statement Nton above Is CFO Board ? CFO/ Board 0.0 Equity Roll Fwd Eq. See eg attent 20X1 40 000 9 203 5 0.000 48 336 of Na -Ex 31 287 EOY - 1 20X-1 Balance Sheets Cash AR Inventory PPE (net) To sets 20X1 3.780 26 250 36150 06.780 89 39 149.489 . 20x0 Rule Source Project as 5 000 CFO 400 of Sales 25 000 Sales 27 of Sales 35 000 Sales 38 89% of Sales 65 000 81 333 PPE Roll Forward Take from PPE Roll Fwd Eq 146 333 30.000 Sales % of Sales Sales 40 37% of Sales 66 333 40 000 CFO Solve for this 106 333 40.000 Equity Rol Fwd Eq Take trom Equity roll ud og 0 000 AP 38 150 Other CL TCL 38.000 7 101 133 Debt Total 2 31.287 Equity CATE=0 Q Question 25 1 pts What is quantity 6? 1 pts D Question 26 This What is the absolute value of quantity 4? 1 pts Question 27 What is quantity 2? 1 pts Question 28 Choose the The "Rule Source" for quanity 3a is single best and ver. O % of Sales O The CFO or the board An accounting equation The enterprise value imperative Industry best practice Question 29 1 pts What is the absolute value of quantity 3? 1 pts Question 30 What is quantity 7? Hint: start with A = L + E. Expand this to A = Debt + all other Liabilities. Solve for Debt. Pro-Forma Projections Excelently Engineered Bikes Hestoncal financial statements for Excofonty Engineered Bikes (EEB) tregon below Parameters for projecting through 20X1 are also listed Given this information, the CFO Deves that the form can reduce s debity EOY 20x1 Find out if she is correct by completing the projection analysis that she has started Hint Solve for Debt 1 7 Compute and import numbers for cats that look like this To complete your work you also must compute numbers for cols that look like this: but you do not need to report these numbers Project Parameters for Projections (Irrespective of History) Annual Sales Growth 5.00% Dissat at 10% of NI CAPX set at 120.00% of Depreciation Averago Depreciable life of Assets 12.00 Years --> Annual Dopred = 8.3333% of BOP netPPE Min sale cash level 4.0% of TTM Sales No stock issuance or buyback Projected Financin Statements Historical Projection Rules EOY-1 20X-1 20x1 PPE Roll Forward Eqs Item PPE (BOP) - Deprec - Capix = PPE. (EOP) 20x0 80 000 (6 667) 8.000 81 333 Rule Source Project as PPE roll forward eg Last year's EOP PPE CFO 8333% of BOP PPE 7 % of Deprec Rollwd equation Sone for this 81 333 (6 778) CFO 2. 80.000 20X1 94.500 Income Statement S COGS Depreciation SGA Interest YO 20x0 90.000 55 000 B17 10 000 1 600 Rule Source CFO Salos PPE Roll Forward Project as 5009 Sales Growth 61.115 of Sales Take from above Rol Fwd EQ 1111 7 Interest/Debite Y CON 6.778 10 500 4 Interest Equation T. Flancial Statements Historical Projection Rules Projected EOY1 20x1 FOYO 200 20X1 PPE Roll Forward Eq Item PPE (BOP) Deprec + A PPE (OP) Rule Source Projects PPE to forward og Last year's EOP PPE CFO 333 CFO 2 Rollwd quotion Golve for this BO OCO (6 607) 11 000 0133 81300 (6 778) of BOP PPE of Deprec 0 000 2 Income Statement YO 20x0 90.000 55 000 6087 10.000 1 000 8020 8.713 COOS Depreciation SGA Interest Tox NI Rule Source Salos PPER Forward 3a Inforest Equation Trate Equation 20X1 96 500 3 8.772 10 500 Projects 5009 San Growth 61. 115 of S Take from above Roll Fwd Eq 11.115 2 Interest/ Debler 47 93% Tax EBT 8 525 9253 EOY-1 20x 1 Equity Roll Forward Iturn E. NI DN PIC (PIC for buyback) 2020 31 287 8.713 0 000 0 000 40 000 Rule Source Project as Equity Rol FwEQ Last yrs Equity Incon Statement Nton above Is CFO Board ? CFO/ Board 0.0 Equity Roll Fwd Eq. See eg attent 20X1 40 000 9 203 5 0.000 48 336 of Na -Ex 31 287 EOY - 1 20X-1 Balance Sheets Cash AR Inventory PPE (net) To sets 20X1 3.780 26 250 36150 06.780 89 39 149.489 . 20x0 Rule Source Project as 5 000 CFO 400 of Sales 25 000 Sales 27 of Sales 35 000 Sales 38 89% of Sales 65 000 81 333 PPE Roll Forward Take from PPE Roll Fwd Eq 146 333 30.000 Sales % of Sales Sales 40 37% of Sales 66 333 40 000 CFO Solve for this 106 333 40.000 Equity Rol Fwd Eq Take trom Equity roll ud og 0 000 AP 38 150 Other CL TCL 38.000 7 101 133 Debt Total 2 31.287 Equity CATE=0 Q Question 25 1 pts What is quantity 6? 1 pts D Question 26 This What is the absolute value of quantity 4? 1 pts Question 27 What is quantity 2? 1 pts Question 28 Choose the The "Rule Source" for quanity 3a is single best and ver. O % of Sales O The CFO or the board An accounting equation The enterprise value imperative Industry best practice Question 29 1 pts What is the absolute value of quantity 3? 1 pts Question 30 What is quantity 7? Hint: start with A = L + E. Expand this to A = Debt + all other Liabilities. Solve for Debt