Answer:
Calculating the bill total for the week:
The Sum Function in excel is a very easy mathematical operation to sum the daily bill amounts. In the cell for the sum, you can manually enter the sum function by typing (=sum), then you define the parameters (=sum(C50:I50). One you press the "enter" the result is automatically displayed. This can also be automatically done by pressing the Sum Function on the Ribbon or Alt + =.
Explanation:
In Microsoft Excel, the Sum Function is a mathematical operation or syntax that provides the formula for adding, subtracting, or getting the total numerical content of indicated cells. With the Sum Function of Excel you can add, subtract, multiply, and divide, for example A1 * A4, C20/A2, A4 - A5, and so on.
Answer:
A. have no effect.
Explanation:
The US Treasury Bill was purchased at short-term
So it would not affect the company's cash balance.
The rule for short-term invstment is to have litle risk
and a mature of less than 90 days
the US TB fullfil both, it has no risk and matures within 90 days It is considered a cash equivalent.
The question is incomplete. Here is the complete question:
The following annual returns for Stock E are projected over the next year for three possible states of the economy. What is the stock’s expected return and standard deviation of returns? E(R) = 8.5% ; σ = 22.70%; mean = $7.50; standard deviation = $2.50
State Prob E(R)
Boom 10% 40%
Normal 60% 20%
Recession
30% - 25%
Answer:
The expected return of the stock E(R) is 8.5%.
The standard deviation of the returns is 22.7%
Explanation:
<u>Expected return</u>
The expected return of the stock can be calculated by multiplying the stock's expected return E(R) in each state of economy by the probability of that state.
The expected return E(R) = (0.4 * 0.1) + (0.2 * 0.6) + (-0.25 * 0.3)
The expected return E(R) = 0.04 + 0.12 -0.075 = 0.085 or 8.5%
<u>Standard Deviation of returns</u>
The standard deviation is a measure of total risk. It measures the volatility of the stock's expected return. The standard deviation (SD) of a stock's return can be calculated by using the following formula:
SD = √(rA - E(R))² * (pA) + (rB - E(R))² * (pB) + ... + (rN - E(R))² * (pN)
Where,
- rA, rB to rN is the return under event A, B to N.
- pA, pB to pN is the probability of these events to occur
- E(R) is the expected return of the stock
Here, the events are the state of economy.
So, SD = √(0.4 - 0.085)² * (0.1) + (0.2 - 0.085)² * (0.6) + (-0.25 - 0.085)² * (0.3)
SD = 0.22699 or 22.699% rounded off to 22.70%
The yearly budget law, which covers the revenue and expenditure forecasts for a particular year, is planned, approved, executed, and audited within the permanent legal framework provided by the constitution, the budget organic law, and financial rules.
<h3>
What is the Importance of a Budget in business?</h3>
It allows the business owner to focus on cash flow, cost-cutting, boosting earnings and boosting returns on investment. The cornerstone of every successful firm is budgeting. It assists with both planning and maintaining control over the company's finances.
An evaluation of a company's anticipated financial resources or the resources needed to finish a project constitutes a budget estimate. A budget estimate is a rough estimation of the amount of money that will likely be needed to finish a project or the amount of money that will be predicted to be available to a firm or organization.
Learn more about Budget here:
brainly.com/question/15683430
#SPJ1
Answer:
The balance in the account = $851.8
Explanation:
The future value of a lump sum is the amount expected at a future date when a sum of money is invested today at a particular rate of interest for certain number of years
.
This implies compounding the initial amount invested ($300) at the given interest rate(11%) for 10 years.This will be done as follows:
<em />
FV = PV × (1+r)^(n)
FV-Future value
r- rate of return per period
n- Number of period
PV - 300
r-11%
DATA
FV- ?
PV - 300
n- 10
FV= 300 × 1.11^10 = 851.83
The balance in the account = $851.8
