According to the lecture video on building dynamic charts, which of the following Excel functions are used in the "Refers to:" formula in Name Manager?
A) SUMIF
B) COUNTIF
C) OFFSET
D) COUNT

Answers

Answer 1

Answer:

OFFSET

COUNT

Explanation:

two options are correct, select both.

Answer 2

Answer:

Option C  and D are correct

Explanation:

OFFSET - From a cell or a range of cells, returns a reference to a range with a specified number of rows and columns.

COUNT - To determine the number of entries in a number field that is part of a range or array of values, use the COUNT function.


Related Questions

A firm's total cost function is given by the equation TC=4000+5Q+10Q and marginal cost is given by the equation MC=5+20Q
(A) Write an expression for each of the following cost concepts:
a. Total Fixed Cost
b. Average Fixed Cost
c. Total Variable Cost
d. Average Variable Cost
e. Average Total Cost
(B) Calculate the values of marginal cost and the costs in (a)-(e) above for Q=0,1,2,3.
(C) Determine the quantity that minimizes average total cost. Demonstrate that the predicted relationship between marginal cost and average cost holds.

Answers

The answer is A because of 5q allowing it to be MC

Following are the calculation to the given question:

[tex]\to TC = 4,000 + 5Q + 10 \ Q2\\\\\to MC = 5 + 20\ Q\\\\[/tex]

For point A)

[tex](a)\ TFC = 4,000\\\\(b)\ AFC = \frac{TFC}{ Q} = \frac{4,000}{ Q}\\\\(c)\ TVC = 5Q + 10\ Q2\\\\(d)\ AVC = \frac{TVC }{Q} = 50 + 10\ Q\\\\(e)\ ATC = \frac{TC }{ Q} = (\frac{4,000}{ Q}) + 50 + 10Q \ \text{Also, ATC = AVC + AFC}\\\\[/tex]

For point B)

TFC remains unchanged at 4,000, regardless of the price of Q.

i)

[tex]\to Q = 0[/tex]

AFC, AVC, and ATC cannot be calculated (division by zero is not possible).

ii)

[tex]Q = 1\\\\AFC =\frac{4,000}{ 1} = 4,000\\\\TVC = (5 \times 1) + (10 \times 1) =5 + 10 = 15\\\\AVC = \frac{TVC}{ Q} = \frac{15}{1} = 15\\\\ATC = 4,000 + 15 = 4,015\\\\MC = 5 + (20 \times 10 = 5 + 20 = 25[/tex]

iii)

[tex]Q = 2\\\\AFC = \frac{4,000}{ 2} = 2,000\\\\TVC = (5 \times 2) + (10 \times 2 \times 2) = 10 + 40 = 50\\\\AVC = \frac{50}{2} = 25\\\\ATC = 2,000 + 25 = 2,025\\\\MC = 5 + (20 \times 2) = 5 + 40 = 45\\\\[/tex]

iv)

[tex]Q = 3\\\\AFC = \frac{4,000}{ 3} = 1,333.33\\\\TVC = (5 \times 3) + (10 \times 3 \times 3) = 15 + 90 = 105\\\\AVC = \frac{105}{3} = 35\\\\ATC = 1,333.33 + 35 = 1,368.33\\\\MC = 5 + (20 \times 3) = 5 + 60 = 65\\\\[/tex]

For point C)

i)

[tex]ATC[/tex] is minimized when [tex]\frac{dATC}{dQ} = 0[/tex]

[tex](- \frac{4,000}{Q2} ) + 10 = 0\\\\\frac{4,000}{Q2} = 10\\\\Q2 = 400\\\\Q = 20\\[/tex]

ii)

Part (B) shows that as MC increases from Q = 0 to Q = 3, ATC decreases, validating the link.

Learn more:

brainly.com/question/15002834

Sam has contracted with Dave to purchase Dave's racing bike, with payment and delivery of the bicycle to be made 10 days after the contract was made. Three days later Sam hears that Dave is going to sell the bike to Gene in three days at a higher price. If Sam really wants the bike, what should he do? Multiple Choice Immediately seek injunctive relief. Immediately sue for specific performance. Immediately sue for compensatory damages. Immediately sue for consequential damages.

Answers

Answer: Immediately seek injunctive relief.

Explanation:

An injunctive relief is an order by the court stopping an action from taking place. From the question, we are told that Sam has contracted with Dave to buy Dave's racing bike, with payment and delivery of the bicycle to be made 10 days after the contract was made.

