You have a stock portfolio that consists of the following positions (price and beta as of 7:40 AM on 10/22/2020): Shares Price Beta
Amazon 25 $3,138.71 1.35
Apple 90 $115.96 1.31
Tesla 85 $429.11 1.69
Costco 75 $373.9 20.69
Disney 50 $126.25 1.10

Required:
a. What is the portfolio beta?
b. If the market return is expected to be 5% and the risk-free rate is 1%, then what is the required rate of return of the portfolio?

In a sumif conditional function, what should be the order of terms in the parentheses?

The monthly payment m of a loan of amount p for y years with an interest rate r can be calculated by the formula: m = p(r/12) 1 â’ (1 + r/12)â’12y calculate the monthly payment and the cummulative total payment for a $100,000 loan with an interest rate of 4.85% if taken out for 10 years, for 11 years, etc., up to a 30 year term. display the results in a three-column table where the first column is the number of years, the second is the monthly payment, and the third is the cummulative total payment. note: use format bank; for this problem. also, remember to represent the interest rate as a decimal (e. g. 0.0485) 2. a torus-shaped water tube is designed to have a volume of 8, 000in3 . the volume of the tube, v , and its surface area, s, are given by: v = 1 4 ď€ 2 (a + b)(b â’ a) 2 s = ď€ 2 (b 2 â’ a 2 ) if a = kb, determine s, a, and b for k = 0.2, 0.3, 0.7. display the results in a table

Which of the following statements is correct? a. two firms with identical sales and operating costs but with different amounts of debt and tax rates will have different operating incomes by definition. b. free cash flow (fcf) is, essentially, the cash flow that is available for interest and dividends after the company has made the investments in current and fixed assets that are necessary to sustain ongoing operations. c. retained earnings as reported on the balance sheet represent cash and, therefore, are available to distribute to stockholders as dividends or any other required cash payments to creditors and suppliers. d. if a firm is reporting its income in accordance with generally accepted accounting principles, then its net income as reported on the income statement should be equal to its free cash flow. e. after-tax operating income is calculated as ebit(1 - t) + depreciation.