1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ratelena [41]
3 years ago
11

The AFN equation provides useful insights into the forecasting process, but this equation assumes that all of the firm's key rat

ios remain constant, which is not likely to hold true. Consequently, it is useful to forecast the firm's financial statements. The firm begins with forecasting its which then feeds into the firm's balance sheet. Management looks at operating ratios and their relationship with industry and benchmark averages. The forecasted income statement begins with the prior year's income statement and is adjusted for the sales growth forecast. Some inputs for the income statement are not under the firm's control - for example, tax and interest rates. The forecasted balance sheet is calculated from asset ratios that management has reviewed and changed based on industry and benchmark averages. An Excel spreadsheet is used for this analysis because changes in assumptions, financing, and ratios can be made to the statements to review alternative scenarios. The impact of these changes on the firm's forecasted financial statements ultimately can be used to improve the firm's operations.
Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars):
Sales $4,270
Operating costs excluding depreciation 3,029
EBITDA $1,241
Depreciation 315
EBIT $926
Interest 130
EBT $796
Taxes (40%) 318
Net income $478
Looking ahead to the following year, the company's CFO has assembled this information:
1. Year-end sales are expected to be 4% higher than $4.27 billion in sales generated last year.
2. Year-end operating costs, including depreciation, are expected to increase at the same rates as sales.
3. Interest costs are expected to remain unchanged.
4. The tax rate is expected to remain at 40%.
On the basis of this information, what will be the forecast for Edwin's year-end net income?
(in millions of dollars)
Sales $
Operating costs including depreciation
EBITDA $
Depreciation
EBIT $
Interest
EBT $
Taxes
Net income $
Business
1 answer:
yanalaym [24]3 years ago
6 0

Answer:

Net Income = $499.82

Explanation:

As per the data given in the question,

Forecast for Edwin's year end net income:

Particulars Amount in million

Sales ($4,270×104%) = $4,440.80

Less: Operating cost excluding depreciation ($3,029×104%) = $3,150.16

EBITDA ($4,440.80- $3,150.16) = $1,290.64

Less: Depreciation ($315×104%)  = $327.60

EBIT ($1,290.64-$327.60) = $963.04

Less : Interest = $130

EBT ( $963.04-$130) = $833.04

Less : Tax 40% = $333.22

Net income ($833.04-$333.22) =  $499.82

You might be interested in
If a business has a surplus of goods, what is something they can do to raise demand?
m_a_m_a [10]

Answer:

They can lower the price.

Explanation:

When goods are more cheaper, more people will want to buy their products. Or they could just sabotage the entire market (just kidding) Brainliest maybe?

8 0
3 years ago
Before prorating the manufacturing overhead costs at the end of 2016, the Cost of Goods Sold and Finished Goods Inventory had ap
podryga [215]

Answer:

Cost of Goods Sold will decrease by $2,679 after proration.

Explanation:

Under-applied or over applied overhead:

= Overhead incurred - Overhead applied

= $76,000 - $79,700

= (-$3,700)

Therefore, the Cost of Goods Sold after the proration:

= (over applied overhead × Overhead applied to COGS) ÷ Total overhead applied to cost of goods sold and finished goods

= ($3,700 × $57,700) ÷ ($57,700 + $22,000)

= $213,490,000 ÷ $79,700

= $2,679

Hence, the Cost of Goods Sold will decrease by $2,679 after proration.

3 0
3 years ago
Sharp Company manufactures a product for which the following standards have been set: Standard Quantity or Hours Standard Price
marin [14]

Answer:

1a) Actual Cost per foot = 6$

1b) Materials Price variance = 7530

1b) Spending Variance = 10830

2a) Standard Rate = 7.5 USD

2b) Standard Hours = 4804 hours

2c) Standard hours allowed = 2.09

Explanation:

As usual, let's sort out the data given:

1. For direct materials:

a) Compute the actual cost per foot of materials for March.

For actual cost per foot for materials for march. We need to find the actual quantity first. so, we will come back to it.

Data Given:

Units Produced = 2,290

Standard Quantity for Direct material = 3 feet

Standard Quantity for Direct materials = 3 x 2,290 = 6870 feet

Standard Price per foot = 5 USD