We are further told that three days later Sam hears that Dave is going to sell the bike to Gene in three days at a higher price. If Sam really wants the bike, he should seek injunctive relief. By doing so, the court will stop Dave from selling the bike to Gene.

On July 1, 20X1, James and Short formed a partnership. James contributed cash. Short, previously a sole proprietor, contributed property other than cash, including realty subject to a mortgage, which the partnership assumed. Short’s capital account on July 1, 20X1, should be recorded at

Answers

Answer:

James and Short LLC

Short's capital account on July 1, 20X1 should be recorded at the fair value of contributed property minus the mortgage liability, which the partnership assumed.

Explanation:

The fair value of contributed property is the current market value of the contributed property by Short.  It is the market value that will determine how the contributed property can be valued.  The market value assumes that the contributed property is being sold in pieces and not as a whole.  This is why the value is considered a fair basis for recognizing the capital contribution of Short into the partnership.

(Table) If Jake and Sue are the only buyers of the local pizzeria's pizza, what is the market demand for pizzas at each of the prices listed, starting at the market price of $5? QJ is the quantity demanded at each price by Jake, and QS is the quantity demanded at each price by Sue.

Answers

Answer:

This is the table that the question is referring to:

Price       QJ         QS

5              4             2

10             3             1

15             2            0

20            1             0

Total market demand is the sum of the individual market demands. In this market, it is the sum of the market demand of Jake and Sue.

Market demand at the price of $5 is 7 pizzas.

Market demand at the price of $10 is 4 pizzas.

Market demand at the price of $15 is 2 pizzas.

Market demand at the price of $20 is 1 pizza.

what is not a major benefit of co-locating team members from different cultures in one place instead of having a team

Answers

Incomplete question. Here are the options:

A. Short distance to the customer markets

B. Reduced burden from travelling and international meetings

C. Enhanced communications and a sense of community

D. Identical working hours without time zone difference

Answer:

A. Short distance to the customer markets

Explanation:

It is noteworthy to remember we are concerned about what is not a major benefit of co-locating team members from different cultures in one place instead of having a team.

The other benefits like; reduced burden from travelling and international meetings, enhanced communications and a sense of community and having Identical working hours without time zone difference are major in nature as they have a direct impact on cost savings and work efficiency.

Praveen Co. manufactures and markets a number of rope products. Management is considering the future of Product XT, a special rope for hang gliding, that has not been as profitable as planned. Since Product XT is manufactured and marketed independently of the other products, its total costs can be precisely measured. Next year’s plans call for a $350 selling price per 100 yards of XT rope. Its fixed costs for the year are expected to be $315,000, up to a maximum capacity of 550,000 yards of rope. Forecasted variable costs are $245 per 100 yards of XT rope.
Required:
1. Estimate Product XT's break-even point in terms of (a) sales units and (b) sales dollars.
2. Prepare a CVP chart for Product XT. Use 7,000 units (700,000 yards/100 maximum number of sales units on the horizontal axis of the graph, and $1,400,000 as the maximum dollar amount on the vertical axis.
3. Prepare a contribution margin income statement showing sales, variable costs, and fixed costs for Product XT at the break-even point.

Answers

Answer:

1a. 3,000 units

1b. $1,050,000

2. See attachment.

3. contribution margin income statement

Sales  ($350 × 7,000 units)                            $2,450,000

Less Variable Cost  ($245 × 7,000 units))     ($1,715,000)

Contribution                                                       $735,000

Less Fixed Costs                                              ( $315,000)

Operating Profit                                                 $420,000

Explanation:

Break-even point (sales units ) = Fixed Cost ÷ Contribution per unit

                                                   = $315,000 ÷ ($350 - $245)

                                                   = 3,000

Break-even point (sales dollars) = Fixed Cost ÷ Contribution Margin Ratio

                                                     = $315,000 ÷ ($105/$350)

                                                     = $1,050,000

If the price that determined where marginal revenue equaled marginal cost were below the bottom of the average variable cost curve, then the profit-maximizing, monopolistically competitive firm would

Answers

Answer: c. shut down because it would cost more to produce and sell output than it would to shut down and lose all fixed costs.

Explanation:

The profit maximizing, monopolistically competitive firm maximises profit at the point where marginal revenue equals marginal costs.

If this point is below Average variable costs then that means that the company is not making enough to cover its variable costs. Should this be the case then the company should shutdown operations because variable costs are only there when the company is producing. If they shutdown then they will no longer incur them which would be the cheaper option.

