Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started