Standard Total Units =  6870

Total Price = 5 x 6870 = 34350 USD

But

Actual Price = unknown

Actual Quantity = Unknown

Actual Cost = 45,180$ company purchased the direct materials at that cost.

Material Quality Variance = Standard Price x (Actual Qty - Standard Qty)

Here in this equation, we know all the quantities except Actual Qty. let's make it subject to calculate it.

Actual Qty = 3,300/$5 + 6870

Actual Qty = 7,530

Now, as we have Actual Quantity, we can calculate the part a of part 1.

So, let's calculate a.

a) a) Compute the actual cost per foot of materials for March.

Actual cost per foot = Direct Material Cost / Actual Qty

Actual Cost per foot = 45,180/7530

Actual Cost per foot = 6$

Let's move on to part 1 b.

b) Compute the price variance and the spending variance.

Formula to calculate the Materials Price Variance is as follows:

Materials Price Variance = Actual Qty x( Actual Price - Standard Price)

Materials Price Variance = 7530 x ( 6 - 5)

Materials Price variance = 7530

Now, we have to calculate the spending variance and the formula is as follows:

Spending Variance = (Actual Price x Actual Qty) - (Standard Qty x Standard Price)

Spending Variance = (6 x 7530) - ( 6870 x 5)

Spending Variance = 10830

Let's move on to part 2 a.

a) Compute the standard direct labor rate per hour:

Formula :

Labor rate variance = (Standard Rate - Actual Rate) x Actual Hours

Labor rate variance = Labor spending variance - Labor efficiency variance

Labor rate variance =   3130 - 780 = 2350

In this equation, we know all the quantities but we have to find Standard rate so make it subject.

Standard Rate = 2350/4700 + 7

Standard Rate = 7.5 USD

b. Compute the standard hours allowed for the month’s production.

Labor Efficiency Variance = Standard rate x ( Actual hours - Standard Hours)

In this part, we need to find the standard hours.

let's make it the subject.

Standard hours = 780/7.5 + 4700

Standard Hours = 4804 hours

c. Compute the standard hours allowed per unit of product.

Standard hours allowed can be found by plugging in the values in the following formula.

Formula:

Standard hours allowed = Standard hours / units produced

Standard hours allowed = 4804/2,290

Standard hours allowed = 2.09

6 0
3 years ago
. In the trade scenario in problem 1, due to overfishing, Norway becomes unable to catch the quantity of fish that it could in p
FrozenT [24]

Answer

The answer and procedures of the exercise are attached in the following archives.

Step-by-step explanation:

You will find the procedures, formulas or necessary explanations in the archive attached below. If you have any question ask and I will aclare your doubts kindly.  

7 0
3 years ago
Bartlet owns a manufacturing business and participates in the business. Which of the following conditions would cause the busine
Crank

Answer:

The correct answer is (A)

Explanation:

Barlet has a manufacturing business and performs various operations throughout the year. According to the act of 1.469-5, a business must have some certain fixed operation to come under certain business activities.  The determination is usually made on a yearly basis. According to the regulation Barlet must participate in the business activities for more than 500 hours during a year.

6 0
4 years ago
Other questions:
  • Explain what the national debt is and two ways to affects the country
    14·1 answer
  • Using non-volume-based activity drivers allows activity based costing to
    6·1 answer
  • Explain how many total number of credits you will need to graduate with a diploma from your state. how many total math credits d
    7·2 answers
  • A chemical reactor gives a fractional conversion of only 10% of the expensive limiting reactant in the feed stream. Assuming not
    6·1 answer
  • Compare the policy ideas of President Herbert Hoover and President Franklin D. Roosevelt during the Great Depression. How did th
    11·1 answer
  • During the current month, Ringling Company incurs the following manufacturing costs:
    13·1 answer
  • As part of its hiring process, TE Electronics requires new employees to sign an agreement that requires arbitration in the event
    9·1 answer
  • Good Morning people how are you guys doin
    10·1 answer
  • Alec must purchase 14 identical shirts and only has $\$130$. There is a flat $\$2$ entrance fee for shopping at the warehouse st
    11·1 answer
  • During the 1960s, u.s. firms created just over _____ of worldwide foreign direct investment and british firms were second accoun
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!