They would take losses on the fixed costs but these have already been incurred so it would be better to lose the fixed costs than continue to make losses on variable costs.

A firm is currently producing 3,000 units of output daily by employing 20 units of labor at a price of $100 per unit and 40 units of capital at a price of $40 per unit. The marginal product of the last unit of labor employed is 50, and the marginal product of the last unit of capital employed is 30. In order to minimize its production costs, the firm should do which of the following?
a. Employ more labor and less capital because the marginal product of labor is greater than the marginal product of capital.
b. Employ less labor and more capital because the firm is currently spending $2,000 on labor and only $1,600 on capital.
c. Employ more labor and less capital because the firm already employs 40 units of capital and only 20 units of labor.
d. Employ less labor and more capital because the marginal product per dollar spent on labor is less than the marginal product per dollar spent on capital.
e. Employ less labor and more capital because a unit of labor costs $100 while a unit of capital costs only $40.

Answers

Answer:

e. Employ less labor and more capital because a unit of labor costs $100 while a unit of capital costs only $40.

Explanation:

By employing less labor and more capital, the firm can produce the 3,000 units of daily output at lower production costs since 40 units of capital cost $40 per unit, than it can with 20 units of labor priced $100 per unit.  Capital can, therefore, minimize the total production costs, as less labor is used.  Capital resources are often in the form of equipment and technological advancement that make work easier, faster, and more efficient with the highest quality possible.

Based on the marginal products of labor and capital, the company should d. Employ less labor and more capital because the marginal product per dollar spent on labor is less than the marginal product per dollar spent on capital.

The company should invest more in the method of production that gives it more marginal product per unit.

Marginal product per unit of labor:

= Marginal product of labor / cost of labor

= 50 / 100

= 0.5 per unit

Marginal product per unit of capital:

= 30 / 40

= 0.75 per unit

Capital has more marginal product per unit and so should be invested in more than labor.

Find out more at https://brainly.com/question/13617399.

Fallow Corporation has two separate profit centers. The following information is available for the most recent year: West Division East Division Sales (net) $ 410,000 $ 560,000 Salary expense 47,000 61,000 Cost of goods sold 143,000 259,000 The West Division occupies 10,250 square feet in the plant. The East Division occupies 6,150 square feet. Rent, which was $ 82,000 for the year, is an indirect expense and is allocated based on square footage. Compute operating income for the West Division.

Answers

Answer:

$168,750

Explanation:

The data below are extracted from the above question.

West division

Sales (S) = $410,000

Salary expense (E) = $47,000

Cost of goods sold (C) = $143,000

Proportional rent (R) = $82,000 % of square footage

Area of the division = 10,250 square feet.

Total area of both division = 10,250 + 6,150

= 16,400 square feet

Therefore, the operating income (I) for the West Division is given by the amount of sales minus salary expenses , cost of goods sold and rent.

I = S - E - C - R

= $410,000 - $47,000 - $143,000 - (82,000 × 10,250 / 16,400)

= $220,000 - $51,250

= $168,750

The yearly operating income for Fallow's Corporation West Division is $168,750.

The smartest thing a firm involved in an oligopoly market could do is to cut their prices and capture more of the market share from their competitors.

a) We learned in class that the best move would be to raise prices.

b) We also learned that cutting prices on an elastic demand curve will be a smart way of getting more revenues.

c) Cutting prices is no gaurantee of success. Indeed if the firm does capture more market share and customers, then their costs will go up and it will be harder for them because they will have lower profit margins - if they can earn any profit at all.

d) Both A and C are correct.

Answers

Answer:

Correct Answer:

c) Cutting prices is no gaurantee of success. Indeed if the firm does capture more market share and customers, then their costs will go up and it will be harder for them because they will have lower profit margins - if they can earn any profit at all.

Explanation:

An oligopoly market is a market form wherein a market or industry is dominated by a small group of large sellers. A pure monopoly maximizes profits by producing that quantity where marginal revenue = marginal cost. however, it is much more difficult for an oligopoly to determine at what output it can maximize its profit.

Instruments had retained earnings of at December​ 31, . Net income for totaled ​, and dividends declared for were . How much retained earnings should report at December​ 31, ​?

Answers

Answer:

B. $ 490,000

Explanation:

According to the given situation, the computation of retained earning in the year end is shown below:-

