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
grandymaker [24]
3 years ago
5

Excel Online Structured Activity: Capital budgeting criteria A company has a 11% WACC and is considering two mutually exclusive

investments (that cannot be repeated) with the following cash flows:
0 1 2 3 4 5 6 7
Project A -$300 -$387 -$193 -$100 $600 $600 $850 -$180
Project B -$405 $132 $132 $132 $132 $132 $132 $0
The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
1. What is each project's NPV? Round your answer to the nearest cent. Do not round your intermediate calculations.
2. What is each project's IRR? Round your answer to two decimal places
3. What is each project's MIRR?
Business
1 answer:
WARRIOR [948]3 years ago
3 0

Answer:

ion the answer do u have options ?

Explanation:

You might be interested in
Sheridan Incorporated factored $133,800 of accounts receivable with Skysong Factors Inc. on a without-recourse basis. Skysong as
Tresset [83]

Answer:

Sheridan Incorporated journal entry

Dr Cash 123,096

Dr Loss on sale receivables 2,676

Dr Due from factor 8,028

Cr Account receivable $133,800

Skysong Factors journal entry

Dr Account receivable 133,800

Cr Due to customer 8,028

Cr Interest revenue 2,676

Cr Cash 123,096

Explanation:

Preparation of the journal entry for Sheridan Incorporated and Skysong Factors to record the factoring of the accounts receivable to Skysong

Sheridan Incorporated journal entry

Dr Cash 123,096

(133,800-2,676-8,028)

Dr Loss on sale receivables 2,676

(2%*$133,800)

Dr Due from factor 8,028

(6%*$133,800)

Cr Account receivable $133,800

Skysong Factors journal entry

Dr Account receivable 133,800

Cr Due to customer 8,028

(6%*$133,800)

Cr Interest revenue 2,676

(2%*$133,800)

Cr Cash 123,096

(133,800-2,676-8,028)

7 0
3 years ago
How can the US of new technology in industry benefit workers
gogolik [260]

Answer:

not just pay them they can award them with extra credit?

Explanation:

4 0
3 years ago
Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.88 mill
Anon25 [30]

Answer:

Years            Cash Flow

Year 0           -$ 3,240,000

Year 1            $ 1,192,050

Year 2           $ 1,304,106

Year 3           $ 1,595,994

If the required return is 10 percent, what is the project's NPV?

using a financial calculator, NPV = $120,549.29

Explanation:

cash flow year 0 = $2,880,000 + $360,000 = $3,240,000

MACRS depreciation

33.33% x $2,880,000 = $960,000

44.45% x $2,880,000 = $1,280,160

14.81% x $2,880,000 = $399,840 (since salvage value is $240,000)

cash flow year 1 = [($2,140,00 - $823,000 - $960,000) x 0.65] + $960,000 = $1,192,050

cash flow year 2 = [($2,140,00 - $823,000 - $1,280,160) x 0.65] + $1,280,160 = $1,304,106

cash flow year 3 = [($2,140,00 - $823,000 - $399,840) x 0.65] + $399,840 + $240,000 + $360,000 = $1,595,994

3 0
4 years ago
What do you mean by Women's Right?​
Vitek1552 [10]
Women having equal rights to men. This means getting equal pay, treatment and opportunity that men get
4 0
3 years ago
Who provides a W-2 form? A W-2 form is provided by a/an to its employees to help them file their annual taxes.
Artist 52 [7]
The taxpayer’s employer fills out the forms because they have the info you need these to turn in your taxes and if your jod is anything like mine they wait last minute to send them out lol
7 0
3 years ago
Read 2 more answers
Other questions:
  • Suppose a professional basketball game is to be played at a downtown urbandowntown urban ​arena, which increases demand for park
    9·1 answer
  • Fargus Corporation owned 55% of the voting common stock of Sanatee, Inc. The parent's interest was acquired several years ago on
    9·1 answer
  • As of july 2013, the population of the united states was 3.164 × 108, and the national debt was 1.674 × 1013 dollars. how much w
    12·1 answer
  • If Ann were to convert some of her checkable deposits into a certificate of deposit, which of the following changes would take p
    9·1 answer
  • For an auto insurance company, the average cost of collision claims is $500 per year for careful drivers and $3000 per year for
    10·1 answer
  • Management at Work While reading the newspaper one day, you come across an article discussing the diversity strategy presented b
    15·1 answer
  • Tracy Brady is in the process of developing an exciting new product in the smartphone industry. She'd like to show a preliminary
    13·2 answers
  • An implication of the efficient market hypothesis is that __________.A. high-beta stocks are consistently overpricedB. low-beta
    6·1 answer
  • Sales taxes, income taxes, and motor fuel taxes are examples of which class of nonexchange transactions
    6·1 answer
  • A commercial cleaning company spends an average of $500 per year, per customer, in supplies, wages, and account maintenance. An
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!