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:
1.265
Explanation:
According to the situation, the solution of the beta of portfolio is as follows
Beta portfolio = (weightage of investment F × beta F) + (proportion of investment G ×beta G)
Beta protfolio = (0.5 × 1.08) + (0.5 × 1.45)
= 0.54 + 0.725
= 1.265
Hence, the beta of your portfolio is 1.265 by applying the above formula
Answer:
Zigzag Manufacturing
The Effectiveness of Leslie Demorest's Budgeting Strategy
The strategy of adjusting the previous year's operating expenses with inflation is not an effective way of strategic budget planning. Leslie's budgeting strategy does not take advantage of forecasts of unexpectedly good performance and fails to provide any reaction that can occur when there are downturns in cash flow.
An effective budgeting strategy should provide the standard for the effective use of financial resources of Zigzag Manufacturing in its business operations. There are no clear goals to be achieved and an evaluation of how the goals will be achieved through the budget implementation.
Explanation:
An effective budget should be able to forecast and track revenues and expenses, which are received and incurred in pursuit of business goals and projections. An effective budget ensures that those who implement the projections contained in the budget remain motivated. The idea of adjusting previous expenses with inflation is not an effective budgeting strategy.
Answer:
$22,820
Explanation:
Calculation to determine Determine the present value of the par value of the bonds.
Discount rate =8%/2
Discount rate= 4%
Present value factor of 20 periods at 4%= ( 1 / 1.04^20 )
Present value factor of 20 periods at 4%=0.4564
Using this formula
Present value of the par value of the bond = Future value of the bond x Present value factor =
Let plug in the formula
Present value of the par value of the bond=$50,000 x 0.4564
Present value of the par value of the bond = $22,820
Therefore the present value of the par value of the bonds is $22,820
Answer:
10.25%
Explanation:
Data provided in the question:
Long-term debt = 45%, after-tax cost = 7%
Preferred stock = 15%, after-tax cost = 10%
Common stock equity = 40%, after-tax cost = 14%
Now,
The weighted average cost of capital for this firm will be calculated as:
= Long term debt × after-tax cost + Preferred stock × after-tax cost + Common stock equity × after-tax cost
or
= 0.45 × 0.07 + 0.15 × 0.10 + 0.40 × 0.14
or
= 0.0315 + 0.015 + 0.056
= 0.1025
or
= 0.1025 × 100%
= 10.25%