Ending retained earning = Beginning Retained Earnings + Net Income for the year - Dividend

= $360,000 + $180,000 - $50,000

= $490,000

Therefore for computing the ending retained earning we simply applied the above formula.

The before-trade domestic price of tomatoes in the United States is $500 per ton. The world price of tomatoes is $400 per ton. The U.S. is a price-taker in the tomatoes market.
If trade in tomatoes is allowed, the United States:______
a) will experience increases in both consumer surplus and producer surplus.
b) may become either an importer or an exporter of tomatoes, but this cannot be determined.
c) will become an exporter of tomatoes.
d) will become an importer of tomatoes.

Answers

Answer:

d) will become an importer of tomatoes.

Explanation:

Consumer surplus would increase because the price at which they buy tomatoes would reduce while producer surplus would reduce because the price of tomatoes would reduce as a result of international trade.

Consumer surplus is the difference between the willingness to pay of a consumer and the price of the good.Because the price of tomatoes in the US is greater than the price of tomatoes in the world, when the US begins international trade, it would import tomatoes because it is inefficient in the production of tomatoes.  

Producer surplus is the difference between the price of a good and the least price the seller is willing to sell the product

Suppose that the value of an investment in the stock market has increased at an average compound rate of about 5% since 1912. It is now 2016. a. If someone invested $1,000 in 1912, how much would that investment be worth today?

Answers

Answer:

FV= $159,840.60

Explanation:

Giving the following information:

Initial investment= $1,000

Number of years= 2016 - 1912= 104

Interest rate= 5%

To calculate the value of the investment today, we need to use the following formula:

FV= PV*(1+i)^n

FV= 1,000*(1.05^104)

FV= $159,840.60

What is the expected annual capital gain yield for Orange Corp stock, based on the Constant Dividend Growth Model

Answers

Complete Question:

What is the expected annual capital gain yield for Orange Corp stock, based on the Constant Dividend Growth Model? The company plans to pay an annual dividend of of $4.12 per share in one year. The expected annual growth rate of the dividend is 12.9%, and the required rate of return for the stock is 16.63%. Answer as a percentage, 2 decimal places (e.g., 12.34% as 12.34).

Answer:

12.9%

Explanation:

As we know that:

Capital Gain Yield  = (P1 - P0) / P0

Step 1: Find P0

Po = D1  / (Ke - g)

Here

D1 is $4.12 per share

Ke is 16.63%

g is 12.9%

By putting values, we have:

Po = $4.12 / (16.63% - 12.9%)

= $110.46

Step 2: Find P1

P1 = D2  / (Ke - g)

Here

D2 = D1 * (1 + 12.9%) = $4.12 per share  * (1 + 12.9%) = $4.65

Ke is 16.63%

g is 12.9%

By putting values, we have:

Po = $4.65 / (16.63% - 12.9%)

= $124.70

Step3: Find Annual Capital Gain Yield

Capital Gain Yield  = (P1 - P0) / P0

Now by putting values, we have:

Capital Gain Yield  = ($124.7 - $110.46) / $110.46

= 12.9%

You purchased 1,000 shares of stock in Natural Chicken Wings, Inc., at a price of $43.37 per share. Since you purchased the stock, you have received dividends of $.95 per share. Today, you sold your stock at a price of $46.62 per share. What was your total percentage return on this investment?

Answers

Answer:

9.68%

Explanation:

Percent Return on Investment is calculated as Net Profit / Cost of Investment x 100

Net Profit= $46,620 (1,000 x $46.62 per share) + $950 (1,000 x $.95 per share) - $43,370 (1,000 x $43.37 per share) = $4,200

Cost of Investment= $43,370 (1,000 x $43.37 per share)

Percent Return on Investment=  $4,200 / $43,370 x 100 = 9.68%

A disadvantage of bonds is: Group of answer choices Bonds require payment of periodic interest Bonds require payment of principal Bonds can decrease return on equity Bond payments can be burdensome when income and cash flow are low All of the above

Answers

Answer:

All of the above.

Explanation:

A bond can be defined as a debt or fixed investment security, in which a bondholder (investor or creditor) loans an amount of money to the bond issuer (government or corporations) for a specific period of time. The bond issuer are expected to return the principal (face value) at maturity with an agreed upon interest (coupon), which are paid at fixed intervals.

The disadvantages of bonds are listed below as;

1. Bonds require payment of periodic interest.

2. Bonds require payment of principal.

3. Bonds can decrease return on equity.

