Compute the amount of ending unappropriated retained earnings for a C corporation based on the following data in an excell spreadsheet showing work.

Beginning unappropriated retained 100,000 earnings Net income per books 80,000 Taxable income 74,000 Federal income tax per books Cash dividends 17,500 distributed 116.000