The return on Visa stock has a standard deviation of 30% and the return on Walmart stock has a standard deviation of 21%. Their correlation is 0. 67.

If you invest 80% in Visa and 20% in Walmart, what is the variance of the portfolio?

What is the standard deviation of the portfolio?

If possible, can you show how to solve in excel. Thank you!

Answers

Answer 1

The variance of the portfolio is 0.017166 and the standard deviation is 13.1%. Diversification can help reduce overall risk in a portfolio.

To calculate the variance of a portfolio, we need to take into account the individual variances of each asset, as well as the correlation between them. The formula for the variance of a two-asset portfolio is:

[tex]$\text{Var}(\text{portfolio}) = w_1^2 \times \text{Var}(\text{asset 1}) + w_2^2 \times \text{Var}(\text{asset 2}) + 2 \times w_1 \times w_2 \times \text{Cov}(\text{asset 1, asset 2})$[/tex]

where [tex]w_1[/tex] and [tex]w_2[/tex] are the weights of asset 1 and asset 2, respectively, and Cov(asset 1, asset 2) is the covariance between asset 1 and asset 2.

Given that we are investing 80% in Visa and 20% in Walmart, we can calculate the weights as [tex]w_1[/tex] = 0.8 and [tex]w_2[/tex] = 0.2. We also know that the standard deviation of Visa is 30% and the standard deviation of Walmart is 21%. Since the correlation between the two stocks is 0.67, we can calculate the covariance as:

Cov(Visa, Walmart) = Corr(Visa, Walmart) x StdDev(Visa) x StdDev(Walmart) = 0.67 x 0.3 x 0.21 = 0.04221

Substituting these values into the formula above, we get:

[tex]$\text{Var}(\text{portfolio}) = (0.8^2 \times 0.3^2) + (0.2^2 \times 0.21^2) + 2 \times (0.8 \times 0.2 \times 0.04221) = 0.017166$[/tex]

Therefore, the variance of the portfolio is 0.017166.

To calculate the standard deviation of the portfolio, we simply take the square root of the variance:

[tex]$\text{StdDev}(\text{portfolio}) = \sqrt{0.017166} = 0.131$[/tex]

Therefore, the standard deviation of the portfolio is 13.1%. This means that if we invest in this portfolio, we can expect our returns to fluctuate by approximately 13.1% around the expected return. It is important to note that diversification, as seen in this portfolio, can help to reduce the overall risk of an investment portfolio.

To learn more about portfolio

https://brainly.com/question/31528207

#SPJ4


Related Questions

Consider a market with two​ firms, Kellogg and​ Post, that sell breakfast cereals. Both companies must choose whether to charge a high price ​($5. 00 ​) or a low price ​($3. 50 ​) for their cereals. These price​ strategies, with corresponding​ profits, are depicted in the payoff matrix to the right. ​ Kellogg's profits are in red and​ Post's are in blue. What is the cooperative equilibrium for this​ game? A. The cooperative equilibrium is for Kellogg to choose a price of ​$3. 50 and Post to choose a price of ​$5. 0. B. The cooperative equilibrium is for Kellogg and Post to both choose a price of ​$3. 50. C. The cooperative equilibrium is for Kellogg and Post to both choose a price of ​$5. 0. D. A cooperative equilibrium does not exist for this game. E. The cooperative equilibrium is for Kellogg to choose a price of ​$5. 00 and Post to choose a price of ​$3. 50

Answers

The cooperative equilibrium for Kellogg and Post to both choose a price of $3.50. This is because both firms can achieve higher profits by cooperating and setting a low cost, rather than competing and setting a high price. The correct option is B.

In game theory, cooperative equilibrium refers to a situation where players in a game cooperate to achieve a mutually beneficial outcome, even though they could potentially gain more by acting independently or competitively.

In the given scenario, Kellogg and Post are two firms that sell breakfast cereals, and they have to choose between two price strategies - charging a high price of $5.00 or a low price of $3.50. The payoff matrix shows the corresponding profits for each firm based on their pricing decisions.

To find the cooperative equilibrium, we need to identify a pricing strategy that would benefit both firms and result in a mutually profitable outcome. In this case, both Kellogg and Post can achieve maximum profits by choosing a low price of $3.50. This strategy is the best for both firms because they both earn higher profits ($6 million for Kellogg and $4 million for Post) than they would if they chose the high-price strategy.

Therefore, the correct option is B.

Learn more about Game theory: https://brainly.com/question/15539917

#SPJ11

An American deposits $10,000 in an account in a London bank. In the U. S. Balance of payments, this transaction causes the balance on the _____ account to _____.

financial; increase

financial; decrease

current; increase

current; decrease

Answers

The correct answer is "financial; decrease" when considering the U.S. balance of payments. Thus option B is the answer.

Suppose, when an American deposits $10,000 in an account in a London bank, it is considered a financial transaction because it involves the transfer of funds between countries. This transaction represents an inflow of foreign investment into the United Kingdom, resulting in an increase in the financial account balance for the UK.

However, from the perspective of the U.S. balance of payments, the transaction causes a decrease in the financial account balance. This is because the deposit by the American in the London bank represents an outflow of financial capital from the U.S. to the UK.

The financial account measures the flow of financial capital between countries, and a deposit by an American in a London bank represents a decrease in the U.S. financial account balance. Therefore, the correct answer is "financial; decrease" when considering the U.S. balance of payments.

Read more about the Balance of payments,

https://brainly.com/question/30363536

If a supplier can sell as much as it wants at $10 per unit, but none at all at $10.01, we know that the demand it faces is

Answers

If a supplier can sell as much as it wants at $10 per unit, but none at all at $10.01, this suggests that the demand they face is very price-sensitive or elastic.

This means that even a slight increase in price can lead to a significant decrease in the quantity of units demanded by consumers.

In this case, the supplier is operating in a market where consumers have many alternative options and can easily switch to another supplier if the price becomes too high.

Therefore, the supplier must carefully balance the price of their product with the demand from consumers to ensure they can sell as many units as possible while still maintaining profitability.

To know more about elastic refer here:

https://brainly.com/question/31030279#

#SPJ11