4. Bond payments can be burdensome when income and cash flow are low.

You have invested 20 percent of your portfolio in Homer, Inc., 40 percent in Marge Co., and 20 percent in Bart Resources. What is the expected return of your portfolio if Homer, Marge, and Bart have expected returns of 2 percent, 18 percent, and 3 percent, respectively?

Answers

Answer:

Expected return = 8.2%

Explanation:

A portfolio is a collection of assets/ investment. The return on a portfolio is the weighted average of all the return of the individual assets weighted according to the percentage of total funds allocated to each assets.

Expected return on portfolio:

E(R) =( Wa*Ra) + (Wb*Rb)  + (Wc*Rc) + Wn*Rn

W= Weight i.e proportion of fund invested in each asset class

Wa = 20%, Wb- 40%, Wc- 20%

Ra-2%, Rb-18%, Rc- 3%

E(R) = (0.2 *2%) + (0.4× 18%) + (0.2*3%) = 8.2%

Expected return = 8.2%

Lead time for one of your​ fastest-moving products is 24 days. Demand during this period averages 110 units per day. ​a) What would be an appropriate reorder​ point? nothing units ​(enter your response as a whole​ number). ​b) How does your answer change if demand during lead time​ doubles? nothing units ​(enter your response as a whole​ number). ​c) How does your answer change if demand during lead time drops in​ half? nothing units ​(enter your response as a whole​ number).

Answers

Answer:

a.) reorder point = 2,640 units

b.) reorder point = 5,280 units (reorder point doubles)

c.) reorder point = 1,320 units (reorder point drops in half)

Explanation:

Reorder point is the inventory level (point) at which action is taken (order placed) to replenish the stocked item. It is calculated as follows:

Reorder point = (Lead time × average daily sales) + safety stock

Lead time = 24 days

average daily sales = 110 units

safety stock = 0 (not given)

a.) reorder point = (Lead time × average daily sales) + safety stock

reorder point = (24 × 110) + 0 = 2,640 units

b.) if demand during lead time doubles:

lead time = 24 days

average daily sales = (110 × 2) = 220

∴ reorder point = 220 × 24 = 5,280 units

Therefore the reorder point doubles

c.) if demand during lead time drops in half:

lead time = 24 days

average daily demand = (110 ÷ 2) = 55 units

∴ reorder point = 24 × 55 = 1,320 units

Therefore the reorder point drops in half.

United Apparel has the following balances in its stockholders’ equity accounts on December 31, 2018: Treasury Stock, $650,000; Common Stock, $400,000; Preferred Stock, $1,600,000; Retained Earnings, $1,200,000; and Additional Paid-in Capital, $6,800,000. Required: Prepare the stockholders’ equity section of the balance sheet for United Apparel as of December 31, 2018

Answers

Answer:

United Apparel Balance sheet as of December 31, 2018

Stockholders’ Equity section

Common Stock Capital ............................................$400,000

Preferred Stock Capital.............................................$1,600,000

Additional Paid-in Capital..........................................$6,800,000

Total Paid-in Capital....................................................$8,800,000‬

Retained Earnings.......................................................$1,200,000

Less: Treasury Stock...................................................($650,000)

Total Stockholders Equity..........................................$9,350,000

1. Discuss how core factors, cues to quality, and interpersonal factors of a product influence your buying decisions. Discuss with supporting examples.

Answers

Explanation:

Interpersonal product feature play a role in determining one's buying decision. For example, an individual who is open to new experiences may be more likely to try a new technology.

Another example is that of an individual who has a negative view of how he or she looks or dresses, he or she may tend to seek and buy products that could enhance how they feel about themselves.

As regards the quality of a product, it is usually based on the purchase plan period. For example, an individual who notices he needs an item urgently may be less likely to include quality in his buying decision, especially when it's a life-saving item for an emergency. But someone who has the time and has been planning to buy an item for months, will more likely examine quality before he makes a buying decision.

Conor Airlines Inc. recently issued $50 par value preferred stock that pays a 8.25% dividend rate per year. Yahoo.finance shows that the stock has a beta of 0.97. The current risk-free rate is 2.50% and the market return is 11%. Assuming that CAPM holds, what is the intrinsic value of this preferred stock?

Answers

Answer: $38.39

Explanation:

First calculate the required return according to CAPM;

Required return = Risk free rate + beta ( market return - risk free rate)

= 2.50% + 0.97 ( 11% - 2.50%)

