Questions
Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel...

Create an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page.

A firm had the following abbreviated income statement for 2020 and abbreviated balance sheets at the end of 2020 and 2021.

2020
Sales $600,000
Less Cost of goods sold 320,000
Gross Profit 280,000
Less Operating expenses 190,000
Less Depreciation 30,000
Operating Income (EBIT) 60,000
Less Interest expense 20,000
Earnings Before Taxes (EBT) 40,000
Less Income tax 14,000
Earnings After Tax (Net Income) $26,000
2020 2021
Cash $13,000 $15,000
Marketable securities 41,000 40,000
Accounts receivable 22,000 25,000
Inventory 60,000 60,000
Prepaid expenses 11,000 20,000
Buildings (net) 620,000 600,000
Equipment (net) 109,000 100,000
Total Assets $876,000 $860,000
Accounts payable 20,000 40,000
Wages payable 5,000 3,000
Bonds payable 414,000 364,000
Total Liabilities 439,000 407,000
Common stock 200,000 200,000
Retained Earnings 237,000 253,000
Total Equity 437,000 453,000
Total Liabilities & Equity $876,000 $860,000

The company paid a dividend in 2021 of $10,000. All sales are made on account.

Required:

A. Calculate the current ratio at the end of 2021. _______________

B. Calculate the quick ratio at the end of 2021. ________________

C. Calculate the working capital at the end of 2021. _______________

D. Calculate average age of accounts receivable during 2021. _______________

E. Calculate the inventory turnover during 2021. _________________

F. Calculate the average age of accounts payable during 2021. _____________

G. Calculate the accounts receivable turnover during 2021. _____________

H. Calculate the pre-tax profit margin for 2021. ____________

I. Calculate the cash conversion cycle, in days during 2021. _____________

J. Calculate the debt/equity ratio at the end of 2021. ________________

K. Calculate the debt ratio at the end of 2021. ______________

L. Calculate the times interest earned ratio for 2021. _______________

M. Calculate the dividend payout ratio for 2021. _________________

N. Calculate the gross profit margin for 2021. _____________

O. Calculate the operating profit margin for 2021. ____________

P. Calculate the net profit margin for 2021. _______________

Q. Calculate the return on assets (ROA) for 2021. _________________

R. Calculate the total asset turnover during 2021. _______________

