Your cousin is currently 88 years old. She will be going to college in 1010 years. Your aunt and uncle would like to have $ 95 comma 000$95,000 in a savings account to fund her education at that time. If the account promises to pay a fixed interest rate of 4.2 %4.2% per​ year, how much money do they need to put into the account today to ensure that they will have $ 95 comma 000$95,000 in 1010 ​years?

Answers

Answer 1

Answer:

PV= $62,957.35

Explanation:

Giving the following information:

Future value= $95,000

Number of years= 10

Interest rate= 4.2%

To calculate the initial investment required to reach the objective, we need to use the following formula:

PV= FV/(1+i)^n

PV= 95,000/(1.042^10)

PV= $62,957.35


Related Questions

A cost that cannot be avoided or changed because it arises from a past decision, and is irrelevant to future decisions, is called a(n):

Answers

Answer: Sunk cost

Explanation:

A sunk cost is a cost that an individual, firm or the government has already incurred and therefore can't be recovered anymore.

For example, marketing campaign expenses, rent or the money that is spent on purchasing new equipment can all be referred to as sunk costs as they are past cost and can't be recovered again.

“how does a change in supply affect the equilibrium price?”

Answers

Answer:

An increase in supply is illustrated by a rightward shift of the supply curve, and, all other things equal, this will cause the equilibrium price to fall. A decrease in supply is illustrated by a leftward shift of the supply curve - this will cause the equilibrium price to rise.

Explanation:

hi

If a company uses $1,300 of its cash to purchase supplies, the effect on the accounting equation would be:

Answers

Answer:

no impact

Explanation:

The journal entry to purchase the supplies for cash

Supplies Dr $ 1,300  

   To Cash A/c  $ 1,300

(Being the purchase of supplies is recorded)

For recording this we debited the supplies as it increased the assets and credited the cash as it decreased the assets

Therefore there is no impact on the accounting equation

c. Enter into an alliance with a large European pharmaceutical firm. The products would be manufactured in Europe by the 50-50 joint venture and marketed by the European firm.

Answers

Answer: c. Enter into an alliance with a large European pharmaceutical firm. The products would be manufactured in Europe by the 50-50 joint venture and marketed by the European firm.

Explanation:

Reasons why it should enter into business with a European firm;

As mentioned in the text, the company is a small one in the an industry that is dominated and trusted by big names such as GSK and Pfizer. It would do the company a world of good to get into business with a large European firm and use the opportunity to increase their brand popularity and grow in size.The Canadian firm might not know much about how to go about conducting business in the European union and this can be detrimental to its business. Getting involved with the European firm will ensure that their product is properly marketed by an entity that knows how to do business in the target market.It will be cheaper to engage with the European firm than to begin anew and go alone at penetrating the European market. The Marketing cost alone will be significant because they will be going up against well established names. By partnering with the European firm, the Canadian firm will gain access to the European firm's already established distribution network even if all that they handle is marketing because they will market to their connections first. The Canadian will stand to gain knowledge on marketing techniques in the European Union that they can then use to their advantage for other products that they might have.

Charley Inc is a large corporation that reported revenue of $80 million and expenses (other than interest) of $78 million in 2019. Included in the expenses is depreciation of $300,000. Charley Inc. paid business interest of $1,000,000 in 2019. What is the maximum amount of interest expense deduction this year

Answers

Answer:

The maximum amount of interest expense deduction this year is $690,000

Explanation:

In order to calculate the maximum amount of interest expense deduction this year we would have to calculate first the adjusted taxable income as follows:

adjusted taxable income=reported revenue-expenses+depreciation

According to the given data:

reported revenue=$80,000,000

expenses=$78,000,000

depreciation=$300,000

Therefore, adjusted taxable income=$80,000,000-$78,000,000+$300,000

adjusted taxable income=$2,300,000

maximum amount of interest expense deduction=$2,300,000*30%

maximum amount of interest expense deduction=$690,000

The maximum amount of interest expense deduction this year is $690,000

Shawn borrowed $132,600 at 4.25 percent for 30 years to purchase a home. Payments are to be paid monthly. If all payments are paid as agreed, how much total interest will be paid

Answers

Answer:

Interest payment= $ 102,176.54  

Explanation:

When a loan is to be paid over a period of time using a series of periodic equal installments, it is called loan amortization. Each equal installment is meant to liquidate the principal and the accrued interest.

