In my lectures I showed how to conduct “What-if sensitivity”…

In my lectures I showed how to conduct “What-if sensitivity” analysis in Excel looking for the changes in the results, depending on the change of a single variable at a time. In particular, the exercise included the request in Excel to calculate a certain tax rate that would change the Net Present Value from an original amount to another precisely specified amount (e.g., $ 4,000). What was the name of the function that was used to conduct this type of sensitivity analysis?

Micro Advantage Inc. hast $ 6,000,000 preferred stock outsta…

Micro Advantage Inc. hast $ 6,000,000 preferred stock outstanding that it sold for $ 21 per share. The preferred stock has a per share value of $20 and pays $2 dividend per year. The current market price is $ 26 per share. The firm’s tax bracket is 20 %. What is the after-tax cost of the preferred stock?