The attachment is the next assignment I want you to work on for me , can you finish working on it by tomorrow? Kindly use the template for the answers, thank you so much for your help.

WHB ACC 650 Module 6 11302016 Name: 12-33 13-27 13-28 13-29 Identifying the correct Proper Proper format Well written amounts Calculations for numbers reponse 10.00 16.00 2.00 6.00 2.00 6.00 1.00 3.00 4.00 Score test test test test Total 26.00 8.00 8.00 8.00 - Format Legend Entry Points Checksums Feedback Score Corrected entry 50.00 12-33 Amt 10.00 Calc Format 16.00 Resp Total - 26.00 - Countywide Cable Services, Inc. is organized with three segments: Metro, Suburban, and Outlying. Data fo Service Revenue Variable Expenses Controllable Fixed Expenses Fixed Expenses controllable by others $ $ $ $ Metro 1,000,000 200,000 400,000 230,000 Common Fixed Expenses Income Tax Expense $ $ 95,000 145,000 Required: Prepare a segmented income statement for Countywide Cable Services, Inc. Use the contribution fo Segmen Countrywide Cable Sales Revenue Variable Expenses Segment Contribution Margin Less: Controllable Fixed Exp Controllable Profit Margin Less: Traced to Unit, Controlled by others Segment Profit Margin Less: Common Fixed Expenses Income before taxes Less: Income taxes Net income $ $ $ $ $ $ $ Metro 1,000,000 200,000 800,000 400,000 400,000 230,000 170,000 n, and Outlying. Data for these segments for the year just ended follow. $ $ $ $ Suburban 800,000 150,000 320,000 200,000 $ $ $ $ Outlying 400,000 100,000 150,000 90,000 Willard H Berry 9/28/2016 Use the contribution format. $ $ $ $ $ $ $ Segment Suburban 800,000 150,000 650,000 320,000 330,000 200,000 130,000 Outlying $ 400,000 $ 100,000 $ 300,000 $ 150,000 $ 150,000 $ 90,000 $ 60,000 13-27 Amt 2.00 Calc 6.00 Format Resp - Total - 8.00 - Golden Gate Construction Associates, a real estate developer and building contractor in San Francisco equity. The cost to Golden Gate of issuing debt is the after-tax cost of the interest payments on the deb payments are tax deductible. The cost of Golden Gate's equity capital is the investment opportunity rate could earn on investments of similar risk to that of investing in Golden Gate Construction Associates. Th long-term debt is 10 percent, and the company's tax rate is 40 percent. The cost of Golden Gate's equit value (and book value) of Golden Gate's equity is $90 million. Debt Debt-Rate Equity Equity-Rate Tax Rate $ $ 60,000,000 10% 90,000,000 15% 40% Required: Calculate Golden Gate Construction Associates' weighted-average cost of capital. WACC 13-28 Amt 2.00 Calc 6.00 Format Resp - Total - 8.00 - The company has two divisions: the real estate division and the construction division. The divisions' tota operating income for the most recent year are as follows: Total Assets Real Estate Construction Current Liabilities $ 100,000,000 $ 6,000,000 $ 60,000,000 $ 4,000,000 Before-Tax Operating Income $ 20,000,000 $ 18,000,000 Required: Calculate the economic value added (EVA) for each of Golden Gate Construction Associates' div average cost of capital, which was computed in the preceding exercise.) Real Estate Construction Net Capital WACC Needed Return $ 0.00% - $ After Tax Income Less: Needed Return EVA $ $ - $ $ 0.00% - - ntractor in San Francisco, has two sources of long-term capital: debt and est payments on the debt, taking into account the fact that the interest vestment opportunity rate of Golden Gate's investors, that is, the rate they onstruction Associates. The interest rate on Golden Gate's $60 million of st of Golden Gate's equity capital is 15 percent. Moreover, the market of capital. ivision. The divisions' total assets, current liabilities, and before-tax truction Associates' divisions. (You will need to use the weighted- 13-29 Amt 1.00 Calc Format 3.00 - Resp Total 4.00 8.00 - Wyalusing Industries has manufactured prefabricated houses for over 20 years. The houses are constr customers' lots. Wyalusing expanded into the precut housing market when it acquired Fairmont Compa types of lumber are precut into the appropriate lengths, banded into packages, and shipped to custome the Fairmont Division as an investment center. Wyalusing uses return on investment (ROI) as a perform average productive assets. Management bonuses are based in part on ROI. All investments are expect before income taxes. Fairmont's ROI has ranged from 19.3 to 22.1 percent since it was acquired. Fairm that had an estimated ROI of 18 percent. Fairmont's management decided against the investment beca the division's overall ROI. The 20x1 income statement for Fairmont Division follows. The division's prod 20x1, a 5 percent increase over the balance at the beginning of the year. FAIRMONT DIVISION Income Statement For the Year Ended December 31, 20x1 (in thousands) Sales Revenue Cost of Goods Sold Gross Margin Operating Expenses Administrative Selling Income before Income taxes Required Rate of Return Productive Assets at the End of the Year Growth during year 15% $ 12,600,000 5% Required: Calculate the following performance measures for 20x1 for the Fairmont Division. a. Return on investment (ROI). Productive Assets at the Start of the Year Productive Assets at the End of the Year Average Productive Assets ROI $ 12,600,000 $ 6,300,000 b. Residual income. Average Productive Assets Required Rate of Return Required Return $ 6,300,000 Residual Income Would the management of Fairmont Division have been more likely to accept the invest residual income were used as a performance measure instead of ROI? Explain your ans . The houses are constructed in sections to be assembled on quired Fairmont Company, one of its suppliers. In this market, various and shipped to customers' lots for assembly. Wyalusing designated ment (ROI) as a performance measure with investment defined as investments are expected to earn a minimum return of 15 percent ce it was acquired. Fairmont had an investment opportunity in 20x1 inst the investment because it believed the investment would decrease ows. The division's productive assets were $12,600,000 at the end of VISION ment ember 31, 20x1 ds) airmont Division. $ $ $ 24,000 15,800 8,200 $ $ 5,740 2,460 $ 2,140 $ 3,600 ly to accept the investment opportunity it had in 20x1 if ROI? Explain your answer. Complete exercise 12-33 (part 1 only), exercise 13-29 (parts 1 and 2 only), exercise 13-27, and exercise 13-28 in the textbook. Prepare your responses to in Excel with each problem on a separate tab. Use the attached Template to answer the questions. Exercise 12-33 Countywide Cable Services, Inc. is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. Metro Suburban Outlying Service revenue .......................................................................... $1,000,000 $800,000 $400,000 Variable expenses ....................................................................... 200,000 150,000 100,000 Controllable fixed expenses ......................................................... 400,000 320,000 150,000 Fixed expenses controllable by others .......................................... 230,000 200,000 90,000 In addition to the expenses listed above, the company has $95,000 of common fixed expenses. Income-tax expense for the year is $145,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Inc. Use the contribution format. 2. Build a spreadsheet: Construct an Excel spreadsheet to solve the preceding requirement. Show how the solution will change if the following information changes: the sales revenues were $950,000 and $815,000 for Metro and Suburban, respectively. Exercise 13-29 Wyalusing Industries has manufactured prefabricated houses for over 20 years. The houses are constructed in sections to be assembled on customers' lots. Wyalusing expanded into the precut housing market when it acquired Fairmont Company, one of its suppliers. In this market, various types of lumber are precut into the appropriate lengths, banded into packages, and shipped to customers' lots for assembly. Wyalusing designated the Fairmont Division as an investment center. Wyalusing uses return on investment (ROI) as a performance measure with investment defined as average productive assets. Management bonuses are based in part on ROI. All investments are expected to earn a minimum return of 15 percent before income taxes. Fairmont's ROI has ranged from 19.3 to 22.1 percent since it was acquired. Fairmont had an investment opportunity in 20x1 that had an estimated ROI of 18 percent. Fairmont's management decided against the investment because it believed the investment would decrease the division's overall ROI. The 20x1 income statement for Fairmont Division follows. The division's productive assets were $12,600,000 at the end of 20x1, a 5 percent increase over the balance at the beginning of the year. FAIRMONT DIVISION Income Statement For the Year Ended December 31, 20x1 (in thousands) Sales revenue ................................................................................................................................................. $24,000 Cost of goods sold ........................................................................................................................................... 15,800 Gross margin .............................................................................................................................................. $ 8,200 Operating expenses: Administrative ............................................................................................................................ $2,140 Selling ........................................................................................................................................ 3,600 5,740 Income from operations before income taxes .................................................................................................... $ 2,460 Required: 1. Calculate the following performance measures for 20x1 for the Fairmont Division. a. Return on investment (ROI). b. Residual income. 2. Would the management of Fairmont Division have been more likely to accept the investment opportunity it had in 20x1 if residual income were used as a performance measure instead of ROI? Explain your answer. Exercise 13-27: Golden Gate Construction Associates, a real estate developer and building contractor in San Francisco, has two sources of long-term capital: debt and equity. The cost to Golden Gate of issuing debt is the after-tax cost of the interest payments on the debt, taking into account the fact that the interest payments are tax deductible. The cost of Golden Gate's equity capital is the investment opportunity rate of Golden Gate's investors, that is, the rate they could earn on investments of similar risk to that of investing in Golden Gate Construction Associates. The interest rate on Golden Gate's $60 million of long-term debt is 10 percent, and the company's tax rate is 40 percent. The cost of Golden Gate's equity capital is 15 percent. Moreover, the market value (and book value) of Golden Gate's equity is $90 million. Required: Calculate Golden Gate Construction Associates' weighted-average cost of capital. Exercise 13-28: Refer to the data in the preceding exercise for Golden Gate Construction Associates. The company has two divisions: the real estate division and the construction division. The divisions' total assets, current liabilities, and before-tax operating income for the most recent year are as follows: Division Total Assets Current Liabilities Before-Tax Operating Income Real estate ....................................................................... $100,000,000 $6,000,000 $20,000,000 Construction .................................................................... 60,000,000 4,000,000 18,000,000