Formulas for only the shaded section are needed

Take the assumptions as stated. Many assumptions are based on percent-of-sales, except depreciation and interests. Assumptions apply to the planning horizon (Year 1 to Year 5) only. Capital Raising Policy: If required financing is needed, firm will obtain the funding from banks (NP) and then use stock issuance to obtain external funding. However, there is a limit on the additional amount of borrowin Debt Limit: The firm has a new revolving credit facility of $50 million. The existing short-term debt balance (NP) is NOT a part of this limit. Thus, firm can borrow up to $50 million in the next five years if needed. Excess Cash Policy: Firm will first pay off short-term debt. If all short-term debts are paid off, firm will use excess cash to buy back shares. Model only needs to work within stated range of growth rate: -0.5% to 8%. Assumptions Sales growth 8.0%