Answer:
a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.
b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.
c. In the formula bar type =365 days; +2 : E6
d. In the formula bar type =365 days ; +2 : C6
Explanation:
Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.
That statement is true
A stated interest rate is the return of investment that is not compounded by the interest accumulation throughout the years.
In general, a stated interest rate will give us a lower amount of return compared to effective annual interest rate that compound the accumulation throughout the years,
The answers are the following:
a.
Brandon:
$7,000 + [($10,000/4)×3¿= $8,500
Ryan:
$7,000 + [($10,000/4)×1¿= $7,500
b.
Brandon $7,000
Ryan <span>$7,000</span>
Answer:
11.14%
Explanation:
Blume's formula is used to combine both arithmetic and geometric returns. This is because using arithmetic growth rate exclusively would be overly optimistic for longer time horizons and on the other hand, using geometric growth rates exclusively would be overly pessimistic for short time horizons.
Using the attached formula, plug in the given numbers;
R(T) would be the sale growth rate we need to calculate.
R(T) = 
R(T) =0.0257 + 0.0857
R(T) = 0.1114 as a decimal
Therefore, the forecast sales growth would be 11.14%
