answer.
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
Savatey [412]
2 years ago
15

Modern Federal Bank is setting up a brand-new branch. The cost of the project will be $1.2 million. The branch will create addit

ional cash flows of $235,000, $412,300, $665,000 and $875,000 over the next four years. The firm's cost of capital is 12 percent. What is the internal rate of return on this branch expansion
Business
1 answer:
KonstantinChe [14]2 years ago
3 0

Answer:

23.12%

Explanation:

Internal rate of return (IRR) is the rate at which the Net present value (NPV) of a project equals to zero.

Using a financial calculator and the CF function, input the following to find IRR;

Initial investment; CF0 = -1,200,000

Yr1 cashflow inflow ; C01 = 235,000

Yr2 cashflow inflow ; C02 = 412,300

Yr3 cashflow inflow ; C03 = 665,000

Yr4 cashflow inflow ; C04 = 875,000

Then key in IRR CPT = 23.119%

Therefore, the Internal rate of return this expansion is 23.12%

You might be interested in
Each service starts on a different date because the services depend on each other. Enter the starting dates for the remaining se
gladu [14]

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.

7 0
1 year ago
Chubbs Inc.’s manufacturing overhead budget for the first quarter of 2017 contained the following data. Variable Costs Fixed Cos
nydimaria [60]

Answer:

\left[\begin{array}{cccc}-&Budget&Variance&Actual\\IL&10,000&700&9,300\\IM&11000&-3,800&14,800\\Utilities&7,400&-2,400&9,800\\Maintenance&6,000&1,200&4,800\\Total  \: Variable&34,400&-4,300&38,700\\Supervisor&35,400&0&35,400\\Depreciation&7,100&0&7100\\PT and insurance&7,700&-600&8,300\\Maintenance&6,000&0&6,000\\Total \: Fixed&56,200&-600&56,800\\Total \: MO&90,600&-4,900&95,500\\\end{array}\right]

Explanation:

We list them and subtract budget - actual

When actual is greater than budget the variance is negatine.

While budget being lower than actual is considered a positive variance.

3 0
2 years ago
Colors and more is considering replacing the equipment it uses to produce crayons. the equipment would cost $1.37 million, have
MakcuM [25]

¿¿?¿???¿?????¿???¿??????????¿?????????????........???????¿I'm not really sure

0 0
2 years ago
Which of these statements demonstrate the economic concept of scarcity? check all that apply. all useful resources are limited i
Zigmanuir [339]
The following statements describe the economic concept of scarcity:
1. All useful resources are limited.
2.Resources are scarce which explain why we are willing to pay for them.
3. Because of scarcity, individuals must make choices.
In economics, scarcity is the study of how people attempt to satisfy their needs and wants by making choices. The principle of scarcity states that limited goods and services are available to meet unlimited wants.
7 0
2 years ago
Read 2 more answers
Given an optimal capital structure that is 50% debt and 50% common stock, calculate the weighted average cost of capital for the
klemol [59]

Answer:

As the WACC is more than 7.5%, option D is the correct answer.

Explanation:

The weighted average cost of capital or WACC is the cost of a firm's capital structure. To calculate the WACC, we multiply the weight of each component of the capital structure by the cost of that component. The components of capital structure can be one or all of the following namely debt, preferred stock and common stock.

The formula for WACC is,

WACC = wD * rD * (1-tax rate)  +  wP * rP  +  wE * rE

Where,

  • w represents the weight of each component
  • r represents the cost of each component
  • D, P and E represents debt, preferred stock and common stock respectively

First we need to determine the cost of debt and equity for this firm.

We use the market value of debt and thus, rate for the calculation of WACC.

The cost of debt will be its yield to maturity as it is the current rate or cost. Thus, rD will be 6%.

The cost of equity can be determined using the constant growth model of DDM 's formula for prcie today.

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

80 = 5 * (1+0.05) / (r - 0.05)

80 * (r - 0.05) = 5.25

80r - 4 = 5.25

80r = 5.25 + 4

r = 9.25 / 80

r = 0.115625 or 11.5625%

WACC = 0.5 * 0.06 * (1-0.3)  +  0.5 * 0.115625

WACC = 0.0788125 or 7.88125%

As the WACC is more than 7.5%, option D is the correct answer.

8 0
2 years ago
Read 2 more answers
Other questions:
  • Stretch goals" can be described as
    7·1 answer
  • Firms use capital budgeting for their long-term asset investment decisions. Capital budgeting is important because fixed asset i
    11·1 answer
  • A company uses a periodic inventory system and during the December 31, year-end physical inventory count discovered that they ha
    9·1 answer
  • Irene plans to retire on January 1, 2020. She has been preparing to retire by making annual deposits, starting on January 1, 198
    13·1 answer
  • Several years ago, Westmont Corporation developed a comprehensive budgeting system for planning and control purposes. While depa
    8·1 answer
  • Consider two products, X and Y, that have identical cost, retail price, and demand parameters and the same short selling season
    12·2 answers
  • 9) Marshall Corporation has established a target capital structure of 35 percent debt and 65 percent common equity. The current
    6·1 answer
  • The GoT cups are a fast seller and you need to ensure that you have enough rolls of paper to fulfill demand. The first stage in
    5·2 answers
  • Mr. Porter’s gross pay is $90,000 per year. He files taxes as head of a household, and his income tax percentage is 20%, so that
    7·1 answer
  • How does a company's use of social media reflect audience-centered communication?
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!