Total Interest payment = total payment over the loan life - Principal amount

The monthly equal installment is calculated as follows:

Monthly equal installment-= Loan amount/Monthly annuity factor

Monthly annuity factor  

=( 1-(1+r)^(-n))/r

Monthly interest rate (r)

= 4.25%/12= 0.354 %

Number of months ( n) in 30 years

= 12* 30 = 360

Annuity factor  

= ( 1- (1.00354)^(-360)/0.00354= 203.3252575

Monthly installment = 132,600/47.03  = $652.157

Total Interest payment = total payment over the loan life - Principal amount

                  = (652.157 × 360) -  132,600=  102,176.54  

Interest payment= $ 102,176.54  

An individual who is not party to the contract between a CPA and the client, but who is known by both and is intended to receive certain benefits from the contract is known as:

Answers

Answer:

Third party beneficiary.

Explanation:

This is easily seen in contracts as it is said that a third party beneficiary is a person that benefits from an agreement between two persons or a contract between two persons. This is despite the fact that this said person has no effect or was not in any way a part of the said contract.

A third party beneficiary can be denied the rights to compensation of the contract, especially when contract is not fulfilled.

Rights which makes the third party beneficiary valid and concretely a part of the contact are been attached and solidified if the said contract comes through.

Brian Lee is 30 years and wants to retire when he is 65. So far he has saved (1) $5,850 in an IRA account in which his money is earning 8.3 percent annually and (2) $4,320 in a money market account in which he is earning 5.25 percent annually. Brian wants to have $1 million when he retires. Starting next year, he plans to invest the same amount of money every year until he retires in a mutual fund in which he expects to earn 8.22 percent annually. How much will Brian have to invest every year to achieve his savings goal?

Answers

Answer:

he must invest $4,855.64 during each of the following 35 years

Explanation:

years until retiring = 65 - 30 = 35 periods

desired future value $1,000,000

first we must find the future value of his current investments:

$5,850 x (1 + 0.083)³⁵ = $95,312.94

$4,320 x (1 + 0.0525)³⁵ = $25,897.47

total future value = $121,210.41

this means that he needs to save $1,000,000 - $121,210.41 = $878,789.59 more by the time he reaches 65 years of age

we need to use the formula to calculate future value of an annuity:

FV = payment x annuity factor (FV annuity, 8.22%, 35 periods)

FV = $878,789.59 annuity factor (FV annuity, 8.22%, 35 periods) = 180.98322

$878,789.59 = payment x 180.98322

payment = $878,789.59 / 180.98322 = $4,855.64

he must invest $4,855.64 during each of the following 35 years

The following information is available for Masun Company: Sales $550,000 Total fixed expenses $150,000 Cost of goods sold 390,000 Total variable expenses $370,000 A CVP income statement would report:

Answers

Answer:

$180,000

Explanation:

The computation of CVP income statement is shown below:-

                           CVP Income statement

Sales $550,000

Variable cost $370,000

Contribution margin $180,000

Fixed cost $150,000

Operating Profit $50,000

Therefore for computing the contribution margin we simply deduct the variable cost from sales and fixed cost to arrive the operating profit

On January 2, 2017, the Matthews Band acquires sound equipment for concert performances at a cost of $66,200. The band estimates it will use this equipment for five years. It estimates that after five years it can sell the equipment for $2,000. Matthews Band uses straight-line depreciation but realizes at the start of the second year that due to concert bookings beyond expectations, this equipment will last only a total of three years. The salvage value remains unchanged. Compute the revised depreciation for both the second and third years.

Answers

Answer:

$25,680

Explanation:

For the computation of revised depreciation for both the second and third years first we need to follow some steps which are shown below:-

Depreciation cost = Cost - Salvage value

= $66,200 - $2,000

= $64,200

Annual depreciation under SLM method = Depreciable cost ÷ Useful life

= $64,200 ÷ 5

= $12,840

Book value of the equipment = Cost - Annual depreciation

= $66,200 - $12,840

= $53,360

Remaining depreciable cost = Book value at point of division - Salvage value

= $53,360 - $2,000

= $51,360

Annual depreciation for year 2 and year 3 = Remaining depriciable cost ÷ Remaining useful life

= $51,360 ÷ (3 - 1)

= $51,360 ÷ 2

= $25,680

The following items are components of a traditional balance sheet. How much is the total equity of the firm?
Plant and equipment $44,600
Common stock 15,000
Cash 7,300
Inventory 22,400
Bad debt reserve 6,000
Paid in excess 6,000
Accumulated depreciation 27,600
Accounts receivable 22,000

Answers

Answer:

$50,600

Explanation:

The computation of the total equity is shown below:

= Common stock + paid in excess

= $44,600 + $6,000

= $50,600

We simply added the common stock and the paid in excess as these two are come under the total equity

And, the rest items would be considered as a current assets and the fixed assets so the same is not considered in the computation part

Morgan Company issues 10%, 20-year bonds with a par value of $760,000 that pay interest semiannually. The current market rate is 9%. The amount paid to the bondholders for each semiannual interest payment is: Multiple Choice $34,200. $380,000. $38,000. $68,400. $76,000.

Answers

Answer:

c. $38,000

Explanation:

Bond is issued at i= 10% = 0.10, n=20, m= 2, p= $760,000

The amount of interest owed to the bondholders for each semiannual interest payment is:

= $760,000 × 0.10 × 6/12

= $760,000 x 0.05

= $38,000

Kenny Lauren want to establish a nonprofit organization to help orphans find adoptive homes. They know that they will need a large amount of money to start up this organization but they do not have those funds. They also do not know many wealthy people they could borrow money from. They do however have a large social network and are experts in the use of social media. What approach might they used to raise capital for this project?

A. Selling products or services

B. Investors

C. Crowdfunding

D. Loans

Answers

Answer: C - Crowdfunding

Explanation: Investors, loans, and selling products and services would not gain them enough financial support, whereas crowdfunding will in an efficient way.

The best way to raise capital to establish a nonprofit organization to help orphans is to enable recurring donations, crowdfunding, using social networks for the investment etc. Thus, the correct option is C). Crowdfunding.