= 10.745%

Then using the Dividend discount model and remembering that there is no growth rate;

Value = Next dividend / ( required return - growth rate)

= (50 * 8.25%) / ( 10.745% - 0)

= 4.125/10.745%

= $38.39

Answer:

$38.29

Explanation:

Ke = Rf+Beta*(Rm-Rf)

Ke=0.0250+0.97*(0.11+0.0250)

Ke=0.10745

Ke=10.75 appr.

Po= Dividend / (Ke-g)

Po= 50*0.0825 / (0.10745 - 0)

Po=4.125/0.10745

Po=38.3899

Po=38.29

Thus, the intrinsiv value of this preferred stock is $38.29

What is the present value of a perpetuity that pays you annual, end-of-year payments of $950? Use a nominal rate (monthly compounding) of 7.50%.

Answers

Answer:

The present value of the perpetuity is $12,242.27.

Explanation:

A perpetuity is an annuity that provide cash flow for an infinite period .Examples are Non -redeemable Preference Share.

Present Value (perpetuity) = Payments ÷ Required Rate

But, first change the 7.50 % nominal rate to Annual Effective Rate to match the period of Cash flow.

Effective Rate = (1 + r / m)^m - 1

                       = ( 1 + 0.0750 / 12) ^12 -1

                       = 7.76%

Therefore, Present Value (perpetuity) = $950 ÷  7.76%

                                                              = $12,242.27

At the certain interest rate, present value (PV) is the current value of a future sum of money or stream of cash flows.

The discount rate determines the present value of the cash flows, and the higher the discount rate, the lower the current value of future cash flows.

The present value of the perpetuity is $12,242.27.

A perpetuity is an annuity that payments out during an indefinite period of time. Non-redeemable Preference Share is an example.

Present Value (perpetuity) = [tex]\frac{\text{Payments}}{\text{Required Rate}}[/tex]

However, to match the Working capital period, change a 7.50 percent nominal rate to a Yearly Effective Tax rate.

[tex]\text{Effective Rate} = (1 + \frac{r}{m} )^m - 1= [1 + \frac{0.0750}{12}]^{12} -1= 7.76\%[/tex]

Therefore, Present Value (perpetuity)= [tex]\frac{\$950}{7.76\%} = $12,242.27[/tex]

To know more about the calculations of the present value, refer to the link below:

https://brainly.com/question/15036500

The simple rate of return is also called all of the following except ________. annual rate of return unadjusted rate of return accounting rate of return

Answers

Answer: annual rate of return

Explanation:

The simple rate of return is also called the unadjusted rate of return or the accounting rate of return.

The simple rate of return is calculated when the incremental net operating income for the year is taken and then divided by the initial investment.

It should be noted that it's not called the annual rate of return.

Despite the theoretical elegance of this hypothesis, empirical studies have come to the opposite conclusion. Despite the favorable effect of international diversification of cash flows, bankruptcy risk was only about the same for MNEs as for domestic firms. However, MNEs faced higher costs for each of the following EXCEPT:
A) agency costs.
B) political risk.
C) asymmetric information.
D) In fact, each of these costs were higher for the MNE than for the domestic firm.

Answers

Answer:

D) In fact, each of these costs were higher for the MNE than for the domestic firm.

Explanation:

It has been concluded through empirical studies, that Multinational Enterprises, MNEs encounters various factors leading to lower debt ratios and a higher cost of long-term debt, such as greater agency costs, political risk, asymmetric information, and foreign exchange risk,

Hence, given the question above, the right answer is option D "In fact, each of these costs was higher for the MNE than for the domestic firm."

Ten years ago you put $150000.00 into an interest earning account. Today it's worth $275000. What is the effective annual interest earned on the account

Answers

Answer:

the effective annual interest earned on the account is 6.25%.

Explanation:

The effective annual interest earned on the account can be calculated as follows :

PV = - $150,000

N = 10

PMT = $0

P/yr = 1

FV = $275,000

R = ?

Using a Financial calculator, the  effective annual interest, R, earned on the account will be : 6.2488 or 6.25%.

At an output level of 53,000 units, you calculate that the degree of operating leverage is 3.21. If output rises to 57,000 units, what will the percentage change in operating cash flow be? Suppose fixed costs are $175,000. What is the operating cash flow at 46,000 units? The degree of operating leverage? that the degree of operating

Answers

Answer:

If output rises to 57,000 units, what will the percentage change in operating cash flow be?

