Question: All hard-coded; no formulas. DE F Assumptions Income Statement (SM) Cash flow statement (SM) Supporting schedules ($M) 2020 2021 2020 2021 2019 2020 2019 2.00%

All hard-coded; no formulas. DE F Assumptions Income Statement (SM) Cash

All hard-coded; no formulas.

DE F Assumptions Income Statement (SM) Cash flow statement (SM) Supporting schedules ($M) 2020 2021 2020 2021 2019 2020 2019 2.00% 20.00% 38.46% 15.38% 5.00% 20.00% 2020 3.00% 20.00% 38.00% 16.00% 5.00% 20.00% 2021 3.00% 20.00% 38.00% 16.00% 5.00% 20.00% 3 Revenue growth Depreciation (% of opening PPE) COGS (% of revenues) 6 SG&A (% of revenues) 7 Interest on debt 8 Tax rate 1300 400 Net income Depreciation Change in Working Capital Cash from operations 2019 80 400 40 440 2019 1800 200 2000 Opening debt Net debt issuance Closing debt Revenue Depreciation COGS SG&A Interest Taxes Net income 500 200 100 200 Capex Cash from investing Starting inventory Additions to inventory Closing inventory 133 17 150 -200 10 Closing receivables (% of revenues) 11 Closing inventory (% of revenues) 12 Closing payables (% of COGS) 7.69% 11.54% 10.00% 7.00% 11.00% 10.00% 8.00% 11.00% 10.00% 200 77 Balance sheet (SM) Net debt issuance Net equity issuance Dividends paid Cash from financing Starting receivables Additions to receivables Closing receivables 2020 2021 100 200 2019 500 100 150 2000 2750 50 Net cash increase 440 Starting payables Additions to payables Closing payables 50 14 Capex (PP&E, SM) 200 500 300 Cash 15 Net debt issuance (SM) 200 100 175 Receivables 16 Net equity issuance (SM) 0 20 20 Inventory 17 Dividends 0 0 0 PP&E Total Assets 19 Conventions Payables 21 1. Interest payment (Opening debt balance + End debt balance)/2 times assumed interest rate Debt 22 2. Cash balances adjust as needed, they are the "plug." (In practice, one should forecast cash-balances a Retained earnings Equity Total Liabilities + equity Change in WK 40 50 2000 50 Opening PPE Investment Depreciation Closing PP&E 2200 200 400 2000 650 2750 Check 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I need help in the ratio analysis of following company. I need the below ratios and company balance sheet, income statement and cash flow statement is given below. Please do it correctly and 100%...

For each answer, do not forget to include analysis from the balance sheet, income statement, and cash flow statement Concepts to include are assets, debt, equity, net income, dividends, retained...

1. A company's profitability is BEST evaluated by examining a company's: a. Balance Sheet b. Income Statement c. Cash Flow Statement d. Statement of Changes in Equity 2. Accounting policies, methods,...

""5"" 1 Accounts, Trade and Other receivables (not including tax receivable] [in N01 vet millions of CAD) answered Marked out at Select one: 8.30 (I) a. Less than $300 l." E? Elm (:3 0:. Between $3...

Zhang Supply Corp. Backgound Zhang Supply Corp (ZSC) is a successful distributor of computer supplies in the United States. Founded in 1992 by Jiang (Jay) Zhang, the current CEO, the company grew...

MUST SHOW ALL CELL FORMULAS Required: You need to prepare a comprehensive 12-month budget, including supporting schedules and a report for the period January 1, 2020 to December 31, 2020 for Hedron,...

ok. Taxation 600 200 Total equity and liabilities 4,100 14,400 5,700 14,800 1,500 Statement of Comprehensive Incomes for the year ended 31 December, 2019 Olamide Limited GHCOOO Revenue 12,000 Cost of...

INSTRUCTIONS: Attempt ALL Questions 1. What are some of the shortcomings of teaching accounting only as a skill? 2. Outline the factors that facilitated the emergence of early bookkeeping. 3. What...

TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia Cable Company (GCC), a regional cable company. TransWorld's analysts project the...

1. Please complete the assumptions section of the financial model. What is the closing customer base in 2020? 64,150 88,000 26,580 52,400 2. Please partially complete the income statement section of...

Barchuk Mining Inc.'s share is currently selling for $150. The current dividend is $10 and the required rate of return is 10 percent. What is the expected dividend growth rate?

Explain why it is important to be an informed user of information systems in todays world. Consider roles and responsibilities. Include in your discussion how this course has contributed to your...

In Financial Planning, Saving is the final product which is similar to profit for a Corporation. true of false

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

Teamwork. Form groups of four students. Shake hands with each person in the group and then give either an oral or a written evaluation of the students handshake.Your instructor may direct each group...

Define team writing and explain how teams approach the three-step writing process. (Objective 6)

Briefly describe what a meeting leader and participant should do before, during, and after a meeting. (Objective 5)