Sell or Process Further Ecolab produces cleaning and sanitizing chemicals for commercial markets. Assume the company processes raw material D into joint products E and F. Raw material D costs $8 per liter. It costs $150 to convert 100 liters of D into 60 liters of E and 40 liters of F. Product F can be sold immediately for $40 per liter or processed further into Product G at an additional cost of $12 per liter. Product G can then be sold for $55 per liter. Determine whether Product F should be sold or processed further into Product G. Calculate the net advantage (disadvantage) of further processing. Use a negative sign to indicate a net disadvantage (if applicable). $Answer per liter

Answers

The total cost of producing 40 liters of F is:

$150 + (40 liters x $8/liter) = $470

The revenue from selling 40 liters of F is:

40 liters x $40/liter = $1,600

If product F is processed further into G, the additional cost per liter is $12. Therefore, the total cost of producing 40 liters of G is:

$470 + (40 liters x $12/liter) = $938

The revenue from selling 40 liters of G is:

40 liters x $55/liter = $2,200

The net advantage of further processing is the additional revenue from selling G minus the additional cost of processing:

Net advantage = ($2,200 - $1,600) - ($938 - $470)

Net advantage = $600 - $468

Net advantage = $132

Since the net advantage is positive, it is more profitable to process F further into G. The net advantage of further processing is $132 per liter of F.

To know more about costs , refer here :

https://brainly.com/question/15135554#

#SPJ11

You work for rev, incorporated, and have misplaced your phone. according to the frequently asked questions presented, rev can use rdm to:

Answers

Rev, Incorporated can use RDM to locate your misplaced phone, protect sensitive data, and restore the device if needed. Remember to report the issue to your company's IT department to initiate the process.

How Rev, Incorporated can use RDM to assist you with your misplaced phone. Here's a step-by-step explanation:

1. First, RDM stands for Remote Device Management. It is a system that allows companies like Rev, Incorporated to manage and control devices, such as smartphones, remotely.

2. In the case of a misplaced phone, the first thing you should do is report the issue to your company's IT department or responsible personnel.

3. Once reported, Rev's IT team can utilize the RDM system to locate your misplaced phone. This is done by accessing the device's GPS data, which will provide an approximate location of the phone.

4. If the phone is nearby or within the company premises, the IT team can use RDM to make the phone emit a sound or vibration to help you find it more easily.

5. In case the phone cannot be located or is suspected to be stolen, RDM allows Rev's IT team to remotely lock the device and protect sensitive company information stored on it.

6. If necessary, the IT team can also use RDM to remotely wipe the device's data, ensuring that important company data is not compromised.

7. Once the phone is found or replaced, the IT team can utilize RDM to restore any necessary company data and applications onto the device.

To know more about RDM refer to

https://brainly.com/question/30711974

#SPJ11

Sun Airlines, Inc., prints on its tickets that it is not liable for any injury to a passenger caused by the airline’s negligence. If the cause of an accident is found to be the airline’s negligence, can it use the clause as a defense to liability? Why or why not?

Answers

No, it cannot use the clause as a defense to liability if the cause of an accident is found to be the airline’s negligence.

About use the clause as a defense to liability

The reason for this is that any contract or agreement that attempts to limit or waive liability for negligence is considered invalid under the law. This is because such a clause would violate public policy and undermine the protection of the public against the negligence of others.

Therefore, even if Sun Airlines includes a clause on its tickets stating that it is not liable for injuries caused by its negligence, it would still be held accountable if its negligence is found to be the cause of an accident that resulted in passenger injuries.

Learn more about contract at

https://brainly.com/question/30224677

#SPJ11

What is the cash realizable value of the accounts receivable before the write-off and after the write-off?.

Answers

The cash realizable value of accounts receivable refers to the estimated amount of cash that a company expects to collect from its outstanding customer invoices.

Before the write-off: The cash realizable value of accounts receivable before the write-off would be the total amount of outstanding invoices that the company expects to collect from its customers.

After the write-off: The cash realizable value of accounts receivable after the write-off would be the remaining outstanding invoices that the company expects to collect after deducting the amount that was written off.

Thus, the specific amounts of the cash realizable value before and after the write-off would depend on the individual circumstances and the accounting policies of the company in question.

Learn more about cash realizable value here:

https://brainly.com/question/30262965

#SPJ12

Paused Egoism is an example of virtues. True False

Answers

The given statement "Paused Egoism is an example of virtues. " is false because Paused Egoism is not an example of virtues.

Paused Egoism refers to when an individual will not always pursue their own self-interest; rather, they will take into account the interests of others when making decisions. This means that while the individual is still considering their own needs and wants, they are also considering the needs and wants of others.

Paused Egoism is an example of the ethics of egoism because it recognizes the importance of self-interest, but also acknowledges that self-interest must be balanced against the interests of others in order to achieve the greatest good for the greatest number. It is not, however, an example of virtues as virtues refer to a moral standard of behavior that is based on principles such as honesty, integrity, and courage.

Virtues are qualities that people have, which are seen as good, moral, or desirable. Some examples of virtues include honesty, loyalty, generosity, kindness, and compassion. Virtues are often seen as important because they help individuals to develop positive relationships with others and to live a good life. They are also seen as important because they help to promote social harmony and cooperation.

You can learn more about virtues at

https://brainly.com/question/9520498

#SPJ11

Norwood Company reported a receivables turnover ratio of 8. 3. Cost of goods sold was $365,000 and net sales revenue was $522,900. The average net receivables must have been:

Answers

Norwood Company reported a receivables turnover ratio of 8. 3. Cost of goods sold was $365,000 and net sales revenue was $522,900. The average net receivables must have been is $63,012.05.

To calculate the average net receivables, we can use the formula for the receivables turnover ratio:

Receivables Turnover Ratio = Net Sales / Average Net Receivables

We are given that the receivables turnover ratio is 8.3, and net sales revenue is $522,900. Therefore, we can calculate the average net receivables as follows:

8.3 = 522,900 / Average Net Receivables

Average Net Receivables = 522,900 / 8.3

Average Net Receivables = $63,012.05

Therefore, the average net receivables for Norwood Company must have been $63,012.05.

To know more about ratio , refer here :

https://brainly.com/question/13419413#

#SPJ11

Starbucks has an agreement with pepsico through which pepsi distributes starbucks' coffee drink, frappuccino, to grocery stores and other retail outlets. This is an example of

Answers

Starbucks and Pepsi have a partnership in which Pepsi provides grocery shops and other retail establishments with Starbucks' coffee beverage, the Frappuccino. An illustration of a strategic alliance is this agreement.

