Question: Need the excel formula. D22 x = B D E F G H I J 3 Given the following information for Gandolfino Pizza Co., calculate
D22 x = B D E F G H I J 3 Given the following information for Gandolfino Pizza Co., calculate the depreciation expense: sales = $61,000; costs = $29,600; addition to retained earnings = $5,600; dividends paid = $1,950; interest expense = $4,300; tax rate = 21 percent. 4 5 6 7 8 Sales $ Costs $ Addition to retained earnings $ Dividends paid $ Interest expense $ Tax rate 61,000 29,600 5,600 1,950 4,300 21% 9 0 11 2 13 14 Complete the following analysis. Do not hard code values in your calculations. NOTE: You must enter your calculations in the order numbered in Column B. 15 16 17 61,000 29,600 18 19 20 Income Statement 1) Sales $ 2) Costs 10) Depreciation expense 9) EBIT 8) Interest expense 6) EBT Sheet1 4.300 21 22
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
