Using Excel, complete the following problems in the textbook Please attach excel

ID: 2570245 • Letter: U

Question

Using Excel, complete the following problems in the textbook Please attach excel file for response:

Balance Sheet: Problems 8, and 9 on page 43

Income Statement: Problems 5, and 6 on page 43

Cash Flow: Problems 7, 10, and 11 on page 43

Be sure your Excel spreadsheet is prepared in a professional manner, with answers clearly indicated and all your calculations shown. Full credit will not be given if your process for arriving at the answer is not displayed.

5:)Calculating Taxes [LO3] The Dyrdek Co. had $267,000 in 2014 taxable income. Using the rates from Table 2.3 in the chapter, calculate the company’s 2014 income taxes.

6:)Tax Rates [LO3] In Problem 5, what is the average tax rate? What is the marginal tax rate?

7:)Calculating OCF [LO4] Ridiculousness, Inc., has sales of $43,800, costs of $22,700, depreciation expense of $2,100, and interest expense of $1,600. If the tax rate is 35 percent, what is the operating cash flow, or OCF?

8:) Calculating Net Capital Spending [LO4] Bowyer Driving School’s 2014 balance sheet showed net fixed assets of $2.7 million, and the 2015 balance sheet showed net fixed assets of $3.5 million. The company’s 2015 income statement showed a depreciation expense of $328,000. What was net capital spending for 2015?

9:)Calculating Net Capital Spending [LO4] Bowyer Driving School’s 2014 balance sheet showed net fixed assets of $2.7 million, and the 2015 balance sheet showed net fixed assets of $3.5 million. The company’s 2015 income statement showed a depreciation expense of $328,000. What was net capital spending for 2015?

10:)Cash Flow to Creditors [LO4] The 2014 balance sheet of Sugarpova’s Tennis Shop, Inc., showed long-term debt of $1.95 million, and the 2015 balance sheet showed long-term debt of $2.28 million. The 2015 income statement showed an interest expense of $235,000. What was the firm’s cash flow to creditors during 2015?

11:)Cash Flow to Stockholders [LO4] The 2014 balance sheet of Sugarpova’s Tennis Shop, Inc., showed $670,000 in the common stock account and $4.1 million in the additional paid-in surplus account. The 2015 balance sheet showed $825,000 and $4.4 million in the same two accounts, respectively. If the company paid out $565,000 in cash dividends during 2015, what was the cash flow to stockholders for the year?

Explanation / Answer

Question 7). Solution :- Income statement

Sales

(-) Operating expenses

(-) Depreciation

43800

22700

2100

Earnings before interest and taxes (EBIT)

(-) Interest expense

19000

1600

Earnings before taxes

(-) Tax expense (35 % of 17400)

17400

6090

Operating cash flow (OCF) = Earnings before interest and taxes (EBIT) + Depreciation - Tax.

= 19000 + 2100 - 6090

= $ 15010.

Conclusion :- Operating cash flow (OCF) = $ 15010.

Question 8). Solution :- Net capital spending = (3500000 - 2700000) + 328000

= 800000 + 328000

= $ 1128000.

Conclusion :- Net capital spending for the year 2015 = $ 1128000.

Question 9). Solution :- Net capital spending = (3500000 - 2700000) + 328000

= 800000 + 328000

= $ 1128000.

Conclusion :- Net capital spending for the year 2015 = $ 1128000.

Question 10). Solution :- Cash flow to creditors = 235000 - (2280000 - 1950000)

= 235000 - 330000

= (-) 95000.

Conclusion :- Cash flow to creditors = (-) 95000 Dollars.

Question 11). Solution :- Cash flow to stockholders = 565000 - [ (4400000 + 825000) - (4100000 + 670000) ]

= 565000 - (5225000 - 4770000)

= 565000 - 455000

= $ 110000.

Conclusion :- Cash flow to stockholders = $ 110000.

Particulars Amount ($)