A strategic partnership is an agreement between two businesses where they work together to produce benefits for both parties. In this instance, Starbucks and PepsiCo have teamed up to deliver their well-known Frappuccino coffee drink to supermarkets and other retail locations. As a result, PepsiCo will have a new product to offer its consumers in addition to enabling Starbucks to go more than only their own outlets.

Joint ventures, licencing arrangements, and alliances are just a few examples of the various shapes that strategic relationships may take. Companies frequently utilise them to get access to new markets, pool resources, or create new goods.

Learn more about agreement Visit: brainly.com/question/27899951

#SPJ4

The reduction of waste creation is an example of a(n): tangible benefit. profitable benefit. operational benefit. intangible benefit. qualitative benefit.

Answers

The reduction of waste creation is an example of an intangible benefit.

Intangible benefits are those that are difficult to quantify or measure in monetary terms. They are often related to social, environmental, or ethical considerations, and may not have a direct impact on a company's financial performance. In this case, reducing waste creation may not result in a direct financial benefit to the company, but it can have positive effects on the environment and society as a whole. For example, it can reduce pollution and waste disposal costs, promote sustainable practices, and enhance the company's reputation and brand image.

Tangible benefits, on the other hand, are those that can be quantified and measured in monetary terms, such as increased revenue, decreased costs, or improved efficiency. Profitable benefits are those that result in financial gains for the company, while operational benefits are those that improve the company's processes or systems. Qualitative benefits are those that are difficult to quantify but can still be observed and evaluated, such as improved customer satisfaction or employee morale.

Therefore, reducing waste creation is an example of an intangible benefit that can have a positive impact on the environment and society, but may not have a direct financial benefit for the company.

learn more about intangible benefit here:

https://brainly.com/question/16791017

#SPJ11

Suppose stock returns can be explained by a two-factor model. The firm-specific risks for all stocks are independent. The following table shows the information for two diversified portfolios:





β1 β2 E(R)


Portfolio A. 83 1. 13 17%


Portfolio B 1. 43 −. 23 15




If the risk-free rate is 4 percent, what are the risk premiums for each factor in this model? (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e. G. , 32. 16. )



Looking for:


Factor F1 = ____%


Factor F2 = ____%

Answers

To find the risk premiums for each factor in the two-factor model, we first need to calculate the expected returns for each portfolio. We can do this using the following formula:

E(R) = Rf + β1 * premium1 + β2 * premium2

where Rf is the risk-free rate, β1 and β2 are the factor loadings for each portfolio, and premium1 and premium2 are the risk premiums for each factor.

For Portfolio A, we have:

E(R) = 0.04 + 0.83 * premium1 + 1.13 * premium2
0.17 = 0.04 + 0.83 * premium1 + 1.13 * premium2

For Portfolio B, we have:

E(R) = 0.04 + 1.43 * premium1 - 0.23 * premium2
0.15 = 0.04 + 1.43 * premium1 - 0.23 * premium2

We can solve these equations simultaneously to find the values of premium1 and premium2:

0.17 = 0.04 + 0.83 * premium1 + 1.13 * premium2
0.15 = 0.04 + 1.43 * premium1 - 0.23 * premium2

Multiplying the first equation by -1.43 and adding it to the second equation gives:

-0.24 = -1.11 * premium1 - 1.59 * premium2

Multiplying the first equation by -1.59 and adding it to the second equation gives:

0.0391 = -0.71 * premium2

Solving for premium2 gives:

premium2 = -0.0391 / -0.71 = 0.055

Substituting this value into either of the original equations gives:

premium1 = (0.17 - 0.04 - 1.13 * premium2) / 0.83 = 0.107

Therefore, the risk premiums for each factor in this model are:

Factor F1 = 10.7%
Factor F2 = 5.5%

Know more about risk premiums here:

https://brainly.com/question/28235630

#SPJ11

John is a very diligent worker committed in carrying out his duties. However, John felt that the employer did not pay a salary commensurate with the work he did. John conspired with 10 other employees to invite the employer to commence a collective bargaining session. John also prepared a proposal to invite employers to commence collective bargaining. The proposal was sent to the employer on 2 March 2022. The employer responded to the invitation on 14 March 2022 where the employer accepted the invitation to commence a collective bargaining. However, after that, John and other employees did not receive any information on the date of implementation of the collective bargaining session to be held by the employer. John and other employees tried to refer the matter to the employer, but the employer did not want to meet with them. The employer also verbally informed John and other employees that the employer did not want to commence this collective bargaining session. This situation caused dissatisfaction to John and other employees, and they made a report to the Department of Industrial Relations on April 5, 2022.
Based on the above scenario, answer all questions as follows:
a. Briefly explain the main function of collective bargaining. Justify your answer with the appropriate sections and acts. (15 marks)
b. Does the John and other employees have the eligibility and authority to invite employers for collective bargaining? Discuss your answer with appropriate sections and acts.(15 marks)

Answers

a. The main function of collective bargaining is to negotiate terms and conditions of employment between employees (usually represented by a union) and employers. b. John and the other employees do have the eligibility and authority to invite their employer for collective bargaining.

a. The main function of collective bargaining is to reach an agreement between an employer and a union concerning terms and conditions of employment. This process aims to reach an agreement on various aspects, such as wages, working hours, benefits, and other working conditions. The agreement is reached through negotiations, with each party making proposals and counter-proposals until a mutually acceptable agreement is reached.

Section 13 of the Industrial Relations Act 1967 provides for the appointment of a trade union as an agent in collective bargaining. The agent has the right to negotiate with the employer on behalf of the union's members.

Section 14 of the Industrial Relations Act 1967 defines collective agreements and the manner in which they are to be registered. It establishes the legal status of collective agreements and ensures that they are binding on the parties to the agreement. It also specifies the procedure for amending or terminating a collective agreement.

b. According to Section 3 of the Industrial Relations Act 1967, employees have the right to form or join trade unions of their choice. Section 2 defines a trade union as an association of workers whose primary purpose is to promote and protect their economic and social interests. As a result, John and other employees have the right to invite their employer to commence collective bargaining.

Section 18 of the Industrial Relations Act 1967 outlines the procedure for commencing collective bargaining. The union must make a written request to the employer for collective bargaining. The employer must then respond in writing within fourteen days, either accepting or rejecting the request.

If the employer accepts the request for collective bargaining, the parties must then arrange to meet and commence negotiations. However, if the employer rejects the request for collective bargaining, the union may file a dispute with the Director General of Industrial Relations, who may then refer the matter to the Industrial Court for adjudication.

