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
dimulka [17.4K]
3 years ago
6

IRR in Excel!(CHAPTER 9) Your company is considering a new project opportunity. It would immediately receive $200. In return, in

the next 4 years it will need to pay the following amounts of money: In 1 year: $80 In 2 years: $70 In 3 years: $60 In 4 years: $50 The required annual rate of return is 19%. Answer the following questions: (a) The Internal Rate of Return for this project is . %. (Round your answer to TWO decimal places. Put your answer in percent, NOT in decimals. For example, if your answer is 12.34 percent, then you need to put 12.34, and NOT 0.12)
Business
1 answer:
oksian1 [2.3K]3 years ago
3 0

Answer:

12.44%

Explanation:

Internal rate of return is the discount rate that equates the after-tax cash flows from an investment to the amount invested

IRR can be calculated with a financial calculator  

cash floe in yer0 = 200

cash flow in year 1 = -80

cash flow in year 2 = - 70

cash flow in year 2 = - 60

cash flow in year 2 = - 40

irr = 12.44%

To find the IRR using a financial calculator:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the IRR button and then press the compute button.  

You might be interested in
Sylvia is a member of a team that uses e-mail, messenger, and blogging to communicate. although she sees members of her team on
denpristay [2]
Sylvia' s team can best be described as a virtual team.
Hope this helps!
6 0
3 years ago
*Will award Brainliest if right!*
Serhud [2]

Answer:

https://quiz   let.co  m/96700748/chapter-4-flash-cards/

Explanation:

Link above provides answers

