Homework answers / question archive / The Method 1 tab contains a projected income statement and unbalanced balance sheet for Chewy, Inc, including the most recent year's data for those two statements as well as the cash flow statement

The Method 1 tab contains a projected income statement and unbalanced balance sheet for Chewy, Inc, including the most recent year's data for those two statements as well as the cash flow statement

Accounting

Share With

The Method 1 tab contains a projected income statement and unbalanced balance sheet for Chewy, Inc, including the most recent year's data for those two statements as well as the cash flow statement. The Method 2 tab contains the same projected income statement and unbalanced balance sheet, but no cash flow statement. Work in each tab separately--they should not be linked together in your formulas. Your tasks will be to complete the Cash Flow Statement and balance the balance sheet using both techniques covered in this week's material.

This part of the assignment is worth a total of 36 points. Points possible for each row are shown in column G. Always use formulas with cell references when possible. All answers should go in the relevant blue-shaded cells.

In the Method1 worksheet:

1.Complete the Cash Flow Statement by filling in the rows with the blue background, starting with Row 58 and ending with Row 80. Any item that is a cash inflow should display as a positive number, and any item that is a cash outflow should display as a negative number.

2.Complete Rows 82 and 83 to determine the values needed to balance the balance sheet.

3.Complete the balance sheet rows for Excess Cash and Revolver with formulas needed to balance the balance sheet as described in Method 1 in the class material for this week. Both rows must contain the appropriate formulas even if your balance sheet balances after filling in only one.  Your balance sheet must be set up to always balance, regardless of changes that are made to the forecast numbers.

?

 In the Method2 worksheet:

1.Complete Rows 53, 54 and 55 to determine the values needed to balance the balance sheet.

2.Complete the balance sheet rows for Excess Cash and Short Term Debt with formulas needed to balance the balance sheet as described in Method 2 in the class material for this week. Both rows must contain the appropriate formulas even if your balance sheet balances after filling in only one.  Your balance sheet must be set up to always balance, regardless of changes that are made to the forecast numbers.