In conclusion, John and other employees are eligible and authorized to invite their employer to commence collective bargaining, as provided for in Section 3 and Section 18 of the Industrial Relations Act 1967.

Learn more about Collective bargaining:

https://brainly.com/question/30395254

#SPJ11

How much do you have to deposit today in order to allow 5 annual withdrawals, beginning at the end of year 8, with the first withdrawal of $1000 with subsequent withdrawals decrease at the rate of 5% over previous year’s withdrawal? The interest rate is 10%

Answers

You need to deposit $1908.03 today to allow for the 5 annual withdrawals beginning at the end of year 8, with the first withdrawal of $1000 and subsequent withdrawals decreasing at a rate of 5% over the previous year's withdrawal, given a 10% interest rate.


To determine how much to deposit today, we'll use the concept of present value (PV) for both the initial deposit and the withdrawals. We are given the interest rate (10%) and the withdrawal amounts, which decrease at the rate of 5% per year.

First, let's find the present value of each withdrawal:
1. PV of 1st withdrawal = $1000 / (1.10)^7 = $513.16
2. PV of 2nd withdrawal = $1000 * 0.95 / (1.10)^8 = $436.74
3. PV of 3rd withdrawal = $1000 * 0.95^2 / (1.10)^9 = $371.64
4. PV of 4th withdrawal = $1000 * 0.95^3 / (1.10)^10 = $316.67
5. PV of 5th withdrawal = $1000 * 0.95^4 / (1.10)^11 = $269.82

Next, sum up the present values of all the withdrawals: $513.16 + $436.74 + $371.64 + $316.67 + $269.82 = $1908.03

For more about interest rate:

https://brainly.com/question/13324776

#SPJ11

Asteria earned a $26,200 salary as an employee in 2022. How much should her employer have withheld from her paycheck for fica taxes?

Answers

Asteria's employer should have withheld a total of $2,001.30 from her paycheck for FICA taxes in 2022.

FICA taxes are the federal taxes that are withheld from the paychecks of employees in the United States to fund Social Security and Medicare programs. The amount of FICA taxes withheld from an employee's paycheck depends on their income and their filing status.

For the year 2022, the FICA tax rate for Social Security is 6.2%, and the maximum taxable earnings subject to the Social Security tax is $147,000. The FICA tax rate for Medicare is 1.45%, and there is no maximum taxable earnings limit for Medicare.

To calculate the FICA taxes that Asteria's employer should have withheld from her paycheck, we first need to determine her taxable income. Assuming that Asteria had no pre-tax deductions or adjustments, her taxable income would be her gross income of $26,200.

For Social Security taxes, the employer should withhold 6.2% of the first $147,000 of Asteria's taxable income, which comes out to $1,621.40. For Medicare taxes, the employer should withhold 1.45% of all of Asteria's taxable income, which comes out to $379.90.

To learn more about paycheck

https://brainly.com/question/31171390

#SPJ4

The world price of a pound of almonds is $4. 50. before uruguay allowed trade in almonds, the price of a pound of almonds there was $3. 0. once uruguay began allowing trade in almonds with other countries, uruguay began:.

Answers

Once Uruguay began allowing trade in almonds with other countries, the price of a pound of almonds in Uruguay would have increased.

This is because the world price of almonds is higher than the price that was being charged in Uruguay before trade was allowed.

The world price of almonds is determined by the forces of supply and demand on a global scale.

Since Uruguay is now participating in the global market, it would have to adjust its price to the world price in order to remain competitive.

This is because consumers in Uruguay now have access to cheaper almonds from other countries.

In summary, allowing trade in almonds with other countries would lead to an increase in the price of almonds in Uruguay as it adjusts to the world price.

To know more about Uruguay refer here:

https://brainly.com/question/14191792#

#SPJ11

Long-Term Financing NeededAt year-end 2019, Wallace Landscaping's total assets were $2. 40 million, and its accounts payable were $405,000. Sales, which in 2019 were $3. 2 million, are expected to increase by 35% in 2020. Total assets and accounts payable are proportional to sales, and that relationship will be maintained. Wallace typically uses no current labitles other than accounts payable. Common stock amounted to $475,000 in 2019, and retained earnings were 5235,000. Wallace has arranged to sell $55,000 of new common stock in 2020 to meet some of its financing needs. The remainder of its financing needs will be met by Issuing new long-term debt at the end of 2020. (Because the debt is added at the end of the year, there will be no additional interest expense due to the new debt. ) Its net profit margin on sales is 6%, and 45% of earnings will be paid out as dividends. A. What was Wallace's total long-term debt in 2019? Do not round Intermediate calculations. Enter your answer in dollars. For example, an answer of $2 million should be entered as 2,000,000. Round your answer to the nearest dollar, What were Wallace's total abilities in 2019? Do not found intermediate calculations, enter your answer in dollars. For example, an answer of $2 million should be entered as 2,000,000. Round your answer to the nearest dollar b. How much new long-term debt financing will be needed in 2007 in N New stock. Now long term debt. ) Do not found intermediate calculations. Enter your answer in dolara For example, an answer of $2 million should be entered an 2,000,000, Round your answer to the nearest dollar

Answers

Wallace did not have any long-term debt at the end of 2019. The new long-term debt financing needed in 2020 will be $3,050,479.

a. To calculate Wallace's total long-term debt in 2019, we need to first calculate its total liabilities. We know that its total assets were $2.40 million, and its accounts payable were $405,000. We are also given that total assets and accounts payable are proportional to sales, so we can use this information to calculate the total liabilities:

Total assets = $2.40 million

Accounts payable = $405,000

Sales = $3.2 million

Accounts payable as a percentage of sales = $405,000 ÷ $3.2 million = 0.1266

Total liabilities as a percentage of sales = accounts payable as a percentage of sales = 0.1266

Total liabilities = total assets × total liabilities as a percentage of sales = $2.40 million × 0.1266 = $303,840

To calculate the total long-term debt, we need to subtract the current liabilities (accounts payable) from the total liabilities:

Total long-term debt = Total liabilities - Accounts payable = $303,840 - $405,000 = -$101,160

It's important to note that a negative result for total long-term debt indicates that the company did not have any long-term debt at the end of 2019.

b. We know that Wallace will sell $55,000 of new common stock in 2020, so we can use this information along with the projected increase in sales to calculate the financing needed from new long-term debt:

