4. Richard asks you to calculate the membership prices for the first quarter memberships sold in the gallery ticket office. The individual membership price is $50. Students pay a discounted price of $25. In cell F5, create a formula using the IF function to determine the membership price based on the following criteria: a. If cell D5 (the Category) is Student the price is 25. (Hint: Student must appear in quotes. Do not enter $ for the price.) b. All other individual members must pay 50. Copy the formula in cell F5 into the range F6:F13.

Elliott company produces large quantities of a standardized product. the following information is available for its production activities for march. units costs beginning work in process inventory 2,500 beginning work in process inventory started 25,000 direct materials $ 3,725 ending work in process inventory 5,000 conversion 11,580 $ 15,305 status of ending work in process inventory direct materials added 185,750 materials—percent complete 100 % direct labor added 182,375 conversion—percent complete 30 % overhead applied (140% of direct labor) 255,325 total costs to account for $ 638,755 ending work in process inventory $ 62,530 prepare a process cost summary report for this company, showing costs charged to production, unit cost information, equivalent units of production, cost per eup, and its cost assignment and reconciliation. use the weighted-average method. (round "cost per eup" to 2 decimal places.)

Eliminating entries (including goodwill impairment) and worksheets for various years on january 1, 2013, porter company purchased an 80% interest in the capital stock of salem company for$850,000. at that time, salem company had capital stock of $550,000 and retained earnings of $80,000.differences between the fair value and the book value of the identifiable assets of salem company were asfollows: fair value in excess of book valueequipment$130,000land65,000inventory40,000the book values of all other assets and liabilities of salem company were equal to their fair values onjanuary 1, 2013. the equipment had a remaining life of five years on january 1, 2013. the inventory was sold in2013.salem company’s net income and dividends declared in 2013 and 2014 were as follows: year 2013 net income of $100,000; dividends declared of $25,000year 2014 net income of $110,000; dividends declared of $35,000required: a.prepare a computation and allocation schedule for the difference between book value of equity acquired andthe value implied by the purchase price.b.present the eliminating/adjusting entries needed on the consolidated worksheet for the year endeddecember 31, 2013. (it is not necessary to prepare the worksheet.)lo6lo1

Take it all away has a cost of equity of 11.11 percent, a pretax cost of debt of 5.36 percent, and a tax rate of 40 percent. the company's capital structure consists of 67 percent debt on a book value basis, but debt is 33 percent of the company's value on a market value basis. what is the company's wacc