S. Calculate the return on equity (ROE for 2021. ______________

T. Calculate the marginal tax rate for 2021. _________________

In: Finance

This is Physics 2, College Level: Someone answered wrong so take your time, do not rush...

This is Physics 2, College Level: Someone answered wrong so take your time, do not rush to answer these questions. Explain how you got the answers.

A 1.00 F capacitor is charged to 6.00 V. The capacitor and an open switch is connected to a coil of wire that consists of 500 windings, which has a resistance of 1.20 Ω. This coil has a diameter of 5.00 cm and a length of 16.0 cm. A slightly smaller coil is placed inside the larger coil. The smaller coil is 2000 windings, 4.50 cm in diameter, and 16 cm long. This smaller coil has a resistance of 8.00 Ω. At t = 0 s the open switch is closed and the capacitor begins discharging through the larger coil. This leads to a changing voltage, current, magnetic field, and magnetic flux in the outer coil, which induces an Emf in the inner coil. Find the following quantities.

What will be the maximum value of the magnetic field inside the outer coil? Bmax = ________micro Tesla (mT)

What will be the maximum induced emf across the inner coil? Vmax = _________micro Volts(mV).

What will be the induced emf across the inner coil 1.00 s after the switch is closed? Vmax = _________micro Volts(mV).

In: Physics

Thurston Howell IV is the sole heir to the Howell Enterprise fortune. He does not participate...

Thurston Howell IV is the sole heir to the Howell Enterprise fortune. He does not participate in the business, preferring to tend to his comic book collection. He does however own a large piece of the company

Recently he had become concerned about how the company has performed specifically related to some transactions relating to stockholders’ equity.

Here is the data relating to stockholders’ equity:

Howell Enterprises

Stockholders’ Equity

As of December 31, 2019

Common Stock, 2,000,000 shares outstanding                         10,000,000

Retained Earnings                                                                           7,500,000

Total Stockholders Equity                                                               17,500,000

Thurston currently owns 300,000 shares of Howell Enterprises

Here are the relevant transactions for 2020:

  1. The company issued 500,000 shares @ $8.00 per share
  2. The company purchased 100,000 shares @ $15 per share
  3. The company declared a $2.50 per share cash dividend
  4. The company declared a 2:1 stock split

Required

  1. Calculate the book value per share as of December 31, 2019. (total equity / number of shares outstanding)
  2. Calculate the total value of Thurston Howell IV’s stock as of December 31, 2019. (his shares x book value per share)
  3. Calculate the percentage of the company that Mr. Howell owns as of December 31, 2019. (his shares / total number of shares outstanding)
  4. Prepare journal entries for the transactions listed above
  5. Calculate the ending balances in the equity accounts
  6. Calculate the book value per share after the transactions have been recorded
  7. Calculate the total value of Thurston Howell IV’s stock after the transactions have been recorded. (his shares x new book value per share)
  8. Calculate the percentage of the company that Mr. Howell owns after the transactions have been recorded. (his shares x new total outstanding shares).
  9. Calculate the amount of loss that Mr. Howell has suffered (if any) as a result of the above transactions. (compare #2 to # 7).
  10. Write a summary in Word explaining your results. Which transactions caused Mr. Howell to lose money?

Record the transactions for 2020 and calculate the ending balances in all of the stockholder’s equity accounts.

Please organize the answers.

Trans

Accounts

Debit

Credit

Ending Balances

Common Stock

Retained Earnings

Treasury Stock

Total Equity

# of Shares Outstanding

Book Value Per Share

Mr. Howell’s Investment

Before Transactions

After Transactions

Book Value Per Share

Total Value of Stock

% of Company Owned

Turn in the summary with this page

In: Accounting

Question 6 Zoy plc is listed on the Hong Kong Stock Exchange and currently has 1m...

Question 6

Zoy plc is listed on the Hong Kong Stock Exchange and currently has 1m issued ordinary shares.

Over the last 5 years the following dividends have been paid at the end of each year:

Year

Net Dividend Per Share (cents)

2016

15.7

2017

17.4

2018

18.8

2019

20.1

2020

21.4

The dividends are expected to increase from 2020 at the same rate as they have historically and then by 4% per annum for periods after 2023.

The cost of equity of Zoy is unknown but the company has a beta of 0.9 and the rate of return on government securities is 0.6% per annum. The equity risk premium is estimated to be 6% per annum.

Required:

  1. Calculate the value of Zoy plc using the dividend valuation model. Assume the 2020 dividend has just been paid.

(12 marks)

  1. Discuss whether using future cash flows to value a company is more useful than using the net asset value from the balance sheet.

(8 marks)

In: Finance

A stock is expected to pay a dividend of $2.25 at the end of the year (i.e., D1 = $2.25), and it should continue to grow at a constant rate of 5% a year.

- A stock is expected to pay a dividend of $2.25 at the end of the year (i.e., D1 = $2.25), and it should continue to grow at a constant rate of 5% a year. If its required return is 15%, what is the stock's expected price 4 years from today?

- Assume that today is December 31, 2019, and that the following information applies to Abner Airlines:

After-tax operating income [EBIT(1 - T)] for 2020 is expected to be $450 million.
The depreciation expense for 2020 is expected to be $190 million.
The capital expenditures for 2020 are expected to be $225 million.
No change is expected in net operating working capital.
The free cash flow is expected to grow at a constant rate of 6% per year.
The required return on equity is 15%.
The WACC is 12%.
The firm has $206 million of non-operating assets.
The market value of the company's debt is $3.304 billion.
130 million shares of stock are outstanding.

Using the corporate valuation model approach, what should be the company's stock price today?

In: Finance

On February 1, 2020, Tessa Williams and Audrey Xie formed a partnership in Ontario. Williams contributed...

On February 1, 2020, Tessa Williams and Audrey Xie formed a partnership in Ontario. Williams contributed $85,000 cash and Xie contributed land valued at $125,000 and a small building valued at $185,000. Also, the partnership assumed responsibility for Xie’s $135,000 long-term note payable associated with the land and building. The partners agreed to share profit or loss as follows: Williams is to receive an annual salary allowance of $95,000, both are to receive an annual interest allowance of 15% of their original capital investments, and any remaining profit or loss is to be shared equally. On November 20, 2020, Williams withdrew cash of $65,000 and Xie withdrew $50,000. After the adjusting entries and the closing entries to the revenue and expense accounts, the Income Summary account had a credit balance of $165,000.

Required:
1.
Present general journal entries to record the initial capital investments of the partners, their cash withdrawals, and the December 31 closing of the Income Summary and withdrawals accounts.



2. Determine the balances of the partners’ capital accounts as of the end of 2020.

In: Accounting

The controller of Trenshaw Company wants to improve the company’s control system by preparing a month-by-month...

The controller of Trenshaw Company wants to improve the company’s control system by preparing a month-by-month cash budget. The following information is for the month ending July 31, 2020.

Prepare cash budget for a month.

June 30, 2020, cash balance $45,000
Dividends to be declared on July 15* 12,000
Cash expenditures to be paid in July for operating expenses 40,800
Amortization expense in July 4,500
Cash collections to be received in July 90,000
Merchandise purchases to be paid in cash in July 56,200
Equipment to be purchased for cash in July 20,000

*Dividends are payable 30 days after declaration to shareholders of record on the declaration date.

Trenshaw Company wants to keep a minimum cash balance of $25,000.

Instructions

a. Prepare a cash budget for the month ended July 31, 2020, and indicate how much money, if any, Trenshaw Company will need to borrow to meet its minimum cash requirement.

b. Explain how cash budgeting can reduce the cost of short-term borrowing.

(CGA adapted)

In: Accounting

At the end of 2020, the records of Block Corporation reflected the following. Common stock, $5...

At the end of 2020, the records of Block Corporation reflected the following.

Common stock, $5 par, authorized 500,000 shares
Outstanding January 1, 2020, 400,000 shares $2,000,000
Sold and issued April 1, 2020, 2,000 shares 10,000
Issued 5% stock dividend, September 30, 2020; 20,100 shares 100,500
Preferred stock, 6%, $10 par, nonconvertible, noncumulative, authorized 50,000 shares
Outstanding during year, 20,000 shares 200,000
Paid-in capital in excess of par, common stock 180,000
Paid-in capital in excess of par, preferred stock 100,000
Retained earnings (after the effects of current preferred dividends declared during 2020) 640,000
Bonds payable, 6.5%, nonconvertible, issued at par January 1, 2020 1,000,000
Net income 164,000
Income tax rate, 25%

a. What EPS presentation is required—basic, diluted, or both?

Answer: Basic EPS/Diluted EPSBasic and Diluted EPS

b. Compute the required EPS amount(s).

  • Note: Round earnings per share amount to two decimal places.
Net Income Available to
Common Stockholders
Weighted Avg. Common
Shares Outstanding
Per
Share
Answer: Basic EPS/Diluted EPSBasic and Diluted EPS Answer Answer Answer

c. Compute the required EPS amount(s), assuming that the preferred stock is cumulative.

  • Note: Round earnings per share amount to two decimal places.
Net Income Available to
Common Stockholders
Weighted Avg. Common
Shares Outstanding
Per
Share

Answer: Basic EPS/Diluted EPSBasic and Diluted EPS

Answer Answer Answer

In: Accounting

Luzadis Company makes furniture using the latest automated technology. The company uses a job-order costing system...

Luzadis Company makes furniture using the latest automated technology. The company uses a job-order costing system and applies manufacturing overhead cost to products on the basis of machine-hours. The predetermined overhead rate was based on a cost formula that estimates $735,000 of total manufacturing overhead for an estimated activity level of 49,000 machine-hours.

During the year, a large quantity of furniture on the market resulted in cutting back production and a buildup of furniture in the company’s warehouse. The company’s cost records revealed the following actual cost and operating data for the year:

Machine-hours

40,000

Manufacturing overhead cost

$

693,000

Inventories at year-end:

Raw materials

$

20,000

Work in process (includes overhead applied of $60,000)

$

185,000

Finished goods (includes overhead applied of $102,000)

$

314,500

Cost of goods sold (includes overhead applied of $438,000)

$

1,350,500

Required:

1. Compute the underapplied or overapplied overhead.

2. Assume that the company closes any underapplied or overapplied overhead to Cost of Goods Sold. Prepare the appropriate journal entry.

3. Assume that the company allocates any underapplied or overapplied overhead proportionally to Work in Process, Finished Goods, and Cost of Goods Sold. Prepare the appropriate journal entry.

4. How much higher or lower will net operating income be if the underapplied or overapplied overhead is allocated to Work in Process, Finished Goods, and Cost of Goods Sold rather than being closed to Cost of Goods Sold?

Compute the underapplied or overapplied overhead.

Assume that the company closes any underapplied or overapplied overhead to Cost of Goods Sold. Prepare the appropriate journal entry. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

Note: Enter debits before credits.

Event

General Journal

Debit

Credit

1

Assume that the company allocates any underapplied or overapplied overhead proportionally to Work in Process, Finished Goods, and Cost of Goods Sold. Prepare the appropriate journal entry. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

Note: Enter debits before credits.

Event

General Journal

Debit

Credit

1

How much higher or lower will net operating income be if the underapplied or overapplied overhead is allocated to Work in Process, Finished Goods, and Cost of Goods Sold rather than being closed to Cost of Goods Sold?

Net operating income will be

if the

overhead is allocated rather than closed entirely to cost of goods sold.

In: Accounting

Summarize the qualitative risks of on‐time project completion considering the current employment and work environment in...

Summarize the qualitative risks of on‐time project completion considering the current employment and work environment in the U.S. Several members of your programming team live and work throughout the U.S., and are subject to the laws of those states. Additionally, some of the programming tasks could be modified and possibly sub‐contracted to India, Bulgaria, China, Argentina, and Indonesia.
Discuss how the project manager should address cost/time trade‐offs associated with international outsourced completion of programming tasks. What criteria should be used to determine if a task should be outsourced internationally, or not? Which tasks for this project might be considered for outsourcing to an international programmer or programming team, and why?

In: Operations Management