Projected sales for 2020 = $3.2 million × 1.35 = $4.32 million

Projected total assets for 2020 = $2.40 million × 1.35 = $3.24 million

Projected total liabilities for 2020 = projected total assets × total liabilities as a percentage of sales = $3.24 million × 0.1266 = $410,544

Projected accounts payable for 2020 = projected total liabilities × accounts payable as a percentage of total liabilities = $410,544 × 0.1266 = $52,009

To calculate the total financing needed, we need to subtract the projected increase in equity (from the new common stock sale) and the projected increase in retained earnings from the projected total assets:

Projected increase in equity = $55,000

Projected increase in retained earnings = (6% net profit margin × $4.32 million) × (1 - 45% dividend payout ratio) = $82,512

Financing needed = projected total assets - projected increase in equity - projected increase in retained earnings - accounts payable = $3.24 million - $55,000 - $82,512 - $52,009 = $3,050,479

Therefore, the new long-term debt financing needed in 2020 will be $3,050,479.

To learn more about debt

https://brainly.com/question/31102427

#SPJ4

Tailwind Inc. , produces high-quality but expensive training shoes for runners. The Tailwind show, which sells for $210, contains both gas- and liquid-filled compartments to provide more stability and better protection against knee, foot, and back injuries. Manufacturing the shoes requires 10 separate tasks. There are 400 minutes available for manufacturing the shoes in the plant each day. Daily demand is 60. The information for the tasks is as follows (with time in minutes): What is the system Cycle Time and the minimum number of workstations

Answers

The Cycle Time and the minimum number of workstations for Tailwind Inc is

1. Daily demand: [tex]60[/tex] shoes
2. Total available time for manufacturing: [tex]400[/tex] minutes
3. Task times for each of the 10 tasks (not provided, but we will refer to them as [tex]T1, T2, ... T10)[/tex]

Step 1: Calculate the System Cycle Time
Cycle Time [tex]= Total available time / Daily demand[/tex]

Cycle Time [tex]= 400 minutes / 60 shoes[/tex]
Cycle Time [tex]= 6.67 minutes per shoe[/tex]
Step 2: Calculate the Total Task Time
Total Task Time [tex]= T1 + T2 + T3 + ... + T10[/tex]


Step 3: Calculate the Minimum Number of Workstations
Minimum Workstations [tex]= Total Task Time / Cycle Time[/tex]

Minimum Workstations [tex]= (T1 + T2 + ... + T10) / 6.67[/tex]


Since we do not have the actual task times [tex](T1, T2, ... T10)[/tex], you'll need to add those times and use the equation above to find the minimum number of workstations required for manufacturing Tailwind shoes.

To know more about cycle time visit here:

https://brainly.com/question/29669039

#SPJ11

hat was the most significant impact of this suburbanization process on American culture more broadly?

Answers

The most significant impact of the suburbanization process on American culture more broadly was the creation of a suburban lifestyle that became synonymous with the American Dream.

Suburbanization is the process by which people move from urban areas to suburban areas. During the 1950s and 1960s, suburbanization grew as more Americans sought to live in areas with more space, privacy, and natural beauty. The post-World War II economic boom and the widespread availability of automobile transport made suburbanization possible. People fled the cities to the suburbs to avoid the congestion, noise, and pollution of urban life.

The suburbanization process made housing more affordable, and suburban life became synonymous with the American Dream. American culture was profoundly influenced by the suburbanization process. The suburbanization process was a significant factor in the development of the automobile industry, as people needed cars to travel from the suburbs to the cities.

As a result, automobile manufacturers started producing cars that were larger, more powerful, and more luxurious to meet the demands of the suburban market. Additionally, the rise of the suburban lifestyle created a new consumer culture in which people bought homes, appliances, furniture, and other goods to decorate their homes and create a comfortable lifestyle.

You can learn more about urbanization at

https://brainly.com/question/12007420

#SPJ11

Kristina remembered that her roommate's sportstrend bike worked well and looked sleek. Kristina had a sunsetter bike when she was growing up which she liked but it was known for bright neon colors. At the bike store, she saw both brands for about the same price and decided to buy the sportstrend bike. Which type of consumer choice process does this demonstrate?

Answers

This illustrates a utilitarian approach to customer or consumer decision-making. Kristina is weighing the advantages and disadvantages of the two bikes to see which one provides the most value for her money.

Kristina recalled how her roommate's sportstrend bike was stylish and well-functioning. Growing up, Kristina owned a Sunsetter bike, which she adored but was noted for its vivid neon colours.

She is thinking about the bike's functionality, like its dependability and sleek design, as well as its attractiveness on a visual level, like whether it is something she would be pleased to possess. She is making her choice based on a reasonable study of the qualities of the items, not on sentimental considerations or personal beliefs.

Learn more about consumer Visit: brainly.com/question/380037

#SPJ4

Akron, inc., owns all outstanding stock of toledo corporation. amortization expense of $15,000 per year for patented technology resulted from the original acquisition. for 2021, the companies had the following account balances:

akron toledo
sales $1,100,000 $600,000
cost of goods sold 500,000 400,000
operating expenses 400,000 220,000
investment income not given 0
dividends declared 80,000 30,000

intra-entity sales of $320,000 occurred during 2020 and again in 2021. this merchandise cost $240,000 each year. of the total transfers, $70,000 was still held on december 31, 2020, with $50,000 unsold on december 31, 2021. for consolidation purposes, does the direction of the transfers (upstream or downstream) affect the balances to be reported here?

Answers

The direction of the intra-entity transfers (upstream or downstream) does not affect the balances to be reported in the consolidated financial statements because they have already been eliminated in consolidation.

For consolidation purposes, the direction of the transfers (upstream or downstream) does not affect the balances to be reported here because the intra-entity sales and related cost of goods sold have already been eliminated in consolidation.

In the consolidation process, the parent company (Akron, Inc.) combines the financial statements of the subsidiary (Toledo Corporation) with its own financial statements to present a consolidated view of the overall financial position and performance of the combined entity.

The intra-entity sales and cost of goods sold are eliminated to avoid double-counting them in the consolidated financial statements. This means that only the sales and cost of goods sold to external customers are included in the consolidated financial statements.

Therefore, the balances to be reported in the consolidated financial statements are based on the external transactions of both companies with third parties, as well as any intercompany transactions that have not been eliminated in consolidation, such as the investment income received by Akron, Inc. from Toledo Corporation.

