Use Excel Functions Please

1. Elvis Humperdinck is a retired tightrope walker. Mr. Humperdinck relies mostly on his dividend check from RRR Corp. to meet living expenses. He owns 10,000 shares of RRR, which pays a dividend of $1 per share, and he is in the 15 percent tax bracket.

a. Calculate Mr. Humperdincks after-tax dividend proceeds.

b. Suppose that the taxing authorities raise Mr. Humperdincks tax rate to 25 percent. How much higher would the dividend of RRR need to be in order to keep Elviss after-tax dividend income the same as it was under the old tax rates?

2. Worn Out Equipment, Inc., has the following year-end balance sheet values for its depreciable assets:

Equipment	$478,213	Buildings	$8,648,382
Less Accumulated Depreciation	265,111	Less Accumulated Depreciation	2,424,171
Net Equipment	$213,102	Net Buildings	$6,224,211

a. Determine the values for equipment, accumulated depreciation on equipment, and net equipment at the end of the next year if, until that time, the firm does not buy or sell any equipment but expenses another $52,099 of depreciation.

b. Determine the values for buildings, accumulated depreciation on buildings, and net buildings at the end of the next year if, during the next year, the firm buys a new building for $1.5 million and takes total depreciation (including the new building) of $404,764.