24.23%

What is the operating cash flow at 46,000 units?

$45,613.84

The degree of operating leverage (at 46,000 units)?

4.84

Explanation:

degree of operating leverage = [quantity x (price - variable costs)] / {[quantity x (price - variable costs)] - fixed costs}

degree of operating leverage x {[quantity x (price - variable costs)] - fixed costs} = [quantity x (price - variable costs)]

3.21 x {[53000 x (contribution margin)] - fixed costs} = [53000 x (contribution margin)]

(3.21 x 53000 x contribution margin) - (3.21 x 175000) = 53000 x contribution margin

let C = contribution margin

170130C - 561750 = 53000C

117130C = 561750

C = 561750 / 117130 = 4.795953

operating cash flow (at 53,000) = (53,000 x $4.795953) - $175,000 = $79,185.52

operating cash flow (at 57,000) = (57,000 x $4.795953) - $175,000 = $98,369.32

% change = ($98,369.32 - $79,185.52) / $79,185.52 = 24.23%

operating cash flow (at 46,000) = (46,000 x $4.795953) - $175,000 = $45,613.84

% change in operating cash flows = ($45,613.84 - $79,185.52) / $79,185.52 = -43.4%

% change in sales = (46,000 - 53,000) / 53,000 = -13.21

degree of operating leverage = $220,613.84 / $45,613.74 = 4.84

If a bank that faces a 10% reserve ratio received a deposit of $50,000 and makes a loan to a customer for $5,000, what is the consequence if the bank then deposits the rest of the funds at the Federal Reserve?

Answers

Answer:

Excess reserve increases by $40,000

Required reserve increases by $5,000

Explanation:

In order to calculate the reserve, we need to multiply the Deposit received by a required reserve ratio.

DATA

Reserve ratio = 10%

Deposit received = $50,000

Loan to customer = $5,000

Solution

Reserve =  Deposit x Required reserve ratio

Reserve = $50,000 x 10%

Reserve = $5,000

After providing a $5,000 loan to the customer and keeping $5,000 as a reserve remaining $40,000 would be deposited in the Federal Reserve.

Two investment advisors are comparing performance. Advisor A averaged a 20% return with a portfolio beta of 1.5 and Advisor B averaged a 15% return with a portfolio beta of 1.2. If the T-bill rate was 5% and the market return during the period was 13%, which advisor was the better stock picker?

Answers

Answer:

Advisor A

Explanation:

t bill rate = 0.05

market rate = 0.13

the beta of the market is always 1

the rate of return= 0.05 + (0.13 - 0.05) x 1

= 0.13

which is 13%

this is for advisor A.

with a return of 20% and 1.5 beta

0.05 + ( 0.20 - 0.05) x 1.5

= 27.5% for advisor b

when the return is 15% and beta is 1.2

0.05 + (0.15 - 0.05) x 1.2

= 17%

Therefore advisor a is better

Refer to the following lease amortization schedule. The five payments are made annually starting with the inception of the lease. A $2,000 bargin purchase option is exercisable at the end of the five-year lease. The asset has an expected economic life of eight years.
Lease Payment Cash Payment Effective Interest Decrease in Balance Balance
34,600
1 8,000 ?? ?? 26,600
2 8,000 2,660 5,340 21,260
3 8,000 2,126 5,874 15,386
4 8,000 1,539 6,461 8,925
5 8,000 ?? ?? ??
6 2,000 182 1,818 0
What is the effective annual inerest rate?
A. 9%
B. 10%
C. 11%
D. 20%

Answers

Answer:

B. 10%

Explanation:

The computation of the effective annual interest rate is shown below:-

Effective annual interest rate = Lease payment third effective interest ÷ Lease payment second balance × 100

= $2,126 ÷ $21,260 × 100

= 10%

Therefore for computing the effective annual interest rate we simply applied the above formula.

Hence the correct option is B.

All of the following actions by a custodian in an account opened under the Uniform Gifts to Minors Act are permitted except:_______.
A. donating funds to the account to make additional investments
B. withdrawing funds from the account for the custodian's use
C. managing the investments in the account with the objective of generating enough income for college tuition
D. selling securities in the account to generate proceeds for other investments

Answers

Answer: B. withdrawing funds from the account for the custodian's use

Explanation:

Under the Uniform Gifts to Minors Act, the Custodian's duty is to manage the account for the minor and allocate the assets within in such a way that it will bring about the best returns for the minor.

