In april 2011, consolidated edison (ed) stock cost $50 per share and yielded 5% per year in dividends, while national grid (ngg)

Answer:

a. Copy the data range D7:D9, then click on cell D6 and paste while selecting the date format. The formula will appear in the formula bar as +4;365 days.

b. Copy the data range D7:D9, select cell D6 and paste with the date format chosen. The formula will be displayed as -3;365 days in the formula bar.

c. Type in the formula bar as =365 days; +2: E6

d. In the formula bar input =365 days; +2: C6

Explanation:

Excel enables users to perform complicated calculations with ease through a single function. Users can create and connect various worksheets, displaying data either in tabular forms or as simple text. It offers multiple tools to generate annually filtered worksheets.

Answer and Explanation:

Below is the layout for preparing the answer sheet;

                                 Product Costs

Cost Item                           Direct          Direct    Manufacturing   Period

                                        Materials       Labor    Overhead          Costs

Rent for factory equipment                                                      $11,500  

Insurance  for the factory structure                                  $1,780

Raw materials total     $80,800

Utility expenses for factory                                  $920

Office supplies                                                    $320

Wages for assembly line personnel           $59,700

Depreciation for office equipment                                   $830  

Miscellaneous materials sum  $1,470

Salary for factory manager           $6,200

Property taxes for factory facility        $420

Advertising expenses for helmets                                    $14,900

Sales commissions sum                                            $10,900

Depreciation of the factory building               $1,640

Total                                $80,800     $59,700   $23,930      $26,950  

The production cost per helmet is

= Total production costs ÷ total helmets produced

= ($80,800 + $59,700 + $23,930) ÷ (10,000)

= ($164,430)  ÷ (10,000)

= $16.44

The average duration for the AC Corporation to settle its accounts payable is 46 days. Average Accounts Payable amounts to $7863.5, with a Cost of Goods Sold of $63,008, across a period of 365 days. The Days Payable Outstanding can be calculated using the following formula: (Average Accounts Payable / Cost of Goods Sold) x Number of Days in Accounting Period. By substituting the relevant values, we have: ($7,863.5 / $63,008) x 365, which gives us Days Payable Outstanding equal to 45.55. Consequently, the company averages 46 days to fulfill its accounts payable obligations.

<span>In Carol’s personal finance priorities, planning for an extravagant vacation is the least crucial. An exotic holiday is purely recreational and should only be considered if there are additional funds left in the budget. In contrast, prioritizing the children's education fund and having an emergency fund is vital since they represent fundamental needs for her family. Additionally, addressing credit card debt is also important due to its impact on credit scores, which is a key aspect of financial security.</span>

Response:

Clarification: 1.6%/2.7%