1. Currency is an example of a number format.
   1. TRUE
   2. FALSE
2. To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.
   1. TRUE
   2. FALSE
3. To combine multiple cells into one combined cell, which of the following do you use?
   1. Column Width command
   2. Center button
   3. Merge and Center button
   4. Increase Indent button
4. In formulas, calculations in square brackets are calculated first.
   1. TRUE
   2. FALSE
5. Nathan wants to run a macro from the developer tab. He enables the developer tab by clicking File > Options > Customize Ribbon > Developer tab > Code > X > Macro name box > Run. What should he click as X in this procedure?
   1. Macros
   2. Visual Basic
   3. Record Macro
   4. Macro Security
6. Where do you rename a workbook and adjust its save location?
   1. Save As dialog box
   2. Home tab
   3. Name box
   4. Active cell
7. A student is asked to find the difference between two values of time entered in cells A1 and B1, where A1 is the greater value and B1 the lesser value. In order to do so, he will type the formula =A1-B1 in an empty cell.
   1. TRUE
   2. FALSE
8. Word is unable to publish a blog post document directly to a website.
   1. TRUE
   2. FALSE
9. To create a dashed line around a shape, modify the shape outline style.
   1. TRUE
   2. FALSE

You recently won $10,000 in your class project competition. Your financial advisor recommends that you invest it in five stocks in the stock market. Omit all transaction costs Assignment: DUE Wednesday September 9, 11:59 pm Section A: Use Microsoft Excel Step 1: Copy the tables in Part 1 below. They are in Excel Step 2. Go to any financial website (I recommend Yahoo Finance) between August 26 and September 4 . Step 3: Choose 5 stocks that have all the features listed in the Table below. Note: N/A and 0 are not acceptable Step 4. Pretend you use the $10,000 to purchase the 5 stocks you pick. Allocate the $10,000 among the 5 stocks Section B: Use Microsoft Word Step 5. (a) Say why you purchased these stocks. For example, I use the product or I own the stock. Any reason is OK. (b) Write a definition for each of the stock features incluing formulas, if any. For example, P/E is ____.The formula for calculating P/E is ____________ ( c) What is a stock Exchange? What is the Dow Jones Index? What is the S&P 500? What is the NASDAQ? Use any financial website to find your company, its symbol and the features listed below. I recommend Yahoo Finance.

Personal Finance class

Option #1: Transactions for fund statements and government-wide statements

At the beginning of the year, Robinson County acquired a new storage building under a capital lease agreement.

An initial payment of $700,000 is made to start the lease with four subsequent payments for the same amount at the end of each year starting in late 20X7.

The total lease payment amount for the duration of the lease is $3,500,000.

The present value of the lease at the inception is $3,485,000, including the initial payment. The county borrowed the funds for four years at an annual interest rate of 7%.

At the creation of the lease, the building’s fair value is $3,700,000.

Required:

Evaluate the classification of the building as a capital lease. Discuss if this is the proper classification and how you concluded on this classification.

Prepare the journal entries in the capital projects fund, the debt service fund, and the governmental activities journal for the beginning of the lease.

Prepare the journal entries in the debt service fund and governmental activities journal for the end of the initial year payment.

At the end of the initial year, what financial statement(s) would be prepared to show the assets and the liabilities pertaining to the capital lease? What is the total that would be reported in the liability section of this financial statement?

Paper Requirements:

Submit your responses to the questions in a 3-5-page Microsoft Word document. Label each question clearly. Include computations in a table and show work.

For written answers, ensure your responses are well-written.

Dice LLC has extracted the following data from HR department for the last year: Number of workers working for the company at the beginning of the year was 1,000 while at the end of the year 1,200. During the year, 50 workers resigned from their jobs, 60 workers were terminated by the company. A total of 240 workers were recruited. Out of total recruitment, 80 workers are recruited in place of the staff that left the company for any reason, while the rest were hired for expansion purpose. Required: Calculate the labor turnover rate using, addition method, separation method, replacement method, and flux method. Answer in the Word document (ANSWER SHEET) and Upload as attachment below Question 5 Not yet answered Marked out of 10.0 Not flaggedFlag question Question text a) Explain, in detail what Job Order Costing System of cost accumulation. What kind of businesses could possibly benefit from this costing system? How are the manufacturing and non-manufacturing costs allocated under this system? b) There are various techniques of materials control. Just-In-Time Inventory System is one of them. Discuss how this technique was developed, its features, and the benefits it offers. How a business can prepare itself to adopt this technique. c) Every organization is highly concerned in understanding the efficiency of its employees. Various methods have been developed to address this need. Discuss any four methods of rating employees’ efficiency.

Vaccines are a controversial subject and recently have been thrust into the
public spotlight. This was caused by the increase of anti-vaccination activists
and outbreaks of contagious diseases, like measles. Although the research
stating vaccines could result in autism was discredited and the publishing
physician lost his license permanently, the myth remains, kept alive on social
media.

Supporters say that vaccination is safe and point out that illnesses, including
rubella, diphtheria, smallpox, polio, and whooping cough, are now prevented by
vaccination and millions of children’s lives are saved. Opponents say that
children’s immune systems can deal with most infections naturally, and that
injecting questionable vaccine ingredients into a child may cause side effects,
including seizures, paralysis, and death.

In your opinion, should parents vaccinate their children or not? To strengthen your argument, use yourobservations and experiences, and information from your research.

