o calculate the actual rate of return on an investment accounting for varying cash flows, which Excel function is appropriate?  A. IRR  B. XIRR  C. NPV  D. FV

Multiple Choice QuestionThe formula to calculate the accounting rate of return is:Multiple choice question.annual income/average investmentannual income before tax/average investmentannual income/initial investment

a) To calculate the rate of return on operations, we need to use the formula for Return on Common Equity (ROCE), which is: ROCE = Return on Operations + (Return on Operations - After-tax net borrowing cost) * Financial Leverage Given that ROCE is 40%, Financial Leverage is 40% and After-tax net borrowing cost is 5%, we can rearrange the formula to solve for Return on Operations: Return on Operations = ROCE - (Return on Operations - After-tax net borrowing cost) * Financial Leverage Substituting the given values: Return on Operations = 0.40 - (Return on Operations - 0.05) * 0.40 Solving for Return on Operations, we get approximately 29.17%. b) If the firm repurchases $125 million of its stock and finances the repurchase with further borrowing at a 5% after-tax borrowing cost, the firm's financial leverage will increase. This is because financial leverage is the proportion of debt a firm uses to finance its assets, and in this case, the firm is increasing its debt. If the same level of operating profitability is maintained, the increase in financial leverage will result in a higher ROCE. This is because the firm is using more debt to finance its operations, and the cost of this debt is less than the return on its operations. Therefore, the excess return will increase the overall ROCE. However, it's important to note that while increasing financial leverage can boost ROCE, it also increases the firm's financial risk. If the firm's operating profitability declines, it may struggle to meet its debt obligations. ####

Which financial statement is used to calculate the return on investment for shareholders?Question 18Answera.Balance sheetb.Income statementc.Statement of retained earningsd.Statement of cash flows

The internal rate of return on this investment is closest to: blank1 - Numeric Answer

Internal Rate of Return (IRR) is defined as the discount rate at which Net Present Value (NPV) of the cash flows is equal to zero.Group of answer choicesTrueFalse