Question: please show the work in excel with excel formulas What is the present value of the following cash flows if the opportunity cost is 10%?

please show the work in excel with excel formulas

What is the present value of the following cash flows if the opportunity cost is 10%? year cash 1 2 1000 2000 3000 4000 O 8,500.25 O 6,475.35 10,000 9,100.85 O 7,547.98

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1 ...Passero company has a minimum required rate of return of 10%. It is considering investing in a project which costs $135,500 and is expected to generate cash inflows of $41,000 at the end of each...

Example 1.) A company is buying stripped-down truck platforms and then modifying them to customer specifications for resale. A local distributor has requested bids for 10 specially modified trucks...

Please show all formulas and work. No calculators or excel please. 1. Present Value and Multiple Cash Flows [LO1] McCann Co. has identified an investment project with the following cash flows. If the...

AutoSave 0 H. FNCE2004 Financial Analysis Project Semester 2 2020 Excel cz hari CH File Home Insert Page Layout Formulas Data Review View Help Acrobat O Search Share Comments W X Y Z A1 X Question 1...

Valuation Part 2; FCF Method Go to the Valuation Readings folder located under Course Documents and open this reading: Free_Cash_Flow_Method_Files.pdf . Then go to Exhibit 1 (p. 244; page #s are at...

Can You please show your work on paper Can you please show your work on paper Developing Relevant Cash Flows for Newman Upholstery Company's Machine Resewal or Replacement Decision Cosmo Kramer,...

PLEASE SHOW ALL WORK & CALCULATIONS. Heywood Diagnostic Enterprises is evaluating a project with the following net cash flows and probabilities (Prob): Year 0 1 2 3 Prob. = 0.2 ($100,000) $20,000...

For this activity, refer to the Surf Print Table & Floor Lamps example. Assume that sale price follows a lognormal distribution with mean of $48 and standard deviation of $4.80 and the variable...

Could you please show the formulas in Excel. 7. Two mutually exclusive investment projects have the following forecasted cash flows: Years A B 0 ($20,000) ($20,000) 1 10,000 0 2 10,000 0 3 10,000 0 4...

PLEASE SHOW YOUR WORK ON EXCEL or the formula's used so it's easy to understand XYZ Corp. is considering a project that has the following cash flow data.What is the project's IRR?Note that a...

1. The responsibilities of the operations manager include: assessing consumer wants and needs. promoting the organization's goods or services. analyzing investment proposals. the creation of goods or...

Which of the following bond mutual funds invest in tax-exempt securities?

Which of the following is not an asset? Group of answer choices Accumulated depreciation Retained earnings Cash Prepaid expenses Equipment

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...