for more such questions on  financial statements

https://brainly.com/question/26240841

#SPJ11

Santana Rey has found that Business Solutions line of computer desks and chairs has become very popular, and she is finding it hard to keep up with demand. She knows that she cannot fill all of her orders for both items, so she decides she must determine the optimal sales mix given the resources she has available. Information about the desks and chairs follows. Desks Chairs Selling price per unit $ 1,046. 25 $ 301. 00 Variable costs per unit 440. 00 110. 00 Contribution margin per unit $ 606. 25 $ 191. 00 Direct labor hours per unit 5 hours 4 hours Expected demand for next quarter 166 desks 50 chairs Santana has determined that she only has 970 direct labor hours available for the next quarter and wants to optimize her contribution margin given the limited number of direct labor hours available. Required: Determine the optimal sales mix and the contribution margin the business will earn at that sales mix. (Round per unit amounts to 2 decimal places. )

Answers

The optimal sales mix is to produce 132 desks and 37 chairs, and the business will earn a contribution margin of $86,956.25 at this sales mix.

To determine the optimal sales mix, we need to calculate the contribution margin per unit of each product and the contribution margin per unit of the constrained resource (direct labor hours).

For desks:

Contribution margin per unit = Selling price per unit - Variable costs per unit

= $1,046.25 - $440.00

= $606.25

Contribution margin per direct labor hour = Contribution margin per unit / Direct labor hours per unit

= $606.25 / 5 hours

= $121.25 per hour

For chairs:

Contribution margin per unit = Selling price per unit - Variable costs per unit

= $301.00 - $110.00

= $191.00

Contribution margin per direct labor hour = Contribution margin per unit / Direct labor hours per unit

= $191.00 / 4 hours

= $47.75 per hour

To optimize the contribution margin given the limited direct labor hours, we need to allocate the available hours in proportion to the contribution margin per hour of each product.

Let X be the number of desks and Y be the number of chairs.

The total direct labor hours required for X desks and Y chairs are:

5X + 4Y

We need to maximize the contribution margin:

Maximize Z = 606.25X + 191Y

Subject to the constraints:

5X + 4Y <= 970

X >= 0

Y >= 0

We can solve this linear programming problem using the simplex method or graphical method.

Using the graphical method, we plot the constraint 5X + 4Y = 970 as a straight line and shade the feasible region below and to the left of the line. Then, we plot the objective function Z = 606.25X + 191Y as a straight line with a negative slope and find the point where it is tangent to the feasible region.

The optimal sales mix is:

X = 132 desks

Y = 37 chairs

The contribution margin at this sales mix is:

Z = 606.25(132) + 191(37)

= $86,956.25

Therefore, the optimal sales mix is to produce 132 desks and 37 chairs, and the business will earn a contribution margin of $86,956.25 at this sales mix.

To learn more about  contribution margin  here

https://brainly.com/question/24881206

#SPJ4

Butterfly Collective launches a new TV advertising campaign in support of its line of housepaints. In this campaign, the company bought insertions within two programs. It bought 2 insertions within one program which got a rating of 5.5, at a cost of $276,597 per insertion. It bought 3 insertions within a second program which got a 4.5 rating, at a cost of $383,693 per insertion. Calculate cost per point (CPP) for this campaign as a whole. (Rounding: penny.)Butterfly Collective sent out 14,777 emails enticing recipients to come to the website and purchase a butterfly-theme flower vase. Of those emails, 351 were not delivered to addressees. Of the rest, 7,357 were opened by recipients, 3,361 recipients clicked through to the website, and 103 recipients puchased the flower vase. Calculate OPEN RATE.

Answers

It bought 3 insertions within a second program which got a 4.5 rating, at a cost of $383,693 per insertion. We need to find the cost per point (CPP) for this campaign as a whole.CPP (cost per point) = (Total cost of campaign) ÷ (Total rating points of campaign)

Total cost of campaign = (2 × $276,597) + (3 × $383,693) = $1,709,369Total rating points of campaign = (2 × 5.5) + (3 × 4.5) = 24.5CPP = $1,709,369 / 24.5 = $69,974.69Cost per point (CPP) for this campaign as a whole is $69,974.69 (rounded to the nearest penny).Calculation of the open rate:

Total emails sent out = 14,777Number of emails not delivered = 351Total emails delivered = 14,777 - 351 = 14,426Number of emails opened by recipients = 7,357Number of emails that were clicked through to the website = 3,361Number of recipients who purchased the flower vase = 103Open rate = (Number of emails opened / Number of emails delivered) × 100%Open rate = (7,357 / 14,426) × 100% = 51.19%Therefore, the open rate is 51.19%.

Read more about campaign here:https://brainly.com/question/30104473

#SPJ11

break-even sales and sales to realize a target profit for the current year ending october 31, papadakis company expects fixed costs of $451,000, a unit variable cost of $44, and a unit selling price of $66. a. compute the anticipated break-even sales (units). fill in the blank 1 units b. compute the sales (units) required to realize a target profit of $103,400. fill in the blank 2 units

Answers

a) The anticipated break-even sales (units) for the current year ending October 31 is 11,275 units.

b) The sales (units) required to realize a target profit of $103,400 for the current year ending October 31 is 5,750 units.

a) To calculate the anticipated break-even sales (units), we need to determine the number of units that the company needs to sell to cover its fixed and variable costs. We can use the following formula to calculate break-even sales:

Break-even sales (units) = Fixed costs ÷ (Unit selling price - Unit variable cost)

Plugging in the given values, we get:

Break-even sales (units) = $451,000 ÷ ($66 - $44) = 11,275 units

b) To compute the sales (units) required to realize a target profit of $103,400, we need to use the following formula:

Sales (units) = (Fixed costs + Target profit) ÷ (Unit selling price - Unit variable cost)

Plugging in the given values, we get:

Sales (units) = ($451,000 + $103,400) ÷ ($66 - $44) = 5,750 units

In summary, break-even sales and sales to realize a target profit are important concepts for businesses to understand their financial performance.

Break-even sales help businesses determine the minimum sales volume they need to cover their costs, while sales to realize a target profit help businesses set and achieve their profit goals.

To learn more about sales click on,

https://brainly.com/question/31391151

#SPJ4

