Question: The XNPV function can calculate NPV for any (possibly irregular) series of cash flows. Look this function up in Excels online help. Then use it

The XNPV function can calculate NPV for any (possibly irregular) series of cash flows. Look this function up in Excel’s online help. Then use it to develop a spreadsheet model that finds the NPV of the following series: a payment of $25,000 today (assumed to be June 15, 2014), and cash inflows of $10,000 on March 1, 2015; $15,000 on September 15, 2015; $8000 on January 20, 2016; $20,000 on April 1, 2016; and $10,000 on May 15, 2016. Discount these back to “today” using a discount rate of 12%.

Step by Step Solution

★★★★★

3.48 Rating (161 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Model Using XNPV function Discount ra... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (3 attachments)

1497_60b7412339985_696395.pdf

180 KBs PDF File

1497_605896a30861a_696395.xlsx

300 KBs Excel File

1497_60b7412339985_696395.docx

120 KBs Word File

Students Have Also Explored These Related Practical Management Science Questions!

Construct a series of cash flows with no IRR.

Construct a series of cash flows with no IRR. Discuss.

1. Calculate the NPV of the wildcat oil well, taking account of the probability of a dry hole, the shipping costs, the decline in production, and the forecasted increase in oil prices. How long does...

The XNPV function can calculate NPV for any ( possibly irregular ) series of cash flows. Look this function up in Excel s online help. Then use it to develop a spreadsheet model that finds the NPV of...

The XNPV function can calculate NPV for any ( possibly irregular ) series of cash flows. Look this function up in Excel's online help. Then use it to develop a spreadsheet model that finds the NPV of...

The XNPV function can calculate NPV for any (possibly irregular) series of cash flows. Look this function up in Excels online help. Then use it to set up a spreadsheet model that finds the NPV of the...

The XNPV function can calculate NPV for any (possibly irregular) series of cash flows. Look this function up in Excels online help. Then use it to develop a spreadsheet model that finds the NPV of...

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

6.1. Carbondale Company has the following credit policy 2/10, net 30. Carbondale also charges 1% per month interest on all accounts after 30 days. The following table shows the collection schedule of...

In the Bohr model of the hydrogen atom, the electron is in orbit about the nuclear proton at a radius of 5.29 x 10 -11 m. Determine the speed of the electron, assuming a circular orbit.

Define the following terms and explain how they are interrelated: (a) Business responsibility, (b) Stakeholder, and (c) Shared value.

Webster includes in the definition of management "judicious use of means to accomplish an end"; planning is described as "the establishment of goals, policies, and procedures for a social or economic...

5.5. Consider a post office with two clerks. John, Paul, and Naomi enter simultaneously. John and Paul go directly to the clerks, while Naomi must wait until either John or Paul is finished before...

Will Facebook be able to have a successful business model without invading privacy? Explain your answer. Could Facebook take any measures to make this possible?

Wearables have the potential to change the way organizations and workers conduct business. Discuss the implications of this statement.

How would a business process such as ordering a product for a customer in the field be changed if the salesperson were wearing a smartwatch equipped with Salesforce software?

The surgery center's building in downtown Charleston has an attached garage, but CPSC employees and patients use only about 50% of the garage's space. The CFO is under discussions to lease the...

Based on past 23 years, Westerfield Industrial Supply's common stock has yielded an arithmetic average rate of return of 10.5 percent. The geometric average return for the same period was 8.57...

exhibit9.9 Based on Exhibit 9-9, or using a financial calculator, what would be the monthly mortgage payments for each of the following situations? Note: Round time value factor and final answers to...