Financial modeling Project: modeling a cash sweep for The Clorox Company (CLX).

This individual project will involve modeling a cash sweep for The Clorox Company (CLX).

Specifically, assume the following financial policy:

1. CLX pays 50 percent of net income in the form of a dividend each period.

2. If CLX needs cash in a particular period, the company will borrow using the long-term debt

account.

3. If CLX has cash available, the company first pays down long-term debt. Once debt is paid

off, any remaining cash is paid out to equity in the form of a share repurchase.

The start file is an equity-plugged model. Note that debt and interest expense forecasts are

missing.

To complete the assignment, you will need to complete the following elements:

1. Complete the statement of cash flows. CLX does not report depreciation separately on the

income statement, so ignore depreciation in constructing the cash flow statement.

2. Construct a debt schedule. Note that the company currently has debt on the balance sheet

as of 2021. Use the 2021 EOP balance as the BOP for 2022. The only changes to the debt

account should be (1) borrowing if the company needs cash, and (2) repayment if the

company has cash available. Assume an interest rate of 6 percent applied to the average

debt balance for the period.

3. Prepare an equity schedule. Allow equity to roll forward with net income net of dividends

and share repurchases for the period. Dividends should be 50 percent of same-year net

income. Share repurchases should occur only if the debt is completely repaid.

4. Construct a cash available/needed schedule. Assume the company wants to maintain an

end of period cash balance no less than 4 percent of same-year sales.

5. Error trapping. The model will have circular references, so incorporate an error trapping

feature.

Be consistent in use of formatting throughout the model, and adhere to the formatting norms of the

class (blue, black, bold, etc.)

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 6-12hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Paper Now