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.
See attached screenshots for instructions. Thank you!
Haunt Compute Dakota Division's residual income for theyeatr. Golden Gate Consnaction Modules, a real estate developer and building oontlactor in San Franciseo, hastwosomcesefloagtermeapitai: dchtandequittheeosttoGoldeateofissuingdehtiathe aer-taxcoatofteiaterestpajlmeotsoutedehutaltingintoaocountthefacttiiatliieinterestpaymeuts mamadeduchleTheoouofGoldenGam'seqlqrupimiismeimasunmtoppmmityrateofGolden Gate'sinammtmmlemmieymueamouinwsmmofaimuskmthatofhmngia Golden Gate Censtmctioo Associates. The interest rate on Golden Gate's $6!) million of long-term dehtis lllpelcent,audthecoi:panjr'atasrateisdpermnt.1hecoat ofGolden Gate'seqityeapitalia 15 percent. Moreover, the market'ualue {andhoolt'ualue} oi'Goldeu Gale's equity is 5% million Haunt Calculate Golden Gate Conatrucoussociates" weighted-average east of capital. Refer to the data in the preceding esereiae for Golden Gate Conan-action Associates. The company has two divisions: the real estate division and the construction division. The divisioua' total assetsI curl-tent liahtilies, and before-tax operating income x the most recent year are as fellows: Dina-t lira-Ta]: lithiu- 1:\" local: LHIIHEI llplnthl hams Haunt Calculate the economic 1value added {EVA} foreach of Golden Gate Construction Associ- ates' divisions. [You will need te use the weighted-mac cost of capital.J which was computed in the preceding excl-else.) l W134? Calculate Emmet-Maa not of [aural for EVA [Hill I menu-ea EmthalaMdad [Burn]; anlirua'lim of Freoelilng Emma [Hill Countywide Cable Services, Inc. is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. um Sumatran [tuttylna amine rename .......................................................................... $1,000,000 $000,000 $400,000 Variable 030100000 ....................................................................... 200,000 150,000 100,000 Dnntmtlahle xed expenses ......................................................... 400,000 320,000 150,000 Hm: spams curm'ollable by 001003 .......................................... 230,000 200,000 00,000 In addition to the mtpenses listed above, the company has $95,000 of common xed 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 revemtes were $950,1'Jt} and $815,000 for Metro and Suburban, respectively. I Enemies 1233 Segmented Income Statement Tt' Cable Company tl- 5)