Flesch Corporation produces and sells two products. In the most recent month, Product C90B had sales of $23,520 and variable expenses of $5,880. Product Y45E had sales of $36,000 and variable expenses of $14,400. The fixed expenses of the entire company were $15,800. If the sales mix were to shift toward Product C90B with total dollar sales remaining constant, the overall break-even point for the entire company:

Answers

If the sales mix were to shift toward Product C90B with total dollar sales remaining constant, the overall break-even point for the entire company would be $22,898.55.

The contribution margin ratio for each product

Contribution Margin = Sales - Variable Expenses

for product C90B

[tex]Contribution Margin =23,520 - 5,880 \\\\Contribution Margin =$17,640[/tex]

Contribution Margin Ratio = Contribution Margin / Sales

for product C90B

[tex]Contribution Margin Ratio =\frac{ 17,640}{23,520} \\\\\\ Contribution Margin Ratio = 0.75 or 75%[/tex]%

Product Y45E

[tex]Contribution Margin = $36,000 - $14,400\\Contribution Margin = $21,600[/tex]

[tex]Contribution Margin Ratio =\frac{21,600}{36,000 } \\Contribution Margin Ratio = 0.6 or 60%[/tex]%

overall contribution margin for both products

[tex]Overall Contribution Margin Ratio = (0.6 * 0.75) + (0.4 * 0.6) \\ Overall Contribution Margin Ratio = 0.69[/tex]

Overall Contribution Margin Ratio=69%

Overall Break-Even Point = Fixed Expenses / Overall Contribution Margin Ratio

[tex]Overall Break-Even Point = \frac{15,800}{ 0.69} = $22,898.55[/tex]

Therefore, the overall break even point of the company is $22,898.55.

Learn more about break-even point at:

brainly.com/question/29063970

#SPJ4

Caterpillar is the world's leading maker of earth-moving machinery and supplier of agricultural equipment. Caterpillar wants to end its support for its Dealer Business System (DBS), which it licenses to its dealers to help them run their business. The software in this system is becoming outdated and senior management want to transfer support for the hosted version of the software to Accenture Consultants so it can concentrate on its core business. Caterpillar never required its dealers to use DBS, but the system has become a de facto standard for doing business with the company. The majority if its 50 Cat dealers in North America use some version of DBS, as do about the half of the other too or so Cat dealers in the rest of the world. Before Caterpillar turns the product over to Accenture, they call you in as a change consultant. What factors and issues should it consider? What questions should it ask? What questions should its dealers ask?

Answers

1. As a change consultant, Caterpillar needs to consider several factors and issues before it turns over its Dealer Business System (DBS) to Accenture.

First, it needs to understand the impact of this decision on its dealers, who have become reliant on the software to conduct their business with the company. Caterpillar needs to ensure that its dealers are not left stranded without the necessary support to use the software effectively.

Second, Caterpillar should evaluate the costs associated with transferring the support for the hosted version of the software to Accenture. This includes not just the financial costs but also the time and resources required for the transition. Caterpillar needs to ensure that the transfer is seamless and does not disrupt its dealers' operations.

Third, Caterpillar should also consider the impact on its own core business. While ending support for DBS may allow Caterpillar to focus more on its core business, it also risks alienating its dealers, who are an essential part of its value chain. Caterpillar needs to ensure that the transfer does not negatively impact its relationship with its dealers.

2. As for the questions Caterpillar should ask, it needs to understand Accenture's capabilities and experience in supporting similar software systems. Caterpillar should also inquire about the timeline and process for the transfer of support and how Accenture plans to ensure a smooth transition for its dealers. It also needs to ask the right questions to understand Accenture's capabilities and experience and ensure a smooth transition for its dealers.

3. As for the questions dealers should ask, they should ask about the support and resources available to them during the transition. They should also inquire about any changes or upgrades to the software that may come with the transfer of support and how it may affect their operations. Additionally, they should ask about any potential costs associated with the transition and how it may impact their bottom line. The dealers should also ask about the support and resources available during the transition and any potential costs or changes to the software.

Thus,  before Caterpillar turns over its DBS to Accenture, it needs to carefully consider the impact on its dealers, evaluate the costs associated with the transfer, and ensure that it does not negatively impact its own core business.

Know more about "Decision making".

https://brainly.com/question/16407152

#SPJ11

Luke owns several relatively new business suits that he enjoys wearing. one day at the office, he notices an especially attractive suit worn by a coworker and decides he needs to buy a new suit. as described in this chapter, what type of problem recognition has taken place

Answers

Based on the given scenario, it can be said that Luke has experienced a "stimulus-driven problem recognition" while noticing an attractive suit worn by his coworker. Stimulus-driven problem recognition occurs when a consumer's attention is drawn to a particular product or service due to an external stimulus, such as an advertisement, a recommendation from someone else, or simply observing someone using a product. In this case, the coworker's attractive suit acted as a stimulus that grabbed Luke's attention and made him realize that he needed a new suit.

Stimulus-driven problem recognition is one of the three types of problem recognition that can occur in the consumer decision-making process. The other two types are "internal search" and "need-driven problem recognition." Internal search occurs when a consumer realizes a problem through his or her own past experiences and knowledge, while need-driven problem recognition occurs when a consumer experiences a gap between his or her desired and actual state of being.

In conclusion, Luke's problem recognition can be categorized as a stimulus-driven problem recognition, where an external stimulus triggered his need to buy a new suit. As a result, he might start looking for information and evaluating alternatives to find the most suitable suit that fits his preferences and budget.

Know more about "advertisement".

https://brainly.com/question/3163475

#SPJ11

Barbie and Jose are married and claim 2 exemptions. Last year Barbie earned $32,400 and Jose earned $28,600 in wages. Additional tax information for the year is as follows: Interest earned: $2,800; alimony paid: $5,900; contributions to IRA retirement fund: $2,300; state and local income taxes paid: $6,200; contributions to charity: $2,700. Find the taxable income if they file a joint return

Answers

The taxable income is $38,700 in the given case of Barbie and Jose

To find the taxable income, we need to calculate the total income and then subtract the deductions and exemptions.

Total Income:

Barbie's wages: $32,400

Jose's wages: $28,600

Interest earned: $2,800

Total income: $63,800

Deductions:

Alimony paid: $5,900

Contributions to IRA retirement fund: $2,300

State and local income taxes paid: $6,200

Contributions to charity: $2,700

Total deductions: $17,100

Exemptions:

Barbie: 1 exemption

Jose: 1 exemption

