Which spreadsheet type will determine how well a business has done over the past year?

Xie Company identified the following activities, costs, and activity drivers for this year. The company manufactures two types o

san4es73 [151]

Answer:

Results are below.

Explanation:

First, we need to calculate the plantwide predetermine manufacturing overhead rate:

Predetermined manufacturing overhead rate= total estimated overhead costs for the period/ total amount of allocation base

total estimated overhead costs for the period= (625,000 + 900,000 + 105,000 + 175,000 + 300,000 + 75,000)

total estimated overhead costs for the period= $2,180,000

Predetermined manufacturing overhead rate= 2,180,000 / 125,000

Predetermined manufacturing overhead rate= $17.44 per direct labor hour

Now, we can allocate overhead to each product line:

Allocated MOH= Estimated manufacturing overhead rate* Actual amount of allocation base

Deluxe:

Allocated MOH= 17.44*2,500

Allocated MOH= $43,600

Basic:

Allocated MOH= 17.44*6,000

Allocated MOH= $104,640

6 0

3 years ago

The risk-free rate of return is 5.5%, the expected rate of return on the market portfolio is 17%, and the stock of Xyrong Corpor

Katen [24]

Answer:

1. $12.31

2. -11.96%

Explanation:

a) Calculation to determine the intrinsic value of a share of Xyrong stock

First step is to calculate the Required Return

Using this formula

Required Return = Risk-free Rate + [Beta * (Expected Market Return - Risk-free Rate)]

Let plug in the formula

Required Return= 5.5% + [2.7 * (17% - 5.5%)]

Required Return= 5.5% + 31.05% = 36.55%

Second step is to calculate g using this formula

g = ROE * (1 - Payout Ratio)

Let plug in the formula

g= 18% * (1 - 0.25)

g= 13.5%

D0 = EPS0 * Payout Ratio = $10 * 0.25 = $2.50

P0 = [D0 * (1 + g)] / [r - g]

= [$2.50 * (1 + 0.135)] / [0.3655 - 0.135]

= $2.8375 / 0.2305 = $12.31

b). Holding Period Return = [P1 + D1 - P0] / P0

= [$8 + $2.8375 - $12.31] / $12.31 = -$1.4727 / $12.31 = -0.1196, or -11.96%

8 0

3 years ago

Consider an economy with a corn producer, some consumers, and a government. In a given year, the corn producer grows 30 million

lys-0071 [83]

Answer:

a. GDP using product approach

There are no intermediate goods inputs. Corn producer grows 30 million bushels of corn and each bushel of corn worth is $5.

GDP = 30 million * $5

GDP = $150 million

GDP using expenditure approach

i) Consumers buy 20 million bushels of corn

Consumption = 20 million * 5

Consumption (C) = $100 million

ii) Corn producer adds 5 million bushels to inventory

Investment = 5 million * $5

Investment (I) = $25 million

iii) Government buys 5 million bushels of corn

Government spending = 5 million * $5

Government spending (G) = $25 million

GDP = C + I + G

GDP = $100 + $25 + $25

GDP = $150 million

GDP using income approach

Profit income = $150 million - $60 million - $20 million

Profit income = $70 million

Government income = Taxes paid by the corn producer = $20 million

GDP = $60 million + $70 million + $20 million

GDP = $150 million

b. Private disposable income = GDP + Net factor payments + Government transfers + Interest on the government debt - Total taxes

Private disposable income = $150 million + 0 + $5 million + $10 million - $30 million

Private disposable income = $135 million

Private savings = Private disposable income - Consumption

Private savings = $135 million - $100 million

Private savings = $35 million

Government savings = Government tax income - Transfer payments - Interest on the government debt - Government spending

Government savings = $30 million - $5 million - $10 million - $5 million

Government savings = $10 million

National savings = Private savings + Government savings

National savings = $35 million + $10 million

National savings = $45 million

Government budget surplus = Government savings = $10 million

Government deficit = (-) $10 million

8 0

3 years ago

Marla would like to collect $225,000 to buy a house in 12 years. She thinks she can save money in a money-market account earning

Ymorist [56]

Answer:

The value of Q = $10,723

Explanation:

Please find attached.

6 0

3 years ago

According to a 2000 public opinion poll, 69 percent of americans who responded were most proud of the nation’s

aalyn [17]

According to a 2000 public-opinion poll, 69 percent of Americans who responded were most proud of the nation's equal opportunity laws.

An equal opportunities policy should: make clear your organization’s commitment to equal opportunities, non-discriminatory procedures and practices. list all the forms of discrimination covered by the policy, ie age, gender, race, religion or belief, sexual orientation, disability or pay rate.

8 0

3 years ago