Answer:
a. Copy the data range D7:D9, then click on cell D6 and paste while selecting the date format. The formula will appear in the formula bar as +4;365 days.
b. Copy the data range D7:D9, select cell D6 and paste with the date format chosen. The formula will be displayed as -3;365 days in the formula bar.
c. Type in the formula bar as =365 days; +2: E6
d. In the formula bar input =365 days; +2: C6
Explanation:
Excel enables users to perform complicated calculations with ease through a single function. Users can create and connect various worksheets, displaying data either in tabular forms or as simple text. It offers multiple tools to generate annually filtered worksheets.
a. 11.5% Explanation: Fad followers are investors who join trends as they appear, resulting in their betas being lower than that of informed investors, who make moves beforehand. By applying the Capital Asset Pricing Model for expected return calculation. Er = Rf + b( Rm - Rf) Er = Expected return Rf = Risk Free Rate b = Beta Rm = Market Return. The expected return for informed investors is, = 4% + 1.4 ( 10% - 4%) = 4% + 1.4 ( 6%) = 12.4% Given that fad followers have a lower beta, implying a lower expected return in comparison to informed investors, the only viable choice is 11.5%.
Elysha's debt-to-income ratio is considered good.
The net capital expenditure for Beta is 95.
Explanation:
To determine Beta's net capital expenditure, use the formula below
Closing PP&E + Depreciation Expense - Opening PP&E
= 170 + 75 - 150
= 95
In this computation, the depreciation expense is added, and the PP&E balance is subtracted from the closing PP&E balance to obtain a precise figure.
Alternatively, it can be calculated based on the capital expenditures derived from a company's income statement and balance sheet. Check for the depreciation expense recorded for the current period in the income statement and find the current period’s property, plant, and equipment in the balance sheet.
Answer:
The first statement is false, while the second is true.