What is the best way to raise capital to establish a nonprofit organization?

A nonprofit organization refers to that legal entity and organization that is established for public or social benefit. This entity is also known as not-for-profit organization, or nonprofit institution.

There are various ways through which nonprofit organization can find the funding sources such as ask for sponsorships, by creating a donation page,  by sending fundraising letters, crowdfunding campaign can be launched, host a fundraising event etc.

Thus, it can be concluded that the best way to raise capital for the nonprofit organization to help the orphans to find homes is the crowdfunding.

Learn more about nonprofit organization here:-

https://brainly.com/question/25230172

#SPJ5

Compute the Cost of Goods Manufactured and Cost of Goods Sold for Blue Sea Company for the most recent year using the amounts described next. Assume that Raw Materials Inventory contains only direct materials
(Click the icon to view the data )
Start the calculation for cost of goods manufactured by calculating the direct materials used
Blue Sea Company
Calculation of Direct Materials Used
For Current Year
Beginning raw materials inventory $ 27,000
Plus Purchases of direct materials 79,000
Materials available for use 106,000
Less: Ending raw materials iniventory 31,000
Direct materials used 75.000
Calculate the cost of goods manufactured.

Answers

Answer:

Calculate the cost of goods manufactured.

$243,800

Explanation:

manufacturing overhead = indirect labor ($46,000) + insurance of plant ($8,000) + depreciation of machines and equipment ($12,700) + repairs and maintenance ($4,100) =  $70,800

Beginning raw materials  = $27,000

+ Purchases of raw materials  =  $79,000

- Ending raw materials inventory  =  -$31,000

= Direct materials used in production   = $75,000

+ Direct labor   = $83,000

+ Manufacturing overhead  =  $70,800

= Total manufacturing costs  =  $228,800

+ Beginning work in process   = $43,000

- Ending work in process  =  -$28,000

= Cost of goods manufactured  = $243,800

Discuss why it is important to establish control on the R chart first when using and R control charts to bring a process into statistical control.

Answers

Answer:

See below

Explanation:

The importance of establishing control in this case stems from the fact that as the points in these type of charts exceed beyond the set limits, it is possible that those points get eliminated and a revised value of R can be obtained. Accordingly, the limits and the center line also get revised on an R chart and x chart. This also allows for the limits to get tighter on both of the charts.

If you deposit $8,500 in an account now, how much will be in the account at the end of 5 years? Use a nominal rate (monthly compounding) of 8.00%.

Answers

Answer:

$12,663.69

Explanation:

The formula for calculating future value :

FV = P (1 + r/m)^nm