Custodians should not abuse this power for their own benefit or gain which is why the custodian withdrawing funds from the account for their own use is a violation of the act.

Other Questions
Please answer. I need this to be done, Thanks. Will give brainliest We can reach the temperature 120 C In water bath Instrument from :A) It is not possible. B) Set up the pressure on 1.5 Kg/cm2. C) Set up the temperature on 100 C D) Set up the temperature on 120 C For we must consider that we shall be as a city upon a hill. The eyes of all people are upon us. So that if we shall deal falsely with our God in this work we have undertaken, and so cause Him to withdraw His present help from us, we shall be made a story and a by-word through the world. Based on this excerpt, what was John Winthrops goal? to make Massachusetts Bay Colony an example of Christian living to make Plymouth Colony an example of Christian living to establish Massachusetts Bay Colony as a place of religious tolerance to establish Plymouth Colony as a place of religious tolerance 41 =12d-7 d= Math is not my strong suit. I love to read and write but I can not do math without a little bit of help. Poseidon Marine Stores Company manufactures special metallic materials and decorative fittings for luxury yachts that require highly skilled labor. Poseidon uses standard costs to prepare its flexible budget. For the first quarter of the year, direct materials and direct labor standards for one of their popular products were as follows: Direct materials: pounds per unit; per pound Direct labor: hours per unit; per hour Poseidon produced units during the quarter. At the end of the quarter, an examination of the labor costs records showed that the direct labor cost variance was F. Which of the following is a logical explanation for this variance?A. The company paid a lower cost for the direct materials than allowed by the standards. B. The company used a lower quantity of direct materials than allowed by the standards. C. The company paid a lower cost per hour for labor than allowed by the standards.D. The company used fewer labor hours than allowed by the standards, Nijah has 45 stickers.She gives 2/5 to her sister.She gives 1/3 of her remaining stickers to Brett.How many stickers does Nijah have left? he beginning share price for a security over a three-year period was $50. Subsequent year-end prices were $62, $58 and $64. The arithmetic average annual rate of return and the geometric average annual rate of return for this stock were: Several reasons were provided for why many professional sports teams are struggling to sell the naming rights to their venues. What is the central reason that teams like the Washington Nationals have not yet been able to find a naming rights partner Two of the lights at the local stadium are flickering. They both just flickered at the same time.One of the lights flickers every 7 seconds and the other light flickers every 8 seconds.How many seconds until both lights will flicker at the same time again?seconds Josh wants to sign up for a gaming website. It will allow him to download games. He cant find a privacy policy. Should he join the website?A. Sure, you know how much josh likes to play gamesB. Yes, theres not much personal information that josh shares by playingC. No, Josh could be sharing all sorts of information that he doesnt want to. Without understanding the privacy policy, he wont know what they collect and why What can I do to make this better? Which reasons did you include in your answer? Many people moved from rural areas to cities in search of jobs. Immigrants came to the United States, and most settled in cities. Businesses located their factories and corporate headquarters in cities. Rail lines made transportation to and from cities easier. A box contain 12 balls in which 4 are white 3blue and 5 are red.3 balls are drawn at random from the box. Find the chance that all three balls are of different colour Challenge Question! If a pregnant woman had a karyotype prepared for her baby before birth, would it be more useful in predicting the risk of Down Syndrome or Tay Sachs disease? A testcross involves an individual exhibiting the dominant phenotype but an unknown genotype being crossed with an individual that has a(n) ___________ genotype. Draw the function [tex]y = \tan(x) [/tex] on the interval [-pi, pi] HELP ME PLZZZ!! ILL MARK YOU BRAINLIEST Which statement is an ineffective claim? Fast food restaurants are dangerous to America's youth. The driving age should be raised for three clear reasons. The United States should increase spending for nuclear power. Violent video games make teenagers more violent. what is the value of this expression when g= -3.5?8-|2g-5|a. 20b. 10c. 6d. -4 what is -7 + 11 - 14 + 3 + 12 Q1: You have to select an idea developing an application like web/mobile or industrial, it should be based on innovative idea, not just a simple CRUD application. After selecting the idea do the following: 1) How your project will be helpful and what problem this project addresses. (10-Marks) 2) Write down the requirements. (10Marks) 3) List the functional and non-functional requirements of your project. (10marks) 4) Which process model you will follow for this project and why? (10marks) 5) Draw the Level 0, and level 1 DFD of your application. (20marks)