Total exemptions: 2

Taxable Income:

Total income: $63,800

Minus deductions: $17,100

Minus exemptions: $8,000 (2 exemptions x $4,000 for tax year 2021)

Taxable income: $38,700

Therefore, the taxable income is $38,700.

To learn more about taxable income  here

https://brainly.com/question/1160723

#SPJ4

which of the following is not an assumption of oligopoly? group of answer choices there are few sellers. there are few buyers. firms produce and sell either homogeneous or differentiated products. there are significant barriers to entry.

Answers

The assumption of oligopoly is that there are few sellers in the market. This means that the market is dominated by a small number of firms who have the power to influence prices and output levels. Option A

Another assumption of oligopoly is that firms produce and sell either homogeneous or differentiated products. This means that firms either produce identical products or products that are similar but not identical. This allows firms to differentiate their products from those of their competitors, which can be used as a competitive advantage.
Additionally, there are significant barriers to entry in an oligopoly. This means that it is difficult for new firms to enter the market and compete with existing firms.

Barriers to entry can include economies of scale, brand loyalty, and legal barriers such as patents or regulations.
However, the assumption that there are few buyers is not an assumption of oligopoly. In fact, the number of buyers is not a relevant factor in defining an oligopoly market structure.

The focus is on the number of sellers and the degree of market power they hold.
In conclusion, the three assumptions of oligopoly are that there are few sellers, firms produce and sell either homogeneous or differentiated products, and there are significant barriers to entry. The number of buyers is not an assumption of oligopoly. Option A

For more such questions on prices

https://brainly.com/question/28479908

#SPJ11

at the accounting break-even point, mountain hardware gear sells 14,600 snowboard masks at a price of $10 each. at this level of production, the depreciation is $58,000 and the variable cost per unit is $4. what is the amount of the fixed costs at this production level?

Answers

If level of production, the depreciation is $58,000 and the variable cost per unit is $4 the amount of fixed costs at this production level is $29,600.

The accounting break-even point is the level of sales at which a company's total revenues are equal to its total expenses, both fixed and variable. At this point, the company has not yet generated a profit, but it has also not incurred a loss.

To calculate the fixed costs at the accounting break-even point, we can use the following formula:

Fixed costs = (Sales price per unit x Break-even quantity) - (Variable cost per unit x Break-even quantity) - Depreciation

Using the information given in the question, we can plug in the values as follows:

Fixed costs = ($10 x 14,600) - ($4 x 14,600) - $58,000

Fixed costs = $146,000 - $58,400 - $58,000

Fixed costs = $29,600

To learn more about break-even click on,

https://brainly.com/question/29511772

#SPJ4

Other Questions
Which choice is the correct graph of |x|< 3 Which expression is equivalent to the given expression? 2x^2-11x-6 Which of the following quotations best supports the theme that many people do have the power to take control of their own lives, even in difficult situations?Question 34 options:"Minerva cries because her luck is unlucky. Every night and every day.""Rafaela leans out the window and leans on her elbow and dreams her hair is like Rapunzel's.""I have decided not to grow up tame like the others who lay their necks on the threshold waiting for the ball and chain.""Marin . . . is waiting for a car to stop, a star to fall, someone to change her life.""This was the house Papa talked about when he held a lottery ticket . . . How a lack of responsible citizenship can lead to futher cases of human rigths violations within a community How does a mutual fund serve as a financial intermediary?. Describe the relationship between conservatism, liberalism, socialism, and nationalism in early-nineteenth-century europe. what was the inspiration for these various ideologies Put these numbers in order, from least to greatest. If you get stuck, consider using the number line. 3. 5 -1 4. 8 -1. 5 -0. 5 4. 2 0. 5 -2. 1 -3. 5Write two numbers that are opposites and each more than 6 units away from 0 Write an agony aunt's advice to Romeo Benvolio tells Romeo that the cure for his infatuation with Rosaline to look at other girls (Examine other beauties'). Imagine you are an agony aunt' for a magazine. Romeo writes to you with his problem (using the language of the play in Act 1 Scene 1, lines 154-227). Write his letter and your advice in reply. If $4,500 is invested at an interest rate of 5.25% per year, compounded continuously, find the value of the investment after the given number of years. (Round your answers to the nearest cent.)(a) 4 years(b) 8 years(c) 12 years how you have been subjected to subcultural practices. Find a online article which raises an ethical issue in business. Summarize the article and explain the ethical concern. a company's income statement showed the following: net income, $136,000 and depreciation expense, $33,600. the company's current assets and current liabilities showed the following changes: accounts receivable decreased $10,600; merchandise inventory increased $20,400; and accounts payable increased $4,600. calculate the net cash provided or used by operating activities. I need help Plssplss Write a slope-intercept equation for a line passing(3,-2) through the point that is parallel to the line 3X+4Y= 9. Then write a second equation for a line passing through the point (3,-2) that is perpendicular to the line 3X+4Y= 9. Kevin and Shuang have two children, ages 8 and 14. They spend $6,200 per year on eligible employment related expenses for the care of their children after school. Kevin earned a salary of $20,000 and Shuang earned a salary of $18,000. What is the amount of the couple's credit for child and dependent care expenses The following excerpt is from Katherine Anne Porters short story "The Fig Tree," published in 1960. In this passage, Miranda, a young child, observes an interaction between her grandmother and great-aunt. Read the passage carefully. Then, in a well-written essay, analyze how Porter uses literary elements and techniques to convey Mirandas complex reaction as she observes the two older women How many waddle dees are in kirby and the forgotten land. Brooke and eileen are working on a math problem together and can't seem to agree on an answer. their teacher drew this number line on the board and asked them to think of a situation that could be represented by it. brooke suggested the following situation:christopher wants to buy a new bicycle and needs to earn more than $75 in order to have enough money.eileen suggested the following situation:paul is flying home from vacation and has less than 75 minutes left of the flight. Computers (part 2) Review and Quiz Test: Vocabulary and Grammar 2.17So this isn't a question it's just me trying to help others on this test. so the answers are: a,b,c,d,d,a,b,d,d,a,d,c,b,a,b,b,a,b,b,b,a,a,a,b,aNot all these are right but it should get you 88%. When Bernard was as old as Hector is now, Bernard's age was 4 times Hector's age then. When Hector will be as old as Bernard is now, the sum of their ages will be 51. How old will Bernard be when Hector turns 18 years old?