FV = Future value

P = Present value

R = interest rate

N = number of years

M = number of compounding per year

$8,500 (1 + 0.08 / 12) ^60 = $12,663.69

What is Sharpie's target market?

Answers

Answer:

The campaign is aimed at teenagers.

Explanation:

Sharpie's global vice president for marketing, because they “use Sharpie in the most creative, inspiring ways.

Have a good day and stay safe!

A four-year bond has an 8% coupon rate and a face value of $1000. If the current price of the bond is $878.31, calculate the yield to maturity of the bond (assuming annual interest payments). Group of answer choices

Answers

Answer:

Yield to maturity =11.75%

Explanation:

The yield to maturity to Maturity van be worked out using the formula below:

YM =( C + F-P/n)  ÷  ( 1/2× (F+P))

C- annual coupon,

F- face value ,

P- current price,

n- number of years to maturity

YM - Yield to maturity

C- 8%× 1000 = 80, P- 878.31, F- 1000

AYM =  80 + (1000-878.31)/4  ÷  1/2×  (1000+878.31)

        = 110.4225    ÷ 939.155

       = 11.75%

Yield to maturity =11.75%

Now suppose that the demand for bell peppers is relatively inelastic. How will this change your answer to the previous question?

Answers

Answer:

D.  Price will increase by a larger increment and the quantity will decrease by a smaller increment

Explanation:

here is the full question :

he market for bell peppers is competitive. For bell peppers to grow properly they need substantial rainfall. A very dry winter in California did not produce enough rain to grow bell peppers in California, one of the major bell pepper growing regions of the world.

Now suppose that the demand for bell peppers is relatively inelastic. How will this change your answer to the previous question?

A.  Price will increase by a smaller increment and the quantity will decrease by a larger increment

B.  Price will increase by a smaller increment and the quantity will decrease by a larger increment.

C.  Price will increase by a larger increment and the quantity will decrease by a larger increment

D.  Price will increase by a larger increment and the quantity will decrease by a smaller increment

Demand is inelastic if a small change in price has little or no effect on quantity demanded.

due to the low rainfall, less pepper would be produced. as a result the supply of pepper would rise. since the demand for pepper is inelastic, the rise in price would be greater than the change in quantity demanded.

Price will be increase by the larger increment of quantity that will decrease by the smaller increment. Thus the option D is correct.

What is relatively inelasticity ?

The relatively inelastic demand is the one where the percentage changed in the demand than the percentage change of the price of the product. As the price may increase the demand get reduced. Most essential goods are inelastic.

Find out more information about the suppose that.

brainly.com/question/1601351.

This question is incomplete.

The full question is

The market for bell peppers is competitive. For bell peppers to grow properly they need substantial rainfall. A very dry winter in California did not produce enough rain to grow bell peppers in California, one of the major bell pepper growing regions of the world.

Now suppose that the demand for bell peppers is relatively inelastic. How will this change your answer to the previous question?

A.  Price will increase by a smaller increment and the quantity will decrease by a larger increment

B.  Price will increase by a smaller increment and the quantity will decrease by a larger increment.

C.  Price will increase by a larger increment and the quantity will decrease by a larger increment

D.  Price will increase by a larger increment and the quantity will decrease by a smaller increment.

An action for breach of warranty generally must be brought within four years of the breach.

a. True
b. False

Answers

Answer:

i The answer is going to be a. true

Read "Knowledge and Globalization" on page 375 in the textbook. Should governments take measures, legal or otherwise, that protect their economic advantages? Should they penalize companies that offshore manufacturing jobs? Should they forbid the sale of know-how to other countries? Should they adopt the Venetian model, or should we look at the world as one large economy for each worker where each organization should compete for a piece of the pie regardless of national borders - so that consumers everywhere can enjoy products of the highest quality for the lowest possible price?

Answers

Answer:

Explanation:

(A)

Governments should take measures -legal, fiscal, monetary, social, etc - to protect their economic advantages.

This is the reason for Ministers of Finance. A country should know the goods and services in which it has competitive advantage of production or supply or quality. The government should develop policies and tactics to protect this advantage.

(B)

Governments should only seldom penalize companies that offshore manufacturing jobs. Why? Because sometimes, it is necessary to offshore manufacturing jobs. Foreigners might have the exact expertise needed in that field. If the government however feels that foreigners are gaining traction in that sphere of the economy, they can create an avenue for their citizens to be equipped with the expertise.

