4. (6 pts) In cell C15, calculate the cumulative interest expense for year 1 (the interest portion of the 12 loan payments for the corresponding year). You should reference cells J2 through J6 as needed. Assume the loan will start at the beginning of year 1, and all payments will be made at the end of each period. Write your formula so that it can be copied across the row to automatically calculate these values for years 2 through 4. Make sure to format the cells so that negative cash flows are calculated as negative numbers and appear in parentheses. LO 0.3 File Home Insert Page Layout Formulas Data Review View Help Tell me H11 f F - NOPEN Origt Annu Loan Numb Endin 3 13 B D E Zeus Tumbler Project - Projected 4-Year Cash Flow Estimate 2 Year Number 3 Income 2 3 4 Sales Volume 5 Selling Price per Tumbler 6 Gross Revenue 7 2 8 Expenses ar 9 Variable Expenses (amounts per unit) S/Each 10 Cost of Goods Sold 11 Marketing Cost 12 Shipping Cost Cost Savings per Tumbler from new 13 equipment Fixed Expenses (amounts per year) 15 Interest Expense -fc 16 Depreciation pri 17 Taxable income 18 my Corporate Tax Rate 28% 19 State & Federal Taxes Owed Va 20 Income After Taxes 21 Add Back Depreciation 22 Subtract Principal Payments 23 Projected Cash Flow Estimate 10 24 25 26 al 14 cha aert 27 28 one 29 I pre 30 ar an Cash Flow Depreciation Amortization Per 4. (6 pts) In cell C15, calculate the cumulative interest expense for year 1 (the interest portion of the 12 loan payments for the corresponding year). You should reference cells J2 through J6 as needed. Assume the loan will start at the beginning of year 1, and all payments will be made at the end of each period. Write your formula so that it can be copied across the row to automatically calculate these values for years 2 through 4. Make sure to format the cells so that negative cash flows are calculated as negative numbers and appear in parentheses. LO 0.3 File Home Insert Page Layout Formulas Data Review View Help Tell me H11 f F - NOPEN Origt Annu Loan Numb Endin 3 13 B D E Zeus Tumbler Project - Projected 4-Year Cash Flow Estimate 2 Year Number 3 Income 2 3 4 Sales Volume 5 Selling Price per Tumbler 6 Gross Revenue 7 2 8 Expenses ar 9 Variable Expenses (amounts per unit) S/Each 10 Cost of Goods Sold 11 Marketing Cost 12 Shipping Cost Cost Savings per Tumbler from new 13 equipment Fixed Expenses (amounts per year) 15 Interest Expense -fc 16 Depreciation pri 17 Taxable income 18 my Corporate Tax Rate 28% 19 State & Federal Taxes Owed Va 20 Income After Taxes 21 Add Back Depreciation 22 Subtract Principal Payments 23 Projected Cash Flow Estimate 10 24 25 26 al 14 cha aert 27 28 one 29 I pre 30 ar an Cash Flow Depreciation Amortization Per