Pick one topic and develop a well-developed thesis driven essay with research from Gale: Opposing Viewpoints located in HCCS library database. The paper will be 750-1000 word essay. You will need a minimum of 5 sources. You will have two quotes per body paragraph. You should have for and against argument. MLA style: 12 font, times new roman, double-spaced. Must include parenthetical citations and a works cited page.

Part 2: Wilcoxon Rank-Sum Test

Let us consider another hypothetical situation. The WHO wants to compare the mortality rates of children under the age of five years of underdeveloped and developed regions of the world. There were two independent samples of ten countries from each of the groups drawn at the same time, and the yearly mortality rates of children under the age of five years (per 100,000) inhabitants were reported (MRate1 and MRate2).

Table 2: Mortality Rates of Children

Using the Minitab statistical analysis program to enter the data and perform the analysis, complete the following:

• Run the Wilcoxon rank-sum test to show whether there is a statistically significant difference between the mortality rates of children under the age of five years of the regions. Results may be used in making decisions regarding which region needs to receive help to improve the public health issues of morality.
• Obtain the difference in the mortality rates and whether there is a statistically significant difference.
• In a Microsoft Word document, provide a written interpretation of your results.

Using the adjusted trial balance below prepare the asset section of the balance by drag and dropping the appropriate word or number.

ABC Co.
WORKSHEET
FOR THE YEAR ENDED DECEMBER 31, 2019
              
        ADJUSTED TRIAL BALANCE
ACCOUNT TITLES       DEBIT ($)   CREDIT ($)
              
Accounts Payable         $ 23,800
Accounts Receivable      $ 23,600     
Accumulated depreciation - Vehicles         $ 30,000
Advertising Expense      $ 5,000     
Capital, Kory Lee         $ 367,500
Cash      $ 272,080     
Depreciation Expense      $ 5,400     
Gardening Revenue         $ 255,000
Gardening Supplies      $ 4,500     
Insurance Expense      $ 3,000     
Interest Revenue         $ 200
Internet Expense      $ 1,060     
Notes Payable         $ 10,000
Notes Receivable (Due within 13 months)      $ 5,000     
Prepaid Insurance      $ 8,000     
Supplies Expense      $ 1,340     
Telephone Expense      $ 1,120     
Unearned Revenue         $ 2,000
Utilities Expense      $ 3,000     
Vehicles      $ 135,000     
Wage Expense      $ 155,400     
Withdrawals - Kory Lee      $ 65,000     
              
       $ 688,500   $ 688,500

ABC CO.      
Balance Sheet      
As at December 31, 2019      
   
Assets:                  
Current assets:                  
Cash       $ 272,080  
Accounts Receivable   $ 23,600  
Prepaid Insurance   $ 8,000  
Gardening Supplies   $ 4,500  
Total Current Assets       $ 308,180
Non-Current Assets:                  
        Notes Receivable  
$ blank
  
           
blank                  
Vehicles       $ 135,000  
Less accumulated depreciation   $ [3]]   $ blank
           
Total assets:                   $ blank

5,000 Property, Plant & Equipmentt 30,000 105,000 418,180 129,600 No entry this is a current asset 5,400 Physical Property and Equipment 442,780 0 410,180

Question 1. What is the significance of resource pricing? Explain the meaning and significance of the fact that the demand for a resource is a derived demand. Why do resource demand curves slope downward? LO1

Question 2. What factors determine the elasticity of resource demand? What effect will each of the following have on the elasticity of the demand for resource C, which is being used to produce commodity X? LO4

a. An increase in the demand for product X.

b. An increase in the price of substitute resource D.

c. An increase in the number of resources substitutable for C in producing X.

d. A technological improvement in the capital equipment with which resource C is combined.

e. A fall in the price of complementary resource E.

f. A decline in the elasticity of demand for product X.

Question 3. Florida citrus growers say that the recent crackdown on illegal immigration is increasing the market wage rates necessary to get their oranges picked. Some are turning to $100,000 to $300,000 mechanical harvesters known as “trunk, shake, and catch” pickers, which vigorously shake oranges from the trees. If widely adopted, what will be the effect on the demand for human orange pickers? What does that imply about the relative strengths of the substitution and output effects? LO5

Question 4. LAST WORD Explain the economics of the substitution of ATMs for human tellers. Some banks are beginning to assess transaction fees when customers use human tellers rather than ATMs. What are these banks trying to accomplish?

Question 1 – Payout Policy

AMC Corporation currently has an enterprise value of $400 million and $100 million in excess cash. The firm has 10 million shares outstanding and no debt. Suppose AMC uses its excess cash to repurchase shares. After the share repurchase, news will come out that will change AMC’s enterprise value to either $600 million or $200 million.

Required:

1. What is AMC’s share price prior to the share repurchase?
2. What is AMC’s share price after the repurchase if its enterprise value goes up? What is AMC’s share price after the repurchase if its enterprise value declines?
3. Suppose AMC waits until after the news comes out to do the share repurchase. What is AMC’s share price after the repurchase if its enterprise value goes up? What is AMC’s share price after the repurchase if its enterprise value declines?
4. Suppose AMC management expects good news to come out. Based on your answers to requirements (2) and (3), if management desires to maximize AMC’s ultimate share price, will they undertake the repurchase before or after the news comes out? When would management undertake the repurchase if they expect bad news to come out?
5. Given your answer to requirement (4), what effect would you expect an announcement of a share repurchase to have on the stock price? Why?
6. do in the word file or excel file