Question: Scenario box in Excel format is found in the Week 7 file in eConestoga. You will submit two documents to the Assignments folder: the first

Scenario box in Excel format is found in the Week 7 file in eConestoga. You will submit two documents to the Assignments folder: the first two questions on this Word document and the third question - scenario box - as an Excel file. C G 1 Scenario Box: BSG-Online Shoe Company Projections* Yr. 15 Yr. 16 Factor ACTUAL MIL Comments 5 GOP Growth Rate: 6 Inflation Growth Rateses & Sales - Unity 10 COGS 11 Advertising & Marketing 12 Interest Expense 13 Plant Expansion 14 Dividends 15 NET PROFITS (US Dollars) 16 17 EPS 19 . P - Permitcic; ML - Most Likelyc O - Optimistic. 20 " GOP Growth Rate for 2021 [Bank of Canadaj: https://www.bankofcanada.ca/2020/10/mpr-2020-10-28/ 21 #*"Inflation Growth Rate for 2021 [OUCD Data]: https://data.pecd.org/price/inflation-forecast.him 12 fourer: Adapted from T.L Whenim and ID. Hunger, "Tomarie Box for Use in Generating Financial Pro Form Statement 21
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
