Tutor profile: Josh C.
Subject: Microsoft Excel
What must be true about multiple pivot tables in order for them to be controlled by one slicer?
They must share the same pivot cache.
A 5% coupon, 30 year annual bond has a yield-to-maturity of 7%. The par value is $1,000. Assume that YTM remains constant for the next ten years. What is the price of the bond today? What will the price of the bond be in one year? What is the capital gains yield for this bond? What is the current yield?
Price Today: $751.82 Price in One Year: $754.45 Capital Gains Yield: =(754.45-751.82)/751.82 =2.63/751.82 =0.35% Current Yield: =50/751.82 =6.65%
Return on equity, which measures the return per dollar of equity investment, reverts to the mean but in order to effectively predict earnings and estimate equity value, factors that affect the rate of ROE mean reversion must be considered. Provide examples of circumstances where the tendency of ROE to revert toward the mean is particularly strong.
1. The gap between current and normal profitability is large. 2. The relative magnitude of transitory items is high. 3. The relative magnitude of reinvested earnings and new capital investments is high. 4. ROE is highly volatile, implying that abnormal levels of ROE are likely due to temporary shocks.
needs and Josh will reply soon.