Ask question

Ask question

All categories

4 years ago

10

In cell e5, enter a financial function to calculate the monthly payment. in cell e6, insert a financial function to calculate th

e cumulative total interest paid throughout the loan. make sure the results display as positive numbers.

1 answer:

eduard4 years ago

4 0

The excel function for monthly payments is =PMT()

The excel function for cumulative total interest is =CUMIPMT()

You might be interested in

Magic Realm, Inc., has developed a new fantasy board game. The company sold 15,000 games last year at a selling price of $20 per

mylen [45]

Explanation:

1. a. Contribution format income statement for the game last year and compute the degree of operating leverage

Magic Realm, Inc.

Contribution Income Statement

Total Per Unit

Sales $300,000 $20

Variable 90,000 6

Contribution margin 210,000 $14

Fixed expense 182,000

Net operating income $28,000

1.b. Compute the degree of operating leverage

The degree of operating leverage is:

Degree of operating leverage = Contribution margin/Net operating income

= $210,000/$28,000

= 7.5

2. a. Sales of 18,000 games represent a 20% increase over last year's sales. Because the degree of operating leverage is 7.5, net operating income should increase by 7.5 times as much, or by 150% (7.5 × 20%).

= 150%

2.b. The expected total dollar amount of net operating income for next year would be:

Last year's net operating income $28,000

Expected increase in net operating income

next year (150% × $28,000) 42,000

Total expected net operating income $70,000

8 0

3 years ago

Pasadena Candle Inc. budgeted production of 785,000 candles for January. Each candle requires molding. Assume that six minutes a

yarga [219]

Answer:

$2,414,125

Explanation:

Preparation of a cost of goods sold budget for Pasadena Candle Inc

Pasadena Candle Inc. COST OF GOODS SOLD BUDGET For the Year Ending December 31

Finished goods inventory, January 1 $200,000

Work in process inventory, January 1 $41,250

DIRECT MATERIALS:

Direct materials inventory, January 1 $19,840

Direct materials purchases $60,4035

Cost of direct materials available for use $62,3875

Direct materials inventory, December 31 $15,500

Cost of direct materials placed in production $608,375

Direct labor $1,413,000

Factory overhead $300,000

TOTAL manufacturing costs $2,321,375

Total work in process during period $2,362,625

($41,250+$2,321,375)

Work in process inventory, December 31 $28,500

Cost of goods manufactured $2,334,125

($2,362,625-$28,500)

Cost of finished goods available for sale $2,534,125

($2,334,125+$200,000)

Finished goods inventory, December 31 $120,000

COST OF GOODS SOLD $2,414,125

($2534125-$120,000)

Therefore The cost of goods sold budget for Pasadena Candle Inc will be $2,414,125

8 0

3 years ago

Compared to a corporation, a partnership is more difficult and expensive to establish.

barxatty [35]

The answer should be False.

3 0

3 years ago

d. Suppose that the increase in input price does not occur but, instead, that productivity increases by 25% percent. What would

worty [1.4K]

Answer:

decreased by 20%

Explanation:

Supposed we have input price of $30,000 and it produced an output of 300 units on the first year of operation. The cost per unit on the first year is $100 each ($30,000/300).

On the second year we still have the same input expense of $30,000 but the productivity output increased by 25%. So we have 375 units produced on the second year’s operation. The new cost per unit would be $30,000/375=$80 per unit.

Therefore we conclude that based on the example given, the new unit cost per product decreases by 20%.

$100-80 = $20

$20/$100 = 20%

4 0

4 years ago

Which phrase best describes a capital gain? an increase in the amount of capital a firm uses in production an increase in the va

rewona [7]

Answer:

An increase in the value of an asset

A portion of profits paid back to shareholders

Explanation:

Capital gain can be defined as a rise in the value of a capital asset (which could be investment or real estate) that facilitates a higher worth than the original purchasing price.

Dividend can be defined as a distribution of profits by a certain corporation to its shareholders.

4 0

3 years ago