(C)

No. Governments should not forbid the sale of know-how to other countries. The government should or could set a 'price floor' that is high, as the minimum amount at which the knowledge is to be sold. Sale of technological know-how is an important source of revenue so it should be encouraged.

(D)

Governments should adopt the Venetian Model.

A 100 par value 6 percent bond with semi-annual coupons is purchased at 110 to yield a nominal rate of 4 percent convertible semi-annually. A similar 3 percent bond with semi-annual coupons is purchased at P to provide the buyer with the same yield. Calculate P.

Answers

Options:

(A) 90 (B) 95 (C) 100 (D) 105 (E) 110

Answer:

(A) 90

Explanation:

par value = $100

coupon rate 6%, semiannual

market price $110

YTM = 4%

similar coupon:

par value = $100

coupon rate 3%, semiannual

market price $???

YTM = 4%

first of all, since the market rate is higher than the coupon rate, the bond will be sold at a discount, therefore, options C, D and E can be eliminated.

that leaves us with options A ($90) and B ($95)

now we can use the YTM formula to find n for both options:

YTM = [coupon + [(face value - market value)/n]} / [(face value + market value)/2]

0.04 = 3 + [(100 - 90)/n]} / [(100 + 90)/2]

0.04 = (3 + 10/n) / 95

3.8 = (3n + 10) / n

3.8n = 3n + 10

0.8n = 10

n = 10/.8 = 12.5 years

0.04 = 3 + [(100 - 95)/n]} / [(100 + 90)/2]

0.04 = (3 + 5/n) / 95

3.8 = (3n + 5) / n

3.8n = 3n + 5

0.8n = 5

n = 5/.8 = 6.25 years

now we must replace n in the YTM formula for the first bond:

bond price $90

YTM = 3 + [(100 - 110)/12.5]} / [(100 + 110)/2]

YTM = 2.2 / 105 = 2.09% X 2 = 4.18% ≈ 4%

bond price $95

YTM = 3 + [(100 - 110)/6.25]} / [(100 + 110)/2]

YTM = 1.4 / 105 = 1.33% X 2 = 2.67% WRONG

Each of the following are types of__________allocation methods:
plantwide rate method, departmental overhead rate method and activity-based costing method.

Answers

Answer:

Each of the following are types of Overheads allocation methods.

Explanation:

Factory overheads such as rent, electricity or water can not be traced directly to a cost object.

When determining the cost of a cost object these overheads are apportioned to departments they pass through for processing  or the actual job using an allocation method.

The common methods for allocating overheads are plant-wide rate method, departmental overhead rate method and activity-based costing method.

The __________ is based on all the goods and services produced in the economy, which make it a current-weights index. eco203

Answers

Answer:

The __Paasche Index or Current-Weighted Index_______ is based on all the goods and services produced in the economy, which make it a current-weights index.

Explanation:

The Current-Weighted Index is an index that calculates the weighted average of prices or quantities or with the weights used proportionate to the quantities or prices of the goods.  At regular intervals, the weights have to re-calculated in line with the current realities.  This regular re-calculation of the weights, which is the basis for its name, makes it current.

Supplier development is synonymous with ____. Group of answer choices materials management procurement reverse marketing supplier selection and evaluation

Answers

Answer:

The correct answer is: reverse marketing

Explanation:

Reverse marketing can be defined as the type of marketing in which the customer seeks the company, and not that traditional marketing model whose marketers are looking for customers.

Therefore, in this model, it is necessary to develop the variables that will bring the customer closer to the company, because reverse marketing can be considered an aggressive strategy to achieve objectives, where the buyer is the main decision maker of the purchase.

Supplier development is a technique widely used in business to business markets, where the company is the buyer who will approach the supplier in order to meet their needs.

Which of the following measures does not reflect a company's profitability?
Gross Profit Margin

Days Sales in Accounts Receivable

О ЕВАТ

Profit Margin

Answers

Answer:

Days Sales in Accounts Receivable

Explanation:

The profitability ratios check the profit of the company. It could be determined by gross profit margin - EBAT and profit margin

The gross profit margin could be

= (Sales - cost of goods sold) ÷ (Sales)

The EBIAT is Earning before interest after taxes it tracks the performance of the company and according to that the profitability could be measured

The profit margin could be calculated

= Net profit ÷ Sales

