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
Alina [70]
3 years ago
14

Given the following time events and incremental cash flow, if the MARR is 12% per year, which alternative should be selected on

the basis of rate of return? Assume alternative B requires the extra $7,000 initial investment. (You can use Excel). Year Incremental CFB-CFA 0 -7,000 1 +1,500 2 +1,500 3 +1,500 4 +1,500 5 +5,000

Business
1 answer:
Greeley [361]3 years ago
8 0

Answer:

Explanation:

I have attached a screenshot of the spreadsheet I used.

First, input each incremental cashflow in its own cell,

Input the MARR rate as well

To determine if accepting alternative B is worth it or not based on rate of return, use IRR (Internal rate of return) function on excel by typing "=IRR" and select the array of cells containing the cashflows. IRR is 13.84% is positive and it means that alternative B is more profitable since the IRR is greater than the MARR of 12%

You might be interested in
Lance lopes went to his bank to find out how long it will take for $1,500 to amount to $2,700 at 15% simple interest. can you so
denis23 [38]
To find simple interest: 

Time = Interest/(Principle)(Rate)

Interest is the amount of interest paid
Principle is the amount you lent or borrow
Rate is the percentage of principle charged as interest each year
Time is the years of the loan

P=Principle amount of $1,500
I=Interest amount of $1,200 (Take the new amount of $2,700 and subtract from the principle that is $1,500 which gives you $1,200)
r= as a decimal .15 (15%/100)
t=unknown

T=I/PR

T=1,200/(1,500)(.15)
T=1,200/225
T=5.3 years 

It would take Lance roughly 5.3 years
3 0
3 years ago
Which action can hurt your credit score? I. Paying your phone bill late. II. Taking the bus to work. III. Maxing out several cre
BartSMP [9]
All of the above josehernandez2017!

6 0
3 years ago
What reasons would retailers have for marking prices lower
UkoKoshka [18]
To attract customers to their store and not their more expensive competitors?

4 0
3 years ago
Forced to lay off a number of its employees, including larry kurzyniec. larry, who had been logging for over eighteen years, suf
Shtirlitz [24]

COBRA- Consolidated Omnibus Budget Reconciliation Act, is the name of the federal law that guarantees employees who have lost their jobs continuing access to health insurance.

<h3>What is Federal COBRA?</h3>

When your employment terminates or your hours are reduced, federal COBRA is a law that enables you to preserve your group health coverage. All insured employees, their spouses, ex-spouses, and dependent children must be provided with continuous coverage under federal COBRA. Employers and group health plans with 20 or more members are subject to the federal COBRA.

<h3>How does COBRA work?</h3>

Under certain conditions, including voluntary or involuntary job loss, a reduction in hours worked, a change in employment, death, divorce, and other life events, the COBRA allows employees and their families who lose their health benefits to choose to continue receiving group health benefits from their group health plan for a finite amount of time. The full price for coverage up to 102% of the plan's cost may be demanded of qualified persons.

To know more about Federal laws visit:                                                          brainly.com/question/29439408

#SPJ4

4 0
11 months ago
Which of te following correctly pairs a financing option with its description
Evgesh-ka [11]

If this question has the same set of choices like the other ones posted here, then the answer would be letter C. 529 plan- money you save.
7 0
3 years ago
Other questions:
  • Jill's employer has a compensation package that includes vacation pay, retirement, and life insurance but allows all employees t
    15·1 answer
  • A store accidentally priced an item at $20 instead of $30 and honored the mispricing. where should the $10 difference
    11·1 answer
  • Michael is the project manager in a Manufacturing Company he wants his organization to use technology for higher revenue and pro
    8·2 answers
  • The P Ltd acquires all issued capital of the S Ltd for a consideration of $1,000,000 cash and 800,000 shares eachvalued at $1.50
    5·1 answer
  • Edison's Lights makes light bulbs. The company is currently producing well below its full capacity. Lamp Land has approached Edi
    10·1 answer
  • The statement of cash flows reports:_______ a) Changes in equity. Equity, net income, and dividends. b) Cash inflows and cash ou
    6·1 answer
  • You all are talking about kidz bop they are actually remixing music so family and kids younger and listen to them but you are ju
    12·2 answers
  • In order to find last season’s batting averages for his favorite baseball players, Jose should look in a Sport’s
    15·2 answers
  • A corporation, like a(n)_______, may file suit or _______, or may form a contract or breach a contract.
    9·1 answer
  • When comparing general partnerships to sole proprietorships, an advantage of partnerships is that they?
    8·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!