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

Need the excel formula. Need the excel formula. D22 x = B D E F G

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!