Therefore the days sales in account receivable is not reflect the company profitability

Tracy Company, a manufacturer of air conditioners, sold 190 units to Thomas Company on November 17, 2021. The units have a list price of $300 each, but Thomas was given a 20% trade discount. The terms of the sale were 4/10, n/30. Thomas uses a perpetual inventory system. 3. Prepare the journal entries to record the purchase by Thomas on November 17 and payment on November 26, 2021 and December 15, 2021 using the net method of accounting for purchase discounts.

Answers

Answer:Please see explanation column for answer.

Explanation:

Net purchase per unit =  List price per unit - Trade discount

             $300 - ( 300 x 20 %) =  300- (300 x 0.2)= 300 -60= $240

Total purchase amount = Number of units x Net purchase per unit

                                            190 x 240=  $45,600

Discount from purchase = Total purchase amount x  discount percentage/ 100

=45,600 x 4/100=  $1,824

Cash =  $45,600

Discount = $1,824

Accounts payable = $43,776

Using the net method of accounting for purchase discounts.

 A)Journal entries to record the purchase by Thomas on November 17, 2021

Account                            Debit                Credit

Purchases                   $43,776

Account Payable                                      $43,776

B)Journal entries to record the payment by Thomas on November 26, 2021

Account                            Debit                Credit

Account Payable           $43,776

Cash                                                       $43,776

C)Journal entries to record the payment by Thomas on December 15, 2021

Account                            Debit                Credit

Account Payable           $43,776

Interest expense          $   $1,824

Cash                                                             $45,600                                      

The net account payable by Thomas on November 17, 2021, is $43,776. The journal entries to record the purchase by Thomas is attached in the image.

Net purchase per unit =  List price per unit - Trade discount

$300 - ( 300 × 20 %) =  300- (300 × 0.2)

= 300 -60

= $240

Total purchase amount = Number of units x Net purchase per unit

190 × 240=  $45,600

Discount from purchase = Total purchase amount x discount percentage/ 100

=45,600 × 4/100

=  $1,824

Cash =  $45,600

Discount = $1,824

Accounts payable = $43,776

The journal entries to record the purchase by Thomas on November 17 and payment on November 26, 2021 and December 15, 2021 attached below in the image.

Learn more about journal entries, here:

https://brainly.com/question/33762471

#SPJ6

A wireless phone service provider advertises that their average startup fee is $73. Given that their startup fees are $8, $85, $92, and $107, why is this statistic misleading?

Answers

Answer:

The reason why it is statisticaly misleading is because, while it is true that the average fee is $73 (the median value in statistical terms), averages are a statistical measure that is very sensitive to extreme values.

That is to say, if a value is very high, or very low, the statistical mean will be biased.

We can see this in the question. Three values are higher than the average, and relatively close: $85, $92, and $107. The third value, however, is way lower, at only $8. This extreme low value alters the median value, making it biased and misleading.

In cell K2 enter a formula using the IF and OR functions, as well as structured references to determine if Alison Simoneau can be a supervisor
A. Tbe IF function should first determine if the staff member's Service Years is greater than 5 OR if the staff member's college graduate status is "Yes". Remember to use a structured reference to the Service Years and the College Graduate columns.
B. The function should return the text Yes if a staff member meets one or both of those criteria.
C. The function should return the text No if a staff member meets neither of those criteria. tsor and have conlelea Academic Technology training.

Answers

Answer:

Enter the following formula in a cell K2:

=IF(OR([at[College Graduate]]="Yes",[at[Service Years]]>5),"Yes","No")

Please replace "at"  in the formula with its symbol.

Explanation:

The formula has an IF function which checks a condition.

There are two conditions here to be checked:

A) if the staff member's Service Years is greater than 5.

B) if the staff member's college graduate status is "Yes".

According to the given criteria this IF function should return Yes if a staff member meets one OR both of the above mentioned criteria. Otherwise the function should return No.

This means if any one of the criteria evaluates to true then the text Yes is returned. For example if staff member's Service Years is greater than 5, then function returns Yes. For instance if staff member is a college graduate which means that his college graduate status is "Yes", then the function returns Yes.

The function still returns if either of the two criteria is true. For instance if staff member's Service Years is less than 5 but staff member's college graduate status is "Yes" then the function returns Yes.

However if neither the staff member's Service Years is greater than 5 nor the staff member's college graduate status is "Yes" then the function returns No.