( Don't copy paraprashe)

8 0
2 years ago
Read 2 more answers
A $1000 bond with a coupon rate of 6.2% paid semi annually has eight years to maturity and a yield to maturity of 8.3%. If inter
mel-nik [20]

Answer:

Correct option is (C)

Explanation:

Given:

Face value of bond (FV) = $1,000

Coupon rate = 6.2% annual and 6.2 / 2 = 3.1% semi annual

Coupon payment (pmt) = 0.031 × 1,000 = $31

Maturity period (nper) = 8×2 = 16 periods

Rate = 8.3% annual or 8.3 / 2 = 4.15%

Present value of bond can be computed using spreadsheet function =PV(rate,nper,pmt,FV)

Present value of bond when yield is 8.3% is $878.99

If ytm increases to 8.6% annual or 8.6 / 2 = 4.3% semi annual, then present value of bond will be $863.22 (using spreadsheet function again)

It can be seen that as ytm increased from 8.3% to 8.6%, price of bond fell by $15.77 approximately (878.99 - 863.22)

7 0
3 years ago
Earlier this week, Trump called off a secret meeting at Camp David with Taliban and
vfiekz [6]

Answer:

NEW YORK (AP) — People who were too young on 9/11 to even remember their lost loved ones, and others for whom the grief is still raw, paid tribute with wreath-layings and the solemn roll call of the dead Wednesday as America marked the 18th anniversary of the worst terror attack on U.S. soil.

“Eighteen years. We will not forget. We cannot forget,” Bud Salter, who lost his sister, Catherine, said at ground zero.

President Donald Trump laid a wreath at the Pentagon, telling victims’ relatives: “This is your anniversary of personal and permanent loss.”

“It’s the day that has replayed in your memory a thousand times over. The last kiss. The last phone call. The last time hearing those precious words, ‘I love you,’” the president said.

Later, former President George W. Bush, who was in office on 9/11, and then-Defense Secretary Donald Rumsfeld attended another wreath-laying at the Pentagon.

Near Shanksville, Pennsylvania, the third site where planes crashed on Sept. 11, 2001, Vice President Mike Pence credited the crew and passengers who fought back against the hijackers with protecting him and others in the U.S. Capitol that day.

“I will always believe that I and many others in our nation’s capital were able to go home that day and hug our families because of the courage and selflessness of your families,” said Pence, who was an Indiana congressman at the time. Officials concluded the attackers had been aiming the plane toward Washington.

Nearly 3,000 people were killed when terrorist-piloted planes slammed into the World Trade Center, the Pentagon and the field in Pennsylvania.

After reading part of the long list of names, Parboti Parbhu choked up as she spoke from the ground zero podium about her slain sister, Hardai. Even after nearly two decades, “there’s no easy way to say goodbye,” she said.

By now, the heritage of grief has been handed down to a new generation, including children and young adults who knew their lost relatives barely or not at all.

Jacob Campbell was 10 months old when his mother, Jill Maurer-Campbell, died on 9/11.

“It’s interesting growing up in a generation that doesn’t really remember it. I feel a connection that no one I go to school with can really understand,” Campbell, a University of Michigan sophomore, said as he attended the ceremony.

Like the families, the nation is still grappling with the aftermath of Sept. 11. The effects are visible from airport security checkpoints to Afghanistan, where the post-9/11 U.S. invasion has become America’s longest war. The aim was to dislodge Afghanistan’s then-ruling Taliban for harboring al-Qaida leader and Sept. 11 mastermind Osama bin Laden.

Earlier this week, Trump called off a secret meeting at Camp David with Taliban and Afghan government leaders and declared the peace talks “dead.” As the Sept. 11 anniversary began in Afghanistan, a rocket exploded at the U.S. Embassy just after midnight, with no injuries reported.

Al-Qaida’s current leader used the anniversary to call for more attacks on the U.S. and other targets.

In New York, Nicholas Haros Jr., who lost his mother, Frances, reminded the audience of the al-Qaida attackers and tore into Democratic Rep. Ilhan Omar of Minnesota over her recent “Some people did something” reference to 9/11.

“Our constitutional freedoms were attacked, and our nation’s founding on Judeo-Christian values was attacked. That’s what ‘some people’ did. Got that now?” he said to applause.

Omar, one of the first Muslim women elected to Congress, has said she didn’t intend to minimize what happened on Sept. 11, and accused critics of taking her words out of context. She tweeted Wednesday that “September 11th was an attack on all of us.”

The dead included Muslims, as Zaheda Rahman underscored after reading names at ground zero. She called her uncle, Abul Chowdhury, a “proud Muslim-American man who lived his life with a carefree nature, a zeal for adventure and a tenacity which I emulate every single day.”

Others made a point of spotlighting the suffering of firefighters, police and others who died or fell ill after being exposed to the smoke and dust at ground zero.

A compensation fund for people with potentially Sept. 11-related health problems has paid out more than $5.5 billion so far. More than 51,000 people have applied. Over the summer, Congress made sure the fund won’t run dry . The sick also gained new recognition this year at the World Trade Center site, where a memorial glade was dedicated this spring.

___

7 0
3 years ago
A(n)_____a0 is a misunderstanding; a mistaken thought or idea.
lara31 [8.8K]

Answer: misconception

Explanation:

A misconception is simply a misunderstanding, a mistaken thought or idea. Misconception is an opinion or a view by s person which is incorrect based on the faulty thinking of the person.

For example, Jane will finish high school the following year and therefore, won't need to further her education. This is an example of misconception.

5 0
3 years ago
Other questions:
  • N article published in the washington post claims that 45 percent of all americans have brown eyes. a random sample of n=78 coll
    15·1 answer
  • Alaska Mining Co. acquired mineral rights for $67,500,000. The mineral deposit is estimated at 30,000,000 tons. During the curre
    12·1 answer
  • The Federal Open Market Committee promotes price stability and economic growth through
    8·2 answers
  • If a manufacturing plant that employs 20% of the local labor force closes, the likely effect on the area’s real estate values
    7·1 answer
  • Responsible drivers assess their personal fitness to drive before getting behind wheel Discuss 3 questions you should ask yourse
    7·1 answer
  • The following list of statements about corporations are given below.
    8·1 answer
  • *economics*<br> What happens when a country's central bank raises the discount rate 10<br> banks?
    11·2 answers
  • Eric wants to invest in government securities that promise to pay $1,000 at maturity. The opportunity cost (interest rate) of ho
    6·1 answer
  • A house worth $180,000 has a coinsurance clause of 75 percent. The owners insure the property for $101,250. They then have a los
    12·2 answers
  • those making more than $200,000 are the primary beneficiaries of the home mortgage interest deduction.
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!