Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining services as follows:
a. In cell D6, enter a formula without using a function that adds 4 days to the value in cell 06.
b. In cell E6, enter a formula without using a function that subtracts 3 days from the value in cell C6
c. In cell F6, enter a formula without using a function that adds 2 days to the value in cell E6
d. In cell G6, enter a formula without using a function that adds 2 days to the value in cell C6.

Answer:

a. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding +4;365 days.

b. Copy the range of cell D7:D9 then select cell D6 and paste the selection with date format selected. The function will be represented in formula bar with adding -3;365 days.

c. In the formula bar type =365 days; +2 : E6

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

Explanation:

Excel is a software which helps the users to easily calculate complex calculation with just one function input. The users can create worksheets using the excel and then link those worksheets with each other. The data can be displayed in the form of table or simple text. It has multiple options to create annual day wise filtered worksheets.

Smith and Sons, Inc. Income Statement (in millions)

2016 2015
Net sales 10,300 9,800
Cost of goods sold (5,500) (5,200)
Gross profit 4,800 4,600
Selling and administrative expenses (2,800) (2,700)
Income from operations 2,000 1,900
Interest expense (300) (250)
Income before income taxes 1,700 1,650
Income tax expense (420) (400)
Net income 1,280 1,250

Smith and Sons, Inc. Balance Sheet

Assets
Current assets
Cash and cash equivalents 450 650
Accounts receivable 900 800
Inventory 750 900
Other current assets 400 250
Total current assets 2,500 2,600
Property, plant & equipment, net 2,350 2,250
Other assets 5,700 5,900
Total Assets 10,550 10,750

Liabilities and Stockholders' Equity
Current liabilities 3,250 3,150
Long-term liabilities 5,000 5,400
Total liabilities 8,250 8,550
Stockholders' equity-common 2,300 2,200
Total Liabilities and Stockholders' Equity 10,550 10,750

Required:
Calculate the quick ratio for Smith & Sons, Inc., for 2015 and 2016.

Old Economy Traders opened an account to short-sell 1,300 shares of Internet Dreams at $46 per share. The initial margin requirement was 50%. (The margin account pays no interest.) A year later, the price of Internet Dreams has risen from $46 to $59, and the stock has paid a dividend of $3.50 per share. a. What is the remaining margin in the account? (Round your answer to the nearest whole dollar.)

Patricia purchased a home on January 1, 2017 for $1,420,000 by making a down payment of $100,000 and financing the remaining $1,320,000 with a 30-year loan, secured by the residence, at 6 percent. During year 2017 and 2018, Patricia made interest-only payments on the loan of $79,200. What amount of the $79,200 interest expense Patricia paid during 2018 may she deduct as an itemized deduction

how can a writer be grief when writing professional letters



A. By adding a writer be brief when writing professional letters


B. By adding background information


C. By avoiding words that end in " Ize or ton"


D. By writing a concise letters that addresses your purpose

A wedding party hired a sole proprietorship to cater their wedding, and the sole proprietorship had an employee handle the entire job. If the entire wedding party gets food poisoning, the principal is liable. The employee of the sole proprietorship is also liable because he handled the entire job.

pls dont spam me need halp

Determining Amounts to be Paid on Invoices Determine the amount to be paid in full settlement of each of the following invoices, assuming that credit for returns and allowances was received prior to payment and that all invoices were paid within the discount period. Merchandise Freight Paid by Seller Terms Returns and Allowances a. $14,200 - FOB shipping point, 1/10, n/30 $700 b. 10,700 $400 FOB shipping point, 2/10, n/30 1,300 c. 5,700 - FOB destination, 1/10, n/30 500 d. 3,800 200 FOB shipping point, 2/10, n/30 500 e. 1,500 - FOB destination, 2/10, n/30 -

Manufacturers Southern leased high-tech electronic equipment from International Machines on January 1, 2021. International Machines manufactured the equipment at a cost of $94,000. Manufacturers Southern's fiscal year ends December 31. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Related Information: Lease term 2 years (8 quarterly periods) Quarterly rental payments $18,200 at the beginning of each period Economic life of asset 2 years Fair value of asset $138,287 Implicit interest rate 6% Required: 1. Show how International Machines determined the $18,200 quarterly lease payments. 2. Prepare appropriate entries for International Machines to record the lease at its beginning, January 1, 2021, and the second lease payment on April 1, 2021.

Park Co.'s wholly-owned subsidiary, Schnell Corp., maintains its accounting records in German marks. Because all of Schnell's branch offices are in Switzerland, its functional currency is the Swiss franc. Remeasurement of Schnell's 20X1 financial statements resulted in a $7,600 gain, and translation of its financial statements resulted in an $8,100 gain. What amount should Park report as a foreign exchange gain in its income statement for the year ended December 31, 20X1

In its first year of operations, Crane Company recognized $31,700 in service revenue, $7,700 of which was on account and still outstanding at year-end. The remaining $24,000 was received in cash from customers. The company incurred operating expenses of $16,600. Of these expenses, $12,690 were paid in cash; $3,910 was still owed on account at year-end. In addition, Crane prepaid $3,260 for insurance coverage that would not be used until the second year of operations.

Required:
Calcuate the first year's net earnings under the cash basis of accounting, and calculate the first years net earnings under the accrual basis of accouriting.

The CEO is considering your recommendations, and it will take time to make some of these changes. However, you know that it's not just the structure of the department that is stifling creativity. You believe that the culture could be significantly improved, and you want to start working on these issues ASAP. It will be a slow process to make some of these changes, but the time to get started is now. You have a lot of ideas, but only a few should be implemented initially. Which three do you think should be started immediately

Crane Sporting Goods expects to have earnings per share of $6 in the coming year. Rather than reinvest these earnings and grow, the firm plans to pay out all of its earnings as a dividend. With these expectations of no growth, Crane's current share price is $60 and the cost of equity capital is 10%. Suppose Crane could cut its divident payout rate to 75% for the foreseeable future and use the retained earnings to open new stores. The return on investment in these stores is expected to be 12%. if we assume that the risk of these new investments is the same as the risk of its existing investments, then the firm's equity cost of capital is unchanged. What effect would this new policy have on Crane's stock price