So we use OR function here which with IF function so that the IF function returns true if either of the two criteria is met, otherwise returns false. This takes the form:

IF(OR(Argument 1 is True, Argument 2 is True), YES if True, NO if False)

Also there is at symbol used in the formula. Square brackets are used for structured references. They make clear and easier to reference. Structure reference is used if we want to use a table name in a formula such that we used in this IF OR formula, instead of a normal cell reference. "at" is used to refer only the mentioned/current rows or cells in the table. If you do not use this at then all the columns will be selected. For example [at[Service Years]]>5 is a reference to the cell in the Service Years at the current row. But [[Service Year]] is a reference to the entire column. So only those cells are checked where the Service Year is greater than 5.

Please replace the at word in the formula with its symbol.

The controlling account for the cost ledger is Group of answer choices Cost of Goods Sold Materials Finished Goods Work in Process

Answers

Answer:

Work in process

Explanation:

The work in process refers to the completion of the project i.e how much work is completed and how much is pending. It shows the status of work or we can say tracking.

There are three levels of inventory

1. Raw material

2. Work in progress

3. Finished goods

After completing the processing the product is called to be finished and it is ready to sell

Therefore for the cost ledger, the controlling account is work in process

Other Questions
The relationship between the Period (T) caused by the oscillation of the mass on the end of a hanging spring and the mass (m) is: At December 31, 2011 and 2010, Miley Corp. had 180,000 shares of common stock and 10,000 shares of 5%, $100 par value cumulative preferred stock outstanding. No dividends were declared on either the preferred or common stock in 2011 or 2010. Net income for 2011 was $400,000.What does the 2011, earnings per common share amount to? What is the mass number of an atom with 24 protons and 30 neutrons? Why is it advisable not to look directly at the Sun? Please Give scientific reason for your answer Which lines from the poem best support the inference that children are more spiritual than adults? Select each correct answer. "The Youth, who daily farther from the east / Must travel, still is Nature's Priest," "To make her Foster-child, her Inmate Man, / Forget the glories he hath known," "Heaven lies about us in our infancy!" "Our birth is but a sleep and a forgetting:" "Earth fills her lap with pleasures of her own;" Write the story that ends in Ive never found such a kind person even since A 22.8 kg rocking chair begins to slide across the carpet when the push reaches 57.0 N. What is the coefficient of static friction? if y is an integer, find the value of y that satisfies both the linear inequalities y-216please give me calculation too tq The peripheral vision or fringe vision is up to one hundred and eighty degrees to the left or right. -True -False A sample of gas occupies a volume of 7.50 L at 0.988 atm and 301 K. At what temperature is the volume of the gas 4.00 L if the pressure is kept constant. factorise a^2-4ab+5b^2-c^2+6bc A bakery was about to sell fresh baguettes, and people formed a line outside to wait. While waiting for the bread to bake, every space between two people in the line was filled by a new person who had joined the line. More time passed, and again each space between the people waiting was filled with a new person who joined the line. Finally, 85 fresh baguettes were brought out and one baguette was sold to each person. How many people were standing in the original line? change 3/4 to decimal Through what process does water enter the atmosphere from the surface ofplants?A. FiltrationB. TranspirationC. PercolationD. Evaporation factor 20r+60t to identify the equivalent expression find the volume and total surface area of a rectangular solid of dimensions 2cm by 3cmby 4cm An investor who was not as astute as he believed invested $264,500 into an account 12 years ago. Today, that account is worth $204,000. What was the annual rate of return on this account Help me please please and if u help me u will get 50 dollars and get 5 starsLook at these details from a paragraph about the same topic: You can mix chocolate chips into cookies. Chocolate cocoa powder goes into brownies. You can decorate the top of a cake with chocolate sprinkles.Choose the main idea that ties all the details together.A. Different forms of chocolate are used in different desserts.B. Chocolate chips can be added to cookies.C. You can dip cookies or other snacks into melted chocolate.D. Chocolate is made from the seeds of the cacao tree. A random sample has been taken from a normal distribution and the following confidence intervals constructed using the same data: (25.53, 37.87) and (23.59, 39.81). One of these intervals is a 99% CI and the other is a 95% CI. Please match them. Which of the following is likely true of a wetland but not an ocean?A. Recharges freshwater aquifersB. Has low gross primary productivityC. is home to many different organismsD. May be classified into zones by topography and sunlight